iowbZ7L6I72+5w0P+r3MALesLeAjuOjLzQwPk/TVX/qF57MZMSqG4MXJcsLiL/tgn1TWafU9INd9Ov9blJiS3q94AClMVxnMQYcroailqkXXplyEKAtXTaT5n40+NAafJukWL0J8ZAPyEKksoS6R6IayZXzhvZRMuRaQ1bpL1LIVeCCFjicdApbbxRxm4Pbro+FMuRWrD/Q8ILrcMohVSF4QLmqvlgu9k+D8/vOmB/FoOf2PfsUwuFqbicx1gclQzUYwEmHu63ut93I/+QCk72DVChFw43feaoYjyq9D7vJzIBCAF0Ly8f/y8n/EPwuZz31cHll00C4N26KRY/2/imEsc/xlUuPA/cDpwf45s1oYkNrzKf7Jq5qLib3/YKKYV72qnqTE2x4QZYqPm25Pswn8TmFtw2egIJcgQZEBDAm0DH87gv2bwl7626erUMHlxEOGCwBvy87tCsX00l3mZaBmfQ+Igb96/e5ZBP1VzLRhWr7tBnhauAj5rWrFtcqkBwtxPxXEXbBGZkiqiNmpoHdhzx6oH3AgEz3NpAjRHNycofepvfHk8B+1gzkUH/W3W3P0Jgr1GmSzHMUa4KhZVRFOvuyGUm1rTZFABa2hiI0jUH7jAVvG97NCS6/bmcXOFk1NFcIrpUBO8fBJcR+U0gHaAzm9SKhiacQ10jkep4yXjb22xGO01c5fzLQdDLQBz/TDWlgaoQWKwhbyRiBHZZKzfzsPYd7jG4+jq6eqaorhfOATfyd31n4aOR10RnCxIsalVVDHcQfQqWiEOgXKz0zA8dgj/lUATtrBpX8zyYLpxJv4olyFdVblfCI7uNrpENtJXs0cr9NDWo7+L2lYDjbRWPcaHxri3I+Od38BAHtKQtweWUy5AhGe6rMV1H80oLrk2srozK+B0BuCAf3/CoZf0zZYpja5InxTcLQrknOrZvOO39jE5pKSrPTQwMLIiWvBFLSd+dcZ/NbBYcbShkkZZUvg+Doz0aodOSDFhLc9DWhStDjBPrqyQi3rEwjH0UAId+RkvNkJDTl1WsVtBlgmHR29MtofuSdGnuOL7BQBgFQiPs79nFp4mxFjglYxIkKboyxgtTqFGHeTIA2Ta75fDjDjdSabq4o8aG3irPtc4gD5g1/eDEX0bGJLvkqHDvfmam8CqxeGfCx2evh/C2ewK4p/154xTNK+T9fODVwIS5oZMV1btd5AmjhVk+YrtxqQSaVaJrbGhsk/8WGzJptLAXJ1ohySwtwWR1j2fdsVZSISfczjDn03OwhOULfAuXwsdak7WjtB8uAV0MtxY6cjACHoOXRVF2acJEZjQW6AIJPznYhZQ+HtftwpSCyWK4XnM9ODn2sAEZGO0Cs9UiAsfX8B7Ea3mIYvY1I=
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