6QbQHansmkj8gjkvCgBFX60IcG9tVKnL71hOmOrLYcVdCzgS9y5HT1L7e8GYRssfOBZ0EdLwUcrlTe+DGl3jtkmKgQ0HhDUzs7XJg7Qj9231uNWxhLd8ckbPAR/nxFf0Wr5EMF5l671Mef6c8p/Y5jeR3z4hWnYCjGP7kMZd2iAzB+pXxFrrQTkS1ptLjrXJMAMc/mQSAd6ZQEIpDEEXsd+QsJKRHP/ddE2Eta01F3F2Slr+3PqegWvyEaGoFU/vVd8tsKmaXePK0M/2/AvYuBq+yYNYFUExNe3wu8G5u/eicoQ8JeHqCmOpQE0leriwacFjSalvgRZI6bjupS+S9SloffqPYgzJ2ZH/7SIShQu8VcurhSHXq3WfZad1xB2WXyUUVc87NQyLxJRPTpDI2TdRhmmyeQjlTr+2PnSMzFXHTqRxfpi4H361iEVRZXA6Ndwb7eYY3AhNTFM5FIWK8MCScpRnLb1B60IFK/PtJzOvq7yfqybfYcSfRgBNh6yLYdYvJOACTPvvaQl996TUmcVVV7fPe5LUUxPZX/Acw13es+JxlZzagsrszW0wpENU653mwftX1oMoXd8Pg4zXXbP4ENiUIz7kJVrRYEuw13v3+qPgF/AZrslQQes8XtJGD3Kw1Fiwc82Fmsd2MyHlnjWuiDo4KwlrIpB9u7fmOXg8nI5dTl63X6UZAKIQHhqIw4GHqxo9Gj/k8fFZwtxLG2+Br2AgMs17BSDEJoFbim2ljyX5PDlJTDRotWFopW3xvu428d5igqRKJtu8SBKDXUZHL/ks4hHGinAkdkq/DeC1Nur1cJpuddrFJU1t1QMqYfp8EqBlkgRNe++JAISCZ0q774Z2ax9n6xHZ5+76xFq34cCTAL2EJzMDgzaE8M/bvHgKERHS9ceJYzxQ+wp4GFhqkXZtap7FcZrPRWW1onPxOWTcuAjXR+V/w9yC+mrlTOWzdx/d0r6wfR7982gGehlsN2zruR4bsVjmht7QNiQYyWj40r2X6O0Laxg8nCQfFfrLf5H0Dtnz8tLqVpQpcdmW4ibrM2cq+LkoSAI2v6YnhAlLX0/ILsBceUty/e8Duv945FLv+pXU8SumtYAwOgtwnVrXXRhauy6hYcERTLEUG5AfROKoH3lNH4xOYekOp8te+i0wO3btj5VL4I95eOnBJkDlZ2GcaUvGHmctgc5DA1GIGQUErciZi6vD/qPddIensrP3257gLRYrjixCK5NtXktodUXiBO0ls2ujQDPCmkfrSyWtgc9TPtgKaCA7oaFnqEuKMXvRJwvvVWMwG/sLM+jAvT6ibPTquna8LQw/v9/UKkAu1GJOIB2fmT9WSYkf40IFyd0rRVtbrwATwwChezDyhI9nfz5D9Po=
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