OZQyvNjAn6WvubjmOQAA1vSS7p4/FAJGe5hQv554fW6LmVp9MGqIrMmvh6UQ7EGp3qTpGuHG1FvIUNRu4RNE89FJPvuX52PD3VQeXdt2y3ZcqKNximDp0G6VQy+PRCDYifGz47RzagwRwb8BPU+iQ30nyu/+epT0JS1awOWbzhYPhfVDhlk8ovgh+xm5moEt9AzfdzE3Du/fYOs5tudOd4KuAoOovfPaS2+daHhdAfIiRvRk6rhqRq0QG0N9DviEWi+JAKsYPmSF3I49S7vSRWObZbVDaLn809DWC2wEOT3csD+DaMirIpbV/bmryQfvWc0wyY1VLp3IHTojYsCw683jG4YLxIHgf/gihRy1SxYvd8M49RXQ884XIbKYgLrrEJlRbaVz9lgBKDSAuYZ9yUUuUNtc/s+yEGEFJwOHY5xZdpb6pECwumEo8Up3H5PT0pIyHiPF4S1MS9sxB1ApYeY87b6y4RLXt9AKe6jHa17cdNPtzEz2Al3yURFZoKn4rLUJcew0SLQki6sMGa8Ydjed7oFaha3vzo0bJjO2ChbDChi+6qI8qBZWMPUdYYx/zi1uE9c8KBhKPM5rlaMjajL8jAJM1GNgzp0UWhE2GVb6J4qHE5WUaDzHuoD9G7RgrmwlnTwfPbzGCe0a9RP4njTZc8fZ2RvHMihk+P0luUS7t4LRJmc1EmkSJZ+Jyd03TDtMCeLZLTFivyU1BMmma1+jBH1Hgq3e7GRp1a2eRzUhAyfRr8LAKYluRWw27ehJ3MFiR2guSSzEPuhSZLeUIZTvxtFmcppP2p3OvTXHzEIA0qNnT4WIEe/IYhEBebL3yHiGz5+/xSdF/NO32Tg0IZW4eGSEWwDW7PjKLB2qh4rvYSVNvefn1ckeEWeRy9qA9pZiAF9sIcGzwC19rrHQCiXqqrCWIX7Uqg7SmOAABqjKZaganMJB7a8vVRZHqX3BGS7h9SX4OuSsYPbe66SbvHONCmop0fllZM53iYIczQDVvgGdGJT760IfPK3TSTnELJP2eczmB97OBPHf35zumlJpwCG4bnHa6IiTR3BegbbEwRmJPi+IHrbFan12izVXaK4NQ6ZjPjbfFYvJvsyw7nqTclhK4O9mUmG3sJQEt75V2OTAEFj1fMdTfXlBTNS8nfq7NM2B0HzPfMIYPVLtIR6cwyWc3iQI0SHNk+Qy/jr5QFmoTSYrYIp0ijpxV4yLD/LFQetwwHW6OdXijqRy93A8hXsS4hIHc4Jk64kPO98flZwfI6iYexHlY+qAV1yV4Ljm4Nw+eqgeHqs5EAKPG5vTLH0u6iq485GsiIP9gGs/raXFiD76fnqRRmbMnw+2eTh9dsCCr0rbB3yc5sV9uiDQu4d53LG6wljocvE=
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