8pgGKshqiEj2DzhqQ2fRyQxGVrFscfrMK0HwyF1Kf2iJ7sO28Gtayk4QRLONojHBrGLwxQ0MKEBe+PXoiy3OWrN3R7a7O7S7JOQ/mxN8TRgrDSDplcJI65y6nEjjDAgDh2m4ubXK573v8x+DylpJ4AlZOdmQiE3ePpD8GnZSJPPxAhHphT1mz6y6kJx4XCXWNSdx2eXbgAOC+QFQAwWB3xfMUL/WCKa+EdLauIdye1E/gpP1f34wsssAVfKuhscMSAIDNsAwe+YphG4XG0GcNMQc1f3al4xLuunkb1Ybn2VFogzeLPLzGRoZaWaJttaP6MQxFCiPD+h0rb1OoxCwZ52hWugeaFnuM33xY9dizm+XPrjI0yBU+A/uQQZPuRCYQDw1HPQWRMRZw7FzY5LX4yJwrHxSEdKRV3EaFxBGEHHySQmjovItlJ/js5tPa3UtwFNQk5IB2+LRAOMaKjIdtI9c8CBMeiKH5BTdtpljYhIHBvPJnKXSfso1rmz7br9NLnhlExM3STp1kdqbexqT0HE48cdvvUFLU+U/mPryFn7rnO5Vaxzmciniqz3mNepZS175TLd/HgsBqmu1jOK3DLfZ0jTpQUkXp5bn0SM3z8DSQer2hdy3/9BANrsQ/1s0WlGiuTyd7pldWoykIKck7Jyqk1MsWHdTvbJXa9USVl8E62iH2IcJKkUgjD+k34ojnQoCcQITiCOoXSfOvSxlmylyjOzXGy9sFB9kgEAGPgqrgfikuvV2qzpytjUlLhYV3zcyE0NIroBMCcSoa3goZPcuPvBoCG95OZITg6YXz1anCigE65eQpTumjqwTE63ThLulsI4KtkCHsBnnNBUkdeMmpRRB6R7cfdsJEOlyXZbvc1PtMPoLgVDuj03lqGImvYbOML59Ak36ZaVPBaKHUBOUvo508QnBuaVSR2VkAznlVDV+GJLZbIyQuZkWXi/ATQ72iodsxHqZBgtvkc9nf0IS/fMCstI+vfWhxgqBMPMsvKfEyXC7ev/PJJ/onMD2U/+rju2aoKih2QD6EULGx2JzoZjTZu2xGa77m+w4l9omR5nP7X40chGe1SYnvO5TAJBtX81thkpYXEI4xQfRy4CbQ1cwPNnlVDHeUL3SmgD6Q5Id+dJ9qJct+fXviOGtKdKxg1gJEs6DV1J7ULvk1vDij3EFpR/ghKi52X69k99lOvoqAvJOH6n1mpleITgju529QGhTEG1F0q4CSGyZE7NFg6wvZVWFOjhoRUOjhXKtZJWTlnhNArZeUJhqnnOvQl94jxaUgoVMbPZ5zIE4IZKQDUnPlwuvfguT9PK8hAYKrrfxBVJLh/xocYve+k5nzTPWtxEICWgx8UivXdi8eEE/p1xDSnSk1qQ/YGA=
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