Fg5ZgEBzCPDBGqMWIAaDntkmYqS8D1nvX0heysSLKqVZU8HwAlpGzk9mtuC1xY5ZY7U7O4Ox7LkW66w9uFuVoEBWvRbLd0LFB5SEZ88A+icdIDPoSUWgB6frFKIYeS4fQMWV9Pqk4/95bnajgXZawWeT8rLa+KWFcD7BRt4JJt6uA+Cil3D5joFLH4Omz9f9cCrjqZBTcbZa2rxkU/ou71U0+Fl/OTp7xzSNEIGFFIIwVz8SPZM4WNPuNgknSxocklqSGlvp6kagluA2jD8w6BEUszzwU2hajJEFW8Pw/1pO8YLe/t/xjb3o1MHipvgUqQUmAzXHGzJZI/wtLRmjTgmbVdYiRu1YW1me+uRlDgs8Djf1zehnXmUptt3lXoLGWNP9MSCdTZrFeXyQ5xgjTHgbTepU+4h4NxxzmnNRSSuqz1vkufu9qTvg4RmnOMCQiIocTn6D8eOjS0lgFiNRSK4YdSV3lYWmDPUIEaVuyagFMcX+4mByIEqHZ+STUgpQFYh0ReA/skZR8AvCn2tKT4OeNNkd08N9sLKnhNU5/wCK3KkuWrlWEMJb+h21JrYMXXTUDEM5b690BsgDGNXJT3M5NglzxV+tHbvRP2c3lXIrnoply46JyAvVS4QFUdAugAgIf5g6aHpWGbudFshkzitVNotSu0bUSGwJTErB1dvYthd5Povp4ZIUkfINl2YBgDGpqv7r3UFR70poxKYH8q/O+2I8fh8gvVAHQxaOkWi2xlrLA3V+KeTVl/Tgq9byjQWSZ09CLBeMevE5sbjuGmFMBZSI2r4g43DAHYcB3HEObUmH++kHcgfP4sg3noqyyJ7tkjhuIZaKQpM0gPz+9n48nGnbdD9r8SXwfJb/sCWRqbrUDLbghaJNEXbvd58+qqz8qPo5WMNZijZuol1pu1+Qm9ju27Hbn2UWhgCmZ8ZwJuV8znta2KIP6Oa9PXMRHCmXf0LBTxJPdxxhIG5cJHPXGbcTsK6bF0AfE2+oAQC4cTijdxdlx34vmVds9SCFpRAkRa1aJLahDQeRhsZBm3XMB5HKbNc7rrPxTw52iFFcyHVg2hGqHbDPR6OlQa3Ymt8i6wmlVJzvAZo89UeXxjGeJgNsykV2sdL655kyyT3vFiL05FIuG5OQ2pLeHz0nzjotOjeoj8DSYq2HGps+f4SZXTwf+c9qmZd3Hm8VuCB5TYgxE/3mHOly8DrdtutMgZmk21ej2YnD5puNoEXGYVn2y5jsGDiPewSr/25J4LFB8EHs8+/SOAg9AJ/RyutT0ov33+Rva7nkjMrtC+IUKIQaQdhT8RqWOcSu28lgcQadNYpK6uFMClhF9hFrgidGXYZ4hKakNDaiUc+XBVld9hxbmBS0shA/VGnRua0Ns70SV4z+M37lAylKBRUGarT+YbF6yYeagCvBosBdivFs0PS1sH31bV8tFFEuccp4xd2egfFtg5aBIRCo1OeNeRAh7RBeE0Vok0JhF3wgXsAufN/Sj02x7uFqQeswbXyxpIng8fU3Wod6RI2mlqR+rch5UeGm47NshD/HqojcOCtUCSQMJxdZxtaZBuXX+IXLU3sWs6FfPWR/Rn5uUTlIGMzg6s0dCoCehkpMiOioStwBSACznOQfILHTsI0UWHgA6MHySW7WZSHbrGEUnUatn1tLTsJ9CQorj6ZiQwKUZuMuc4mMgTP/N688hf5+OvQyDSByCW/HGgCLJBpfVbA=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100