5YCr0rSCnLhR3riRyyBR8KlfVAoJnM5kOqP0lbLBmZkanvySlqEAtCFHWZ9q9p5Wb2f2wimRxtG+oNeEqKHCY0ELiVx5ehk9y7HYiQawVh8B1rTy9jyJnYvQ9btXYPHH8YYMtojHc4fOd7BPu1wp4y3wk/Zjk3F9T11ChRpXWvlikcu8JvG5tzpj5hrF45b7XcaUVkFIHzBOiuVGwvZLTE0ndLKxA6DTKIvelEg98w/KX3oHbskj1lCWB+vfgfnKxeHmOndqgaPsAwLmSlmVf16GT7jyMZM0whtnspPWAuO8mKoxLLAC6C95F6TpDZSXNP8hafYkptpTL0882J0kCV4kqqd0Epq9z7i0tdIiv/TTn5DxRki6KZgW9AVNw7h4tg6QIos5e9Mb+jCJdhjYe/R/UAbjUWu+BPPN9Gzj/xCf1IqkQFCfrwjrIczSuTD5wnd2Xi5z946drBkDgFU4yjt54blbIyfXwyZXOUyOnLK1FSLMUsRjHMEeaUBCV37oIOt928hI7+HNv4dqzh+8IMcl2T3dw7St0ULlqraBpjJSdO4vTYYpku7osLappcIQdIHzvsbClwPXH+i6/J4GFqY6R3SEvqMWb5HdHPHXpIaUovVTduhmhyRZpB4F8wIuo9YzjlWXyZbjLo9sJb2oayoitqxF7EYwXb1taRwtJT6WYL051fZBi32fIYI2jqtZDSHm09u59rpu3HXRxSpSK9FUgLuO+fh4MHvJbZP9K94XWORWroykYVc91ABgMVrhoIq8oSwPJeQADFB65CQwR90MwFAAGPwCx7sFUEEBILQjzA26th02c5l+lbdOS8GKHahoSTn3Yp6BPpfeibvdjqlOoQ5p2w4I/ZSspC45djKBnalLPzsbJiAXjy6N8EDkRUXYrJg6CMw+XQ2kmosqd2jtvsw5cWfIOtCfLXz1iogrgbL9hRqUKN/+Ig7+4Dr6r0xldSa7q7zMUz8THee0V0SncujsKz/y56fkIUp11WD+0GrRERPCIwUf9y2hBokPkIqRvA2Ek2acIyOi/yEZgK0J8x+vVaiv6G7Ocs43hIhAqDB9b3alvTOKn4/WNFpwt7HJ4hR9kvJ+7KLJ3hUf0N6UJWWffsYt6jZxpUL0vd210m7o233RsNK8DDWtEsh3VYkwH6gbVyz5YTvqxF3VqghnUkPiVCM9Pg7c888Hyx1LkXCFE9CdjnMYOCrIeZON+KPvHA8pHj2FW8DayBuII4PSQi/epWymQbd2NIL7VvzfWrURLQr7eCCgTCkGTDdut8It6uQnphWhbU4ZZ2V1jA/SzFf18DSg+5f5jSiaTOU70K0YxAg5ON+s37pg6ftWw/fZhX89V9CGsG3tUFF7FMz3jt9aJ56RERjJ5ug=
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