Chemický a farmaceutický průmysl
Různé léky, balzámy, vazelína, klystýry, rybí tuk, kapsule, sádry
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`) JOIN join_companies USING (`CompanyId`) LEFT JOIN firmy ON join_companies.`id-firmy` = firmy.`id-firmy` WHERE (`state` IS NULL OR `state` = 'active' OR `state` = '' ) AND alsenta = '31670' AND zvyrazni_do >= '2024-05-03' AND geoDistrictCode = 'CZ0635' ORDER BY zvyraznen DESC