YCiVSbsHEEg+xtUsVrDFDlMQwPNsT9zHSjonNsVGIWU4L63AR4EHUOiBqKT9I9SmlCE9NOAt3KGbHPtanA6xHrWjxG3CZA93FcoWv/liNl4T74tF4KQVCvkm5ke+gX1PVUUrmwI7mWujbPoknChbF1WgncRtC7v83e8Teyz8Nem7xeHr00eitpbwzWLjRim6GwZj38T0IZgPVjkRca8VPkDpa21g6695WO6iPF5s7lMnpKhiMVOJ8iHDB6VEtqM0THXO1F6zJRHuJOvuFyyU0ErnrLuB9c1SztEVk8fOeXW2u0BUI4MsGeAsoDYOc/+BSKcX4Gbs9v2/lqrq/dVGxrauR+03bW06qSg8fdNeZIgHYXd65uL5lXn8VuRSQtnqs0yH504UOQRe98BKeev1JI3WBq+/JjjX6BdyhWWU/Ioa3ZN/qZp508DtvU76TdVVNaaLmMPBSBCXTwAb+rUGLHRVc/zcm99zGjKyu4dEO6nqkbco7MFm5iLYnWrtsrWWn4G1nlYU73fyCajgw+RBmGp+s0qaj97khpW2LBgl8NklNEknJcXd2lTNrcZSzO8GXZD2ZJd+mprCR/J2BH9GSiPwHkvemae4m4IhChP12NSb0CDoOYttX/b39w3VhyAG56VCC/P2FZGeruFeWl5QyiTqPj3ezeuJi29wLwtfqUzgPN257Ay6hsk9HrWaH+kODVYw8vWUnp1O/Xlon8iCDRsHKH3d2rGcLsXWN1LIHOX8SzON2dCOKBM0EIp7rwhuGY9gd9nUiRJLtHAJAqHluQztvjay9ObPX+gUPd9Cwy6Elcr7N8xFW7PQJzDvX7QtdA10+OL8NIstJnmu0EII25ssFNxpXrxURSU9MCGg3Z6Demkq3M9jYfbwKEGKgdrircTPS7HPfsrxqgTdFPGHugLOdYw/KrvgBe19e/BL20SkfOpvojSbMRcJveHjJtz2UCKep+7+j/0VMphiQmuOdwkuuiZlvzOEp1szQwDVNRac9x2S+DagAUzH3p+KZZWwhVfXEFuagy2xHvpaEkjlrgNVwUU1GGm5w2k11MXdYCtLfiYp2zbZ6rrlfh+rbME0BK6FZaiIYWRGzNSUWJN3r4TTVdNO7oEMJq5vqzJr9yHZ86uozapl4PbiPTDACr9toVTbMUIA9fhvaL0QpdVEf8ZeTzpJagHtwkJJI7Lbdy0VWh5gkU45yrX+B0om3BdsrrmMoeKH0RroUqndjbhQl/DW84De4l+gbfkSvOuhY8eudc7VbTEaOJbGJInMcrcKY8vfy/Swuz45SemgTks/PR6DZbNrZn+uGB7SbZKINb0w9Nb/XNzQxEhYfg0e3EWWoIgFAaPYC7iZIcLvDVJgzMrrNqW1pmiq3TXeDNk=
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