(SELECT CompanyId FROM cz_maindatas WHERE (`state` IS NULL OR `state` = 'active' OR `state` = '' ) AND (`name 1` LIKE '%nohy%' ) AND geoRegionCode = 'CZ071' ) UNION (SELECT CompanyId FROM firmy_klicova_slova JOIN cz_maindatas USING(`CompanyId`) WHERE slovo = 'nohy' AND geoRegionCode = 'CZ071' )