VYHLEDÁVÁNÍ :

corporation

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