Stavebnictví

>

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 '3032%' OR class LIKE '2518%' OR class LIKE '3034%' OR class LIKE '3036%' OR class LIKE '3050%' OR class LIKE '3189%' OR class LIKE '3244%' OR class LIKE '3246%' OR class LIKE '3256%' OR class LIKE '3291%' OR class LIKE '3301%' OR class LIKE '3307%' OR class LIKE '3319%' OR class LIKE '3321%' OR class LIKE '3323%' OR class LIKE '3325%' OR class LIKE '3326%' OR class LIKE '3327%' OR class LIKE '3331%' OR class LIKE '3333%' OR class LIKE '3334%' OR class LIKE '3375%' OR class LIKE '3381%' OR class LIKE '3502%' OR class LIKE '3504%' OR class LIKE '3506%' OR class LIKE '3508%' OR class LIKE '3510%' OR class LIKE '3512%' OR class LIKE '3514%' OR class LIKE '3516%' OR class LIKE '3610%' OR class LIKE '3632%' OR class LIKE '3633%' OR class LIKE '3634%' OR class LIKE '3641%' OR class LIKE '3644%' OR class LIKE '4518%' OR class LIKE '4532%' OR class LIKE '4534%' OR class LIKE '4536%' OR class LIKE '4544%' OR class LIKE '4546%' OR class LIKE '4548%' OR class LIKE '4550%' OR class LIKE '4552%' OR class LIKE '4554%' OR class LIKE '4556%' OR class LIKE '4558%' OR class LIKE '4936%' OR class LIKE '4958%' OR class LIKE '51%' OR class LIKE '52%' OR class LIKE '6670%' OR class LIKE '6680%' OR class LIKE '6682%' OR class LIKE '6762%' OR class LIKE '8340%' OR class LIKE '8410%' OR class LIKE '8412%' )AND (class LIKE '3032%' OR class LIKE '2518%' OR class LIKE '3034%' OR class LIKE '3036%' OR class LIKE '3050%' OR class LIKE '3189%' OR class LIKE '3244%' OR class LIKE '3246%' OR class LIKE '3256%' OR class LIKE '3291%' OR class LIKE '3301%' OR class LIKE '3307%' OR class LIKE '3319%' OR class LIKE '3321%' OR class LIKE '3323%' OR class LIKE '3325%' OR class LIKE '3326%' OR class LIKE '3327%' OR class LIKE '3331%' OR class LIKE '3333%' OR class LIKE '3334%' OR class LIKE '3375%' OR class LIKE '3381%' OR class LIKE '3502%' OR class LIKE '3504%' OR class LIKE '3506%' OR class LIKE '3508%' OR class LIKE '3510%' OR class LIKE '3512%' OR class LIKE '3514%' OR class LIKE '3516%' OR class LIKE '3610%' OR class LIKE '3632%' OR class LIKE '3633%' OR class LIKE '3634%' OR class LIKE '3641%' OR class LIKE '3644%' OR class LIKE '4518%' OR class LIKE '4532%' OR class LIKE '4534%' OR class LIKE '4536%' OR class LIKE '4544%' OR class LIKE '4546%' OR class LIKE '4548%' OR class LIKE '4550%' OR class LIKE '4552%' OR class LIKE '4554%' OR class LIKE '4556%' OR class LIKE '4558%' OR class LIKE '4936%' OR class LIKE '4958%' OR class LIKE '51%' OR class LIKE '52%' OR class LIKE '6670%' OR class LIKE '6680%' OR class LIKE '6682%' OR class LIKE '6762%' OR class LIKE '8340%' OR class LIKE '8410%' OR class LIKE '8412%' )