pzu5C2kLQ4ba75Y2ItUUaZaIEs9Taji+42UBVeXov+HDVu4/qdg1mp3vkFFghQ1AQMCfdu1mvXkgCZoIQ1mYHC09bAxLNFKmu0+tlqGhyHxIeO/5IUkbI77PGZRdgfi09201enWkxkHCylzVYKT4XEcVWEeNI4xG+4zrms7AoD2Ol/mKD2SNfz+82Ccd5gRc+IZLJQUf0IjFUbmrL00Dy9OFi+YoUfNhCAc7Yd/USISuIjiqSktAFr+AXQzN7U0K2JRCkYGej8xcv32dpTPBz539TwfC2asUhKO1bosBzdTHbCksAffIV6VMD2lUu6+KuspDSfW8Hc+ub55XDwWMhdk5aWUZrYtMVdZfJsnLIFo2mU4An0IcHgppU/AivRaL62wI2NAyQBx6ng2A649EVx3wg/uYWW25p5sRqca3H6X8LGDp+Jmqo1IJCpaHiXh8jpROyBrJSpJGerCipSCSfZ+NHaMX3IeapvcstVn8iarqYC9/8hC44jb0LD2NO+y1276A3KuPfDuqJsJUe8yIW+Z5gxyjNXW16qdgyKnGy31+Qei2N/o+CTYlFq0M4FdV/bowrKRar1IJ1wc/sdLY6GkerhwN9lntY2kN6Kj4XSCshaYyArCWFJAeSYpswgGEAr7RblnK2WEPSnxAJEeo4rqrOq1jnXdo0ENntXeKaK3JX3rxiGZlKuXzizFAaCqLoDWZ2NgDCLt4nuSVtLfXmAhMc8GDo8KHfMug8Des8HNSGPJNL2Ydk16lj7Yc/uxsdSKmcSX3aMTYoiYS8ksPaX3NbFLH5rPovjgmhx4H1ywc6V/IUpXZ/Vyv+XtNjXUA94ymR/HHayNQnSqHfTcBzHqC2E9WRSvlaq7MmEr4txjDnR9XumWCDbGrUSsW7BIbROaEVWRWMaNXCiSJH3C52R4VeTjdFBIvLlW2aemkglS2QdgH7bhvf7C5b84Y6ZtacmTZB4P0ZL0+sSt8IigitRkc3TFyBPhvbHDuDr2XbpV2ObMWRrKxkAw4JsKkfTkFb8TMUxJcaNoWVTncZ9r+cZZD/4ZNaePWyLOTRxmTgVczuQWVF4SQjse++7T8FNHBdbTN7UumwSVWwH3NYpGCZGuTpj24nsoDXOPU11wF1/V22dD4cORpn0lUQbm/VasTqgJlKZjv+2EtFFR8cuTFJ8MWsjrl7zkVae+CxUfM+OoENAyM2EVyyiqyo2LQIZh6IFB6qoGs0NAO+feRbR2wlPTWRdXibIsxR9Ub0f5FM7RbfDV/EZXN6OoJBLeRyXB2jCFB5IAfBKxrO6vch0gGWjvNMPCvquIc6DWu7JKhCn2guZB4Zg1ILG4cmG9FqKvNU2q6d5nJllNkdY8FnMY102zeTgSXFFT8LMRopYc=
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