FR1shvc+aC6ZSxe5GGL/1KRpDNRH7NNjsoNovca0TH0xX8WIrPEuBNELxlo22Zk+li4JYA79QOwRZW6lEwU7x6zn5anM2ds7o5bHGMSYM22BNHDDFlVsxXGig+xmPDaGbjtegk7oo38fyCtOhkYJuJigQ/ToCAZThs1wIr6J9V8hBpWg6bXbkPmDY97xNzfhCM+64TGWxkMTcRgeSJdKkDGF1wgnZFSVONp3ZcrI2TdbWs+1h2+T7MNgqWvFbBmwXbvDxjTZSSfgu4uNQi6vn1Zsaj3zVr2l3/RnVfMS+ovvSkGWWxKqdpiqeEC6PgF+7N/aBtqCI1VHHm1S4SlQr5VVkaPqVBs8Oz2i8jCCPEjPDBmFM6EKgY9nV7+xyHkwd/omFqMjduAotWJqvJEKGIEu4iD1xFHLrpGtsJEhbJ620hBwdX2B9/biqr1rvOyY64LPlpManZpcMfnXTnT+mazd2XHbk1rGFfMSjpf0Zpog5ZCKHqt3yQQBdHOwpllXWro2cB2cR+OPfwsbZxLKaPxDzX893aAsxlecfoHdyHKWpBgUu6B/t98AiZx4H2BzxSdYJDJuJyf+J5zmGlgj3ltVVL/QtGuCmbiVn2hlKM62xeXWTPB9PtczPRFH8fwQvAUe1mduys2i1iIAuhJHBKWwEJf/0lw7Obs22ivJ1hAXi2+PwgEs9ZxrqeA6bIPSunFGpYkFpw1UtBLnREkJaUzlbaeCq0U5cyVIhkb9UIP6+gxY2IOY8H5ReP7WL9/ikx8a5V8cpuInY+vdWXX4MJMHoIbLn+D6YTfaE37Yog5QC5daIs167HwGFhOyQv69ipl6GBS2EuE/0fWW6spZC8mrid5gcKncAIMIcIpI4LAbiZX6dRzQVkZ2N7AoA5EIuN7BNiBrdLg6uHq9U5tXqimCWyTWV+pG3Y9QWqQYvHqllZSK/1S95vRb82Q+Jqr+2l0QGyoh8hAgxab515FlgQoWy7tp/QgkQjAI4tpJoPCTZ0ckC3EcgicaXSWsPULZj9LKTASwwLpNfSxCynbwxEXshqxyDmovMhgUmDnRkbaVzVfhALFgi69UsFkvKMd9nPmCyjW/kkEGtOeoND7DqMQCi9TaIY0rXzNr4eoqufhsA0vLkapEe2HWZ6D6V9mnBOTjorCkZFLsbJ2lKRD1UBHnGo1phRw5UPEz6bXAKJrLVPEefaT3A1J1Dg1UX8xi59Jqr3BePOeXAGsFr9q5l94GpK8nEH2209u/F+z9Gpb1Bdvkx6yWb4enLJg6SqIMJBPth+5nJ0x2iTdjf1iQHMK9Ss0Emi2+qL/C3SKtdrSly6lZdh26S0w++RKWohI/UYHBuMFurX0uTtebCRet/W/378yx/UsWWK8WM04=
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