dCuYteswHW+5XpFVQ0TG928UfP2vxiBZ2deZCo9BoUa2pwkSjluvtjmBBXm790+pcNHhJsd63JpnMvfJnkNTEx/zRb03pp/TKjheDn8I7RqRZWK4ngvZkXfCon+P4/MCGZ1zIJhK5M09TAsHWr1iPZby0nVP1Unms1Jg6XWZGViR/Ed8i27Qc2D2EwyHFm2rqnrdInw99Y0+kRTRRPadB54MhGXbPIhUwJcyLRLQoXhmBA8X1DrnhnpFuFE3LIaDp+0VWdM+6u9jARovKv1hPe0C8ZncjzUvIjeUOSJk1jOxGWRo/bBwUdNqtZV29v743OB9ZlSC0RCIPYoC1fhqqtLJZD4dJ4sIImfJUkuh2qAWKKloQuO5nMCiC0zu+q9OFB7FntIkqlBebLkYmVAUrkv1HZFVgf8JVKJzMAS2dKujoJC9STg14AbDfdB0YPOfzCHtd74DcPRo+9duamYmV+HrMO0XtplnnxtjagBsSCXmde8CY4d+CbCwVZtRbnuYPagDURjBHOpEkLYXM3IfHHp+y2bNYMktQ5D53mq4/ShGH2aPeMgrrBbnk13IkOJmeNBtV8FnaQyvX81DuvsJFCeVwJ0uoH1UosmVZYnkBN/JOnE8F2tD+ueIne9bMUllDujl7ozPygRlTT9Tp5PykgKlKIcugFEbv/g+kxx7pwyzqeYdw9D4inf7uEuubXubBaZOHN2VeG+XGTNn9WIUDQrszEDR7QXNBABJ1REfPwTbLkVGxkEG1bsneK3k8471xwGEKrkVsOROuC9qrMGCEErHhFUkqDO+/7q18f9znZzbCRHHa0oY5HCOjB/gUSRV/2IxKZImUL5TKDfdttjXJ1nYBWRmE8j0DYV1Fsfx0dEEnoy++tt1l7KOGI1ou48MgeHWddxXyRpOsqnQ9t2ied/mwMJtONWaBQJoHt/Y/vCoO9fh5tICNj9Z0m90lfBl5JOeByi0cQvRd13XNLTox+6QqqbmaP8eugKsp3NFwku+sblC+ylRLMMoBLMN7i8mq4vxJJd/Jc249B7J73zY5r2Rv7/ZG4O2mOr2ut/UJOa9d77q1h0xcGkWmtf1Be3Fo3BWOaW28U8h3hUx9OiPNBeSNVaYyAcJfeCTFDJrORcPmoCwVulkP8qb5kzdjJGsk+FMfLTX62O7WRg2+ZAow7YUE1IbYTTACMgF0kcPqOLZzzjXehkb2VSbmWZ/xFALP5QHarFfjA+0RK64qaZbotlJctIwLf7q/3bCEOT4r+8LkRg/8/6v3uJ/OsKHoSyrNBG0nNSRH9d0aKPFp8TLogMOG6PQ70CCXCmbzuEqxE4RauH7jawNrAskMJi3ll3NUf8rCl8rySIo4f6gO2OiUlApmX4kIhVTh8Fok2Q=
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