Yp6D+tezKy7P7Yaci3dTcT9WcGX9U8KS3nNyHCkuvh05J01q5D0LJOdpM2kYC5dH3Mt/jePEkGyxAmQsb7gjlvmt01JuRjJjk/l0OyfQT/sEd/ezIg23y3jkONBcNGd6gXvgbHjnPbno0WsA+kTthgUoVvSo4L4SpWJFHYnJ/GpeKTlrbfUS9CVoNsWmG9CAYyJvYAB8Fai7ZmhkAItlw0ayGsl3xkBnYDG2R+5uLTHjf+kLWulyOtIA+AeQqTeRz+e2S2KHda2GtzZVSb0CB/Aadb+vY7cD25eBURDVGBnL/1XWgZLtXC7dWVTzlI6czyHvGlMkDu5ekdw+gqwGZ99RaZBuyI9ZWALYmuEXyjwZi1Rf8083SP1zfzCUro0luvTSejcrrFejSzDDzbbABNmKFaK81F7Z1UfBGWM1/UNh7zQ9oP6iz1fzanFx4W2qglFdCqu5urf7+C8artBpnJKBFyODj37aw1CIntpnXnpc4m3ZMkbxeO0I6JCpwunGX3CVLEikIuVVnxtgHCwqZY1jFv7QtSi/HtGuxIdyFXgzoaxEmZZDDaR1mR1lx+g2Ckv8fiUK1q0pw6RDj6FVk9mfqa9pY33HBqzv5ZMpOyKDs5/hLJ91LFUblFJPTNvWvMyCTRSxhIRDu1YjN/5qcTrZ1SCyZmNW2h+b7Jj1za/pJIbLfqjnRRrpJvk2tWk67HPwyu/cVvxIxNlncIafsp7xf5hV7rpQf79/yjrqVtdlBM8F2zv+qjk/hrYnzcDDIHgK+vHMHg3KjmOmkLQRcQ4Llz3jryvAx1d9/oNPjv2PYP8/jegSqXoNJyyHXCzqm2RdhACdPqHIVkgN2yzOBd/Qai3S4natt9TLtUrINyN+OKinKIvZRJnHkJbPiu5aYXYesOOxvdfXsPE67SMsIlwdtTTa+bE/6ourG/M93qGMJE2Vrnc8XxkkzmVPk8Hf/+0m4WZDWgJZNUQvlMeI1qGrH9u13odAwGH+SVEDP4obNNaTaRKcTynE8TI1HsxJsUl4ktXCs3Scksi2jo4k9vw3chLf4uI2ZVaP+a9gWpenz5EqSXi2v4tBU0N7RDNU3Mv7cP6zETEVOXoKbF8pDKOPRNHJIubtSMqzoTVS4Gw5/8VMZV1tbFvPIXCDo5b4AtlpSnXHaq5rlzGZRK+088sM51B/qlEWzkmRsOaek7k7t3FR0vWl23EAd4TrTv74u/8KJl3n/zW93acbHauAEYrBzpKZtw/vbW8fSF12D9ZStuNCyo2yZCo2QTUojZN9G9m1otiP7ScK7l4yP+dYuMf9CHWJPp7qrCqIzqjCGPFW6vh5YQW3m0Q7TSo+Sc5E7Mvu0Spun9rOBDIyeWvzFJNefUG4/NpOWJFG08c=
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