dd7mh481p3Cji5ceAguqvFypncgP80qNnetvU06xCZm/O0z3LUzejA8SM42odw1Y98UuPyaCnCjW8aHPMAHPkmzVi8xWhCgp+so6lSkQT8EWNG2c0RoZkDHtLzKlBtp7eJlpAApARL0K/2iOvaLP0oD1DfP7sbwJ71lJVAkscpIXOVajiVV3dA5ahyhLQGmZsHGEy/6dJwKGw+VfXNYiEqkAhqX76ueAdtGZSEsB1SmEt9uS8g82+7wuDZ6DiEN3BRfdQwAedeA7/RtZzI2LIxkFe5pq81P+zcXox9mU2AEK03hC0fzzMmGy7stZw5F/pwhHuyOBfePcnGLL3WcZCpdgAhUeTjT4/RFySIQwRzEbPF27Y5O61plXA6EeNfl8xOcBpkwdUbq4fKTjTnU7IFpHAo41OzjpDSieRSowoBsa6WzY1sEDLLDDv9hQWFN37WTPoNrMSwL7yLvIASZKxtQmkKpw+dwuqdDpSKiLg5xBH49i4t+/phCYaBe4hCMR9uAf5DCAOS+zEUzdfhIzfO1QJ2zbb4dmhEyvg+E0PtYTyXZ2lFotk8F0UBJ8EgYIHWpGvbK41i8Eb9wflCg9YKmVtRqVzuWqN2PIj/TyBbPH8TyQ1WOF9Z61Vy0DZ49Aa1Z8N9PB2HEG+qW3AQNJeV+Xs3LaYh7VsNaOUARaLv7zsSGds8w6Ju6/vkw6XXMckEHUxo7OZlloRMEHbdk4HNgwa0D16D515QOTjNKB14x5E5vtcVPALPlrcLRfQ7ty7i/73qx3rKmn2vM90DlrpaXyXMCtNJJ0nv0lvJygdk+tYsN59K4SNNmAa81ou2d1uzEYzg7u9Sky0II4t4TWfnsofRxaMogZVA4KWpLCuj5CApQg7avr9UziP2x4vmYfLazArZEw5qA0nKnpDvRnXN8dbaG6QFs3o0ujL8fKfdUdPhaOJ8BIUllpYvG2m+TdDkF28CphwhQkMl/6ppQZ8aFGxdBb+pZI0F2Mz6QtXCxtfe/wBXVbxHi6zcaKty4ffeAIobF3lUFIdcwLMElV+0LXgzSGgcfRtkFs9dGbs/4tgpdbCBpSaKuF3S/uVFNQJhwcr+R7Bp8Xr3WnodpXVC/5MiIjMRoEdgJCPEe5yBacme1BJtMRO0SygCm03ScglhDc/m5m4fhIO6M6cy5b8f9cFNkUI8OOHHBT1W+WTXPyqkW07nhtXjwlr4vkPiET5YwKxLj9JtCODS+pCy5kIf3cAzDXAZfSvkVRQX2ZuMRGlfrd2WmuYeNHgNO2TAwsz2uTlAz/18WDCO5wD7E2mZq+immghXy9pbxck8lEbmMrsP2MZ5fKC5LIxITgM6SomXCAVyLvdQjpY4zbL848/seu8xegsyTRFdLH1Uc=
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