Metalurgie, zpracování železa a výrobky ze železa

Kovové budovy, obytné kontejnery, haly, sklady, přístřešky, fasády

SELECT CompanyId, `name 1` AS nazevFirmy, `city 1` AS mesto, `zipCode 1` AS psc, `street 1` AS ulice, webURL, `phoneNumber 1` AS telefon FROM firmy_alsenta JOIN cz_maindatas USING(`CompanyId`) LEFT JOIN firmy ON CONCAT('CZ',firmy.`id-firmy`) = cz_maindatas.CompanyId WHERE (`state` IS NULL OR `state` = 'active' OR `state` = '' ) AND alsenta = '35060' AND zvyrazni_do >= '2019-05-20' ORDER BY zvyraznen DESC