4TrDXsYC+vpwPIPfA6lwDYZwrO7GDEetJfN5wphxnQOZfCIWT43vPlBj4aaXnOozdWgNsyYaZ8ekpuUazOtJvAX0kafVfboMNurcPl8fEXEauE8STqt9ssKQ3B0+HWhLxPXjebxbQt7xiVtewB3APdNmKymgWN5ZE0ttPBB/lMGgjZ2T6kdczleB2kDokxkulaZrXziUP+gP9Cd2RDgmh8BszAwU2nQKS5RUYhuxQL1OD/qFwFAap/igSz1G527Y8DRG7fN/3rO4I7td2OWj8mc4rldt4UEtWDYYAnIVn4DmsJDYI2KfzC58E+1HaWnpt7vl6cBr6uAcsxK5y+KDI5Vt6G2gKfEdFFCVRjUKSuaoWrPIbES+zxLEeTVENjCCNp+DJ3EZ3KNDWvOqKy3Ha/XIbiflcutb851I/o1FhBAtS0OSpX4lZY3qgStNkoUhffH63d3bdr4udiSCoZdJMXWqG4R8gjQHhmXCMqvVFm8AnYldN1ox1hKCOgJg4+e5k4IchpW5RVBo3mUgGvlsSedOiCVZ9ssQJ/ynGyGzZkwSnLqAZbBMglCbUq8JNyXIdDp4NGTAkKjYdHttlWRV41ptA/dnEqx188ZBd7JuV4mscygZHe9yX7U7+TGHzFor26lzyyCF5g9Gbo6UbbTq6RlyvCXXY/VCODn81jBKz/Qd9pix3Tm3q4QMbRhdhCrcPKQkcsqw6T2TFDQR0vfYaaLjvfIrnR8MVnWn3jjz55xWLShDOvaTPNgdLLVFz9v7WeGuptCjBvQeGp/cq8fTQUEEyAl1u+SF+kBHMbABzUXvScH5lye8nKz4FgY+vvjPazL11W9xv5ZiZpM9tx7JgV4m/i8rdNE2Ss/u3IHlazph0sjlwrFg8W8sZRTXB0CEi8ccUDTfY9BUByy07kyBjYTkMXgCCYpDr0Se/wvO6z5Dw2QfzFqLzAT3JXTCuWO7OJdcKPqc1ra09HQ7yxhEHfLSzMpuC9rAeGYd57uMzecNKS06JO2c/T6CzHt+PzrtvTT6d5AkrfIPW0dOwWH9MrRdIL/Vjne9/1OMknNe8KjWO9M5LSemiBXiECS9k0+AwXNoN0Pthi1CukDQxavmkNi6aWmW4O6pACPjUHgWwtHHsH4x7elh6NhhoK83iucvdRTFgAl5Fv2oHACLZOCfOrPuHOCA/fNGjkMxLHAx0w1XSXgunK1MrddMe+Yxr5LOV2oPxYg/ESn2rl5P+xCckJAa5emN0AvJuMY1HKf1GohmHys13n9wtHwW/nUzsqH5Vshz8LFLgYt05Ig0Yahe5GAevEXmstLwwkPYRIP1eMSGuhgEzOcAHvVRZg++K0bOkSSKsJmUc5bVxFJ2peZUGuhVBuXKDNLjovVTBcU=
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