8ueedX0O3Mow9YSp7voAVbx4VeA+Y7K1RNp/0F7QIPlfQ4P7DjgJLF8cCjIbM7h1Hg+TPLSVyGzAuWs2c5luuTson/gTXdAjTqKIXKpAcaTbeRfqjlmRKCl3YNlvK59wKPUxS4M+p91YySOGEmTT1Dsl9CwUixxspQPeTw16v2zss1/uAmYPOKUBRmL03lA65LLZKvczLBf2SkIqRByGHJM8MO5HU9/exzDW4alhTZeCwo2LjXabA4FtV1jnV3tKWqV5JfbPYY0KtRf/Y2H5PDspfnm3AYQ8rJktonFNzoe4EagKzc8wXQheXj5acMI2ap8OlulN9pB+XAvrr+8ggnyLhItCtrKJcHUnxEG3sjjJtuLt/qOptuTNdIRc8+3ERtesBc1LPJYhzSqhleOUjl3iAmZRBYvRZAvr4w9GN7Ml2l3eGSyLOtya/Hcc1o66Bkt/ZnYKIi8Go9YPa+zaY+c5Dyk+O9PeJ4jbuXUk4EqcKO1KZVXniA9ijWwDYdXOnj8RRY3eqoKVvLBeOU765PMB7aXFAXf7HOW/zY/xPikCCnBHmpyAuC/6O5sMiDOn9pO4AicvkCrTRklcMyMY9vhBMauv1J9tD9TQaNlHESKtkbKn+TUr6eyXabgzfZHZOJkqDh7/f8BNGBcjyrtsrM8QaSOhw5d9dXF31Q+L33IdSMwnsCp2VgnJhHF0FG8r16sngbTR9fvHu3o32F155Fsagd3Hy99T4Lld6xlAcMdL1zXwTgrq2n2NaGEfHPUkpFwhE/VFHjKcoRm0vBNq2/rTgkuK6+5yj3idRG+FSWcIWshues+wFL4JBEn140kRmS8dDY01rrzgFXj3/y9rTEfVT8rHRt6N0Ydr0X0O7fApzRGcdpMmItPqNKZH0Qt9Y+qi8Oe5It6YD2qKWz7cGjl9Niw1btQuh2URsLud9SgxMEGDJuiBAB7EBdzsNkgYaEdyJiV4O7J5gIlpsQfJL0ZSAy+pd4lQ7muuCjuCarUCdeuKQz0zTKq+fqQ7m+hDvhxiHUZSIE4/56AFlovpPZGOxdlyyS3a1+g9Km3SYBLkiT3REr98CjecazMhlPoTIu0dA5GWVjpm+Yrlzsl7HGrp1G3cPMiwiJZINbtDcsik5P7d+6LdnSPV8pM7jeGhxFZgBFB+zpKlsJO5/M5vxOrdc4Hem7vJrmtfPuyiQCY8F4ZaLnkwBBrMZ99i16AtjKIUupr+8G+6tE1dy63I50Wo5l6W+MYnFK9HYnlNGKoexAjAebXWjJURn6RqlFJpbRLTqXkrULWP0JeA0voSZSw3nx2724amypjWPdR1Ie07N0EabGaLknqSKD9PLOo9cEOxAPqCCfjWzrGaq5T4l8Qo32w/G8466NYycfs=
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