601Mr0WLOzP3KUerZ/RxKZboJ7eoAv/W5gsTHNUH0beEGdSkyjYcyvuy+NAvnxU6Et/5310ocTEMnl29iLPfqWq9r+QZm8sRl9rZ0cgPF2wRavL+hV63USaVPbq5fsgIPpA5lX1xzmqElp/v8NGwJl6A4OfTb/ODLpSGqDMCk7poUYtJPNKnQvW9TqKPxUefmAYqoCvLOwo4WRD2IQGKY7nPdVfffHeQ1xEWw2f99UxFaQdKbOEEtCr8qxfVgSLcCob77PNsJjcM4qvjuC4Zeru3k2z+0q/JiANcogtlSg7iPPgqFHjAPT2FxqFtHoWHCQJ1YMOk8dDRmgeEYVYgAZMJXu/pnFF95mnFoXO2NRObzzMq3shhveJn2fNhGDl8WVBfa9ks4DF87IOxIbk0qxY79M30XirxXV9F2Pb4UGXPl6VaL5VtU+NT/iprzs4Qujc1PILNKeaEL6YiswnrGBRqtq2ompabpJzsVdsnJg4YKaqHkkA6AaKOyvA3FIjDM7iBQNb8+fW/R+jHx3WgBekVWGukCbsHDwmNHNrZrv7xoIcyOhEyxExaeWv4CEQR3jwfFOWXIxdUse+mvb9ckpGwMGp8mHDEnsdH3J+NgoxdSe91Ad28h6jpE95HQSOMp99LdEQx/n3AuvAwiCPvK+rtNycmlRgFjE1M96FtArfj30HnXUH3AmJD0ccTZcEeFnm98pqtYWohUw4NA45Rh+ylT69B6rzNQAp0VGYy7N/YSlK7Xh2FzU1eJcN2sK9vCqnuNIExqjIHJZ2TdwvHhkEeyzBWPcznMIvtLJebsAVXzBzc3ZGQdgg+gqyHsfA2XIKCL7sh28I691nthPU8E22ool18uOMhELdu3cL7GArUWCvtBCX1i25amKfo3Ur7q/zj/o+WpH6+/hy9xceZBK+RcHJ8XOjAopCo2w9D0+od9pxYX5Ym9PKxc6aRQtYixUfQMBl6efKoUbmdiPHW4y+3Bpm38PrFnl4VMe1fx7KTyT7O/Oej9lyE6a7aohTj+e97qt9AglejK+jLzOk4GYct6/LzhblDBl/sLb6B17iywNVpQ1t7mR6YYixgbVhEFaSvlYUwOn6D64+y0xLL+GG2a3BxVLNMg3sCBBKKJGLvmb/qd64ZhCAniRiF4zfl1cYje4l+hu+xXI80DujGxYmWLbLbaD4vAsA1UMxTwH3Qxe5j/Tm8quiSL2j8Kam87yTL7XtLcR9YTONn2aY307DmGJby19pIux9Jrq7/wmcAUt/5lK4QDxerHcG14C5r364GZysNYde8dZo9xZMBTqOzRP5gFHTGgkNC9G1TbSTmk2Rtqyfh0HcYAXkTWGL7vxNlQGdS4TIcuoo1uO4GiI644jAAt0zss3o2A94=
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