kgL+uBGt5qxO98r1TmNENtsz+w8T4iej7oGUYlSjh92gZ3QLRt8LgUhOsx2/P+sxto3AUyPS+Y3cetRs/7yJco6AyhlbnEbPwx8RA6/aAQkgmDNl73ECLa5r1jekQCwqLQy4zK6VefLqSB+ZTeUnyzPPPCT8DxfoaqmZffkzADcdHvMbeYCSVAsjU9saIgOyOJvg4ZygkQO3WljX+yAY34Sf3YviZTuKBvN5Cv2BFXwuXPVeSdMD/yMeRKSz6ieg4S4yuFivdESCwE8vG8NNszxGgE6qnGu4T2eyv0CHMqofB5TQslh9/xGcyEzeiCZL8V8tAATn5imwGpWmUDed90V1yTSBfeScBgFa4aAYXkkW+rRYFAczHgIYro3yAyujfrD95dhD4J3LKIu7xXuT0GSBEIfPm9Ze7wK59oigSLGljyD+8UQvvBaaWg//PeqhCnWZN/nXm9XbCfKaZ/aZuStHCXk9afXAuO3R4aqLyQOcY95x0JYmgdJiFZfhazbC2+OLJc32MhfG2jvG5ctjYrRY/sFV1Qbi6tu8Pss89Eq2apWI9LAXI6fGxBiEgAIhzUbNYRN61OxGsD8jLrwC4ukyh3XnbFtTTKd+6PSEmlJocUmRns0V0qq159GN7+tnyIlb5ekrDb8VwsSo7bhRIqzyT2uw58JZpwMo6GFvUBM/Ge3YtdGuhreUgyYyOdVzm0KBIj6n2AvQaAwZ3hRM4utc2lpLWv7VcTSjn0yXJgvsCiSy+dcDEBXGsLXj7lWD1JHc/esyoJM9Zl5Ih0/gpLX67ZNfEDmYbm/JbjTDN40nVk9OKt3rXFUeHSEAsdU+FW0gig25a/7mrPkq1eaw/27H2GldoGfYlytQIoyKG5MO+148l6pMXhfQ97V7kvi6fJKiH4H++fy4oFBccTSfwtl7JVVBH06LLBDZh1ouHIKL7BqNVwy/7/k/y8ccaMegqU0ifSpOwgNJUsgmY4NL1xPfGTwSJBVlNKjUs8AXJr+ESG5oCGa9pdd4zWhFZCQbwJU6q7KnBblheqLzPs9ne69YiKEfI/yx0tX8f+Czo9jkWzv7oPWbkC7u/8ZQ8AnyONhEeWA482ns+nl57bUJE1yW3jke73BLYAqBUB6vw2Ny94Bm0fRE9eLQu4GN33QrZ3dC5psyrzXoy1dLxGNvri0xD0d0b7WgEH/shxHmZ7wKU68K2QVPkPo7/VTkz9EhN+M7AvXGj0hlgm182DkpfOK3K3JMBsrAySVaWVfHlFLFeDp7wVHcn9D0dhlNVL0ODbX02O0FI3Sva/uN8cmYm9QmwMpXnGjPW23XdQ2A8RVUFZ3axq8v2cO/hpdSvCuvFyTtoRAl9wcifk2RPEYnk1bOvM+80qPxMAubCGE=
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