Id0TJBKP/jXY5KyQyTwpRElKGshzf1J1dR30Av4VTG7kSgEm1x9eOqlIreIL8kEaOoBn558csCnsL7QjpqVE4ijQF65hwfrixcpRYkFXp0srUPhJdSnQ/+zEmnbdNqEbE9Eyjd0eTIHXA7hPvCPhk5iTlr2QbjsOMzJNzuFoczUmq9iPFPS5OIJpyWaHzvE1jQ/pwT9UOUVQZpv5cJixqDCUtHZEHNYPfjHGwq3dibVzUPZyTIC0GvedCwCoyuHHKsy2HeljMORo8e/RjaVspFFnT3pr9Z3iSHe8wOmBP+zYHUOd12d96MZ8KToqNeIV+k2ScSqUroFpHNR9fE+322W4O8HPnEZcTmGL8Qu+45kbmzLBrfoCSdpN0/bP15ucbaM6KoVk6l3FHteZ4FkPJ9gK82DQxpt/uLu9MdrunCJP4DJBvlntl0MTxKga1+MDxvoEa3F7roHXfPOqZITiqWA+5Wp5X7d63FGmalyjaDaWaC/iy11CX89WRnO8gPdwR7dlv4qrzMyQ+Sp7L53c6CIUi8QAhct0sfPvTw+usjyCk5TfitpjNtESMokL0iR58Y5aJfIkmXleZWBI8hQOut5T1yyxcPiWSz7pKJmncuewjMEUI9vutnCbAkT9JrQzQ5Ioa+q5UK27IH5RO/+MNlYVSea74qX+T0UD90KmXPqWivZqMXEGe5Z61uSOKZiDq8HTc13SKIJniah6AFDdZQ7HAA3jDcgAdj8QY+MeLGhLyBMSKkQZqmBr3a/4oZBX4fAMz6tty8VkZLyBHHn+YMNb7yxq4tjpb26jrHy0sSj5PgQ65qt8sPtaUa32ojVF5vytddRKfCRH3q1JbfaqoyHLGxCUOwNHkpFjBVK6Lmb8Cqeqf+Gd1G3Gri0HArSsDZkyP4xIAxVso7Z5uxFPMGSez3VuZHDPpvnJ+QhGL0IuhZH9dHdKtVmEAHW3O5DCIjx4U/SHZpY1kFDHgkBuDHr/iXVBAcdOJbCH4F9SBOL6qCacp4U6n/5PLOCdVQt4a9kYH9RLngAdO6fgc7P3IBzL9LVC2VThY3DhlntojsQ+DJabax6AeyqQj16EkAvE+4iZJ6d5DjGFlANWC9tVmZQBIt+GV2lNujuwOA6hxREfJuMEZHPdoY0wZQZWPCFbDRrd7IKseP0b5FC/VN+GnfQ79JKBGdqJDmJl8txGv+iw4ftvfEv+cGJ9VGcAfOK35Fkw92vox6K99y95y0c4Vh0U/9mJ6p4SHjPTtizJGee9AUCOpskXNsggTqq+Y9ak2hsbXxOtxto3se27Ev0V3znYXeib6nCO7HANUZHyZEuQXc6w32xxT+44q4eEZ9Swbqcuoq0YBcmq5bZBp2TNAFMaNPgaBBFwyhQBrk4=
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