SELECT tblClients.client_id, 
    t1.action_textF AS action_text_yes, 
    t2.action_textF AS action_text_not, 
    t3.action_textF AS action_text_notnow
FROM 
    tblOffActions AS t1, 
    tblOffActions AS t2, 
    tblOffActions AS t3, 
    tblOffers INNER JOIN tblClients ON tblOffers.client_id = tblClients.client_id
WHERE 
    tblClients.sex="2" 
    AND t1.action_id=1 
    AND t2.action_id=2 
    AND t3.action_id=3 
    AND tblOffers.offer_id=99 
    AND t1.offer_id=99 
    AND t2.offer_id=99 
    AND t3.offer_id=99
UNION
SELECT tblClients.client_id, 
    t1.action_textM AS action_text_yes, 
    t2.action_textM AS action_text_not, 
    t3.action_textM AS action_text_notnow
FROM 
    tblOffActions AS t1, 
    tblOffActions AS t2, 
    tblOffActions AS t3, 
    tblOffers INNER JOIN tblClients ON tblOffers.client_id = tblClients.client_id
WHERE 
    tblClients.sex NOT LIKE "2"
    AND t1.action_id=1 
    AND t2.action_id=2 
    AND t3.action_id=3 
    AND tblOffers.offer_id=99 
    AND t1.offer_id=99 
    AND t2.offer_id=99 
    AND t3.offer_id=99

SELECT t2.*, tblOffParams.txt1, tblOffParams.txt2, tblOffParams.txt3, tblOffParams.txt4, tblOffParams.txt5, tblOffParams.int1, tblOffParams.dt1
FROM 
    (
        SELECT tblClients.client_id, tblOffPersRefer.persReferF & 
        (
            ' ' + tblClients.client_name +' '+tblClients.client_midname
        ) 
        AS Refer, tblClients.birthday, tblClients.sex, tblOffers.from, tblOffers.to FROM 
        (
            tblOffers LEFT JOIN tblClients ON tblOffers.client_CRM = tblClients.client_CRM
        ) 
        LEFT JOIN tblOffPersRefer ON tblOffers.offer_id = tblOffPersRefer.offer_id 
        WHERE tblOffers.offer_id= 101 AND tblClients.sex='2'
    )  
    AS t2 
    INNER JOIN tblOffParams ON t2.client_id = tblOffParams.client_id
    WHERE tblOffParams.offer_id=101
UNION ALL
SELECT t1.*, tblOffParams.txt1, tblOffParams.txt2, tblOffParams.txt3, tblOffParams.txt4, tblOffParams.txt5, tblOffParams.int1, tblOffParams.dt1
FROM 
    (
        SELECT tblClients.client_id, tblOffPersRefer.persReferM & 
        (
            ' ' + tblClients.client_name +' '+tblClients.client_midname
        ) 
        AS Refer, tblClients.birthday, tblClients.sex, tblOffers.from, tblOffers.to FROM 
        (
        tblOffers LEFT JOIN tblClients ON tblOffers.client_CRM = tblClients.client_CRM
        ) 
        LEFT JOIN tblOffPersRefer ON tblOffers.offer_id = tblOffPersRefer.offer_id 
        WHERE tblOffers.offer_id= 101 AND tblClients.sex='1'
    )  
    AS t1 
    INNER JOIN tblOffParams ON t1.client_id = tblOffParams.client_id
    WHERE tblOffParams.offer_id=101
UNION ALL
SELECT t0.*, tblOffParams.txt1, tblOffParams.txt2, tblOffParams.txt3, tblOffParams.txt4, tblOffParams.txt5, tblOffParams.int1, tblOffParams.dt1
FROM 
    (
        SELECT tblClients.client_id, tblOffPersRefer.persReferNot AS Refer, tblClients.birthday, tblClients.sex, tblOffers.from, tblOffers.to FROM 
        (
            tblOffers LEFT JOIN tblClients ON tblOffers.client_CRM = tblClients.client_CRM
        ) 
        LEFT JOIN tblOffPersRefer ON tblOffers.offer_id = tblOffPersRefer.offer_id 
        WHERE tblOffers.offer_id= 101 AND tblClients.sex='0'
    )  
    AS t0 
    INNER JOIN tblOffParams ON t0.client_id = tblOffParams.client_id
    WHERE tblOffParams.offer_id=101