GMpOODd3t1WxlAezjeJEoliO5IX+P4z+G85nZ+RdKE+dYEPWkYduKKmcIzz78cJnX1ZqHfCd6i8b0JCwks25Z14oZG03HMLA5Kwi+LM9WgcLNdStZG63sqGZuvP8scw4VitnMCg6pW3GXDO1COQ1w8xaik0r8b4sftyS0j3Np6J6UbzXnMbxneECwTxrP/X0nCev0Uzd28g4GH/zCDGfWxVqNJmwI957OxP/rlHNoKckLMKuMym9UB+uGVZ1adU8s01otGtHwXDCVmAIOquBiGk1uUna+x6kz7wsDR+pGQ4J35nWQAO8v0xNHvuA/i4k2iYhyk2CDNHmZAwmcYgzye4Gdeq6wQYgdWyBLxFakERqTObZ8mIG+FredBk7Mi73qn1RoominsRMIT982BbEWOTSCa4FlIe+zm33olps+YDx58Xz6JoD8IO88ZYv/qWh4bdezoP5hWvrZ81marmw7tjeooM/CYmJUXfRXLzK4VIWtFgLxZj2c3rzuuNcEgTR1J6Vh4Es/6VOzC6cgTuxwGpmhzrW2oCYSEVAhVODpFbIzUbAhrdiZ2LnWJY/nmZHIsAYUrj68s8pot8mavrlC+GzC+rd1Yqd57jnT6ppVafLZWJmuVpZ0oBHhtZ+B8JH9z1z16f35I9bhbyiGzH5yJHJqheasiH119SIBWlrxlTnpP49H2xqIiOa6W7cqRZGnAtbCHIQgzdeXgPMxZxvyXXzY+KvECQBWaUFI4DTpEuHL+N2NZRAeKvjFKI14HdY4ocDazuungF99TEt4xIFHTHYTIy4OcXKfyUt2eB9L/G/RbxcWDV76pLhalM0fA42LbolX9Oj3KqQy6kbmKSayOagTg71vxbCkd7Aq0Pwy+iBaljV+NOfJwlYrfwIdXooMR+Abx2KV8/VOW1BaWYOD9NtVLjygeZ28qBYOj2eB8hOvvtnCsdfVYsYIIYFAizs33Ue5AR8tLpDecmBbxbKTbP4RoaFeYRidrqjBL43fIDLD22ceeMDcjV3L5QA/DApOO3lQnp+psnGlSBus9toYiDpf5gmf0048DFdBuW6/tbbAYa3+VhyARZk/txOl/mGDUvUs9u6snUi1AmPFAbf0UyaM3bRSS6cdPOWgRdcmKni/Zq30o6dmFYBp/Z+IMMfRy/8Xffh8XVPePsAC4rlLhneWIQwK7UInMPgbk4dnV6wuhM/OKorNInERV+jCcJpJ9Qe3jGMMx30+fngd2tj9lhVSQ0rfGPXuwZ4ZeLVyETf4xiJRLCiuXJrP4pkrSjggn9DEtZivXYn7UDaaCvrZUjGi4UA7FhJlyBVfYP1UOUCiDoM9U+9BCqzkYGVxyt4FoPRCFe2w3R7wNZViBb8wwOiJQ3OTHGxh+xDUjw=
1 - SELECT et.id, et.residence, et.bottin, et.emploi, et.msss, (eev.dateFin > NOW()) as vedette FROM emplois_temp et
LEFT JOIN envois_eer_emplois_vedette eev ON eev.emploi = et.id AND eev.dateFin > NOW()
LEFT JOIN residences r2 ON r2.id = et.residence WHERE et.bottin = AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT desapprouve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0')
AND (SELECT affiche FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1'
AND (
et.residence in (select res_id from utilisateurs where res_id > 0)
OR
et.bottin in (select serv_id from utilisateurs where serv_id > 0)
OR
et.msss in (select msss_id from utilisateurs where msss_id > 0)
OR
r2.groupe in (select res_groupe_id from utilisateurs where res_groupe_id > 0)
)
GROUP BY et.id
LIMIT 100