bRy7hw+AIrI2bohHo4fjquTtqWlK2hWvg10qDHfZD0qBuMlYul3eO0I+QQjpdDhN0Itr+Hwu3Uwo2dKNHgFkwVcpbADspooClWy1h+ctNCEBcnXiqAtJXu4Y/2fDiM1eUkzgHlX+GZfqeyiBoYFkurt4DjNxk8Y6xPxE6Sa0R18FfYqQN2Azih0UI9PoYQg2ZBIwCkhoWhAryxJFm7htMy0QUfuw6LYq2JXH1aZkd4nxj5Lf8WcpPTIPBYEkdGZjGt90v51d/bYLYUTEiNfzXI67qw6qRMgCySPd5raCSn/tcLb8U6RsdJNhbs26TvhmXnTExFqkKcw1zTku2SULGiuIxOMaIKbQVUlnXEXsJq1YgvRWCF7DeXQq9W0dzuU9S39sqShzgMiwX3NUyPimu54tcOmqNslP6TlCffDg8PyLbR7Fz/LIh90XxgN6WiMcHJaiFEbIXXnpJ5QZCM+CXxALydZrPN4nfxhcyZdP+G9Isd1eWmzjR3HgqZjMEoNEvvoYj2i+jNRlVIwnjhimHeNPrmvYE1FLhr72ZJJ9XztDYyC5GnGNW8FoDIKePgjUOG+PIOl1e4bYDRNQ/cUGCWbOIWiO6ollepvsYMDFFtZOXPCSYBKr816A22cZTKv6wFxa2ETmyG8ZqH1GtvNJnUmsX1oHMWaV+u3LV3FLDCJ6eGo6x5k+AcgElg3RqfbIkU8+vZ628Vr9KKGZllVN/dlQde5qUKgtpyw4QUrbTERIE6hMTRv2ezpPVFWCraNeCWtCcWmBaO7yox5kUrIaPId61hDJ+tIyKoVsX96YgxN9FzZjhgrVnX0s+yrWI/GDnCxNYGpU/QkJcBGhpFlNmjXcxE2TBv0ErMLAPTuo2puj6cmMTAmqpdn25OKrKghZNhQCr+kgEpD2FKKEwC7Z/Nyo3n61hSXEOfEBcLgwoJXt1NR6BSGAUcmKV55NgYdFTdLXyWk4Ow/TDCKD+TCNgoMrToRR3DWKltYwMsGj4yt8PdPPd60i5KlXp6iLDWSaJTuwvBg2IpKWV/aHHvmzkSIm44z4zypJkmucbO4tNFia7NlEDxwA06wOruoM9W5ly7thYTwrnFE1/lPDd0B5NNr8K1VaeBDPlT9F/HqFacfFbcgVkBURUTpP/tE1ym1ePcDlkOesIy/iu5zHunILtqpG69p2DvtfUlj43U5Ja5r7DDoLqzAXC/NHBp6ckGGa+dTvAaN+wK3uWnPMUBnA8PVL27RZOP8Iey8J5Y41VEDS65+hXaKGsyyv6NCvmyBUSXZ2SUGP0J5I3tftmN1VOlcHFsjvYyPNApJS745S9LQQQ+nhMTRJzI1JZ25rDsRTECjG5M5XRKkS5xlu+BF0Tt0lVfh3X6PdX7Y3Q9I=
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