SH4dqoqf8ToumikrBMI1lL9Ao3BtSF3lxL84xhSfIaGoezidyHkBEU1rQXrrUJhUKm8YIPOmiZmONdJodyhJMRpkSceIXAXa+1VvUID3MyVXV2UoBnzlJhEJy9Vg3SPFs7iMo9wik23wk2pGzV0M95CvuxvJyw9HhEw+ZXPl4P3mtbhONNU9D5kWX5TYs1mJRmHd/dEPTvJgOTTYR9vHPybeS0Mes3/ciKeMzjmMlPLE1aBK56V7cxWxFFS2hVQMh3achlel2GQlp/j9ysWabhkzE1A82bmsPtWq0lUiVJwi4/3MywGTEuwB8ow5YWFuQr9zmXiJhBU/kYQfUaNWHpI48udarI2h259CdSdJaNwkxoo/ebUb/AA8qsDXfzUOKUL65ArvMOwXDD8bMDsVjEJu/1lWmWjIU0zZRyr5vSfLQSKA0zqY8Gh72ze/tPon40+u6LEgKtnoge+OxAn5f08YdS1SGZlav1N6aJay0bL4pnQCGiuDZsQdcybWoDbbxfwc9omNnZk5wcWeQxnIiyu7ffRUCqVZMX+BAq+fx7THCvMyqufIWWLJ8sCPcW/Ry+SQjXa3KcwCy6ZAwmrvRBZ9qT/I5iE1ORuqHMT1BWqBQxqMgWS7VjgQcIjuaky4BNUGUEoMYbwUfncvFaIHdx2+OECZ547G6e5CxvJ6ca5KYS4SSf3NaxyN8HtqwZYVdY3M0hZrI0gl9t6JG7vpSVxDTxtx4cAxYXY+xouV17o8avOZwesxPJkdY8DncWTC6wsflITdFV9boWgDCIwgg5n9/UHrf6/yIxtPrwn6r0qMma7xuP1FPgfATvLFQmHUa5O6/yGmlKchaxqeknJG2DpfYFGl5sFtw+KfaRpRBEuDQZh9c2OBZsw+Ctwky5SoAcKF8JAY2KhhKqiI6gA351lsMNTUI3MCWC+o8o10SXv5HcmXQgAfFrq5KM0gENAk0SqzcwMMl+eSUNE5Mk3to7KI1IVvQ1Ke2FLFcEV8PyZY9I4gL+SU391wnq+q5yXbAYBLEiHsg3szFbuMoyyJdfFbfM5LiZbLFZbe1QSV87ZKvq5rKLFgS1MdJC3+zgxIzOwFicfCTFOLKz+56MgMonkiGh7rlq9WZmP/qWWyoCqnjo7BuEzZlYR3AIb726ljMvQi4wrsyjYE7Vc46E6/OeNI81Cfo5BY+9c9LjytG05iD/4vpM0mdCUa1SSP0RrDkZZ4mf3EUHuAk01t9+z66jXQcd8cLidgRW1GsG3gEe2egJr/zfyeQdslFzuNsv2hHOw20/F96cVRjjY4tgDQhYvJK1OAj4SQGzdXertUerXfMWe19TSw1c2KGYYnUpeLCrd5ZQYkhZ/f2otkLNTdyfpi9OkrQoq7m0OEkBo=
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