0rDsa/YQDMvPQUzxjpIUl6nG+CsMM7Igf78S1/Wi+hmSoc55QLt9UD2PbduhPkint1G44wBb3OtC5HcV6zxnCJUGUcCh/MHKqj2cUo2EIRtW4RMgIIdvrQmANjc6IgVAyTAD0QOg2zaaBFerUm1o9HrSGLsJ2Qg7jAPtqwrfK1xEh1uRAbA+2A+Gb5qxeXdk40GsC/75T9s3UBp3QyEjS2nrkEVroN5C98iKkRcrnhYcNLwrLz+jQZlVmcCcBGh0XCc2GpOhFkwgJic1FPuxWp+SCZiV2fhUbCPwqWXQ79fJlndHqDKr0BCXZ8h8fafQtPWQJD4E3ndFVp7vT3GYGO8FfHcVxcer/NOatjyQrbUqKThTU38YE64oPgHZMLt+oNe4TtlWl0ZzJYMM8ReFUySqLVFhw8LXoWgRj6VlukGfw0Hctj3BWeqPgsR7+TOZdOWvZGUkLFvRgfwh/bKZ7D2p5LZy2/9V7vS4ANhuooqAeprszvolMITAiwHhZdNa9UfqowSeYATYMLZWwf4jh5Ojwa2b7N2eqpys8n+OrfZ1Hp6bmBH/I3lUXWKJQRhawjiMDC0s8oHuSdAqB5TdbywplE16zzr0SGmTsHNyw6XylPLLlWQqFCKL9TbDYFpOkm540+df8Hv1Bk5DDSqORozTn6pK0gikwfGlaDNEbKjLqLOo9gTA/4a/vsad+gtSYhMxaLVfSUE+rRjBIqCEuS+s5QfrQjuH/u3ffVmt2E5ewzIYeCic+eP4/xLMu+tfDCiA4htMroJLkVw7x1zDDpiTD/0rbdZEKAOsvBBiIljOe2/ZbHkHY2WfDHnxqrXx/WYFZsSN2jCs9bpuHF4HnytnNJernkncMl/yTSX/olrrf/qP1nTzqBqD7Os3aVh/ZS3GJutAweETdX0r9kPgpD1oy26+QartvWvcrqUl5sFVa6FRZK30VM20EYA2oDYH2uddhegnuOnN2dOtLxUv5e96NhnihNPh41HN0jCnxgHfuxldFSS0W9rxXoyJeS9V43mWn3/mQiOTJ4KdVfGiYVDnqSvaEPcpgar42u3BE9sBUBR7hhRqpHC+HCFOZHj2g5CJC8w5I9niJi84FiHyjQDsShUcy3hGhPoR+EUgnyGc3Cv72SRnImscQ1akUAwLcJWGLejPQsKCNdMKfzPpKFXwLklo1B4euuFA2nifeuIoRKL2CRipUQU32591o/Ow1vpuspwhrP7rKUi0IKCg1Q5RNyfYIbIJaTBeU2mBZngl1/AOVbYdqWxWpgqR5MG4AJ0VC2fmCJwcsEeHd1hS4vBNNYXl0n9WmSlCzHW7LmNH9tAbNS4duRONN9y9nBA2GfpyJb5au0na0ctkjQTsICNHnmeD8rCm/XY9pac=
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