BOJJwoDlzWqFc5w7ITT16dvHA8YcakrvyofO419XmcoBb0eyRkjdmXlSCRNoiZLt4KGjiAt5kQ2ghiXv22WaPO06KqtxO785jG6bgXjmRY6l+1VxfJsSsEjH4VXnHbpL8gM71/kYL5m9lgXEu7W6GpT9s6JVILST5ddgotxoDt40M9mEa1Z82n3HdHo8QQsaTnk0/L//e+AN59CAsR0NsHBwTOMFkVqILEPGQpYvLOVTPKpodyoNyEnfWrvdgK1co4a1AZPXvIqED9Q7qsCuKgU94Skekzyd6ytLStsj3o8DbfemUgybKA/yN0bDyiTQE10izwiASBtms3I6wOROyLsmk2HzE231Rl16fQYfrGkzZvMmvF7j7DfYVUH1Diu4OpAm7HeNFnulUEMw5fL0O6Yf8EkgKuV++LLRDfkBtNOczB/RoK15zFPuISx8TYNjBhX50AnDLxXjmRH7gqCH69sVH6CWzo/PqAAZIN0MDc+Of96CsmpLeUBgJ08XTlARPZrhu1ayfdUwdoyH2RzG2c3VbP5picivo5il1dxfl9FX2Q6QNnhvarLWyjoTlU1qfc6rQdNQz8dNsudQCPu0lZd0eVwA2Js47Oo17mHxXuZW9NPGsJUzlq56UdMK/Gd/y9XGXEq2cRZZ6ohfhWqO2qKC2DEdNEFo2WNwC3suSz0j6cBiAAaSgYn+usaVtnSme+w15tWt7msinOaDzgNN16tFw5m5thK3v0IfviKec4KTB1j0NzBHpUvbSBqCbbfnMrCwdCISHWwMbAlBrwXmjo2dBM4RRSvnLqyIphZyLLcwL/o4TY5EHBlLZejYTIuY0zuuADs1b7v39Y02uP0e+ZKz0OSvqqPxhdbVHczAPtJd0nBkNioi6RIcw/BofJ8GU7g9AeGwzL0sgbz+3X30o0vJKC/zOtQXuqqGNgP3PXCxhA6Wlb7BSrUskRRU24gDvDELdiMA3UyAAYkbnfrNy1Uc4nZuGuvhV0V3YHPcCFtzdB8EhlV5+rA0j4BuwXpLc6FXmh5s4vrvctvbnYKvoAvce36S45yCsUTXR+aHddi356aicTNFo+5kOCVEMmy77uyk09IFRxKjoRk/n161YNP8QnaKQlXoHWJhfcwICLJa0kqV14aULYLBA7AIHonyCZ9TgVE1O+SCQdu+3TEl+DIbAxbQpmEXCaDd0kF8LGZZcBA5/aqirgqDJql15tjsmqa/Dpq3OupSWxmAwZS9+QauMES6IN7a8PFxzgLoMp7yqufCmFvqzjUGHV8bfI5rtwKCtGhpcxPx9iXYSvQ7rjdrKrFkOhjC5BcH0w3Jy4dlN1jpSgGsYZa0D5Ph6T5dV5Pqo75Ui2GL6l8+AR32m6h1JQ0vsENi38h/3C0=
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