129ofI5D+u5uEjsDNELNEbnavN2EzcMGUaHf0Umdbq5sOIA3LQREp8NKqfvPwY2vnLAmsbG64r8tmwbi/Luuve92tvRS5ryu7D/+W0gby171/VqYQYL6qs0Flu0Wblq6PKOYXzi+rjxmw5w/aNutcddjjQIyLxMOb9BIyzrEorIHHL/xGfXUfuHG0ZQAUYlpfY+bWALikLaCRo0NZwDuZ5nma29cOAuwfSpcEwMYGO7qM9j0sDsA1x7MDtaEeXlGOa+wK3+ULV8jYN7+JfagIUPFOwNAoemPV4NZK0TEBBh5s6dBxYnvY5tWLSZ+vFH0kONcXmC108f3xxSmaWc67G9ZEmII8dJ7ELmk8HioiOzcrh5XwgaarAKXBEUuE9QKQvhLoWB63O+nZMjTqGJLFnzzfzHeilvzm7dfC6HmO8FBfAYIDgTNWcDB+p1LYsbOD/AQxlSwEYSWISkPRwjfIOLtgI9OhVsp9F/5vctoy7a573KLse3FcQM3vEmMpqV4rGMY2mXrwfetiVuRaEikBheG7Q/ZT3qVQVCeTOhxQk1Sa/vUdLMnukdvQrCgphP026aLcvSBB3zu/9kDYB5TN1Sih2aPTVwuDaVa94p7apETh1IDLNPB8fou38cBvNn/PawBZv1yhYt28x3qHf8rtMT4Rtuj9QNiX5Q5/Qrksva6k7u/jdfb2P+cLIbrOjdQcREi9Ta7sMjuUD+jT39ecoT38CJ5Y03uxzIYiwFveb/mjaSiB5nSTtj5l10xHv+dgwrtRKLe0Y60POi83aW8qRaW0mz/jHeenE5UoGheaKtPNRbhQWMeSZqaeChManl65KeyJ8is9wIJYBSzw5tyB9k6OyOwszGWWiW55+mrq4AAkbfO4hECHuhuGlbMcXFz7H0HikYAdwXYj7Tffuoi8UtNveGIHZ5qPSziKyv+Z7WlMdFMz26BYaQZA0p/7Jw3HiM27XSJMxlw+wNtgjuftA8K8soUbydO2p54kmD+dXyfRMfyW9Tx81AN2Gau1gBorH90Kxtog6rW03uE/Y2Zywoghgb23yPFp+g29u8WebUKWAnl/lkoll8fxMRIG0Nfz6rhflsTp4oq0Ced3fwpkVjLv8ffvg8tVPKw2S3tJzlZm273Kc0j+rjDSX1PA2aGcryA5OVs/1l7fvWqHYBbBv6C/oWOh2qfWdmZx9SLU/GV6xAslEh223X6/YHyQNLlOpw9XZYdv5eEuyH81/XdBhX4x32Zsw5l8KsiNfLxvD1S8HsQ9pMAT0efUHIo4GHT3gRtIubPuUON2hGDfz2bk0dfjy9dv9XwE1G36EJcRTqYDmEmbWHZ6mjw3K1kKo28L0x1cJO7lvA86avet7eY62tf/cy/PkwpDyAlldk=
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