(SELECT CompanyId, `name 1` AS nazevFirmy, `city 1` AS mesto, `zipCode 1` AS psc, `street 1` AS ulice, webURL, `phoneNumber 1` AS telefon FROM cz_maindatas LEFT JOIN firmy_klicova_slova USING (`CompanyId`) JOIN join_companies USING (`CompanyId`) LEFT JOIN firmy ON join_companies.`id-firmy` = firmy.`id-firmy` WHERE (`state` IS NULL OR `state` = 'active' OR `state` = '' ) AND (`name 1` LIKE '%hmotnost%') AND zvyrazni_do >= NOW() AND zvyraznen != 0 AND geoRegionCode = 'CZ063' ORDER BY zvyraznen DESC) UNION (SELECT CompanyId, `name 1` AS nazevFirmy, `city 1` AS mesto, `zipCode 1` AS psc, `street 1` AS ulice, webURL, `phoneNumber 1` AS telefon FROM firmy_klicova_slova LEFT JOIN firmy ON CONCAT('CZ',firmy.`id-firmy`) = firmy_klicova_slova.CompanyId JOIN cz_maindatas USING(CompanyId) WHERE slovo = 'hmotnost' AND zvyrazni_do >= NOW() AND zvyraznen != 0 AND geoRegionCode = 'CZ063' )