rEzWo6mRbyUViUwDCNZYCR81r2ay7EvYgu7CVJPeSnDa9Avi4aqO8RD15UVfFESFFsqtXl2jTYQMpLJa0WAZsacv/czpD0BCT+sA4c4bCif2lrLyAg9dQqCqY8fJOlWBOMqgp5GMc7Fj6/iFu/h2Fp7jh7Afx53KixQ2KgLS9L/B/O7+gtE0wQSR2VFBWC2YFytRRzAWp+YJ5xbFYE8OhiEI1B9oi52vZhFbJiwXEeOCztFlX1gMG9XQ8FDDe4b/DaZN2SzAehE1uzrioioJnUXPjtlJbHijK6t2ot16S55zP/UoD7dJ4ItLYnc1BxS1Bpv1lDV7rGE0F2SGHEF7t4qluSOxCtP8Zsgn25Q84u86PX6b0/4z9snk01pyS89DT+5vLLVk8WRk2UvhlyPUPVtNfTNNJrqq2YF1ZMzlkpWLBB/E4r+4jHyj51F98Sh39FvcRmIQQCF/FrqRpC86K3RFFbRy77/CGL7B5FaW9THo4PvDC3nj+qfp3BRL9Y79Jek48W9SNW77F+kbp6q5azcFrcAOEVysKTN5dy8U4zkJwIJxMVyRpMj18KjLoKl7BM/fA996H/Yaasi6bASszzHVxc6Av882kLiJ91FFm++jpoZs3txYk7KXZl50ZlPHhSz6+GgVyhcHy9MYrwJbUq3pfOmXpmdpZYPh7ziiV8zkVIu/wGy5FkIthTSgTekw+wPaTVA32OEOlcji8GsabwYUAPQ7QRPoHlE1xuL5xYoK3/cpK13dXgLZVmxNaFmvdB/06bkTV2Uhgh8s/wZGtSIAYA2D9+hbInL5ER2XoM+34nbBoBfEXGJVafSCc/J5uC6sxH/W3CJ6UKIJnVAeOCzq0N03Ihs6s4T0nu0e/uZZlp2EnYD3gGOHu2lktLwNEgb6wOKXZPdHaPReGos3+DRnJv9ClTh2cKcI0o9QJxpUW+Tlg+MBGo2B6NljpoqI+DaJTcBPzN8lhc/h4nsQA8t0ckL8oXC9HsH4QbDOPtXeWcrCdjBSQAj49mdsmAfFG8E4mdey60rE1qPAWFh4i7b/RO7XaOEE1sQK2E/6fonci2BDA5gks13ARKnHOfLwnhfavyYGqzHHetRoAQy9hHjJ8GZt86wlT7BIjoEfyNY++u3MuYdxn+EjQ3rtsIKdmQAmNZoEZHVdDQv50J3g3UPnqfB2qLv1Kg4rgWDqZLzs1FaMOqlmYsVphxIvtMCUrHEhzp/j2aQn8/6/fQWA4wb5bSgHk7S2IoTnoCRvdikBwMMgf4kdYnMqmmEZjuej7xoV8wLEqQghjC1Q8zOAJjbDtKVRwrw5C9Nx45oDGdVzlcTSWueOuYQJzAEWCeGZ/dpVWUHSkG2y3oCKf2spMsqKdNyy1Cbh3kKjbW0=
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