lDlwcUY/HQ/4ztEhguplewgur6mnwo/HyBBsgRPZ6Qn6xbT5xSMDQwKm91v4cwUL1ztjQju1hwv19k25SC4v2tPDtEbpHZ9VqS5SbahRyAsA4RoANAMUsSBK4CR2Xl1RmMrV+qvS0z1g9r++ExqcTLYtSOP7yDMu+2O9W5ulzyqaL3rCYIPywc/rv/3i2o6KfRGfyDeZ4c2heGmQAh12vqdMkMG+KZHcozU22KO8sE1FtEe8iK0kieKqBRZlvdUkWdDClc6DtahyuTvOKfZGeecMe14KtZBNvDx3F46SC5lkWu6dZq6kFHiIaqQGlE4XuTvkJu1TQWTbBSFAKJO90iMecr3XvpbHhEuzp6c4eILPrvcsf5tMUd4IX40pz1WS1eCBJ8gUpC4/zbMB2ILzfW63p6+89VC8BnfZzrTvQZCqO8D8ERUAcL4Mt60YrtMtZFT6NlacTjdrThZ8qyZe+fN7dhoM5D1F92J3j1LlgWJSqyszXu5mLUTk6EIzGKW8TnLBT9QXqztKmDN9I6Et6LGxBz//c9GlwAEy0rA8BRb5MkyG2efVPMV+qGCSty3Ne6aSwxY9OpROGiQa7F/d8M+GIg6rHiGFDFSyKHamH1upI+g/R1h5+QeBOti79l3KhCRdkeUsnPEpOJEaGbcOwNXNaZfhe5cRtNIsKac+6xYZqI9DSgjezj9yJGdhInhNenIEwoevsCZogEBKdJARh2fjK+lVzpV12atPuykNtrHS+Og3vSBWI5NssZs9PekQDSENSpvvIAqmo0HL4q3Uo9Uuu1iyavmz79uDLZp596JIAD6nzNem3v1fDmRz2TtNHfmVR2a/RdHThyAgaHPXeDBR7eatkq/iJy4llQRCggmEF3lVQMGsI9C1qMSHQZoBV1ypcyvgk+Pmu0la1xVcIo5inw8LofdD6juGINoXbxsrWo5ebusf9EpuvEkCHCb9B6uZqC8LF93QcgLlJG0kKxTZKQ2Zv0rrQcFTkeO0L09bu4hypO1t1YxTg27kNXJ0/VKAq4xxf5Sb9/RuzODGFwbLR+9t/B+yXHY+9i+KEDzrD29XZf1MN9rLhv3o4tXpYS4Wuq+uKKPhkpdt5dsWGXOxejiyBJ+am6QbFF2PTPhajh2+v0+XMAGsZE1wh+icJIxlAdJ6NWLa969lyND+sv7ShXFu/AS3bnDoBdGEL26N/Qhqc+KiEQTneGXUcXp6bF6q+ucyamMA4GdPDuVEcAn4JQ43jHb/mX7MU20SHffMkwUxKK8MUNpX4eQqQzpsFmTbtGMuqbOl385awd6XAELUetZ9EPkYPN9zu5e425lD0O2e1YBxkXNDSVmVLNSnCSyqs7gEQ5+S2k1QopWgZU+3izlhFRyElzEVM6Y=
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