z3RWqmxew1vkyEpq4N+lz0DO2pZCJsr+e/LcVH/6ialbn0eOH8yLtrdP7Ap12wIDLlyWTS9vAWZ9N4bGi0G+hKnkmI25khAGYJyYcu90ESmU7RWMUG7a3MepmQ3IMrsSmM7DGEO3/a9zo+0JAmOIAttmapQnZBnJ+fHbdg7zg8BCWf6sjr3FNUEq9xEsRjrcITdSKJgFkt/pLquFF+0Tx/MSV+UVcdIHvhkOwyaDHDm18ujdgOC31wL12/gDPAa+/ptaI/18H3vwpp13fuQCMjiGp3j2fEQaOlKeEWS1KQQSdR/7fTGtboaE5SGtrpbjhFAbbAFUbjgF4N2K/V/7Z+4D3N+QljcQfaN8dUIecur3AFxRPaBcmawnlQa4qwxqQ9vhLRQofU2LoFOmtMU1B6zUgisIP9Dceu2Ggc9Pe9S+AFWyNU6twQOIV9PNGwfeOpZNKjoaDDU9hUlylFRSpPQ813ybHpPD/LkYWj+r/hx+d9lfYVtV7vpwi1yevaJipaZABeEYN726EWSpLE4Fn1HaIdaJpjBs+QssAvvcNSEGqJAEaG9xycD+dPxvvqsT6l+sEK4nQzvclLLXIawKnLk5jiNzUx4/LliQAlBdj08sjTVDkmQRcpJz6/CK74Fskpvtk9py0gPnb8l+bhtW1dWL1fpBDAwY6floLs9otoOaT9hEqLBrDFvIaVSrMDIAVEKQ+pOvA9rGKBliYYDt3+7WSehvg4kJGFHTyz6RH3YA+ZCooMzFLk8C8psE2OWhJZMMgit3hEsYMjH9qCq4WNHLnbRsuXNxsKNniualLQZ5/Y/kgz+37g4OJDC+nr7eTIVxTu2xhCYZAQYseUor9SASdmj+n6mRxCa6TJC05ZGkKrAzkV1Cht7VcKrt8oqG1ibGjIXlAJWFuK/oX0vvKtNi9H75MwANplwDbVBsNGDBOPHGxn/u4vvU2BOrpHGY+IAtEU1jt2pHoPjE/eWkIBeEs5shbrtOQdBEPIgoXO/FkFk9IQMawMklLok1QwddJlalu1nIO5vl8kn/SZwPcDZ+pnXoTZuSEMQ3MDyN1njv00+vauPjJHYxX4IjDEnOZQ2jtrwS5fzNo79BVp3n30MkxDXIlAuvKZ8XxDDnU3q2ODmJkcqMXD4h1OKUwSpG2gTzMGMr0xawzODHbA40sG+vIQcDbDDjDWJGaO/r0ZXKeaxeQLkj4TWvF4LvzoejcnQrpgCvxCe33Z35DDI8fJ8RMEuOrzv3+pnPOKje3x+XyF+yxz2VJyo7zRWbbmY+ZfkTf3rJsRcTDegDyx2jDdOH7R6J9xUwtgJ9AQdNt7PQ4qt5asYJyL7qiBOI5EjZzyOCEhSzksm2ctMLpNu7cIBoDwnSl1cs/HmiLpw=
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