yp+vz++QBj73/JtQWm8tXt5Ilg2x27BUtOqsU3sgspikj0eSoIWjyO44/L8oQRU2+VxSfvugHoz/zGnM6TZPvW/f8MZ02CZa5R/8F9d7x2mn6HUBsIxF0U//JMHyjmexgMpLsUuGREitjoJgW+bOAfo8QW/2VYuTrZjx1uN3CxwEOrGygiL+GQwqgsOF1311GJ98hmtl+i/tiAzSRj9U5AByVEN6YUrH0nrDYRLxVoXX6DrRnyBWTxSUsThrOX1UqpQspOcFYRBZsnAGl16P4wPk6dR424BMtunGGBJWnRJjumJZfybRN4BgrASEaEd+Q0bztVeXk9jIx9H9ailT4BbFlgAAGzQ+DpQXiNYoPMXpz6oUjAzT7k1/efGNSpbA1ZtTiglB3kMC5xBQdPDqoayJqCB+XfVLMyWu6+MFXSnkB/beV+BT1M1gE9hOS6ZvZAfV7CqVrLvGQKR3jQ1wfJOoA0qSUX4QfXvEsZsszQYfcaUZ9e6p+UYtS/DjrmtIA5sIB9NSLfT2xYo+y0nFhIVQgSPUHIA4LtDLns45ongE1BxWMjfxHLli65nAuZYiip+4MgVe5sinzwQPW7/bMxITzXEWx//RYwQbpTGZx4Yb9ULJ0anNoUOSIxTICPnse8tZAWhKpr4YEPFAe1HVhQ4YcfpWOCyGB9xury7NRG3hvJCTka54JlbNqscT8IETwxKIfhXAos4WGB/a6rnwNESsWgfgLQSOYktmyurHeDiZ7FdrIY9jRuSsgFnb1JGIsIbVvhEzxqEn09JQfxiRt46fRjQrZCAfWhK9MPR2bZWnqjnogALqLp8/JVm8tn4bIil7f99liEHNdDux2GKNMt8O3CdAb9eXI2+CvEpVdSJsApyW8qlGTS0JNGOcGSqRq2ZNuggzzc2X0grXKK6DCUzncEigNgLIQHQaOzi4f+aQRchiIBt30OhPuWXXcD8VhtnQsx072EUFKg0Y7a6IQNBkbBipPl3cvXxMazp2mAMJvU9fCxl0Ssf/nYoCq0t6ZDK9oKoUt55l+0wgxLMD/TqF8q83rUPD8OS8qORsm1NuGUUndJDmIyE6Vu17bugItEhgf0Z8gq7xRu9gjAKMy1i7C/j0Gzf2dJOU1XxkyfOw5wdMhiRUSgnHQxr09VKFW6uPti+IMqrzK8Uc/V1VmMd1nMS5pEetiOqSjsy/yWgdSvAsomZeqVLqfAbkR//nXxWtygiolIFyKujRw6yFb4rJLOXGHV2J8akBcclvdxlZ3j2Yf+K8BqzxNAUKECjNdxOB2YOc5eRRjOnEDUkU7T7rqt1byfNSSiiGD3Etf9NPwFv5VdLkPOOM/LM7KY6R56TCiaIkwQ+o/NLpeNbqe5QvsYsxGP0jKWKyns4=
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