VYHLEDÁVÁNÍ :

corporation

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