RShx6t59BeaPXkTx/EWF+KPtqZm86NxSzgA/k10bqd1RoBNOfQcRiZiyt9CL3PnWsRsdB5+7gUSuXdL76W4IgTLP74/gqj/XQEf5N9AfUNg3sXij6UcbhjA8FLnoQGO8Fa9qIXj5ZRWcrqJQvTVPC7aP8JYeeNvDrTc36AV1Y7m6EWmbtgfQdfjOA2Gsuy6yi7D5FqkqsIg9LB3OddXK0byN+JuqzGYOFXytFqXEzK6mS+S4ACLe+pMSV1B/0PzhcOU9l/62uxdeJHO4MIuxs3F6yNsoLBT644llj4rIov58a8ePOf2gLoeVwOAjKOn9HIvfj9Elgj8uFm8OJTBcL6+hsxtgVnpCH8GYpyuUEItqYX50CM5lRrcrtE+RlfXT8+MadSZ6ccCFJ1UMr6a7dThKFwcUHszxCvqGceeXuHfZNw0q4g7QMMctB7urfr/ug/B3BF5mur5lUkagxOVigAbrLshRSKe6FQznKoHmqtq83VJyM1qzrMxX+/2FiuhPbCBH0+aVTXVzcX7ZZXlyf+usqvCunUjqTga0bquG5EbhQQbir+jkXM9mJP+IxxSoX5qh4U4uAWz9zdvq2dKC5uI/GFnTiytjSeD8mrHXXFj34KbFmpxvdF17AqkXk/zds1aOdhgSan7zHZOyH6boH+RFQbobvZP2te/H5F5b4TBzDu35dNyFzdyonWcfI/ToBBReVEFdbm8YIC3hSf9phxIvqa3KJzr7Ipp7qZGYpEvQUsNGUOvgGWSjykUkRTdDLVJTsej8lKGfspUv76xuLLliXjKSqFeCiNCt6tPJvhtqoRsIWQsXc2zhykmawZVbHtAPodW17VxO51mjDJNb0ASMCjSs1YeHurdvSPA1rq++8iMlMfmGovFV0JGyuL39UVT9gHlCCR6IZjjzJuHCRPxOdd5sxhbq4ivJoWzoksrivHV1BZIoNb4q5x+IX2U1LrTcuxq0U8vFvk1K/4OIcnK56/Zm7RAHr/gDnFL5yNNlnlxOtgzkGSaw5XjyYgTDrh01qRNUPiU4rusivfxjKDiP3Jb9n5CB9ORbeL1Ib6GHFHlXyTaV+O3fYLi6jN0tHq3pJr5L+tLtBs32Qm1f80xlIifwwujSAz+QY56k6UDpIU936Szj7mXRkF4Lj9R63ZK8b5fQHeFn7iRlGsMTBcAJvCV6HwkljLEgpKi84ygkE67EymYItSYBi2GdlPOiGxnWjM3Ghw0DUeEkSTHW7bX7rw+5rCJiKo2MMS8turxMvKG4SgaDYB/EePhRErcrWCrA+ZomShsOOSJdSffih2+0q/fU9qVMi70x3f9q7j2/+lY6gAuCkvIdnkQbJkvaQd1wrgW7uEu791y+zNfZE0y12mRx9cXsnFIqD0w=
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