AdRs7LH9lBCR+y2KSgNKr9XTDD3cY1nhnpCLstU0Fh02P8oPB8A9qcalpNhRahnVl5cwZ9S55UTi6Dg9FKXABWLAU6dbnRJc2a7mqeUGSK4rPlqBzgoXPGcuzdNzdqDBqweU432ejH1zVSJxejN8JQN6Rs9x/fKocxJf6diCkF/wHzS3kulH53SILRflBXIBHJROMFZddEqvmjn3HPP0jRe3NVOcB1wLjsFLdlMtgnRfVmqE5w8GRz0VUJWtvTiVDR9E0MkldLgPAv5lPBeaWklSvglllD5Uu0yuIGRR5K5KTjFfhUu/x5Xw5lB7gdUft43pwClpxvkTfMHV9fEbtmqnrEpUVRUvPMN8OT5jEIS95v8HgKZNAWdzHEyLWMIwBHg+nRvVbdT7YrbkjSLYfQ5lWG0nrv26X1bBMDOxduhGhpXe5qkMVtdVSPYPOmJmsYV1F1pZYpNRIGFWZFA37UYeofeUgwOaGh2UJ6aYJTishLLjWp4zoX21dwTIDRqYkAuWyqpjpsBPnuBGcfe87+zwm+QfNIKbxWBN8IAHMIuUQDPVHr1mE1QDM5OZUlcrIRJGRDtZbD1+8aIwvKwW5ERIDSBTQAbSbQMsu0BytOaWSsHKaUkBgOZv1KZfLHcLVCjYmUdcBwfH3xvi2FV1tXvWi2MLfIrk5/ykPV1CFKfQEJbE/6GsWqcQ2sz9jf5huk9JhoNzeTaB0nHAkN/gH6teurolt//PC93FFRLBC4xyyhxHBdvb4HQlz9KTzKMpwv1rwWQFhtw7IZwodG5LJQdTcGtM7G02RsSQddzLDb0tqRsAd1ioC7SFKqH8mn9jdvJRQedSqI+bcjQuzDCE0W8M+8/2GDvGJBPqbJ2KvqiI2ESmGElXpjWGb+oM+493yN05LWKlc9t6Tw/nWJoF0dLzMXKDhQpOGkqxmozTHKCBN9Ay+J+DQnA3RpRPxAQG0ZUQAlGCaOAAx5SnHPDixjJU29PTQwNW3LIjH6Asi8gxQDIDxqGmzsWEkOitngOfrGYG73HzjHbi0ya7+Zs2XO1BNjd2o7mu2AJjs1GBgDKpoRs2UWDKUf5AjJOsH08LL628B2uVfJpI4/pRd3P1PY0m0jAOZQtFlp1m3VPz2Zgdvn325DvmSeZGZsvD5xWhh4L0D/xrEsLVvu/c8Vxvq11BcXk0aMY3GvZ6of2BSZ1Eg3gl2VAqijvmHWagLDO5B6bcnYOvMfiZWIC6QiUV9PXO3yL99V/FyyPyP+QRXKIqOrSjtASrN9b6+e4frCJAwudwt4IU2H2C/3XTSkHp4S142Dmms/2eNt6U41mCGLdmdB4mCuHfLfgOLthPXLKpNn3I60T4cl+KH6iLCqfmGS30fVMrWxcDUJh48oo=
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