5LfYvCjAzf11qppN+5ex0woXgBnPv2lp9IHpnvhO7i3jzGDiyuZvMwv+U0Y4kcC0Jsbzm8TKhGEz5ZzdCUl8mmmu9THmWuzA3eIR0gm3DAijmMuBSdxyVLBMR3hZWg60U6PVrVWC1W66iYFn0S41N/7IKOBcRKsaBx58AGz3Z/7SXnwsL2uRlc+YLsS1/+umbcYl0Eu5lI4DPNFF+3RybgIec79XONqgdAKYYM9m4OpFNYcoivcpVqJyyzygRIocQa3LEGS22q7pBSvXM1820I+OJuVz/Fvfl5xxBznMEoTM2ENDFeaNTtixfA+jw1+zjuniJSkCV9B1H4KPJadlv3rlsEqm5I7T99GA+KdJVhGktO1phdncMQMR5b6TCq2srbUDsPwhQf79reagqfL2LbY19nTTV9N/PKh552Pl6tkhzeiK8m5gJqpJE4mL5tCreZsdOaetjMJb3y0NrkaLY2COucTrff7taShxMHDbzu2TLzQ79+eMB5ovqNVVWRpksSLksIeBsBFjI65tzuCbNf3D0xJxKJtia5+YGzbt9c0ftmdG0I/m5HRKPQd/XKK1A4PlyN4zDYeTue5oXhLf7VJswo2B0AM+eoaWndrcBIvg2D1dHGl66TuzKkUFU8jj/80SgE/BVLGtOizxFD4Yv8BO5DtHLyLDqkhIu3zjLVWVTQ4OUa9ctiKAO0nBYGRGQx5DGmWhY1e+787BcS1ePsOBIyYx1ap4YzTm+0V7GEs6Brs9LpPn6ZJVTwzSd3+QUZklzOpTiVjup9BwgDH2sSz6dg5eAVgAgVHQaQ5mGJxrreg7EU+1H6xrz7sGuewurVnZrQOVuGcoOYF2YCwu6Y9HAEdGJBlFzunNHoguQKSBCjFeGq28NmlM9cQiJdjs2spxRXyJq0TENz2qZ/9Be9d44wHQUn3SSU7DaFS0kzONWHEb1yHp0sTJ4MzlreQxrhv8IOZ9UoGiihMyQgumYm9CpFIgNcd49LuWFKzmIDbJmI/9JkhuUHFerK0FKTTrYuJElPSngDcRVv3egU7OZn7SRVYdy5JpvyeaOZt/9qTdGEhwhep2AizZGL8mZWlsXYALgeSUsKANF2mqJA5RZ2lxG6T2/znPnes1H9BKV/JLwmxLUxajE8aSaRKLoqZbwChhVtm72Hdyqr6/GLOOWhRRb56UOWJKQq6x7OVa/h3mqJs/Lxw94i6cI6b8iwqav3tZpBRgNDFWMrvm+XBcy5yEEDvMXXZOr/wIEAtnBW/HbjHPrv0zggJ9EZnsnc4O+cFwUY2zUEGhqHA+3T7GDpvsbnPMiXMnmg52Wu8d70b8MITJsODbYy623cCUm3ZFi1mthdmacwlbgtDEuddQ44pX2sLKch3Ox84PxlY=
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