Telekomunikace

>

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 '3730%' OR class LIKE '3731%' OR class LIKE '3732%' OR class LIKE '3736%' OR class LIKE '3739%' OR class LIKE '3740%' OR class LIKE '3741%' OR class LIKE '3742%' OR class LIKE '3743%' OR class LIKE '3744%' OR class LIKE '3745%' OR class LIKE '3746%' OR class LIKE '3748%' OR class LIKE '3749%' OR class LIKE '3781%' OR class LIKE '3883%' OR class LIKE '5247%' OR class LIKE '6782%' OR class LIKE '6785%' OR class LIKE '79%' OR class LIKE '8376%' )AND (class LIKE '3730%' OR class LIKE '3731%' OR class LIKE '3732%' OR class LIKE '3736%' OR class LIKE '3739%' OR class LIKE '3740%' OR class LIKE '3741%' OR class LIKE '3742%' OR class LIKE '3743%' OR class LIKE '3744%' OR class LIKE '3745%' OR class LIKE '3746%' OR class LIKE '3748%' OR class LIKE '3749%' OR class LIKE '3781%' OR class LIKE '3883%' OR class LIKE '5247%' OR class LIKE '6782%' OR class LIKE '6785%' OR class LIKE '79%' OR class LIKE '8376%' )