HZyfWtb93beGPwLbIR1LRc73GZ0LrqoWJlahypc9IIB5p7mbqoS65PskP6+7cNoOa15XAgK52X93wS9euGcnoRVNkcL/GYd/qCRJZMZNp5bEx5Gkxj5ihUNFECJ/1gQ2sFb4MhHiX7HpbLGXhFeOh1H1xAVaJSjhOHP4JIEFuQdlncbCgOZR/OK2LYeFZhVGpdwYzTQyFbTPUlik0K2J4JAi+5RnmFvK9UVLTzTNhmae57u4wY+ogCgqH0NV0ynZnSYcs6VeWganZkMuBbPGrzU8Fj8tkI4R1R7xeXgVpzm1JrYmREqX7woV7U6RQZG5wMzuSdXBXt+jUcsHL3OFCnsSh81tWtnd/YKMZpIFRzoe9mRPhvuC9yxPQPi9rX66bq3Qmjpi35mUjoWI249unk8hF8fiOXgJKRkKbOOtYPRIxuxxuxFXhSCmyZhzBS64BitrZW2yb4OAK6XYNazk6NwQ2/08aCF/2FNeWxo46/bjkg+ANoHMwR0kQi1y7kqzTyJTLp1vwss/5760TChA9VTtE5K9p9OeBV5SxNzYIONtuO2vCFc3Ex3QNocw+spD6OBmcFbCYQ/Ha9We8ED7/qotVTl7Bq8AdJo9tXvPNUlk2z6OfKJUKW5FHusqn8wnW1NdCGageU5hnpyPtTPpqrbccfTBvkvZ+w5T//aPnugTk3kKrl2AVl8VNPYr2xWydScuWdPnIxefCd67kXmoMZzkuPTusJZOAmus9CTrR1AyXHN/gvu21Cv8dKq72jRiYeCPCIuiNgOSAEKFRouuOLqF+DWsrVfbZ9VCXduSuZhnjJYXODwym3t+PceBa2yV42XoQRPPBS9B3Q1C1Pd3guuxX+2uyuFlQ8J0qa48jFK9oYkVWz0oLJqC33LRKlEu9Uev7hHohNChb9vTHHpv93CdcZGyUWvYfXQ/Mc6syXs2krl98UaqAoAS86Zb2ajMshkm0ZuGPdGwyCSl22Eemgk94PN+zdnW2+yXE+GaLNvbklXAnIlt0PMcXWQUM3hBFvbLHQYyKFugYIzNMe2CcS1rLPF6tnWBEM5BGu5z8MlJR9LwaZr2/aFEQkA4OE/Ku3zwbcvYJ1b3UEYi3NJ6HP7KsQvB+yOz/hknzS5yigJK0fp+WjijEjyF6NZekqtB2Br6b7UQd721Wl9xFMdO0RAb+yCBaRDbmTIenB2aC9lShmCIvYP3DWFlazSKUzTgbEHc8RVzc72qzrIPjKzN3FE/ZVr+ptK0jzwyAKVUCiq8xVt+AhzIym99hCyP281sO1FHBAx8GJy8MDqeacei9NxrzSxlgSAk0eDkIiYXaHZ7ZFQYkhZ2V1nFugo48l7ZeCg06I1cNrsKXD4dIyTuhP8iPuD60VCqysAs78c=
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