wYeiSFHyb27FTOEhQNSNK3bez6RDKHd4nQ3BnkAInBl7jY/NjLsP+nHGMmAKMNt77I0AXNUZ6J0MTfMGkvBbj4eEh72fzBmJCBTvTLvJL3D0pUI7cQ4dpnp7kR13wPLVCf57Gbqol7kAvcugRAwqsSmsYYh9Vdcmk04FibKAo5hgrfXJsX89KH6i+e4bbbSzvBIS/o1p0DAf0I3LGl0wszGVT+KhCTx9T/GiA7Qscxz5yspXG23p4KyRot30JxJDVaM1e+cPh/TxrsMmg5ktpgknYZnYZYW71priU7e87Bmw7ouZ0KowuZ4jXEgoRcs7c1UAt/zBagnQTuWBi/AsuUc0oDUQsynobi9rLNu7l9cu2pZZ0B6OyC1LGjIDPcY6x1WZ2ZHN3qKcMVsYDO0Fzs1Ee0qTfqdF5iDwyhBv66oeYqDbSD5GIEDxmPouMoupP7H6kO80jnV7JqfpMJ4Milt32g9ZOLrgrMdpho18GkXKXKHDs/oq4qznAzAkvFw7p3rrIyV20z6HZ1h7yBDodMCJkn6vC6WqDMSwfYqvBOGqrJfpcn94Hozb9nWJStChHknGwMYa4Xt4ygCPaakHpCHFEAI+JWA+uwAGlvtkHcXOEUV2+0ID/Rjb46LG79cpsLGg5ZMNCUzxNh3jAc6VqyRDnnoanC5POPCYIIXqrGdbkBqeUtr2asRo6xCrvQNYgVSkrGcSfm5t2JJSLC62yNZiaPScVPIX7+Kl9bwB78DOLKQqeaSvw5WDMjBDzAyMkIhgkjaB2mA+XvZrjCKPYQ/PQA6UJYk9PYVRUE0OpmMjipcsPCUnp86Ohsh16Ugz/9Ino9U3bFP//N03MVyjNDo/NwdApE6eRJ1moAlQOU591or8ye05DMwXalYPD8ZMLjUeu76KkEX0qKtcMLjpMrI8QhjwQN0fIEGurdJaEoYdDnw9X77+P1TtOW98wDhFW1xS1+OWnNBi1CCjYYmneMzoMOcr1E1XsqAg0GnNXCoXjaKSB+VOfeV/j8tlWm9VUpGDq0pm7OoBQjdz7TfGmD1I0gMSFAsq10vmdi3z60gXDbcmOIVY9w6KyqHU427cH4qisnNnQXsw4RDZRVB9w3q+U4TXYCJf3yR5duyJ8jiLWu5gIWxbYgLOxB+t40+EIxgrLOP9EaFni8y4drKjnDVKhsa0HEu1hsDa00FG1EmPcJgt8EJwLwydgjl6I9BZH4V6TZQ+gH3P3/GYr9tjOdVA0FTsaAf1Y4QOmxcbhb3lT09fI/kMqpVW5WAUiSWLyS9Rf/n2/MlgTk25643+R1UEsWLDJ0y/AtzK0pYpSauqvBaSJHHxdM1aft/mkWzPAATuWPU9lIbpJjo9JW93AhjYpYCo3PAAiu9tylc=
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