YXJ70gL5T3ajziw6crT2d2ghy7VVQlZfwxjwb+qjI7pTCpVufvyRK4ktB3vwq1SfnaxD4jyqvovKqBOFKtVi//TkuPU/Rh4gAF0M9A+O1I0D2ibz4y1RvJk47CyREwNpFor3YUwglm6WQYjuC38+UFHdt32c7UT3ylyvzFuho0BCzmIX3OIzcrivMjzyvyMDBg8+y+sP99IuARDxUNC2IftgD7HqQBqTtrI1huodzlfsqiwNfll2rfhZlC0obuY3LPiA3maWEOxpgKsvgNF5GhYCvQZWMd4QAtD9A1PWimLR5mC5TzZRsCZf+zJOqphmaJDQ83RNGYOnLUBaqjuv+CrDlTg/8IH/5h/vaRLYehFunSQK2Dzo5/jHNjjFbdqpdD+BfVOGIkyUJmz7Ane7mzkqdFP7yXo7kGRdxvWeaMSnDeQ0sxjSvg/UnMV8nq9TF25hJ7PCxdsUrf9pEvx8zJPhiSBDTbCEZmVG1S3hI/PUO1UmpFV2+TiuuOGPEHcBQwmPx/uXlXlg31XeT8C70tdsea2RFVyqV3IUsDgz1ib3gE943aQOklnfyoyfuQBAbQrRHWTIvGjTSPyZ3gbXV5vimdTHAHa258ZHtuYLOUsHqDxEKOsKGYfn/39XMt46qVTw9cHs865RnXc0+WCKWifvyBdJiHogx757GbGTBg98CpRfl2gjRY1P6k45c675BFkvo5151U1+QXH95V1dbpfN7/8Y0eTl2slLjTFzxp7eeVvK+yhcgSRge64aQlOfulIgujweTYPL3ZYzxo43FtEacqI797WjRSXCtnx3yTl0qNtgd7YitTnWSgkAOXXcKdIu+oo+628SnmvU2I57xBnT4Q5yXrNpHRppCksdHZP/DN53Ra+t0pbHq4eqdnPPa173pTeyFjFenKmQwtoRYnG+qpJBl8k82qF1coZKdGOp3SAqB4OemDx7tPHnnoz6JdnC4xtJZWpUZQfRVOvIfukulVDiH5Lb83w+ulUB1qHMHtYt7JRmdKH1UBfaaN4Z05ezpdlRjjVt3DKBUI6CdsuEkHbQEY9pfoEmkC+GhisEJCiBIJyGU9/Jv+h8rF5mmRcrldisHc6Dl+u9yNHo0TWUAi4GOZzV2ObG8tQeNkD3rApfX0wp8RjIk7fZH1bF8owiGtt4CneR4s6SBJSLdA2o/Zn7zzJZ8oMrwqIbd24WXtIlSZHqdiv/jpjwg6FHy+wBXG87Q5NKOcuV0NFMbqjXzXM8H1PN9gIFW7NBvYw7h+LXYagDw7or1NW5hdN6D2T4itIidw7Y7ROt1gGf/5s41R4OCjEUxXeA4cduAQ53aiapFW3WzbpWspQ4ZipwziH1O75z8jm8LoYLC304JWVF5SPJyLXhVuW6EE0=
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