Zemědělství, potravinářství a nápoje

>

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 '02%' OR class LIKE '01%' OR class LIKE '08%' OR class LIKE '09%' OR class LIKE '20%' OR class LIKE '21%' OR class LIKE '3060%' OR class LIKE '3062%' OR class LIKE '3089%' OR class LIKE '3202%' OR class LIKE '3204%' OR class LIKE '3206%' OR class LIKE '3240%' OR class LIKE '3271%' OR class LIKE '4070%' OR class LIKE '41%' OR class LIKE '4953%' OR class LIKE '4954%' OR class LIKE '6150%' OR class LIKE '62%' OR class LIKE '6610%' OR class LIKE '6634%' OR class LIKE '6720%' OR class LIKE '6723%' OR class LIKE '6725%' OR class LIKE '6727%' OR class LIKE '8305%' OR class LIKE '8454%' OR class LIKE '8576%' )AND (class LIKE '02%' OR class LIKE '01%' OR class LIKE '08%' OR class LIKE '09%' OR class LIKE '20%' OR class LIKE '21%' OR class LIKE '3060%' OR class LIKE '3062%' OR class LIKE '3089%' OR class LIKE '3202%' OR class LIKE '3204%' OR class LIKE '3206%' OR class LIKE '3240%' OR class LIKE '3271%' OR class LIKE '4070%' OR class LIKE '41%' OR class LIKE '4953%' OR class LIKE '4954%' OR class LIKE '6150%' OR class LIKE '62%' OR class LIKE '6610%' OR class LIKE '6634%' OR class LIKE '6720%' OR class LIKE '6723%' OR class LIKE '6725%' OR class LIKE '6727%' OR class LIKE '8305%' OR class LIKE '8454%' OR class LIKE '8576%' )