3tk0vR5W5q56xBLqdvoSArWsCMrL5zjh6plhxwVKgfph3wf9xqtdM6a7bBv6mDAzR+pfOGeAnpkibeEUGzv8oolhuuR//QCUyRhDnCGtRogMiTsHScoNBja0MXpHzxl46X1jZ61yVaFJ7tX8F0fMmzkhbqbVBP0u6ygPzibcq6fkgrMJGvCgj4mi5MkPZxKtH8BBzAqqkI750/buROCbXJjIQs5tTbCq1UyygGCrk+pj2bDFTnvElRtBzoZaqoZy3AQhQrqxYBuHlAw/dKAVtlSd/73hFMSK6eRikH9KxXzDZAA6WUzN10c27MEurdEpwSjk2cyBBpd+3oQDFEFtZf4BWGUDpeZKXyqiqVlUd2PllSEBqm++HW8GC+CwphpRkW00FQem+YzN0e5r3siI4/SXszpXU8draLN6scAUEqqZVvRXfdFAeDZ5AzjeDH7PSI2yTDcso+TTZb8JcvhkzEZyd1USQVBShi6H14snr2IE7tNjUYZHbiPhJtbA2KrRCLkQk2UBa4jPbvOirRPphFjviD18bjkrM8braibQmdF9frwGFFGjTdUP78zyMgdxTNsHAGED3SSFwpiirJBrDa0EnYqM4btRSs4bqUELS841cKzbvsx61cY/YqDzT2knhbAsTTK3GE7dOBWL/cU+ZVOHTL+DdpHZL3RI0m/EqDs0xPVmJn+hPkOo+pb9DdJpEPf1y2xH69Di7wzS+PUu2poy3PhS+MeqkI5pG9yQFEQH0r3aYhhi1/0FZqF2eU15x5Be7EOnTClpjhmtDPrUa78FYfH8Ux139XzKidWlWYAKKqMsEFLZsLKcJCcwP05y8OnCM8DwRPy/CW4HuQuTl6Hc2o5nGUZp92/7DiAPyM/mUrySR1rlTwqeYwaMTlhuobkMf9SD8P+bE0UeRaiOY2LAeauELje9FBXKm39ScPE8lqOZz+rvZxLFpPGFVi01UKTA22FTk6e9emwQOZL3cizOAtPNZZHIHgmhhGfJk1IobewHFSLn8xm2Q0my85l2Mi2BGREims7Lx1nXZ+x7WC3Cnn2ukB7KyU7Q/YOUcm4yBCb/fh10XujTEpHrZIja99pPKhVucXYlE9WH1Sjzm9Z48faLHS8GmYFYQAuzIlKg+ZPZID9rgrH/Davb29I42TqnNngJxPlXknVnC++I0oQpXHhXHslWNHWc4+QXmUVEPtEQMQbsJk12ZOIOJyb74iX/DZN/vrsBv+vDxpqyDthgf+lk453eA1EQDmSP2oCOYXkpwW2caTXEy3Eq59lzpBDLPX89pSk8VH+v3rj8Ps+GpgQIsrFMYS1+bn1TzN63vFx4OTzzRy0foyk9sHe784kJ0hbDESuet9b4cpGTopiYvxKjE9I8pk+lugW6g1iMUIV3lIe9R94XPfydYa5MW9HVhmpACFsX7ibIwAtrM/dv3X8KZuuLsS9BXTlIYb8DqgEoMmi+VnUedponpQEyl+x7psAqXI5gTOniKBajC0ArjFiAbRZr6rgThsPgGJxlrK56IZKl2BTy6eRZnApkn/lWIstRM4kSnMaIdOnIJk0ofSb6K+aehB3XWyyADJ/RR10S6zc5GesbHegfrH9V/oGhspXQjciYk7eYiFQMnEevF+h3Zt5Ez2ObqtcOKeovyZNMyQixAdOaUWQeC/zFKApxdxqPOgdgicDDSfROSDqlLO6vxVfLWDt/eaPfMMwd0vnK66ekIjQ582A=
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' 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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100