EUyoKIppAIXLsO8nP6W72DiCgoQutG88V1Wp0Yu/tFKmO+KKp7diBYS5jrVD8ctP9egvPv95+2WXuwwFoXF/EAQykpsj7uIf0vKNxmtE0GoS3EaFkcneSdSaMx7HRJHKMjtKv18tySoKgVAsVi1/CXUkjBryu7+5judbXzCWwixA7ZVw7WWeiJA8wSL8GNoXe80bM89FzodD+I7YbsZ6Ja5ZnFX4Dt1acYVoF03pyTMq92xva/8VgF/sqzwTAwwQbpY11tcYlgGAHi0Eliu/V12HKXxUkUC7DONrKI19Zbz9Q9U7xuvfZqaHRBkVgMQFDq3ToxL/X0l8bLEk43/WxPGYGZjAPBi395pSBtj+MFEn8KvTCbZBpcrisFrWxvfFBAbEvWZCYIC1tDoex06PxINQHPuQaT1x5vodYnQU81URk7xleDIkC9JxGPWQM/4Rs2Io6sKaO51/aijI2pMLPiqT0B44pf3sIGFTD6lo3jWo7tOG1lv67P/mSClijPFV3v9IRW57M0CSkaHco+bqTadoOowjPiUeJKFxjCAz/0wMDnP6ZH00JdN7vDQwh8O4bjVYnnryLrYHYuLA07tLL0wA8EangkCN06dm6626PG93IO/GDViZ3V82N0eymziaYWN7mCuiwlJz1E4BKb1Tn82k3nWwbS/d1QrsvVWCzdPQ83LVouzt+zRV/nNfd2MuCiprS03WBjFw/5hnas1EIbjazu/tiIJtRR3WFKgb+Y2PKQEH0OSkwQjkjEafthsDqgDFADpzfjA9Iq7ZpenSPA3+hx9hS4p1zZtgEZ4rTULucX5O95tFI68DEmISAayoiKCq7pbESh/NJwXHVyk6T3Bd1aIZMkip27fEerDMaU/bu5WpwKvNfjcBB6ZpfB/gEXC9yhNPlEPYIUPrFaVAloozqe6ISvGxhHAFi1Jby9TnZCaHNb1mzjeHgRHVUqsqh2izlhllN21vJhGbnFf/NHnaM4zIkCDqfSK8tmeR/fzjm/U4a2gzEZs+FlGJN1i03rPjlAXFQaHlL2FtFE2pRNmexLGQl7vy3X05VMZ2BVmpdbdfqSL//R1zSmMhRfdLZlWY56tDH+M6DKUa0ADj1nC29AuMRQHATWxv4uDmuQPE4Fe5RcfKu1jK9r5LG59IdbJLltcoIUPmthgXUD8qe/cL/TCKUPC1RPFYSyIjh4g39c2g5tEPAB9a3ADCa0iZUw2JKMjBp2iY7foiaYuH3qNYOVVQBSJSEnece06cMiscE1miyzCe5DhoReThivqtnP/pDXHnbCPYI0bsLjsWLytLQ3tcbFw4JZseCtw9lmOrmU8f5jwddUsXW2d86VLPRZZDd0e8PorxK9ry/fIOiRVzdBrGGpz9Opkr+gI=
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