MxbgNvV3HWXYgdinRBjcNxUV/N/iWcxFZ5UkJpQBEGQSwrf4e3jS5kh0IR6+9FoFeetxyAPljXW0sJwqfkB3ROQhhf78226afsHoFRLm1a7963VtkimOjBOz7hs95c87sK0vi6LyRniqESYX/ewHm3fTrEDprq+t++8lMjTEOVOxKvnfoZJK5n/NxZLjJxNzFL1JIPtP/B4AfHQxNSDX5L54CXgOYDQ8XVzzfSQxn/TiK5qkNrOoDZ8Qjd25swE4YrVY07hj/A0ZvfmRjap6gZRERZoL/JQzoJG4ypMQsZqjUZWa7TgIbv4ghhIq2RNds6LuNwRDXjRaiO/lwpf/bfvxi1XVv5hJ8rqggOrXV6t9ehnonI1jQCkx+Ruor2K0QqeYvPhUJU6BV7wev+DuWyh0zB6V/6XklJnA5CY5f57P0PCr8LkX/9iY/8o+/oZM78hhgmRzeN+AloDdEB47eRE2neoLEC4/v4P8D62YJd4vnP04NBrTYP6R3wWwmEwiA9QXngFGjo33UqJmSbUfnOU72sTqaEhOkVDNIxc5pbS5HS97I6qlmOa5enp+4h3FrCMPQsiAGkaLx9h3FB8TDwWlnWf/6FK+ndsSk5mKZi2e+HCMXLSnS5yKnj3ucF0aA5OQuktO4/ahxJlXP2F/C3PBTbONT0czcWeAkRENU23uogcI8qcQpCqUd9Rfm2kwpMhnCDnjHxnAlH3TtFhzckZWu+zQXDyXmgBjNJCcqEJGXJRQrGqAa+oKNE6Sbuu16i4+P8bcWhjAiTNn2SM8zRINWmXbRmrk/tWhvrHJotNRwjO9/dNy3rspDHiRdWDbywXT6TGWytC+SDtNRf9UXlYBfNGHfbJZhMzhZWRvB+CCvgsKzFN4bDoekGkJvIziNywDad6hFYcAUZ5sCH3cUE8hDbJ2QAkHX681VgvWL3AUfelyQcywjbVy64+qSLnskRjOgnlCSGcRSDxTDXbdAFoJOcvnlTIuVmJPX4ERxftrref0v6v+jbtX4OxOR31t/Y0L1UaLPpDoF+gJc6I6ngPA8sVTu+kgPia8h0MFTnyyktgdE3YzseLCzzCZ9sim/JAewCAh6pVA1Juf3c0IVGdONbGnBvjTQQTlaOwiRB/FV9AN41ZH9Sp/MQNMhB/ikSgiqDJF+O2N+CYQxp68lDg1bpzaZxLReTeHt8btpbi+69NZ0WP3ecuJMochw83TkENrQFN8SO2gXXHb6rngguH/TkZLUY+0o+D+EGrLy7/GkkQkxrAZePuX/AcrwkoVAqle5SZNs1OAa+aIsHfzqHr8DNhLbKRCr/b3qCyzn1qKhsFC4nMqOOD1BVYrc+K/vL0GtYr9TcvNGr3cVT3GLUi525F4UMn9K93szef7lsRuxITP+1l663PnCfSs390GOOe9zS4+Onke4aCZoRer3ZZ30PWc9w//ulJYf7AVi2d7kvkUlPbrGTOWoz7SpDCSG8i/ESSng0/0NDbZOeHzbA74xcSLWeBHWcGgnInQVv+yKGxZ9MO55NsqfyYyrh9jstWvBV97Ur+Jk6kuFTHrPWSGfd0+Snuxt20eZ4XT5KLbnvtZUYgnEiPi0KRlkWFZOdvPA2K42JIh3C4UQF9sArVUPIdfL79oIa0Ol9SDlSCpHsBnA6yw+RN4qfTv+OXgMEaq35K/y0Hs6NEHpS305Gae8fZK18CkOl8DaWbDy+ZTGjmYtvm7cZupECQ=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100