+ng2f3jHb38zOcaqQoyCEtYdqsiI+Vy32XC83KhF2q1F+48jkWLweJuZQuHK2RZ9GdT43811v53uLsqR26tATEeuoc2WEOTs6z8tGOP0NNlfiwVXFjsIwrwDBzHjn6+3q3QFN1X6niA8MuwBZ+aWc7L35TjbCxwkcMg3iuSUp0jOriGxuXL3wX4EomLd+MNPSVXRIgn7E/XWIApLFKZbN7c8pHXYDfqWavBMmLYKZbJ/EyMV0GLDk3qH02Mf4TCb1tx7PcNczgZgHqDd/svZyQr+/FgBHPwu/EgKp+kdznfC5svNXZSsvo1PwKLq7K9Zf+LbliWdEVXOJTWIKoEg57vQ+jdm6ifYnRSjlZ4ZkDC7xjsPE182eRGlgHkGu7JDeDQng3ZC3uBPgHa+Dq7eFR5Rg4NHGKYDXV25NPzgyhBJ263OUKOPoAjkcVCkp07DDjojBDl/UxI1Pr+YWJVN1Ssr9MjrGy5A6dR+oNOfkz2/o8jCqmePkNuF/nzJP4pt+GTgrcsbQAzk7igpUAcTOTtbE1N8zko0/KTTxOOeDC2/oT29oH6X8Ecj7i3hYx5xr/YH7tF9UtuZ0NuhcD+4LLA1VB+77gHe492r/icdFd8CkJiLqD0/BpphOE+0qSZYJ4YhjuX4JOfhZxamk7dJstE4N7icbvWjqpFRK8cNNIrjch8/b6fyxeyDmDC3jap8zGkcTyuAnZsSPs0kOdegpWw+W68lH+0qfwWKkFr9Hce6e4hmWLzH5gCDR7NuWeu+4fJiBk4YgLy9dDc7bl6F3NHrVCKRdkHgkXQDt7TsPrvTgqfVlsDzrpdNd1ryaPGGBzcJVaZj/2k6h9If6eRXyA32kkFWDVi+Te3aGFR5DoD5tpTQ+7j+GdRTI1qUKvQ17Jj73YnJvMIWQWiZ72H+LfSfMxrhKmObefH96PFf8sx44Kzge4H6/rjczhwLX+2ViTNkuoRU0m5o0anT2uB9OKv2Yujqoz6HBJ9ZQ3w1KxWXayEKvGveSXCWX/PGnm4Cz9UbGOL0Kjx0Rg8rcYaCLbe8xAhST9tQZRxPN81rrTn25k3k+LxD3yubOTcEaKiQ+I3GZTUK0k5z9va7DFEcSfoy79tu84kf7o9yu2Qbe8hMFzXjrZOoK09ijdZrZHsFvD4yYeP26e74aNpOrzUqvXmcoLHKtYW/4VeaRCAMt6Ynx3wQ2n4EJvSKx0B4Epm6My6H5CHuXoJWgWvoryc2DqIR48spg51OCd0vj9+SdRtOyEHI1s3fwyRTxn3abOlmBGDVr5rjLlO8Pin12b4Kod0hC86B1pH2fzuEFNT0ux6gTw5Oi55uVfAOHkCJVmkxi/3wuKSZOf5Ois3zMqZEEpsUNxkntGddFLtwEkA=
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