5PVE9NrptVWS2X5N+QEckpOoqlVLEO7CEwrr+KpYwtiYXDw/fma7BNYVXy7RT5r1MytkDsgWBFqMEVpn8r9Ml03GZP2yTMD7RPS1HG+WHlIruyVRYqJDAuAJAGpzvArp5re+qsNV4LTe7Y23ypFT5dMfcYK8R4OOe3QtMBVd/NrGLBTkMSrRzwi9ljMif/9ALJxqWDUd6seDllG2h4z1IGOsYoKRlfLV9jwAO1AdbOSBzL+J3TjmiUJNGy1soDVRXmNQkqgejbyh9dgyxGOspDflpEvq9uI8gGM7wRkKfiHcMA0SR3kdV/CXz/ILkhQpMBdWycxfnKB9qbXkTR2MxQDP2Sj/nlduA6IlVackPcYBMF1V6kMWhIrOd6Le5yFsGvVypcbK/+dncJCpgA4KTA/mp8o5pqa2SQVjnESz+WiFp6VJbG9J97LA4jXMWKSYUKiTcO1TaJxlm8R9DSA+SVQ5oN1qsoJMbyZpu93C2UjR9G+3gT4OlaEIvO4uv5BypvgQu1yE/vsWUN3lKda+4hWqUO5ffVIQUDWIrvh5aNnblQ5wJm10sZ0aewzp/F+4YnOLu0MBf0sN1jM5gLPuRTQ+T3B6EnUy2uLsB6C/hQ/gBNu7iQPBx786K9keUCR1r1Y5BUpYB23hM+OR8rz9Sz39o7sZsUtyZBTwTXk0Ku4YWNlspzMm2TcwvgRZqQL6zwBd/aH8oAZsJ7kErMwP5+j18yibG7PyfL1xQesnxewZxmhnTyViSTEB73GJNtzusflQsEHGXPRuZWmryI5ZvDmqHv1kqLI9uXkEgw78IBYldUkhSQABYA9/0kNtMvA+TKC3Dd/Kl075xG2bsOFqQEldUdxgTqfeRTgUqf0Mgvu+bU9Gcm9WQuPntE7/PHM35cXCtPTc04fCpIyNTCChBhaSMLM1ea5s/59mCNVg11gPYuXabWVsWdakFOiWOeHZnD2WjJqcK3Az1q3MAgejeu2x5RqhVrjNSkFn97xh9T/mnFKjyrhU/7Q7rqqLpEON02HKLRVAxi3ClR7NMXssES8QAyMi9WRNdSJhR5G/E5wZ/6LVqbjpo0zmR3rrNscwbHX1sp6JKklQL5FlFqC9OsKm7xa4nSSbEX9GEBf30krTWphJtegbk3d2Ebs7GTG20Wi11Xq62jUsxxO5Uge/bnPMqJa975ZtkpR0FNv+D1UWvR7rGYcxV/UqZ+ON2F5IkgPGw6uAbTqKk8sNbg4pePksIzKA/G3vvO3Y7bcEdqcPffCEqhUHQZCFjXMZH8Sf6546bYZVLZzk+aPxdzcRKT00R/Clnx7d82dlZg0OkWlR9iiEpR/O7VCya9SRazHsVKKaiTcbvKIED3QF25DO452TlRergt0Yd0gb4r0=
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