2pyeptBxp3F8M6wvc8Zhcsk0osHDUiNPFC3tULmhJJJYwzPPbhFYsqHooX/SqCuEN1dfyUvd0h3TklKmpkFlm841fjw+82yvRch/8ZsoVnglAPoKTeHCbjWlxfvdrazkN3XFpbPjb/JPp2X/JoS5vOuKpCi/3dePCU1QlZtgBoi2zV/v5ok0nGIht5GGQKYlXfkJkE8SjrCcfQR4HrCCBbS7e76Nket68r7KcMAyqHV3EJbX1dNUUGsTLamBrLL1LCgMYv0XhNBk230C5xAqSsIiwvPvxpkF/k0XnU8BwE65vrjtebEcjjY/3ZBORzxTkhSgrmjUODVBaYOnO1l9Em5cPmwk5ANWMl6YP3pw917ZNzJsVq4x4Y5zQsZ+U+ifjcJ2K2zuI6ScmAyxGKTkHdPTP8KYLQDnlsQMURAEsVFZ0tBuvY7GxJtBX1wMAJm8yWBtZP5yhdqYaESvge3hrTukLWF5fuh9HB79buuhb7u/CrrC0ALmzkcVoHfHLiOPz+sfczOqgJAmjY7F0Nd2j4qRmUj4XQ0iG/5c3IyMN+7Gx/GUYAe8SGfjPPYhKKNd1kfG/Odg0EV3o8rfuG6O6oyzZbBxJVbC6J4liZS11AgjkbscxRznjTjN8jsCA3nVxF2vP6TWFMMIzRxeCQiDTGIzf7d6mRqnzAjPR7lwbPU3mPtsKdm5B6ZAFnPCOlAfC/z5EGMA5KOmEIpOPvf0W+aIjeO3EzB+f2LcZbVl+B0E3e9TPlyeuLStUjoUG/EpLf293UWNvsqQaH2RzBsh1NOn1I0FPy1wvUAE7nVsyx6qhHLITgkMUADTnU0DsW5QScjMMGRrWVOS49nwni0H2Q1hQMhxmTusP70Tn9LIo/FsHcbSJJbhSBx+8TBCJvuiF8UTc39KBp46W+SS1sipJqTTRl22i1MdjMCok3m6gUqLezW1bL5toTQxpOPv4jWyo4/b+OPYg7y9EIrC3BayYiD9iEJL7wqe9m6rTqV+Dao4I0ckY7y8qFE4cYlJm68EXPcsUkekqjDniDYHU5mq2SvX0lXBfuy5s2iYqODmHIDcGsRxuPqZU2o/tLxLzkpYd+e7WdULFy1bMKvpzxyIwPLQE6EBgQmjHUvqiDfLDkMIwlzTZU+WyeUn2udeM7ViSYnAM1fBhWwInG/rC4+lMt/fMLnqRZM7X2dnxpJ2NJjuh+mD2KrMnz1th/K4hMZlTxbbou8GOv5w76540m3Nx2Ri5BxN5lOuCgFI5wQOUJUIGXtsLTLz9zvo0rM2T2t33IpQZcUEdg6xNkaJGi7XfpLL4UNUnTxTy+YGOP2/cC7JVkBke4hP+xTlVQerycYpPV7C7ymCmCzEnwFlP8rFw20Irq0+I0YbP5K6a3o=
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