Opravy a údržba

>

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 '2912%' OR class LIKE '3904%' OR class LIKE '3942%' OR class LIKE '3982%' OR class LIKE '3993%' OR class LIKE '3996%' OR class LIKE '4497%' OR class LIKE '4496%' OR class LIKE '4552%' OR class LIKE '4554%' OR class LIKE '4890%' OR class LIKE '4895%' OR class LIKE '4956%' OR class LIKE '4959%' OR class LIKE '4977%' OR class LIKE '5235%' OR class LIKE '5240%' OR class LIKE '5244%' OR class LIKE '5294%' OR class LIKE '5420%' OR class LIKE '6868%' OR class LIKE '6870%' OR class LIKE '07%' )AND (class LIKE '2912%' OR class LIKE '3904%' OR class LIKE '3942%' OR class LIKE '3982%' OR class LIKE '3993%' OR class LIKE '3996%' OR class LIKE '4497%' OR class LIKE '4496%' OR class LIKE '4552%' OR class LIKE '4554%' OR class LIKE '4890%' OR class LIKE '4895%' OR class LIKE '4956%' OR class LIKE '4959%' OR class LIKE '4977%' OR class LIKE '5235%' OR class LIKE '5240%' OR class LIKE '5244%' OR class LIKE '5294%' OR class LIKE '5420%' OR class LIKE '6868%' OR class LIKE '6870%' OR class LIKE '07%' )