capWnenaI/j+naI6fHEk2h28jw/4mwPMvHlnEZz4O9J5doRWdRSfXEp3CWMGsPfrJaFn0RTddW7zhfza+O3C52EYz7mJz66xhVgBPWAN0qztQdV7JMxriC8xkFB913BWM66wUfX+TR8CbJATlKwIdGZZWyMHH3IpNpAd50b/NBUEyAA59/i0cqrhnwU141EsT9e7uJicu1A//VhA0Qwd3kVWlKo1n15J1xYetbKGV6EPl99l+N+Qrk7Bf2fVLMBk05fF1C3x3NBv6wc/sXWn12OWAELdknaRhgqQ9twgqbU/SK4kaov4pv9ut+ltOLU6uz5f8Mu4deOQsxP6D+Znco9gyl6JTzid4lcNR3Taxvo7nJ0tFOYG2vgMYMIPWMX1ZJIDILzNbp1GERkVHV5SpGxd4pmPKOg01LhUR3bUX/YB6xfIjejTqqOLD7Aio3H28fLDisbkmmhtwLhTYewM5pSEh/IzlOgOwq5ePopVBoZYARrLvJKvaBLS1KpUvJg4c0bZ05c96UiDRas/INps/psPVn/s6kuw/CDtP7+3w/uHReMfGiDFgAcrShn5Hx5e7cJXhmlyoPg/BmZkJyjFStT4dtFF8tC1EOJzHqYWaIu+ywgsuVaE45Zuwe3zouBRYqfByq4J5cJBIheTnu1IC9XVH/ArOvzoOzd/rCdkwwx5wFStxct33q37X6G8Pxcbq/EUj/qWC6iEi2MLn40TSeVGC6L10GDoGlLqgmBdHf7QOQGTumQf0uvMpacxnz7o7CdcCKYwPaGMBxotEmTgzab7SpUhKkMLvegokh/jQwzl73hnEZQYlsqye1eq+kzs5UryZF63FF6cKQSH4MHiIs6SpcaNH2/yzJpOgYPn87DOQR2Uv4FU1+4HelR0Q24faCTyc8wwM4a5jnxwvm1UiA1eLCqyMZSOKJreYpubTuoyHe5P0+a3fOP9XrVHwoBbKvxiiM+3uAv5ohOyi/RJqNGRNbRc0O4vwulDgAwCLtCv7+iXus2Y1zzHw2Rc0Bf5pVcQ0JDYZBipF44gJTrtHAZZZT2b5qzWqK8U6tcrvPlveg4Q6DOQlxlxzeLHuZz8PQ4vf3L/+kFaYMit+FrlRfPl8Tgxl51KGcNsiD/7HW33n6VM64t9r3qHCyKDI6mKke6LUA9yvKoLUOmK9YUTysYAhFOTn/wJmiW1UonqnxBYrhUqAj713Ye4Z3t7uOU11w88AScqOlcfrJ5LFRb9CnUDPWFHdscTdMpvQpM+071MU0PDNA4qUghjxvb/IQHBK6es3FQe4mCLrCWm+JKYNj1Oakk1GQPQty6+xQ4kWI1oD0BkSIw5mr4p7Xx9N3CKtq8sDX9A63YmANYqFL/Nur29mGfqv2mvAfAbK6o=
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