ksxPtAJoDUWjxfk2bhxv76rO3zOHOb/VsXZGnFaGLeFI1owi+ovzWNb3vlgLpN5/UiWm3WlLR+O/tnE1vD975BIOMTfSVwzecky0MU4TFdkW/iS4JdnmDI8CrX3OvIaatlY91TEqIuTvyOHuX6xjxV72YhB+O3/b7jP3+ZSY2fb6BjZjvZInxFG7jFCqE5sj4bg3ORR5MQy7nCvhrRep8V/Yn5N1TgANHRceFK+daZXQLg7yOzQqJJu20bSSw4HwRdH6iKvz5Q7ExvGNe6DfHZ/ZVgXjcKAYRLEfoqo5DdLPVGg4I3njBbkGHA5EXKzGwtS4RsaEADM3U9yURahH3+vy3IYKtf4MaUqSDJDoboYqaJ0dBWDvw4KPq011X1+eOGCeDdY+19UdeNlrRZMNLonLoglgy7mt5P242GARWW1w23OKNJshbGsQ95MpBBkS4PzI77RrrbJZnL8zZLZ3YuO9+dSE89NypbW+6d2p2tShvvhuOZz8DwHARnqtkC4Ao+3vfplKuwgVJAx+D88XquePuejKasjW34uATE034yQqgKh0Th5f4/doMEIHE210xM1JwPZWyPVJ+cbG87SiaKLbMlhrGgkmbptYn65NQX0OdUgi5F6k875dwyBDSAoOerEn2yztAb3nq1GZE8HQHLfcco2s5vhCfDq663aP+M5BVkxSH6oa0nmq+OWxCs6Susl2WhUyJ73FJBn7anMI7q7t6fk5QD3gUDngH4A48Eq1+Ixng49G7YwZ+vWGfg/Xw6N4Ak/7zlovEdSRMdySwQLl3L8bhWPeQHDqtgKdjLf0IXOJJNcI16iBPoE79nST88B5PlN6oN6XxDyjo9uPf19Qkm7C1K3l8B4AlaWiFDPwsYPPHfghFiBNwhW1W4A7ZrPismg9In1oBbx0r/RiGwCE9taiN/Pq29xBzaQ226P8Lg7Nx06RxRG2EyQQATgnwOdrtNjnNlXZcJTNP+GDWUhe8F1j6g0EFMC+zPimiYxpj7geKnGlsNP1Z5aPpPrWHTQCpvn0adCWWwUPqFjK0+z5Zl5A7M7qQfrD1w28PMMz/uZP5zQcoMde69AJyhtBB+ba1Z/IFT7uqz75leK5TvykPSB3Q1vZT5Jt6KhWaUqWah29jYvCUbry7MbwIC0O+fpHwTD5iqrx81ulpgilN9n9H6bOU3QCbqX7z8MbMyd9sa2sOb6ndONTlUGGb/LQzF0K4mAIrVnKkLqK4vEGTS2oNLh1dpkqQW1tXDh1Hj4YlNnRNMsvtcXR9XGwvORel4RBvMOc4lPs3w7lbS1+RaFMh2Zryhw+oqdYP5m/0jow1m+X3h2bE22iLVbD5vNiDiCUI915eAoDWIj2uoGmcS656c4MGYBB6f6MqSE=
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