xAP+0FcnUK/zCpZA5PulTVl+Gt4UEIJKdFOrx84gHPdSP5U334CcKIyU5OyQ9Uowkfd4rGGqX0PwIjowxsBFQ9850sB/01BUAqyzy9vC6Zw8sARV9gFQ5Q5AhxU12yWDHCElDiUVY3UwAMbt01iU9KcEPutKuQQMDJp344DcjTfEe6TvpKh7yZiuTvwwbk9EEj5GHE5fEpwBUlGFb/quS4HXAIqJsn6aszvqjsNxd2Z5X0QT/ZFSAAE7Bp+nBSU6k4NWcFK32LC/yU8vL+HLrLAuJfjSYpkLKoBfUhtAybSJ32gEfZjx8ZZX7er3WOjqyatPbMnHIsHHEhVX62LPkYMpM4EVl5p522IAKE5MUtl4V8yWKhpQXBKzbDHVBjNEnGDxPUgOyIdywEPm8aSK1ZKfnkmBBeSf1iKOMaFAWVwIDI7xwtJCD4Sz/giLCP1kwU8G1i7qm4DW6vFM1yDbDcKdj9G2nHP4hP+3NEOjUg4l9DPW2DBKvm49EvxxracqbklPuuhn3CDu9/mTeYPEBGb//NVZhcxwaS3I8MQtOX3A3mIqa/rOoVyQswenotrx8X20MsYijPN4n0ura8lps86g8Ltq9I1HlcBWfUAip54vkY6tg765qUE1FGo8rY7nWXCag4YMsDJ3cGc+z1Qe9WbSO0EVdQ423TGDZs+uO7RXGDfASIUBeRkwFkC0ivb6S6OUEDJ1KT6VS9Unj+evdLdIzoAZxCG93Jebd9YRcSZlAROTLuw6J1aRDpMCcRoVdZhVifLgBmJgOjI3hDsSezGmLvbukXQXWU6x3XHCEpI9OOVZ1FR1yeQh/X2wP1RzPFMe3dywodgUg6IwHWz4LRIC5l3k0/DSG3Qc85TmS8c3KiWJKE39DCNl58BvnjBz2f1Ma0H7p4VZVDQIYKfkpX3j8/m0EE80d/XTflXHp7gGrSY4kDX3A97G0bAO1zu8Q46gj1omcYaMdchi7geZU+auZS9zB/iWwuSRe/gCFpe7h62t8r7iJ+u0G6IzVlLGA2YeQjn76XNvrXm7orkGN4iQiT0TdlwqZOvc4Nm1lPTISZO7HRQ6yQ6kDILsEL5TgU7iF9FXsw7BHKfk52cLcA2Z8eLQrvvTPtgEPqmV7iNnMflHjUAxSFxl7hsSg76G7p1fUGuSBrIsg5ef44sc6cEesTSg+ij54IKx/SHmfbLQhE86+6jo0aQasdtqU+sf8yvEr0Qf3ktfm+J9Zg38zUXMeOCq/XtDEPLdAr8/YM+OhVEySAsazjs6iSFkiIh+UJv7c3U7gPPnFSFaZPi3V45p4Q/Mx+Gv4wDyzRY4fQgooSILJ9Ne0leffiGF79pZjhvmehH6AGBsUAL92JN8LRG6ddT52vJ01fM3ZHI=
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