MEooEKY897fA/r0Mu8nS9OhQjGO9Tl8Q8e604y3iKp+TFx/1OwclFXjHNZLjUwTkF4RdpqslTRtj5MBVDatuntT24AKf51x8IqeKiNUNff09T5kN3et5q+gcNEjBPtFQndx2e/1zO2IYfuonUNUlN0z3DIxGAUmLr4NP3UYiu2S90unlAf/lnL0p+YaqYTMp4N6yzWzhY8I5n4L2nwR56AOfFtovOH/PkD8SCeaLDu7rlLEEgIZg0nVW+jDyDGMxCtZ0dpNJLv64BIQqHTbnANtm2xrtcQnfXmP/96FspAdHHuGzUSdqieBdR+jCKMqqiTgC1vycUwWyT5g4UaHAeLWWv8kXwfUa9ocNacF4AvxHfL8tT7a2+w3iN0TZIG+zpFGR3jfgAV6aYiQHq13CoahIMkOjEIcMRj878cDqGqGjcU08giGeP35+nroT7R4Bqmag2y6GoCc5QDs1BtFtfq0rK/yjxdVhmD2rWtKZsqIf9Cjzg7cMLL5OkN/IsJE8eDCPDvxh3Ps50Ee+Ssq8ymGEaYq/CZCYQAuWS+s0I9Dt80nDEx8pLBnUkGhOc173kkJN/O2Ho/XQoYKTMyW5ITIvx4qwS8GE8mNqIgpOBXRj8u4xyTuvh+PYetQsYgwd3nAWP7b/OlWhvxh1MAIdcplOFvORz411xsCgcHeskcvvWA5J1MEPs3LBdoEm/AMGEKKHeA0kyiy1t6uFBqaKC2vXMWiAaJr+erjCazL3nnm0unFAVT8gGoS++xlvfxObOGyqLIDbs47sc1svalW6WVZHCXPeAaCWwdTCt+2/KGyqDF7Cf73nda3sODmYVL+swVtxRcBMW00tMlotC5Wz0fHRAYmkTyzA0+im9S2XFIHpJno0vc7+qGPWff3cytqitk8owD5D/JSXv4AIeYEosJJKDXKZKxrxl2Ba2UdhKkjIE+udZElZMKoYbaJmxIMOSXs+qn6NkPuLX0TB2Q+sR7fvjT8dhnQktPHCjZdyUqzXyBeVZPulqQr8Ielg5dWDQxwIIC792ih4QonsDtmNOU0xY1ryxFbH+3YXT2r0kKrqowbfu/UtaRieQRabWAoDHXvhKEkeZj5CpxFfRzO5baXFbGx7m/K2tghWmCORSym+NJ0mS11B7C6ORMbg6PD54iMPooWpUs/Y7Y5pyjrbPl3H/IMfrUAteDtRbc+6xGOigwlXaTtzGVpBQUiJJfX/ENbEfWOPgexwxTOE1Asdr9EBrTSzk68xWgXBKB7gdL8fesHGKb/yMIpfG4CivNGV9++435wC+KWy21opF2UaWH9IAD8Y+lCqvnoJOTk0MUlYcdNgzBar6lU9VuEtnDOsrt5OnMAHU8qvhTy7Fiti3Is1n0+i+R/sE97PmVg=
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