pbjlKfhs//zFwV2Uwh70Czx+j9ICvvY0MiHzdJlWDEJAkLbmBVPGFa5evHsgd4CfZeQjQmBkGktKKyuPtdH3U+zICn72+pb4AVAWOYvFvzyOukN75tZoTbZcUk+OwxtUIOAACibVgd9sq2thUhCad03dDZLYzWH7cR4ABP70vkQyDaOphwauCUxhN0UGY0pwMwDFvb9LdLhTVR42I+6/V9sjoO73Fz7VL7xERnJFbgr1Zb19wbQ7Zktdr/T2bC+Ezz+zt8528IpHymjdWO6zWG/JETiBFdf5YBC3IaTlRq0xOVo9AIF73kSyv+FNYWZcZXmkde0Havz3ksKUwN4bn1JCondchnO10JCJWezzdC/RdnHz5WY1MI9MDq4Fg4k4277Hfs85J0U0EwwDYJFiTVPkwFtdopVU0hoqWemFluurJ348g1a7nGzyhJBA02j/boyONR6aeejHyt5QOTFmvmJQhmk0OGxrsL8SgpMdespuUYdM71bmkM+9Y9DmtS92j9gXWB0zZFN5QoXuP5rbE1qYOFoLguZNXh+E+uq9z9b6+y2IS9FJIWwcZLkITrjETsZdx8ck0aKbnstBbY3urf5Q/9bjpL4Qy7ei2/NbxbAHMnOvks/7I3+2YcEypIL92zSY4cvHODkMdHS5LrKTal6WyVPzZ/HTPesYSaG26TnfdglN2w4auBXg2/aZ3o/YqcLiUOM5LLGKTap+yS0T9rR+mHwSbAcb5tIKVvicjFsRzel8e0gx+IIQJUNdVP/bOPiGRRRHm66OhhOASmRclTI0FKBjPDYv2SYhmkJ+DyV5s0QUZXco+m4GOiv0sZ4fQ3mNEPxeW5qUw+HjCNYg6OBV0K77L55nsMeVTaImk/ZL2wN3aDipSXB6n2dWWjJqtvzEY2QxatrpTKd9IMRO0V2DmccH3Lb1RRAftzOjKsfuyYjfAIWiu1fsBL6EUUHqXlA7IqMzSQp7WuKTKVRhckdvj4gzSDC8mdYtjfmbxeXh4hwB6+QM6cxJZFTmb71XQFiE0km90/0SmAdpKVCfV85QSr1pD4Kao9bBL+1ydk3IfD39BPSIVXA01M5/RxBM1frrqlSutjjbPm72Fk5wzLrjM1Qvk2i49Kh4QV3Fp3Cu0thDbM+HP/cil31WJ1o+s/m97BXp1bqkQYdDfov8X8HjnLZjaDwwSNBf8i6RJJJgXrwk4EmRA3lstETqQcU/AQ0untETWFLYYXJHXUsbk8futqEgsZ39//T/2y0pMHU03iyZU6sbOr5o7a7yKx2ZhgqOAY/rEULbCZ+wthcVeTVzAXmsVV2BGLjyKvrYU382WrPrXbTXV9Z7dkzgUM26LpiWh+oY9Er8GzrsAXoyz2lWjBQ4kALHPpuxKGU=
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