9mCj3++EaCm3FPYtQRyWjDhVVTm1KVa3wGFceIIVOKarB4ibO0wH/Da+sCgIl2nh9VYvmTSlOkMDTPiWLCmX8IkTsulkVr7CfxaTboQ7w9/ee2mVt9/0Q2VjxSBA+bPif78BEYqFwc/7LSCccWBRP8uhQVviyRsDI9SxNkLp2halkV/+1PFBiO3ksLYmc0Dy+tYwPWA13nzhk6il4xq+C7fNnQElo8Tc++LWEf/J+IFfas9Whz8QEaGc/MK7Hj/PGzlMAS1dV3DWth2CYH6Ajc8wDcQp9FLm5m5ZfEBj6ywZFJDN5h3iQt0GZYJLJ1fBEDqZInPhEPpifE8R1A3IqFmpXvYGQZRjTqWtKSUsj+VwG+hH4B2e5XXXM509Ul5oqVNhiTruYLI5q7z5mRf3cPt3lBTuRKtB4N+0/r7TFJyla4jnjs0NHWD+qY4T0HMkGYqzlX3P1a1OWJAyXVSXyjszMpa7PldiaRWtZ9Xffl9S0nFOEwBwhi5qMCe8t1dj+uvBS3vdiI0qw4O7KdgchqVntq1BjCkMQJNc/de06t7YEIts1bnqzcRfYPAPTWAuSDf/ldgBTKAWBETuls+eQzOnq50CrNYsoO37VTD4Zh7VP8urvA13RBMaJh8Pt0WiyfZlmQwvbLFGtA8/oYQ2tHu9ds2K+xf229bcd6xJJV6kOm3T/KKOD14jqgHvKMhm8rz1ZPnKDq7XvBDpyk761yad/kFq7Y8Ccr8K73XpI2AAeYXiE87qluJBxlC0RvZfjCQiwMY/KdICf/pGTfyL+ul7QjNsOtx8rLEPndDwlcyhJ1l5gW4RG8agiB3jRcm6Luo6+Uij/pBvU5PlS3JgbzV0TEPtFtCmIoyQtzPCPUC/iMRYE/BOKEG7xZ8aCKvpUWK3ipU19pOdrx0mwj+uCeCOkm5RNP7q61o8LNSesPVwDxTcre/NgV4tr2wYb3zwytCp7bFYtbLjVNG9ZUEIrVAjlocxlyRtMuW5kieVrnPExd1Y4GtjxscaalVmheQvExXD4ZEvHKVheV4FhALgBpw+j5+pPKf3XZxuM0pQQqvDUYXNzoEbOlyUiEV6c7LmmN3AfPpqKk6RxNcyLwoybZdn0NkH0IXBgRFTN3kx8WOo9ACDJryxljR4B+dKRxsK+WriKDELkXZYyZsJNhYMLFJbbFWcbdBG9PtEVHzJ0SwRRWsI0hx99Nd5NquCQt/rvOzSkxc+aWZXgJPc2fq4bp3psXh1sx7w1mNgsGzyqXg8ffagpzvI6v5VdStj4M7WgHA8JIh0OsYUslNL7fmrHBx4W30km60Qeao6F099njhIlpaLBsFq3dqW0Y0SRCbeqJEqOggO+Ojbu3Euc1Kx0bNPcmsman8Hidy9R9U=
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