8ZPFzeTLZ1lZLQ13HlW/abwP2jbheqtDvAinWQSvGHr9zOlcbZYLjaU1mn80x34y/8iRm/qugzpeV6kFXXFi3X19Fg3p/wMFVnfxoa7RNlrRXLuCtDHRl+U5T/R0coEgMFSwgxqGDAPK01xtUqOKMO5z2Y7mdL7QsvfdZ4axmEngiDKfFlXL30zZe8NrJ8TQa733vmt7u+vZcsn07njhPncO9xA9vXYyBSu2guLcbqT3SpinCQdQRgv0fp+bcRaIgs0kZFHxQumTmQyzvRJIITTihHWR+5oYM0EIxYX28iexiW1Lku6+C78ufz2n2gVKDzWEWVNRqe2Yfo9nRvY2KDrfjS9QZQphJHkVFJLTfJ3KbX9CKqmLcnnZFUKTRdkaGsbXgVPgvcDBDioy5QCR3dYVJWrdK6x9g4JP8BxD9nEooxuA0ZxN0kYC7h5WNh6LIt79puS4OKt/uRTIkUspoO4Ikyyitljhmp1xR6Kwp8SO8x5eUO2IJW0ZQtK1aBKsz4+mN/9L5MZloT43a0fnAUR7LBt0XAdaQi4kvPaCIWrvn8akWmwFx+AlIg1tT24JHa7UtD6cp8OepyrkD04wwjSCteomUxPPkZTMmnwzV766va6Ji93QwFq3LQjHh29AANe6TbMJQHoc1X5CVYBfZfyBK3L3WlSglTkr15MpcGUnppi1fCqF0Q72pLQ+6c7xQe1QWzNpC1Wwp3//JE99aJENw8A049pt2xa5fgNwfDp77pnWczUE8qOLJMjPvMC71iS9xNrKuMNLWR+uEeQu1i/phy9LEGj51o5rh/UKUlMlWb3eqnE6oEcujLgBu3gCfWKbbeglidWr7pPnTc7fndvCXtr/Wt9gfytwgQ5xiva+oB57mjtgW4JYOHAs5M+Q9cwiipxzD9VlqZReHiE2YZ9tPIxC3IwAkMM6yRg5yu+PCxjKCEq5tKjhFV+op6cLkbFHoAUzPSiZnY04Gju+Ini8UChG8vAcgcqMjmZg8GYqgHUYZ6aJpS2i43OvYt1zlV9arp9yBwoc0EMo82AdtCL7o72FkC5AnL8kcICvg+AWS2P0/OCQFS1dq/UvT48fprWy0mte68v6AFeTbcuo+/KxKtNM37pq+QiSU0k6HufldUXge7r7vkF0skC7ZYwwNJ6v1jH9urhR4itHPSBxQ7bPLNtXzRRPCIYxZA7Zhu0g8RfbWJB3Fudi2hwlfkpHZSVXW/UmNr1V6eqVfQUwXO67vDGV3Bk+iggVqaBxnChcGTY6in9v4dKveJcaHm31j2chAyQRgB6fojElCs9m+V3nrdrI8hHttH9mirKTYmBMZ2OgRAi6hnW6LCkZKCFgeD4urwr/e0B7t7+l/DNP7ClnDD5NntiHg8eo9LE=
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