r/XKJDTSI0Z1etfE0qjsIPVJ1GmVFsX8Ap7SBDrN6VtIZ8I4oi4js/K/gFjLcHQ/cB0OJljf9xQDRMvzxSptfhgoAfOJ5RdVX31GhXjQC6P8hKacA0AyTJmTook8ZtybSEcUjL8O68FtqJriZzRHaBnOjflHPn2yKkGvDidg1GydDg2YWea6O1bM1CchQFCtJbFpRmfBp48zmlivfDm06W+kvbIYkYuNZQ7D9iwbVtRefkLlaqfs9gqahm48s2UG76RFV07CLsr3KME1gsgGb9n6Y5YfFAUxSfKSxqeRbO5mjg98LxxIgA+BJ1rX2GKMgcmPzh6zLI+gZliIe41SuJAk5YoHOrWegQ0IpSqqXJ52SrCOrxgVn62pDCc35R1C8kNra5XMjYAC2zqaRdTA6seKAWNWQ9qb5yGE1u70jLJcoBKaH0nEjdDyPWn/N78cOlWRP5G2RRfX57F3n2vY6/13qnY5aoDBTNLcE8aHWohnp/oDTbWojPDMzSLX7Cu5R4DwwLzPe0soyuZlSSn0J79LePfNBRkXTyNDzLIESPCQiSHqBJr3VnwNQrSYwBn3m5P+OEmb0LxiUKekA7MKCuzFizNkOYaVWjFzTsyBv8/8MNF3GtfwB2+whScooQgSPPZs7jMqgaHTFWLw9MTNN/o2tBPrRY0Ui891vMXGVHP+tZtxMOX4pz/XsWc76nYZ7zOdqebS36ZtdzuKBRM1SG2uibQnwbbE+WyPqcmpHtJJvJoVjOjuJj8AjnWPVyIyWP3B0P91qm1T80FDuUNHyA8M7OkXUWdKnPUjvCGGcS2PA/IAgqLkGVJBZMree7lk+4Q1t0doHfIF/mxbDdM5DxSMKBEn5Bvm4yyqCEi6yd63NyNPouI6QSlvknmKmhlnVTDWzmWEQcfubfXQIkALdop+sGZ6PtCHQ5Ip09PY2gNM825fQcQKC/Og9W3U7wdo9Dt7XfBOzG4zaU3CYSR88Wih64ch3BVsVtD3kGVzC39SaGvzINMMSG7YHDZOBQxKTiK4vVT35Th4lLej37O6hproVD1wAY1HsIFNyvyjr3qKXtE195cm5mRwFui7NR1xrTMqO+wWHmfewgxzA7b2Z4oCVk+gbYN1PFz+1+vM3IdmT+IJ103IzuZ/kKs5o0VTTjfPaWLkiJiOH0BR3QcAW4D6LwFkqjS8Z79DbexrtlkLPSgAL0eZi8u+qjzVML2sa4S4vaGmE5YThJGMdeVuDGapEI3gdDycC5lzfIPhAumt7LWqJU9uUF+CHfwiqVHkz3sWPDNFV4+tEGXNMA1jKWSGHMZgOpI91PJ31UW22yqwDziHbtHH6BkrRERZ0kvsNEwKZ6ZvNNo8etdNvFFcJlSDJ4rj6CLraM8ZnAU=
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