nhhpbvpcaWjDu3Yq9u7ZKGVHONJ4k9GWNhHBPOBle2P9sJ/QuDBJjtD9bLQuQH1lSEgb0GPwsYgcYWqjwuUWVpe4LjVx+IPO80LjNQ0kDx+1vlYZpd3uvk4EdjOuiBc4C0WTjhftioCA8nOQy21EInjfxDd2vQnZb9lTqhRAwy7zgeJ9RzZFqZmYLqQ6+I9XECISmCwTi04Gx9ZRyNuhoWmkjpBWmRxxTNYk+8cI+QZv1wpvV4HKZW3n12XC2CRf7GI17un1hkh3dGSRqoCP8dujCSC++VihpF/ItKcNM+cfC+6dkn2+Kzx/2uBWFq4381A4UZt96aPZlB6Zw28a65YpRrHYnmZ8CE86LFSum67ll+fr5x3rJXIONv4r4gXBkUuhUax2pNmDczwA+VKYYdIFM6i75xOownha9UfZ48UyID/rttcBw1sG72kRihvmqu1C/RF/yET2wq+Zlcz52WzCKiuXbnGtAn6qIeYX/NxIudtSk3fgcc6jTli+by2tK1dqbYN1CBABlLdC5JLglhR8AxfYm19acu0HLO1B28sa6tam0kXJqck7QnKM2TLgOZvgqhRBZvTM0G66FbbSKL5ITBX9KShHjEk8gT88JfdO5l5Tog1B3jjAM7teDYff9dKK79dOTuaMlp8oW7qD+zVpA/SJQczy7xPa6vRG8Dt44rADK94kUiQAZw0Diqoo2+7ScSxJaTCrGm+iC0j46pFJihd+AUWzFvVMzzEl6FkCRcB/Wbkt4jfBH5Jd7pqh2vaTbw+bVjc8lh8/g0Ho+rMvhsOyJWJuzGR2VgCobS9wldEPOmPL54JG9Zg/iEalZbc4N8N1/3k+ZLWeD8s6YARH1scb/IEOcU1BUCfFYH5agF3jOPbg7VmELXYHPA8+99sVH2lTaubPn518hFH67XFwKYgCGDFNVD45OmoiFbCDqC2XIZW7syZlQEOyMqrmvsgoUbJrv7BeVLh/1DRmJC2Nu1kBoAzMv4hneVfnxzHBiIAtjkxTYkuw9JsoDTQ/xGQWMQ+XSZFIxz/NMoB3kxyWWUOkwoPh5dHVSN6vlFDHENHHueq3l0HdYB81VuH8o51NbHvJovorLbzMKQZBeGKiQnsYGeC72A50lO41Cp5KjVfszf2fmJhvVS7ztO7yY4442rYHa4oobDXutYn8C1iTxsj6BF8MT2ganodidrPs56Yt0FHQEUcHiHyWM6VzX9hLAYEBGaGXEXSrCdreuu4LT/4xUVHKpdaOORLicOyFuUGQy6I3NhA5CFcSYO9uiRPWMccCvn0iwxOuwbCiL8eYOpv4qExj1tBrzLXH1AMAKcdNIp4iMybU+oHzk3s2oB/1eUW0LNDjH0Gw9AZ3o6MydbMtr9XXl981tu0=
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