LNeshJlniwNrmlhzvakz3qU3Rmt+bIyRIj7pzSxUbl1CxLf457EDV+2KYIX3lWNUvLk1XtwAcc6lx06nphg+//zSEEoOqD/dGIn8iY+pf5NvtawCf54dFKPa1egKTz4E2utzGLEfILzD7S5g7JSv4N0wiwCOrjcH6tqQMfqkM+9xdwoRs3fwpHGFmR6OtjGvkxhRAjisWKUYsyZU3GUcwNWpyQmBt0M5T9SP3O/JeOfO9NfhTa6yaWQEFAIXEPT7LlMZ++8m2a+aihhFGoaB0WSwgC6cWfkIuKRCZWzm+fYlclE5AB6aSTWhUceh8B2BHN008x6728P8CogvT7T0M/qC6OWhM7SUl1g1erOhMe09BXiLd3zTmFGxgjumAbT1rD+uHrchhCjCdsHcGlqzE+Ov1oSallrj4P9Qa3RDBxecAGngh9HuwJidlgXW4eg/G7kq+pCQWebuQsoOcoaxy2U9hZYmL4uuFIHbDtbu8BwzHNixmickQVErJNRh/OU1POAu6rbUvGIcGrSoTruXkR2S+CX8cBQxO9IjwoaNBg2RWCS+DfTuJB3lSyw5OeUro8BMb01fX4qURG4EarUKJQWmdA9C0HLXSgM7vn3VWxWJcuTVjTRjIRTa6cFgYH90TLtAoedCOQD+BRBPAio26lk8bffsGJ2FyxIBgH7OFMXuKTr/X0U3JW+AjfGgmnvdrCDFwoR3cbhK65RmeBoPCebks+zbUNAUYMemaWdu0oIhwWE/eXplJxf2Mjx9OUotSmeIKAnHJNMjlprB2Qm8vR0ImWM+8cZ0hI2tyRMWXB/JpRG4zk4KPAEkx2UHsHlPr8LSuVjj2UjbEp8Z74noPzMooSrhA1hzAeEy7TMbe3h05TMY3TIoeORcPqiFyiWSgIQg6Yicu3E8kio2oLr76AQJ+qoJdYPkb3IQpTRfnJ3wBi12DvKqqcsuvtaL+JuJ6NcbbXuU8OhUgPPmSBbFI4rxqjrfdyy36mm4E9lH7qRCxwSmmiYbEqGBMTVtuU56JhP9vd4QE+DSWKYUVSGH/aHP1fFxTU9tYzBro9lVzR+rggRJ24hmJvps9uI/sMhE6tPJOhHV+g/uRfVMqMvZvf55a76KZR9JS+PfENWHt7SR5URq1hk8S6y7BqwlbNLBm6dBTjAyq87bGfhceZ5yJqSsMj4xM50RZ3mqIT4foDmZn0Uw8tLsrhojKVsK+MRjY4KazqbEIToaH+YYfQM0PPFYi4eDFYuuKQGrj//+XZmXlXQNTPuD0rkLkPoCRzIg0C6RuazY8bwEs1SW6csh1TGiqznqT7slLlp/OXe+NtadJlQvOEXzksVQmxSQRrH+HHiVvF9XIlhX3YzioSMOiPoTAmYUPi9bKtjo1XU=
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