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