O/6gaJAzm6L36deTnI0yz3BpVAK7ZJ6meigqGvBxW86WEOmfCFOTz662jJHbdjpVCIAKjWC9EskER5FwnOswemHlQ2pATCYaH/XlurUlHGBwQNVKScjozGkqHG1jMAHAZhnCBPFbxlUPrrV5UyiZ0XbdHTZs1T60U2+5LzJy9YX82Fr1JeJ/qSnbd/YkMQNAnbanK7+Xeuqop5o7mbaTFGc7BsvmGAlcKOco6YaTVCJVk3X+l1OnaHpaLGXcHucWUgkLyDP6dbs1n29pNW16SDDOrXaqG67AsPW7RzHrudEvemec0TiDRq2Cgw1T7L9cZY6+ru9s9ZwVs4gDHkfhKMPrzgj/5lRYTnmENmKSzvWwWivI76HF7FT911IpEwEpbIC7hCWzgNOhROcqLfyCCcXO0DZniRg0TtoWgwFABOkEHrtJWYdLx1tnfRNdjrXAZwtGqkssJk28glQ5EmvzjWvJI1RE8s26ZjggM784XnG/o1mA/X4mBJZ/K+iLZy46xXWIJFGhaLhy23FwvgauFN/TadbEZrk4uLkNdqxuUzuocDf74atE3BWenKYqAtf1itp4H5X9M5+5JJFkWeMk5R4P5lxeYjjOwUlPxcgtj/UFhmwg718gG+c/dqIuXRv+LaSmz4SR/ACBnr8xCvXtXamafXJWblgKZ/gAOHNzPacwS10bveZk2C00fLsDKG6iTNmmbHE/HtIxa8SkH8YGo4U1Yml2++hU/mfWktjZP0fx1Um5qnNPuMZuS47Hfc48Iyd6gIRMGKKSnShWavnQsVMtc6nxi5v/VIxhM+ANXymXRGXei+m6S0wTx9/dMbFjKii1VdcOCnExskq7CFlh28YqeOM/9G9bWKncAQQCigssv2oDCovgbcK8yLBphumGUR1cSuMFQHv/zE6NoiRgC4ySJgDOkvaE6pmw39JmJAgzqOti7d+oZusa7f57knBrNsC6DT9Q8iwqxbtGg22A9pbUfDaOiTUKXU1mmGAC80R2+zZJBJ29Di3VCpS3IO+OFfwtMBz8HTYfhMuOpYlNkZzKz9du7KFFaz+A/kzd8Y3uAUWpqbjbkpNDoGACmJaDDpYuKXwCalw4swr7sERtoad+G9azvfaCGihB/0Z2MZ2xYiOGncjU8OzB9Kq/urwKKJJtE9Tv2D049pXIFiPV3VojB8oY+XkFjZxWEnBwMuyJGKROSev/IOl+Nw331JEHdCfNVdlEtKTxTt6OD837iwSQ4jCpu3ofaOv87gjNRsQTQSDGmSSPiZ6m+Xy1fYHzbs2wqieODy1lGZA4L43gqrO69W1BQ1VnOE/PHjdd+IykFzbjO37DFzpM6lT05U1TRLyoPvZm5e/mM9sTUc7ZMP/VjB0Sud5EGD41LWAyTXdEKTKKZlIXXxKh75SuNZN+xeNnuoI/Wf6cJaMe8afT1APIr6HTrEFuCeLUHdCCWkVCt6FDRRgvNs9+OWKM0osWJJdsjvInfny1ud94SwR9AyFQGwWfeVnpw3HfM4s8v01tRLbj3ACZ2GJRQ9A+ggpnPjly3Nrt14VFIYHiXJBZeg72iOYqSLpHOCDtT+jUGh6Nqk+vSeZqI+Vj2H4WEC6hNiadaAq08f1NiJDRgmhsIH/MbjeC2v5c86Zyb+IG0tObOFWKGgAr3wCAjA4sUODxzCvUkJynzVRm1UHW1WV+2qaRwKu0LuB+6/4GOBohwDxLQwDtqiS0JZJUVU8=
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