sql sample

SELECT
    COUNT(DISTINCT BASE_CLIENTS.ID_CLIENT) AS C
FROM
    BASE_CLIENTS
    INNER JOIN
        BASE_UBASES_CATEGORIES
    ON
        BASE_UBASES_CATEGORIES.ID_CATEGORY = BASE_CLIENTS.ID_CATEGORY
        AND BASE_UBASES_CATEGORIES.ID_UBASE=3 AND BASE_UBASES_CATEGORIES.ID_CATEGORY IN(12,11,10,9,8)
    INNER JOIN
        `TERYT_SIMC` AS TS
    ON
        TS.SYM = BASE_CLIENTS.SYM
        AND TS.NAZWA LIKE '%awa%'
        AND TS.W IN(12,10,8,6,4,2)
    INNER JOIN
        BASE_PERSONS
    ON
        BASE_PERSONS.`ID_CLIENT` = `BASE_CLIENTS`.`ID_CLIENT`
    INNER JOIN
        BASE_UBASES_TITLES
    ON
        BASE_UBASES_TITLES.ID_TITLE = BASE_PERSONS.ID_TITLE
        AND BASE_UBASES_TITLES.ID_UBASE=3 AND BASE_UBASES_TITLES.ID_TITLE IN(12,11,9,29)
    INNER JOIN
      (
            SELECT BASE_CONTACTS_T.ID_PERSON FROM BASE_CONTACTS_T
            WHERE BASE_CONTACTS_T.CONTACT LIKE '%wp.pl%'
        UNION
            SELECT BASE_CONTACTS_F.ID_PERSON FROM BASE_CONTACTS_F
            WHERE BASE_CONTACTS_F.CONTACT LIKE '%wp.pl%'
        UNION
            SELECT BASE_CONTACTS_E.ID_PERSON FROM BASE_CONTACTS_E
            WHERE BASE_CONTACTS_E.CONTACT LIKE '%wp.pl%'
        UNION
            SELECT BASE_CONTACTS_W.ID_PERSON FROM BASE_CONTACTS_W
            WHERE BASE_CONTACTS_W.CONTACT LIKE '%wp.pl%'
      )
    AS SUB_BASE_CONTACTS
    ON
        SUB_BASE_CONTACTS.ID_PERSON = BASE_PERSONS.ID_PERSON
WHERE BASE_CLIENTS.CLIENT LIKE '%urząd%'