Vytápění, větrání, klimatizace a chladírenství

>

Seznam Poptávek 1000+ Obchodních příležitostí

SELECT COUNT(poptavky.ID) AS p FROM poptavky JOIN class ON class.ID = poptavky.ID JOIN class ON class.ID = poptavky.ID WHERE poptavky.popis_cz <> '' AND (class LIKE '4046%' OR class LIKE '1840%' OR class LIKE '4048%' OR class LIKE '4058%' OR class LIKE '4060%' OR class LIKE '4062%' OR class LIKE '4064%' OR class LIKE '4080%' OR class LIKE '4082%' OR class LIKE '4084%' OR class LIKE '6684%' OR class LIKE '8365%' )AND (class LIKE '4046%' OR class LIKE '1840%' OR class LIKE '4048%' OR class LIKE '4058%' OR class LIKE '4060%' OR class LIKE '4062%' OR class LIKE '4064%' OR class LIKE '4080%' OR class LIKE '4082%' OR class LIKE '4084%' OR class LIKE '6684%' OR class LIKE '8365%' )