9W/fI3leroiPjg1dGkCr1LhyQu9Bvwy2214YTEJ76UEha3Rnb3XfuBLSrIE5Q3uWmr7IfmlGHkAUMgWinFb4fZPt2o9OAi3YPEPFJl5R8DFSBa0tPHWoJxPAjyr5uZKgVt8nvm4URM1kZMuJ1xV+Lsui0Mb7X6SnyaJb9TH3Mv9V31jSwBWSzR2PrT+lzGKkSHvzXTYHR9YlCz9DKD0Mnn4urhHqNsjuVDeQSkvnMUctVPJ0ABDT/Ha3fe4AdkkJpcAFuFj/6RnylNqCG3r3beFraZnpGp7tA02nZUmwHP+j5TT6wkRcPG7qQPbK5FxgUewpLa8kuqetBr2J12H+KcWoZbw1/mS0uiHabrvlRXzMJ62mKiqiuVahUgwF+R8VLpxR/iq2msjEng7NTriP7dae9iTM7w/xnMrGc+f9Unc6emPkrZa5u+HO6LIyApVGp75pz3IEPjS5YQsOV07h2eNJuLQliBlWmtn8TlZXjf8f791TFr0rrPO1lfo8zHh2zsQzyvnEuUDlxFbWwSNbUKZvqyHz4ogEfLJbGKqY8k8/QAN7TUfaEdDj/UszZ9/JDIwawPRc2QxUYhk0JvtQfdeM85v4Nmh4UV1JqYgLMIejEDHYpeMRajhdBkvyeuaYBhTiTx78PzLsmM09JxtIWQRL8wjM6GpKXrwCxwTeW853ddPSRT5QGKAi9Uk6EEDDOiuJcOAhTMT7ZpjoJ+Db5rdZhf01pXUzJslgY59XAXwIVdUuwcoJIsDJubFrWI+qa5Ld8GVw7gaLsin4ywUyW3zWFkDtazHiyPzovNPgkJfPogyAYTFkcNj23/D4NMbgkOq8YUB9rASwaPjGM5Bl1mECGtrM0puTuzvjjCfU2qpaG7iSBOGHMWF7NonthobsZAROUNSLLEdbqCYVeSiWYqA/RR+BHrn+vkUIPYi9lgunP3+3r8exv8f4nkXhSHN0iSPPkfuCqpg/3PtSZXuKlVq3hOm/VcuIOK9uJywVmneEg4RjoNGq9Rmy2vtNfF6uohGrJQ9NvmeAkjvyDNUc1XBqov6VyAJD2DJD7c0IJC1CPjioNaUa9pCC0yjrmE2d0W/b4WIOE6/zXYOXEmhSo8qxaJvEdqvarZyae1aUA4l8NbyQ3Thv5B5e/Jp0H5nGMV4VmBs2+BejW012jY1bq5zNc6wGjlRWzIFT+6ZeK578haxrtdHfleNbbvtZmmYjeE7cVQ3YBkYVANyIuSQfOZfRcVe6VxMJ8OMJP393SxWJZWDBjk87AHXVwKCz2FtBP6Fa9HnxX/u2jzzCNMOVJ49Plu1p/1Iwn6tb74hUcRpjBsOmkNHMOMJwpp19e3g8pAkzbLnbpMsKAf7ytagijFGB8xjHeapazWNbLq8=
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