Strojírenství

>

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 '42%' OR class LIKE '41%' OR class LIKE '40%' OR class LIKE '43%' OR class LIKE '44%' OR class LIKE '45%' OR class LIKE '46%' OR class LIKE '4957%' OR class LIKE '4965%' OR class LIKE '6170%' OR class LIKE '6664%' OR class LIKE '6714%' OR class LIKE '6715%' OR class LIKE '6716%' OR class LIKE '6717%' OR class LIKE '6718%' OR class LIKE '6720%' OR class LIKE '6723%' OR class LIKE '6725%' OR class LIKE '6727%' OR class LIKE '6730%' OR class LIKE '6734%' OR class LIKE '6736%' OR class LIKE '6738%' OR class LIKE '6740%' OR class LIKE '6742%' OR class LIKE '6750%' OR class LIKE '6755%' OR class LIKE '6760%' OR class LIKE '6762%' OR class LIKE '6764%' OR class LIKE '6766%' OR class LIKE '6768%' )AND (class LIKE '42%' OR class LIKE '41%' OR class LIKE '40%' OR class LIKE '43%' OR class LIKE '44%' OR class LIKE '45%' OR class LIKE '46%' OR class LIKE '4957%' OR class LIKE '4965%' OR class LIKE '6170%' OR class LIKE '6664%' OR class LIKE '6714%' OR class LIKE '6715%' OR class LIKE '6716%' OR class LIKE '6717%' OR class LIKE '6718%' OR class LIKE '6720%' OR class LIKE '6723%' OR class LIKE '6725%' OR class LIKE '6727%' OR class LIKE '6730%' OR class LIKE '6734%' OR class LIKE '6736%' OR class LIKE '6738%' OR class LIKE '6740%' OR class LIKE '6742%' OR class LIKE '6750%' OR class LIKE '6755%' OR class LIKE '6760%' OR class LIKE '6762%' OR class LIKE '6764%' OR class LIKE '6766%' OR class LIKE '6768%' )