VYHLEDÁVÁNÍ :

miroslav

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