Chemický a farmaceutický průmysl

>

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 '32%' OR class LIKE '31%' OR class LIKE '3068%' OR class LIKE '3827%' OR class LIKE '3831%' OR class LIKE '4201%' OR class LIKE '4202%' OR class LIKE '4203%' OR class LIKE '4204%' OR class LIKE '4210%' OR class LIKE '4211%' OR class LIKE '4213%' OR class LIKE '4215%' OR class LIKE '4219%' OR class LIKE '4225%' OR class LIKE '4227%' OR class LIKE '4235%' OR class LIKE '4237%' OR class LIKE '4239%' OR class LIKE '4240%' OR class LIKE '4241%' OR class LIKE '4243%' OR class LIKE '4245%' OR class LIKE '4246%' OR class LIKE '4247%' OR class LIKE '4249%' OR class LIKE '4251%' OR class LIKE '4253%' OR class LIKE '4254%' OR class LIKE '4256%' OR class LIKE '4258%' OR class LIKE '4260%' OR class LIKE '4262%' OR class LIKE '4265%' OR class LIKE '4266%' OR class LIKE '4267%' OR class LIKE '6394%' OR class LIKE '6396%' OR class LIKE '6397%' OR class LIKE '6398%' OR class LIKE '6650%' OR class LIKE '6730%' OR class LIKE '6734%' )AND (class LIKE '32%' OR class LIKE '31%' OR class LIKE '3068%' OR class LIKE '3827%' OR class LIKE '3831%' OR class LIKE '4201%' OR class LIKE '4202%' OR class LIKE '4203%' OR class LIKE '4204%' OR class LIKE '4210%' OR class LIKE '4211%' OR class LIKE '4213%' OR class LIKE '4215%' OR class LIKE '4219%' OR class LIKE '4225%' OR class LIKE '4227%' OR class LIKE '4235%' OR class LIKE '4237%' OR class LIKE '4239%' OR class LIKE '4240%' OR class LIKE '4241%' OR class LIKE '4243%' OR class LIKE '4245%' OR class LIKE '4246%' OR class LIKE '4247%' OR class LIKE '4249%' OR class LIKE '4251%' OR class LIKE '4253%' OR class LIKE '4254%' OR class LIKE '4256%' OR class LIKE '4258%' OR class LIKE '4260%' OR class LIKE '4262%' OR class LIKE '4265%' OR class LIKE '4266%' OR class LIKE '4267%' OR class LIKE '6394%' OR class LIKE '6396%' OR class LIKE '6397%' OR class LIKE '6398%' OR class LIKE '6650%' OR class LIKE '6730%' OR class LIKE '6734%' )