GmkiVNmjoeRrSK3kDO3xzH4hKU2NJ0H+vCr+Aq6wRtlxI5yXYZUPf7MuH0bvKKxeXQ6pATX4kdangk+xiz7+HhfzX4ulJ032U0tY3e2Uz2fku8RhL55/n8dzfeS5oaIZ0NlIjtJREh4eLK3CuOylBDoYgpbt/rW9l+pjohQ9Bv4zPmgPi4UfHb9g0vA7UYuy9o3rBXJwMMYCPPAWn5VtbUHzHnH2/ddOmcOqKrz9GfklInnWvmpg6quviI09gK7hXVz2eXhciOvwxqEpdJKAHqCvcp4IO3qQYmWQiO5k3xhdmenh3fPxeJu2y50h9bG9tHB8PUxy1AeeUb5bEMl9XNQe8LBGYA5kENsdoM8F+EcVJyxgqnkICcqINHFEw6qHc9EVzFj7olBscTSD6l+hjiux/v18yInEInxX2yGO7H5cgGHhr3XineTnru/HF73h25cMefHapXET9FkJQA/+brCCjh2my8Rcp/oUI93c5IlmDyqHceVVQAbDoehTkfag4nI49uAf2obkbk42/ve/X4+QUMZnMf+d144BoNNpTiP/AjCyKOA1YZCkAZ0/YkhV+fYALP6yFdytmACjGXb8IGTdzsOqUWC/5X8N8rc822kDKavC1QTVzIEDJmV4pZTK1GEnFPHMPJBCXkbzh4R9u49NU4XtCUH3ImF4YqGELjS0SFqKmy6qar7PWh8tFxCMz+M6u7F7gkY3kJzghaHMhWBqCgcgP/qQUnAY33/iW+a6fMbF1h0jekhflyBqhWYYbXy3G+QOgNcE/4AaZf/7SCVfh9drg8Yaw+s8SriVTpg+DOzL03+DO1Gl7QdVocjao6X9xLlB9d1yXVCjXeaw8rYPVPV3ETsQiAKlEN1UclBTyjEyeNwZG5XeAUWU/fJfOyPaJ/4/OprmMZ5Lkam8Ws1HxNFU7hD3N7GxVUrqrpAs6xTLzdAdK7FM4hGnlPtgsE3V3AjzNWwfUz8FmNYlgm1LEGelrhw8r6cP0mfcsm0hnoWy61hVfFg8u4apCM7JozMfztm5jnqXodk6Qw+eNoZtuXyiMapVDGt5QaPyEX9dnmspoT1eaOmM0OwWsVkvB6zYIoHdJe1h4b+kD0Fk0QXxJnE8kLg/b3HuXAhn8z4Pe+DYojc3R7Mck4e49ZR5V7z0hCj6dn3hTFUZ01O5ERucyTiEXrIpzuXe/ZjRgNBLea44TrXNzJMJmArAEakvNjg2+718MNUxobewrAmQm6XpnmzimphbkRm9tzjAonLKrhFL3sJT88uSSDoogAQHC+0oMfcvRV3HWXaL5DmfWMbEYD4W3HmEX5Dhx3r1dbYyz9Irq0hGHA9sA4ZxnlAZDfYg1md0aMKPdTKcPi7xisnwUkHzCW9MfUaGm2I=
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