Zdravotnictví

>

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 '2644%' OR class LIKE '2480%' OR class LIKE '2956%' OR class LIKE '3087%' OR class LIKE '3088%' OR class LIKE '3089%' OR class LIKE '3358%' OR class LIKE '3754%' OR class LIKE '3755%' OR class LIKE '3756%' OR class LIKE '3889%' OR class LIKE '3890%' OR class LIKE '3891%' OR class LIKE '3892%' OR class LIKE '3893%' OR class LIKE '3894%' OR class LIKE '3895%' OR class LIKE '3896%' OR class LIKE '3897%' OR class LIKE '3898%' OR class LIKE '3899%' OR class LIKE '3968%' OR class LIKE '4944%' OR class LIKE '6397%' OR class LIKE '6398%' OR class LIKE '6770%' OR class LIKE '6772%' OR class LIKE '6797%' OR class LIKE '7260%' OR class LIKE '8356%' OR class LIKE '8485%' OR class LIKE '8810%' OR class LIKE '8825%' OR class LIKE '8832%' OR class LIKE '8840%' OR class LIKE '8890%' )AND (class LIKE '2644%' OR class LIKE '2480%' OR class LIKE '2956%' OR class LIKE '3087%' OR class LIKE '3088%' OR class LIKE '3089%' OR class LIKE '3358%' OR class LIKE '3754%' OR class LIKE '3755%' OR class LIKE '3756%' OR class LIKE '3889%' OR class LIKE '3890%' OR class LIKE '3891%' OR class LIKE '3892%' OR class LIKE '3893%' OR class LIKE '3894%' OR class LIKE '3895%' OR class LIKE '3896%' OR class LIKE '3897%' OR class LIKE '3898%' OR class LIKE '3899%' OR class LIKE '3968%' OR class LIKE '4944%' OR class LIKE '6397%' OR class LIKE '6398%' OR class LIKE '6770%' OR class LIKE '6772%' OR class LIKE '6797%' OR class LIKE '7260%' OR class LIKE '8356%' OR class LIKE '8485%' OR class LIKE '8810%' OR class LIKE '8825%' OR class LIKE '8832%' OR class LIKE '8840%' OR class LIKE '8890%' )