Elektřina, elektronika a nukleární zařízení

>

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 '1245%' OR class LIKE '1810%' OR class LIKE '3072%' OR class LIKE '3292%' OR class LIKE '3432%' OR class LIKE '3433%' OR class LIKE '3636%' OR class LIKE '3804%' OR class LIKE '3810%' OR class LIKE '3817%' OR class LIKE '4072%' OR class LIKE '4073%' OR class LIKE '4078%' OR class LIKE '4774%' OR class LIKE '4776%' OR class LIKE '5160%' OR class LIKE '5246%' OR class LIKE '6386%' OR class LIKE '6585%' OR class LIKE '6658%' OR class LIKE '6780%' OR class LIKE '8470%' OR class LIKE '8472%' )AND (class LIKE '1245%' OR class LIKE '1810%' OR class LIKE '3072%' OR class LIKE '3292%' OR class LIKE '3432%' OR class LIKE '3433%' OR class LIKE '3636%' OR class LIKE '3804%' OR class LIKE '3810%' OR class LIKE '3817%' OR class LIKE '4072%' OR class LIKE '4073%' OR class LIKE '4078%' OR class LIKE '4774%' OR class LIKE '4776%' OR class LIKE '5160%' OR class LIKE '5246%' OR class LIKE '6386%' OR class LIKE '6585%' OR class LIKE '6658%' OR class LIKE '6780%' OR class LIKE '8470%' OR class LIKE '8472%' )