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

>

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 '3286%' OR class LIKE '3285%' OR class LIKE '3287%' OR class LIKE '34%' OR class LIKE '35%' OR class LIKE '36%' OR class LIKE '3830%' OR class LIKE '46%' OR class LIKE '4810%' OR class LIKE '4815%' OR class LIKE '4820%' OR class LIKE '4825%' OR class LIKE '4830%' OR class LIKE '4835%' OR class LIKE '4840%' OR class LIKE '4845%' OR class LIKE '4847%' OR class LIKE '4849%' OR class LIKE '4870%' OR class LIKE '4875%' OR class LIKE '4885%' OR class LIKE '4935%' OR class LIKE '4938%' OR class LIKE '4950%' OR class LIKE '4951%' OR class LIKE '6384%' OR class LIKE '6590%' OR class LIKE '6662%' OR class LIKE '6690%' OR class LIKE '6714%' OR class LIKE '6660%' )AND (class LIKE '3286%' OR class LIKE '3285%' OR class LIKE '3287%' OR class LIKE '34%' OR class LIKE '35%' OR class LIKE '36%' OR class LIKE '3830%' OR class LIKE '46%' OR class LIKE '4810%' OR class LIKE '4815%' OR class LIKE '4820%' OR class LIKE '4825%' OR class LIKE '4830%' OR class LIKE '4835%' OR class LIKE '4840%' OR class LIKE '4845%' OR class LIKE '4847%' OR class LIKE '4849%' OR class LIKE '4870%' OR class LIKE '4875%' OR class LIKE '4885%' OR class LIKE '4935%' OR class LIKE '4938%' OR class LIKE '4950%' OR class LIKE '4951%' OR class LIKE '6384%' OR class LIKE '6590%' OR class LIKE '6662%' OR class LIKE '6690%' OR class LIKE '6714%' OR class LIKE '6660%' )