C56zcDWgN4j3BGrXpuz2qafNI3+YXlc7ya9bfGETQn3sMUFL7hVJaop1F8pxn/6ANyg5sI6EkTKVolcDu32cpnrXJd0RB9bytF9LmWyuaO78czY+m+ESHxRI09hkrykspnKUjiiY/R318l2mBKaXCfCjrgpt5hBbV+Zk/hiB28fN7wSVHA+G+RpFU0nCrgzzGJE98jy3TSGD+inXUMGrxvohf84fGPmjpZHJcbdmZ1Z3Vhnsd+uGi/kob5tEk6eFZEtfQ5vkj/mbKEMo0dpd+1ZybOf59InHRPwSO25af//gbpvoxH/OojNhKlSt4Lyj5r1404UF8q/Hzm3e2N+imx4GHzPHG9co79CJ/NJYCy0niesP2W4f3OGCVY7m501LWOsAESKEiEk49MaH5qYHElh90plEneRpxXDXWMI5heQkFqt8hI1ltiLhVDSSKnGM8Sas7Ml99P+BetupWkOnQyEYVIod9eNYhUsrokbgV0C/pCy5iox+1lJOtZkIgCmtbbQKegtbCOAU35s7qjwcuNtFZlXsNFI3wWzztZGlnzI2br4mazOAbFHnyaoob6VbjixirP3LP5SnXv1IsLIdYKJ56ie91pVGUe1IOH/wIG70F8oBEJJYLEIhxSouW8Pods0EzgojkvuPaDTrpkhF6bPtiI35fzkw6cWwXO/tIc/oFYRhz725QPhVCR8Uwxx4bS26bxYXrIOBpMuYEYrAKFXcb+3DEb1mfzu4WSsMNGCAz6meS+ad0eEhhvRtTt0HRF/DGqIKllYj4Hgnj/S6a/wFhEJo6eS520S81dKpYwZMp4TrdkXcZNG77gB3VR8Q7RgG84tqUkiU9Y3CE7cGI8rxwE3lzaALEPySYFSI4R3+dC94g6BmHgQxXdjr222yI37O3RKBlVARPGHYdEDKbOd7ciGoYpHDtm2X8Sufq0anRGSkPuDnAh9cMWAQVIl/m1ATPSLgrv/NMD+25fj+dCV94NI1lB9Q1mTUW9Iq0jLlJ+JOx5DIitG8pSsyd1ZaL+8fR/R0wu4ueKxQA1f3O26f4V4kDe4WfDiLc0el2inCzlfcnheuVSWplu2d8JU4xsawSjJQQH86btZ0npljk3TSDYqMD7OUf2STFccVNuCPcyvOlI7bePKrAd9SgD0TOS5Qan1q83uvsefOfxn/vrumF4IqopmLBoYqzqGXxB8QQmQs/6PdXiP07+XEwoHBn8PhPdyxdnGbAwHD6QLv0zy5TdMZijMtuRWZDr6WkEqDTs/p/VB54VAuvrInAK4zvaGIkLfzDWBCIEmhzHsmqXuxSLXlTUATISkmIctoZ8LRyX2JCCdQmHcTlAByP3kd4bn7OZ8erVO1CAzXYqTtjzf+YHEPd3+Zam8wGNw=
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