7Er0C4nmbjRX2WfwP20jXCTjudrsfHIcdrSiwQsuxhg4D6usoRlkQLQIBmjDftkEPiN8BJY4hFmxinPQAfBC19/q0uwOwTtJaGqzLmdSuROgLfdwYZMw4Hu9bfuqVL8rMfgZaaPzxPYWEC/FHQaAaWNR0kuKH0ETfY+PRswvbJYDnnBy4KS3v2S+rARbFMIwkhTBboT2rNks4WsR46qA1URldsOweWRgNdpk5kacCc4fstmPNA2TVSZJ3X2H0TUjxjFoRTjLEDrDUcWmSy2Ppe2rVLaY1itQaCSNx5x5YL9D7QdSKv2sJW0i4AL/wOMdGRoKQbEVaUVUfS5RsEYy0BA/c//rt1V8TSfVe7o9t+jJ41nzmuxKeaCDW5xXGD7MvLyiET5xkY4NM3rM5ko1MlCcQLGCVohtPMXcgdmFuHP5AxuLq1CxqPyBlZcMZIQoEpkN/SFPiCRBVk477gg1BJOHc0dvmwkLu4IPd6NFTJ4Cgo/JTRXac+jdmxHUKAKM2pvE13PovorRTllHILr/2Om04c/bVC2D2hMCSOdlU34SEbodQzzDeoMJsHczQhuVAxLubv7JuDouB6vjuvZWOiseuItK6yvnjoRzMLowyhlw0yhuKBPlVQnVxosq+YL0vGr57nMYtwVlzWsMFbLAlKnDowG1JiLxvXgvrBg8gA7tBggpqryCNSvLuPQko+17QFbtKMgcrBYVadpw1uMHdkUgvKBcZ7D+VY+UdqYcWR++xL86UszsluItCH4he8fBmZ53FvbRvnt5t4bWUBQJF7CXwHJKCJnag55jBiSoRrCnhHUcDOlAXvx6kyXcx3jIt8LCjMhHxr11d2awb7KAcoCbOVNb8LiTgajS80VA6+5/nrk4o8vFkYzKHvvyZBJRQuf1/UcTTIb7wivOAUDsxNsXRVygPKgbo+cfVOKVm2nuZX6W+N+rRhMxar8Ag7MOBcyw2pMtABGZL0fzs8IG1KmExRKOZrKKWcBEZOx/HoJ28kyxNWoqCp4Sezvq9uij4G896DaOd9xLsMNCMzkSCB8px2iLPpPntrbISggOHNrL4ne9I8UeO+/w1v7rAH+Rv/O9PaXdzkAngPwkwI+UHPbxVV80s7yOXBozEVnkjXQKc1vXwaIEZyxaxtMJWgcRMoRYskolatCZ08cGJ97JAZU0/kOp2LuTsWYlJmTK9p8D3L2XRufoQc5Nk8HqdfmQJOGOAs2S5raJNbPBAMxHqEx2iEd5NvVkr2TBY8XA35jrWEXGNZaTLAU966l7u4IbQLf0OJfrPS0OwwUn9HU0FsGwGrz1/nnsMz6vKUDJMWrw9IgQF/7PJbPcXWxJw6tPwA0q/N/ABmN8FqG2QS0Y0VXzlzedNVJ56O4h514=
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