7xCwqewJh6e7HM9Wx2jJvwFeOnPf7wzv5YaNecEflr9Ms9VgHGaEtwXcrg26mko4T38uxlTdY/11VfmcmnKcqwm5LrWD+XYT8gHik0RmuSvggBJ67sPEkxBY01QdyI2fBgiihBB6/3Jrmynq/d6GepyGKZam7mayW/CkO49WR9TVXa4DIcmf3pVQTeeqQrsJf+ac4zcZoHTCEPT/BMN5xoD1yxHK9IAj5uZesWL12bcSpvtJUWYxEAd5H5m1MxVzYNeiul5/Wes3NDnjc6BwKsmm3Mv0oJFaIEhZohCMIgsfDLa5iJ7CGyKM2wE6d28S2piBO8DiNobgbt5wy4q9GF8P1l+GdNT16bXs/x8/Fzxoo5hBakrEuBN6UCG80CJppf/JSTq1FTQvzP/6c9kItcohpyor1aMUena2DSL+dja07tDx8eds7ZZF396b/NWYqGLN9NEkmCWBfoSsrF+P2rPxya+6McgWAWT5pvjuc+H2PeVKudsrxju3aRePUOYyvxg10Rw3qzaA7RP+L7dl41y9gIyWHxEjjUfZlNNejuFF65JcbjDv7u9fAbLYkEzkD6NAXUWN2/nF+wMz1myrjJl6l12UxGVhGM6xoWCh0hTGG/0Jiv5/ctdtTaaS6IKNzUtAYMXKtNfTtUO4gp75uS1VEwI3R/4FZcG+E58KVJHPyz/HXPtb0pFY0bmWp3eE7zvM7TddIFhsbRVePToW/k8YmbBklPi4V7B9Boo9QQtVkaf+ZU1FxEILcwDeBYq4dXNaco3ru4blatfxIGEAYmbGTuXmx2kv1X17cs7bSE1uVZYtR8KCC4gJ8613lZow9LSopzYs0tMag57P4nTwnfkW2rJggTX5xdkhtdMzovQVgCp1r4aoGuFYdDBhcK055VxFpEOrbMgpZAzNaBuSjIG55VB+L2Np7tDS0mFk9+dS1P80V7aKiM99C5IRMsMzhZ2NoZzhAr1y7rszurSGt/XTqYetbO+hDHt51KuoW4rrIq+VGKHkPl1wkPKgaJV6yMpJ7z4xY2qhF1WgnQ2RNIM2FS6XvvXdAMwwdIW0rLmWrk08a24CJ7sSsr3a0XkE5+DdJhXm2Hvqff60Wq5KrAaa3PCbeVb3v59/mvLOdiq+LBMW/tTIQOwJm2hK68ewlbzMKmHLdR6k6lWgqKt0iqcktT71CWyIMmoVe0KNH3id95eEq1UwV7qIojzydLYlZWA9nyOpMr552GuKeQcvcArTIUY59NkqcRaUcX3SHtUFgv38haVFUSMZ6HplTNXw5R/Lrx7qWD3YbPZI4XFkxbKlfX88IoZkizOCdaceXf/AjJnjiCwquHO7F3a9yTUpA1/mk5oFXTVqal+oqzf2BH11Irq2Nl9FPrhVKGI=
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