Důlní průmysl, lomy

>

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 '12%' OR class LIKE '11%' OR class LIKE '14%' OR class LIKE '16%' OR class LIKE '3294%' OR class LIKE '3633%' OR class LIKE '4501%' OR class LIKE '4507%' OR class LIKE '4509%' OR class LIKE '4511%' OR class LIKE '4513%' OR class LIKE '5155%' OR class LIKE '6760%' OR class LIKE '8325%' OR class LIKE '8520%' )AND (class LIKE '12%' OR class LIKE '11%' OR class LIKE '14%' OR class LIKE '16%' OR class LIKE '3294%' OR class LIKE '3633%' OR class LIKE '4501%' OR class LIKE '4507%' OR class LIKE '4509%' OR class LIKE '4511%' OR class LIKE '4513%' OR class LIKE '5155%' OR class LIKE '6760%' OR class LIKE '8325%' OR class LIKE '8520%' )