bpsjOt3jpvMMjCMeA0eLF+1xWkKHPYd1CSLh5YZKGgr5c0pWaGJbUuReZNJ8j3EbxwZ1kd54139BsecD4tZ6x/RXbtUQFrrz4eQ2EgCpIT44svkqOSrLS11CVX0UFgvBC4VOJeW3HWV/Ep5pY/H9M7Dyaq1POUckFEPZc/sFibt2fvOO/pkL9oIIajQckehfQ1GqU7E15qpBYcO3klFm499p70/mVpI9Z1khbR0fMQOQ1IEeF/+4SW9WYVJglNdGeYFYvhIIFsLVHWthl92lgWIdVFJ026jJY/aVana4i0gKeejlStLWQlvk+b+qIPXNVj2hrA6l31UDCz64cQWSllU6gBdNfNmoZ9GLi1tAciKyuf8z9Z3m7vm63OxhaDVL39vhBDUSF6VgUCVuid74IQT4RsNOIQWUQRcOBh26Bq7vHjnI9B9OsOpwWiGNyLJWZAGA7UH7aPdWPHM7Ch+1deYk2R6HCuCw/uzIW0aoznFIwShv/NpS1OlouxQlRf5WJyW9HJJS6zJZoffeOS8ymEl5qCBxX9jz8vfmKgFO24WfEiup550qBawfW1eqc+OLuvOcRxyptYme/Bvm6o8uxEWLk0PRgn9ruOQaplSNKLr7KDeQv1yBll5JKyjBrX8dwBj0xV6I2RJyWgqoDnlcnBpPes6Xhmvd9dpQ+1VOX3R1qe0labBRdNaXb9dA2sJIgRiJ2sk8xYv9xufiM08CQqHw1ubn/7E3af17uJgLe8TDx4sPBm/7/NShOA+oaebnbpmj3KPG3diUn/hnCrWrKAFNx3dXYgZ7srBGxjSnZbjRhHUjmfC79jT5WCLp0n9W/go0bp+R4EXd3njdPadEKwitW2EswCIzGoRLI8DiQ2Zl6XclC2Y9TuTyfadRC9q8WNgttRs7RzYfWWARRocw13sC+82L7IT1QNVrpaoaJoFD/BOalpiKVG5kXgLS5NVmoISbIz/1myxMn5ha7syjDwDjvvuNKmnlU7bm7kE93zlAqR4Tp/7i92KrZ8l+t4/68DZPXT3pkUe8b2tsXPQOL73mdkqizB+IMzNA4JKU6kaQNBolj8WKl/UKVCRSwesfrs5DNBmifcfL+q8ZyPxceF0IkKAhZWHAwf8ZCgml9V1ATVLxqi/RnBBoCpu0JkDFs0h3VjKCVCWqX7mazrcA2PzvdLGj2Bqx/sHfdGK0mkORWj/w0y/zC5fEcKHOrGRFvxltUcryqVC16rhPV5qZKj9T7l10AlrJlDIuNHNt5GboKC3GNGm9/mk+Me9VujLD0Q9wNFeSf6MbpLDTF46BQwNP32weXaEL+k4uvyKdE8bJxY27vEKUghQjUNYLSuQiltvYUrMy7gr0/hd+UTfd3HCQaGFT6VoomraVV6g=
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