3Y1SAXGL1QunqlhXrnIwWDi/PhsKs2LzPAnQeYqDzLoWpgboB7FP6+QzluaNMyRQkgzObZncRM75IXfmcJaUMMC7Sk8wuneGQ35Fp7vl3yojxwVkCaPap91rNropOWymi5SFszGIa9F8uh14d+8UJCTqFzZqm98wzgUHIxM6IBR43jm4WJVT7cNQidJbuqsFm6EU4jqmXQ/Kx6CyWVa7nTvXeZYICBymH0xyF56V6B+LliNeZbijsCyDH+BtZaa3+I9tIhDAnuqOzN9BH5AGSxB4PfW9RhSbOEehbpXqSQO9KS9QceRkdvk4foSQDulAUZQmMMBvFNRVddQQVqVlAshk2k/pZAUKTIq7foxUQRmQZ696QlbLIXFk9oTSDTzHT3sZS9AfAGcvKwV5Zr5ovsIBWUMvV+N5rpCegzaR+vuKQ8E6YX7QbF4M/oCPUKg0w95CyvKqmzp4Zdd+S7vFLmz2wrA1Yj6Ypn0jBLUNr64l4vhM2Bzzqu5T1PnlE8I0ocdJoYNeTBZQHe32Oor4gA+RklL9khQMrSW4En+ImXs/e1P0U4k3OqWhKlAuZvzKY79ve/N1lVqaSUaFxCIIQZswQEn21IQLhwy+gCXA3WVCkKZf2jBAAHPv5fkgceogi/FW0CVH3NRrlwDDVi85l0mLIRtsLDac5b+hvIYkfm+vWS4MooSiNlqymH78vUnl+/UmWXLr/0s7oCsNJVP5wYKuHwwE72KHqiri27Fvv7YhoswumsTy3ymJWeZdmLF94XoXDSVx9sB1V4AytTM5aoY3MaYBCsIq6WX1rg52fxeV+Cb/HihLJ1QLnElEjSX8XpI+42S7GX9/XnjFoHz1BEyzZLL+tApDazq+dnJWO63HOjJ9l8dT5n87VojJSlMm+ah7Km1HElcSG4/EjwKN/VNsCrkb1PJY/atsVljpgnkFGsfEoEOnV+k+v8OXEchUnA+g969NyOqZeA+uEMD/SzUmfQMRcyis9Rk7liHV7qbN0WjTv0ZbBvgqBD6Rgsvt+oGwA+hbeCW6UeXj7osyAS/2+TdagyzkIn9eN+t5RRMhBCyhDvpA+lOhZ09P0gmmX1YoT0MpMs4bQ3ynSwXLBmBkghWqB+GU1ukcwhfIwKiPaldaREzjozMsTvidC6tMXEgP1SpswkMVA0bV58qtistCN/um4C0yCx00hpSGa4HLpHYo/DHFl9Oj4bdaYuUmDL2RojGoyIkAdz+RyQ/f9IHngNMEN1iHaNkW4gTRSh8Ijkko2V/6s5RvsrLWCl9l2vXyM4fBWS2BpnG/uAf5Ns335DrvIXIKvMLV9XhNEnzzndaws/wogXWVpgoXX2AR7bnbZTRkgE6ilDzAcHR2S8xFJaqBExdkiLQB5Qg=
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