y7/N6+AXnxL9KGVHgS/fE0EyI58TWzs6Oemtwkyf4KPwz4/xPOALGvia0hAjGD5HjyIMt6z4sNQPUUhgFtMIW+Twd2txIbbuPZ06yU76+y139sydLvjX9A6LCUG9PCdKV5EgQPENU1BfNA99PoqvqTjss9dNmUjLphZFEZEuzNq9IHE86+haOYoaFILbo0dTsGRr8M97rs9Qc/VWWnWEyF/ea3r23qe3zNYsj5Co2kroUfcn7iyGsHq8UkiN4w8h/WA99XDu3aRtNQVfVgUejnp7wHLBDKdginISZIN+8hf9NbIoSkbdbzOIa5QssceEsvUNuJ83WRQNiTxJaZetcbnewwU/icP3Ly3vDmiXfxTtkaGLrAz1UP0paZ2Tyj7ZTYhwUQPpJZp3qKOufQQRQEOSv3MaChDrEdXo/vlZk/wOSiQAQ9IPznERr7MZHa5mGmgyyCBWa9FmGs3pmxAh8VP0dDcHs8bJYTf+IMWmZmhC7PZOQp6ps+Ys0ML4na8hY7qzHC0ElazEZvLcNwLI9tjRZD7mIR7w1Cg7ojZgEuknjT5iQ07I3x+A2fAz6xCPxyXXxpFZoIKvLY0lW50U8uo3LICsL9nXrh+T8NX5G7yxF0reSX+P509yjnGgipDGYXMw1ixeMz9oulH5alUkLleIDV0z4bdLIWJLkYCwA8hADnsziCLIqC+Vrrk61BIH9gJTrQGbbRX8q1ueArxSmeP4Ezt1wSGq1gF9mT1c2BOAXnadvGKiKVteYLUg/nWuLDw17QRemLiSML5FdNcWQ2SZx7z2d96OsPjfGqV31ONz4LzhQZ3E1ueOM5g89K4uP5KZf9JuSlDJdjBYs8t6XNNt7LSZ6gIPdRY+9P3Y6QPqd4GEJMS0t5s2qrfPpYMuzyTrp3FPBsMJCQfZtBQRdd8RJYCJrXrTV/Xl2Q053jOerUtrfeP+Uhq1LqA9qbppLK9m8X1o+3rov2TbUq77kI9ySSFOgNYSqB25lS9uhuiU0T//omCMhb58xU6BGs/OiR8jEoCMD6mIXpRMMdjB1LOYQcd5py/nf9Jh1Ts6n+zHIRHbXtVxVXGLah04784CjAq/tPE1fkeKtK3BiE5yCOtENlldAFhB6jrQUy4TRQYAtGqF1x8YuGr5E1cnLmQs6V1JIO7R4AHhQ3gwmqEXwMYSTmsr174ikxfbgadIWSbdL24bLxtw9SGcKO53uoNQFbgsvsuIwpOs3M63lU/ANBoRxFJQ7yC8nAJd9KQv8X+nwefV6AUT6/o1+Hi7YD5rKWJxvNCybSuON3O75CsR4BWoJQevy7fmsyUHna28MSGS6R+u3CPLIHs3qnlMcv0DS4cG+KbhFp+H35Gd1G0uZ4Dh/tUeve5yTTVZ1yc=
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