mCH6Rs2EyD70PVQ/TAtD2glf9KqMPsEgQ/hT7A/F+H7rFIn1Bt7aalyLhJuCLhrNaMpBS0fhJJ+GEk04H4otGsvkss+1dIGy/cbeO7cGq1yo8h3+4wNns1hgVAibYNgoLk4+yCtStDl8PxDPjkyyhRBVyJrnuyQMTAjGU5fnJAlWlCaUQTxyOX1JU955mZRtKL5hkAlLtfVws4yLL7YFrWBdXvvtC9KawBKY6D5SD3Jy4m5j3ufwsa2+aAbgxa6+bjSOQJuE5y7WP2wkcSS0pmy7VntBTmD0ipd6I6xvyomQ2xETzMTz/2bHfJtyFveCIWsY598nfNQIseniO3LLxNhIg+I1N/5F4B0QGD1YcNtUg/ub6KcXU0unZ0V4lC+78dCP1/kaHJCOrwN41KfzdwB1cEzFg7JeMJEZp86vV6dyDJNKhf+np5z0vJvzm0WmTbMBliWS6AAAsPmEABwQeVa1ido9OqOlaralnmgGhdluigy9qx1aUB6Ft+f1PeapODOHErfK5rq6Pf3l7SoKZ4HkMJc+CPMMvJ/2XZWx34o8VVC/YNNg7lRc7IsadqEfceBjA8/pftK6dqL1nvpKzx5pNPm4UQ70tAX9iS9xoH0tG9ll6leZAnk68Q7oO9YCXKMPQ4QtvI5c7RmrqfMBLe11mHSuUTINdKu2hqBIqQ8uFNqGh2CqAT4zX93mQpHektQ2kl1VYHXl/RWnQKZ3UN0/qby+QadStHK+V7jIrJfLbksdg4g/YISijnEFDoYM6v5unxdsd27nHx4h96dw3e/a/c/uzKQbrvW5kuev8xoWHfMsIdAplEZm5sMUXv75Kbi6mxsKbwpl+5on2l3d8GUz6PPs/DaBLQQszdTVeqxlkghs8OZIVYSD33u5T9FR9NCw5M7m3d/n/k0YzaXfyI8NabtU7DVw56eEQBbPgBOcyd68wqDRI4Vo6PzdBWO96jMNjea62XwzG6BzdfAP7TIZRCckm8blC8Tw0Y1xJNOvVpmJum11qfGEGho2pieVTNHzb/hulBASlbpQ0tG0C7H0LZKi2hNF7b6+YplxI5+EsyHpDzcx9GLdtDUfZU7nPEvAZuP8Y9cDw6UxKKImO3UN1/NXFt8hOs9H6BYq9+CxihiUGDd7oahNe5CIhlylZWczxa9QK3o9jKYd4Z9QQkH28dwaMFjVbm8Ph2oYdhy6/mD9hkmdHAqBE1k/KS3fpXQHfP6G5tAdp8B8kvS82yhhz5Cfj703vCWfRHXPZRiAUCgp5vJuajSYUPuJS15Y8/ylEQEilRhf3E4wtWbOcTh58pG2DaK5lglj/UTKpYLDfDD6+mX2Edqw+H6QeoHnDZ6vxXeTWiWpwYmu2poIC7zMSvtMdDcBkyQC8QI=
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