ND0wP4qSpMxDPCVOys2FCzqBqqsEDPcoYf+5kzApzzebUN7HlEZpUXiPfW70DN87ijf8ID/1aDzmYdRP2Ookq+cFKz0n8ByfhBTSE2hgjmjWexeIKXjUTtZfpgroZ875euTwQ+WXaCYvCdcPuX1oJrcdCGR8rGEFrpgPgyotcO4m2sslwhFaJw2a4TWjgxjq5fOG7bDkx4I7orwHtkENGUn4jEmBPn1r1OoDORkDs4l/ymKsy8mNFlQtS5aUYRYhXtyi8VO9FLY7w0KIiz5inAJv+O97inIZJGUjrlc4Jp5RzGaYyjFtv60mTqJLmyitt7eYkzpyVZ3EyziYfZHOuasHtX2MlBMYdY2oc+ZybAUVDvnz2akMPFM6kB1HBTGICirJNBFrq1w42d5jlLBfK+ENnKoL7gJqu1WPqV0Ap9owFWzt45WyPOtKK+2k7g6t8dPIGpzIILzKzym7YnweTvO+zDj2LPT94XJiVyJ+1JdoOtkQlQCHFi9+k5fR3gV84TYeq1wJj2orTTbdr6os/MFQIys3o70M85pCoNIRTb5ggUFQiJJi2LiEbabLdeQsDrrjO8zXIlDiyWlz0owN2G1m7V9BMh0IVYBjiL/Hg7JBV5H5mUDfWuJ222GSJS0Se6uTwX6JgmE3RUBZ89ELAIomTxvqHA2E4AmZGPeIkXhdr/e/n72uxGCoLYrQLrr1HfnFaFrUiZIYvicNSEUyNE5JUhsAo1LJblj097nfZyfqoo0co9yE3nXD8Y6mAyZtNTMjHuR9DjKwc2NfGI4eyBV1zLbo0615potAPJ82w7rmlzvHKpiYm2kKIFyjTjmwsOSn4g6CJgdY4CUG8hAcPLEEIq1z8xLRMyWtBh5ziqeVKidZqTHFj5D6P/CBtTaq8+PhYs5Ekzk3MXfaVkywy3tf7/G2iiI4ueH9zAGvkhu71ZLk0xk8ERogQ/cNUbFoCJpr90j8/xHyyJe3JzVscERKqPW5xHFY1zeIbfdd3PvjTc459XKhNDjUx6YBz/2AEKVdJ1OkFfUCFPutkguTA8aI6TY1y4iqyO9A0mi1qeIoe7IEAD/j17iD2+s5HnWIJnnq9YPfzFjGw0xtrm1Sp7D5OMjvOT6cWpN3i8ybycq5nYLo07QG/KFEmfXeNkHIunw1CeDe6hSVbvzcbJw/G9ZyV3p7ir8/aJss/1ij3kYHr2l3TUdkl6kBT6lFxPTLPEkZbhxwzARfcicz5ixLkGBahlKz0S3ug+Bv5kD7r7H/0v2vYJyc5RIXSBg7mO7XRYAtNVz0ltwU/sln8jrt2dbE0FJW5uKY/d6ZM5Zs5HkEQXXKg3MYP/K/VeIW381IbFCIrvNyLcSkKNnKmbAS7Oz+m8ODNLcGJnUZWg0=
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