+1WQzSLa9iK+OcRQ+0qmNJmOPNkM+Z5MIt181+ADmXWACp68EXpaDATJSTGRc3F4RgkZP7BCG37hSKs17o9OtBgJ5lPiWqQHsehCvoY8Ip0AMFVF4ga88dKwkBH7jwaje21tisqr1geFDj9ySNPmeGqXy9RsEeGzVD0SpAJy+ZcWIrex/xId6R3epCL9aPos+nnqcZXP7mmta80YZxDZti0jVLE7vcNf/dWxoVU5IFi2+sxJrLV7ux84Vn+Qt3srTLPLNYA7wm1uHVkg7aJZB0bQJUS6Zzxj9vNVkuN7ZLWbxqTBtZPTl5emYs6TeYAX9l6048jWk34WqIH7KfiQkI7iEpe3WchAv1wG5EDKF4pN0nRLx1UAsrccSfON0Vv5uihSUpyXg7PAzvFcQcp8TIv1p9yBaDab9CB85/4jObzUSKAPOc5sbq/fECSQ3WdCdyE77uq0dx1kVpRIrfPWJRu9nVTqYIQZ49xXiH+4kPMjjl9aDAuPJRBPdbqEw2SbdD+vlzsZhaawoEqNAwIkMjsjCbuV0zyd77oDfax1zUo0HqeM0YezNlcY4xZMP5Oz9fZQqM7vwgT3OEIUhqDaVYg11phbGoTkjQFqkEA90SeMcchOiceMm9IHBqa6NUFddERrRMKe6RCycv5EU6/ExMgOdsccAVV5aVtfpKYQf7cLex/2jLfP6Qb5qo4ZTMf6EuK9N0Z+2mLjJveykXrl3WIeznN9/D5nD844PEcUeWlZgbth+U1o4+7y1ME34TcbeJTKzgXPMEvjK0uyoVPQAXlAhVJHMWTf6fV5PwqPN48VTE1Dr29itVCXlTVh7Rxc0XO9n5WbruVZWBm1/8VRpvKgXagjc+Rl8y4Mqi2T30/g9eG6NAUsKQBBpP8ZaIg7q+YMxwt34Iqch21/l7u9wd5yeuWgDyFgdN1QIAtM5FGkxge/yxveSaSuZligM9Hg3wtWgvu34U1x+wdiNkuwjT58Cq0hiCFzRb+qL9kVx/zwN5x9oOf4xgbQssqHYt0ICiaTOkEFzsg46lwUqnpUDRqqyrmaPy+iEiMzC0KUlRKO0275cmpZml1NiGQaVB+iv2BeVpkG7VQJrxt4bos6pOGLAgicJ7Zd+mZKVebRe0PcvqOZFNGZAdl02E7pt0+L9N6rTVsiCe4zdXpfQl2bUA3L1fl7qubbD2DHZCdmh8xT0qRU9fnTHfrqUtGE0XaJke3TVBdho3ugBbxAiP8W+B+jXKozbTlpwWyt127K8LeM0c3jgcoxWORLlI0GlK3p8UXEmLM7cg5Hs9uCQVta3joLv1x6p7A9sOVurwemalBuFJqoJ9n/sFKwzr+bq+JzBaYhRVToh5tdXgGWz05cxqywmhkTWoMlNFXaF8U=
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