GdO2LitUZMhttxhkaEto0u6aflDpCj2S0XeZ4cfG73+2i3q2xIWd15I9EbazcIM1LWwQJ3Y3GmH1n9vy6zzwe59Y12v01pXFsY91HGYihZXgX2j+mddtQKlOKufG34Xgsmfk7g0SgoV0oUfFM1OawX0OOrDkemvFZoAPrHa2slNHSnnHxeNiAN9ZVPpyRzp7K2v96zbZ63SZ0RjtChqY+S+Cz8FlEMgciUoaSpBRTPgbHTqhefcFm6Ti5q9SM7pYi9YP++IzqSnNxwmYAOdQ5t9s2Gnb+lIPDy6I2gWKsdcsIMIplEOwkTxqR2jPgHOMIACSTIFAjWEGVnkSWEyAr5H2Uv+9aqOUj/q6Jr0JnK8ewxkMZXi9/r0WR2PIq6TycUs1P1p7Ihx6i3TP5fPdg7+23bgmwOWFGNAKZRWpnie2UMvyeKc5beDtkRD13/1UNAxB3dPLZ+XFr0JEZvoy7vtzBG2+PbZSZx1OYYcmLV8Ws3Wuw0ehLDhEA5xQCYWPJ8CBbNRyuo0gRw5OR39r4UMfLb5fPioa7nb0SiSUjWJwH4iJMEk/qSGk85zRjnjp4lAxix5FAp2/twfK7QGfGs2RED9yt9IjjNBXNce6PZcnmQALBWxgZzrxGlLUODwAuDcv9vDjC55fzMP2Vdn5lK/MTwbX1vE2a6pIm5BPbOmZWOYyjqJ3XnRWaC1FzPs88e2q1p5A4eyo1mgG9nYxZE2KmXa0aL7RNBHCxKbNOkNiJB2xiWDn6Wn7BbSBmsdjEQA6owFgPNWLwxAAE0gp29TTHTRUCLjlNapHlqFbVY3Hys2spXm4Ou28fcBh3O6C+/SknlHFnru2zpakFTb7wuIVbfxmih4R13+4pJlOHuDzPVn4ccPGBmimF/Dp/e1P7yifbRaUlXQy+q4hdS0uNfQsEV1sZqOHMJnUhCKeVf9L5CYrl0svRt5inlJOAPryTjoyzTu8UHEvlTBsKDc4ngAyIcOSls1wGBPIGceJVyJPAKIOS3rk90WuLPprhS0PAtnlUv3cWIFKYVd+Lt+TCyQvEU8Sv9rcgl8nQNf3BaM3ONVj6wPSY2OueoxWV8ewPc8J00D88hWtI6gysluOMaY+iGg36zT449x9GytZGHTJaDDCEsmo6goT4gcabTs9fl2d4cHbu74UIoDjRccZb/Nm9Y7JtkPYpUpazyDx2pqU7YdJiJKETNNkUoYa3ILrwOUVWPWY465U1KT2c78Lk99ZD11UtB9rnLKguaYUKolI8Z9UKUdn9tlFJfEyFv2gCGY+we+27PRaGDL+qhTMMojBOEi3c+t9Ndeo2k67qasbqy01gNU/BDW8VHpDn4+meF4ntH7TGug5q/L1djhx1yJ1/SOlXRoCiERa9cI=
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