QYZQL5BhIDqy9JD80qVYkdPlEnJ7gpMXCcjTYKCM04fVBeWaaBzwdSACcfFtyHnJU3IeN4idwjxcEPB++Z/tsxDjsYbM2IUEO6CCMgNav8YHEKGvPlZOVQxjoeUz74eYJouh2WNptXgjkVIXfR7eu5FyqcElfjfhoq/CLM/3C3IbBzYGJqwliN+NRQmjG0sZZ1YjqhwgFkP+EapoCzr4755iMrXMIdwhTLS4ZvEghPxuf0jsIW+OZY/8vZdnYZKCZCzhkcdLFfRftX+0ulNHm0V1Rt6+FFG56IqFypLszsz/MU1u0+iTjXSOD6xcbnSMKaLoyQG9nvSa8E7t81p0aHTBz1xp4qyySmFwegyyBmM+1zuE9tr7EOarR/z3Hi4YqjIRZNSLa7kQwiVHPYr7J9jRe5OvLYj0joPA9q1/20jp8xg7lQOEN4rdqWLamDpQBG9kvd1f0JVJUIP2clWLJaJy3TuFrlnzQjVHTOCtJBCeEFT4g57w3Kc3oZYBEHYAnsbn1ApoKtdRULZBbZs9IOoYzvaLv4Lp3+tVlWPGhzvCBi6+XmiY6+zPJeIfXma9feVgtxnpu6fwuknpNL4KkDKaeLfj38M1kM8WuyFsnBONGfnsN/fk+9UbinWxYIEHAV0HuPerhOKT1sYZdr27JOX8wIbg4Jj1ZfYWGcx/onuODwCgOF41CWSFl3eLgIMtx/tHXceVoA8NEoaO2iZ9IDBKU7J7hOJjNwc0Vu78LC8u3c1xh041sLQelVl2Yp08yL0iq+bZxqew1pDHaOgW9OCZEYNHM3HDyCbUDSHWZrfYrr4l32G0b1HRJeQA5LHLA0/BOb8kmWIMH551oWiiTKk5AR84MmeOcRpIZOq/RmTS5uIHM0ch8P3NqEoj8sU6+97kTCQobGuWAt+1DibfO/B2/P/YVITwlA1EH2DOE0eyUN4tr9M4JXFUyl2piFsVlUknjfggN62+qDd/LqFLB9FCQq1cxfVhZ7vn3F+JtMrGFfOLy8zSLWDKoXsDI+o94Zn27zGDmXQx2YWsabLsp20dqLPCr6pyRyo8qNu/IWFxQDlE9v3y6ey/7j49bZ45fX7VtOZNry1KqeAkDzTm0SCm0DOhm/9r0kp9wu3y4Q1Y9NkcW9Cqud4x71AjGly8KnWC26m77YzAyfSZQAXJc1/RZ7XQTW3oGU9XlxNUSIZPXJVpaJ9ZJQFYkDRy5RPJONtF5QdbzHz3lXoKdxpuPuvccDqcuNkx0RgJXT5dQDP1n8qDQ3A+CaMD2Uzg5Su90D9rpgJ4sEWWUrLno2sST4QcMspQLfAl2u6TNgWZ+zxdQBNiNRWi8mSJ/V85+1r2USPDe80+4Fdczm6VH94BZwNyCwA+jG2Nm0RJw5A=
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