UPkuAzjMSQlfQNQeZoWzlcsOe3hHwxBzsneiB4UfvkOOt0yY+RUxXvhzXeLKuxjWm0OzCR7GtMGf1q3Abz8P7k5zAFevaWUjqjZj+TtVFnQOYJwC+zeLkIwHCOxTva3KE5S60p1QA5ptFxUhZUVhIajxC0C6aJdb1hZ1wBma3cPOm4OCH1wKkgHEUs0nTH17ixSMTKVF5Ly1LRBtrVRSYkzfsuy9oZF5xwpwERbuNcdyDR2haJSYMCHpYFaFhPEF18iFpY9Mu2rjQiIdES7k5gZXGGnH3QQCXLSz5kIQwR++fpp5AjZD7iZuJLGU/p5x8IV7Xrhp3oHac9HWN7aJQFEFn0gYGueoSXWDjkTC2Nf1BZYkh2CToe7rQ6ENQBqnQrdDax/kpW3tE/ZPhCpFgIa+w2Mqf+te2uMSnR2bcr9AomEz8G43cyAxtJn98F3NzPZU79B5LybxHGFyi/ggN7LvTnlokL7+Rq1o+g+UwPJFQN6mc94mtXvuZ0AAK1EAIi3CjAlg9PGwXl8c2JXW1jhqqlxZyxNpahfSrTkd5udKn7soeVcYDGT4Xp3icDd9kNv1FukSiZ9u60bGUXm2HZTkihC6Ln6cdCMgvn27p79hntVwyeFN/d8OUSRi/5qOYpy8Sre0Mlf71DOEEOgLWIC/aTF1gUMCpDrVxuYlRNkknU7sxOOYeCtVALi/v9XIWMLhy6/3/B8Q8DfGyj751OGtX7xxahsQ6WCBZvVZiFdAlm7gCjul9Edz/MrBvo7PZdTRTrP/Te+1aCzhJd0LFNE0j0N8BbaGWc5VjE/ncH4nXdmw8dOobSqNVjkh51lvXMyyp3KYEFs5R+mRwbpSVtMExsHalXldaEWzHSu0KBmwDsc4384UzC4PiO5BF3cP2hlrYhZgI4RJKi0I8j/5HegU5Yh9PW4idfy1hYcHT60UKzAPFjPo5niWLGLOJUZGLSgWtirP//1JIoi85tzOWbgltK0e2mpj+vXOSdKnafMK10FD7b6co2Y4JBO7TXncY93kohd19gwtnyCbtpB749mZWbuxXwTWskwDxcFCsN2uSVFHEuOiFTPGjMERDHCkO3N/BiypnZFZrF9j5x7tNaA8qKU2J5zEYg8l2WN1jeVozpkcxWKz/Xx5hPbk2+ZeaB9jvmTUcBtNdh2Jx0mPwu64Ei4A0ssCUOf4kJW1GJD7/H0k8yACwlvv7G3gBPWQs25Z33uZFq0ekvpTD2/xCYU6YeBhTavQEzTs/HinUoVLzsBsFPrL8da0mQHwxNSeapLQE08we6/hfg/LxbzzRD6l9msDE6bOqQzVtp1EwFU9cxJPMMIPlmFDbs5CQyCJWy4HC6poXb08OKdWB2qwd3mbJ/BIdjK3S7BFFnk=
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