Shb3qpLdtOkCHniSVDBIezWvvwvyD5YIzWHDRmHfzLLpuPTvRms953HkxobuuAl3IqwxMDKsLap/yTacUwEexZEiQUxcUoREOll02NZwVK9btpOPzEMOGm1/fpllTjUA5S2tPZQYTVXD+3BQger8mz6KMOLyYq+x0rXkk4xj8L/cQzSBUMMJei1Vru4sYHy5wRSpv0BTMvhxWBy6pJJV/jZ0feQmER1fa17FMYIT33WxjcqCA9oEdJAYga4aV/V7oTgxeimsOgF5/QPkpNMp42w1h8tB55H/Sxuln5fgrox5EFqzvfS+116qPINtFIZGlrTGxxZlYZrbLBOZ6BXTGgCBSuNif648VAJrQQYuvC28DyvufR1W1TKdziI3kFtekgIdXMtJay0XFmwgQY8DWpML+V70k524Cm/eZF0Pnh8EkvMnLHH+C7fYMBul4s/MT/UhRZH/AaI2XWfhf82Xirs15Ov7Du+AxsFnjnmCC73N1t7a9ewWcmVUTG/kCM3Ju+KLPlsvu8ZbZCpyuqhUuFqy3eW8bHJnFjJMVcn4Op2x1KHOqmwgj1JTQP9HYUy6e6tNN4MQmgCqApql/D/neur7JENha+Dx8biVwrfV1KS2moFJ945/01d2rvn3sWHvb3okPIN24lZaS7eAvzMzzgGbsQm7Nszd6NcyohG4giJlyJJeymN/3PsSN8AixLJTTeLeYI+a6rfuoO8UJpjLtOJwk3fx9Ig+Ke/Hgrdyks1bTG5oDoStkR5C6tu2WyooNCoiyOXJJJQZgXjaRJMDIl0T1aEwHZWiG1a+D/gJTE5vr4x++kbqfRgLzPH8grfUtstzUdY6A3DJK8z8qY3mhA2WKEjwgdwRn7eBDUdyFfPQJieZgr/lRr/8CdAsQwA/CfbWTuuv5BCgTf1Do+RpZ5JLFdRhQTZAxTyxAPn3JhWbueCadbgmYI6dOzDEn4aYqymOCXce7xLIkvSYnGMQ329AQQoJcSBmHkOsZeiVQcd46W9xjo+x2jDj1lo57H7G1VsL4PYLCZc4tbPqaxGhL+oJjqLcuKb9LrpCFrniqqATdoRY2eGWS0/aFad09dQyhiTSrrJohpJ1bqJ4Jf4tQQcy9WArRYiT4VbUniQ761X2bDKdIa3LdeXaqmWX8wuhYXyC5Z978WRnzLsHbzhrC6cuz76Qk46DJJ7/SVatsdIEq09omabDfoJRu3CGHBxjiBpvUmuVKioFkFCa0H5kaoqC0ky+wrAMc+Qv4CM05nL99RPXR/PqU2GinskUT/6XgFyDm6sBM7WpO1jh7/CXO9VvOzSqEEd8KTzSA9muAdhKQKJ+3ZZYWA1C1PA730CsNA8mPj0090naHCJb7nO4vnxRckHccDh7UCdegdo=
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