OGgN97ryX7hLWIhnHa9eU75OASOFOXrReqwiwudCsHo3yVxjtDqLKS5RR9va/G1s8J7384yVaeLK7Dx2b125opSMIhs4rXcOKkStlzeeekdejtjL2AkdbjW8Atp6t9D1CXDXddwsy5w4EBPmP4+0A5AeDiiGNszz9SY28yDSwlc28WGwjehG/eglH4IC/GA3u7ex6JcghGeXfR2JA2bK1fusVOKss+6c1ZPukUyRhbvE98FKt58ztvOECjMi1dya2OaHdi/4oguOqFNZf5QBisLgM+sLXD3DGfEB2VavJ6Te0UL/dgC/ajtBU8enbWClK/+AondMPMG6Ip313S8Bmluf/Dxgv0uzJuiZlpDD5YjdyoEpw2CmyOlaRph8bD5l5gAu4ie+0aWIf1TfbJwePY18C4A9p9TRv/dsnncrbAW50N+EW3lfi/THS7KcKi0TuCYN8yy5T5VBD/qOrjxkw+J3XIRFRspzRw/PUt03fEj2qXA3ib/BzyNSGjbmE6eXGWo9YrEf59plMhFwu9QRR0T9XW1w8isQ0ubrhJGBpjw6HJcGAxA0iYZXCwoBTlCiIOB8WCP1IJk7wAXVfVsG0eXGU3H0afPp2sO4Qpkfeo81xqHw0MMsut0ukiTFQFCJWHO95s4IQnbA5wNeo440Mam3NwrBxBfUSc933jfdYcvEM+f7n81aPuGkq2M2XPWBCX2unWIO1Qk8YuuMA9jqnC1GqwiRmY7brAMr33ZQByRxGuew2NUDlIDzPTGSh+3pUpEaWNXlEG9aGA2jzbmSHb9Gn+Ls37qXexcXHM4yGmQI3tPmYoAPUCIix/wBqoh9qq/ZItho2njrEnTQLO04DWtL9wiUByEnJIXmIjTr+gREcvY1/dfMOlMPrLcIBXPVTx1/eKzcWEoVyLI9aqbG2FKrCsImFYQy93jR9eS3sYndY/TtblCTH1NNZAWK2lgOvsSxaan9BzoEAXSuB8KFEOmPpD/pmeM2KWUmJ62gYGEUZWR00skxhIXOw2uwTxnGK9A4PyrG0ZQnEHrsPYLP8rDS/azOzY3sEkpDyKAUceYNOCbPqGyK2Buxxw71XgSo9eeG4G5n7gwOIn7NONAo/pepco7DQq+GjaVO/81opJFkWyK9ALsow0ZApRzwHvm3OWzqUaLJh4lIuxWPObydDQy+I3TXg6HM9YxoRoOW8sxHXmhj6qPFoYbHkIrt53GS7khk95sVnuNk/PmMPxzhZuA5ISu1z3gQLW8HQFCDrlCx6b9beOAwIs3zCDvZuE3FigOT6dWy7zxN1ldOvcAQs+Kv5y2+SINjz59XVBskZVJPUYHQ/aUsErC9ZytKQhqiUwbXcwJ/D+9HDZGbayutflMH2BaT3RMDDSBbEjE=
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