F1AvC7qAOsKMmFC51epYRxl+NLIJgs8HNaIO386Ca1Q3Z0lNC8eVFZ9QtCgf/gmEX4f0ptTDYQAFX5xyjf6HM1FqkEdH+T+KTwGZ49Syi8pc0msrWWQkCLnnmqUIesDbZXLK2ZU5BnQxJm9R3zAfSUSCJSqjxNR6CrA6OLKidOBYi+Zyu/xNLSBokHEe9VBh9m2g4y3duX9UGKIYSu6+AYyrEo2c8/uYAn2ntlDM6+RsB3hqyR7ABeg7jO8MuiUxrQe44vkRgCkzR8599FGn0uZnIS1q1ctWT8ZGlgcYv/x4FOyx2YTfEaMUWTOoiexJDwGyvF+YEbaVqbLNslFvVd6xQ5kIQWRUtYhohGbM8nHMFvM0s94QfqAfZ1rzNRyoJfQQtIpXLS0qmXpiCpbFBHzxXiF+2khB10ok3oms87hpfG7hgp3Cr6d/9LcwOp9mUXPmFq2jGIN5ydBkb7q/5IW32WSF07lv/7y2q31DHZLebXBk/qW0eFDwibyMCVzY1cY6PaoQcgXZAiyBa99z/+tyLI0OsWd7TX3arILiudFpbXYO0N9z8uUpDt9q3oCarHJwiDvYutnpuG6oMfS21AG5MHnxmXWegKMUqRKndw7KAhrEnaJnVR2629TDbC/bGFK2WuKuO+R7uE9l47fd0q1OptZQB/cGFfqqIf358XVuuR9CrjLfivgtpLPzXhqP3rpENldgq3eXoMnt8xq4ZBwU7mQwstKEevX346Q/Sh2oWPLhzzXGaClBY3cW0+hLkRLNC1llAMctQMVzMKDulLr6b5PMywFtl+mtbTIDAGBP30oTG7YuRULxalWooD0rtjUVgrpGVyyQihUZC7cV91Ie6GGRoJ3yet/MeAgBc7ux45vaHdvudeqx0KmAp2gAqIRL1QVXEmLyRhPOkd5Yt2S7W3g4yEzUqGa6F2cP3KoNOYKpfksBSe+pXqQzD7wERp75Pz/KghVwbYN/5SvsIo5adlaLCU5eo886Ea2zkPf9w2Yys85WVwmAuDKPQHmIB9G8kZVivlDbcD8BantzrlohSSUpqlh9apR56nfi7MZHKMJiFUor+BPHTks51LKP3pZYe1+l5ay734WZEr/bAnzhO4KrXrs1KTLaF4KPtN/E1URkWIBk+qyoxYhg98Afwgi7DJdl4oxy0J3qPXW8e/fHyLgMjjD5lhZ9SQ3F1CDoj307lr0il6RBWc9Hq1mUQVIfbbeKWn2oWmkVqEt/dBhSiDbqRcXtY3kgYs+Q7JthOlwnfnxBQLgti9Qvs2EnSlXElsJv+qybFncOkLWUwgnrHHCQ4K6G99KhTRrMt2SXSkRSflnBYCOUMM4llHdRcUYcBE1LwyNSVNWc5QH9coZG4WX1RdLwr78RUdg=
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