+PYYFUpCOKbs4dOp/IpI+E0spnqKPiRKofgzOMtlwvqvqdk+l7+c8FVjtrPwvDWkKqdm9N4O2V8E5mmEvHSgcIX0fWY9GLHGSuWkBv9DqkU2AreKfgNi2Qg3hLD6mfXMzBPxLaska51pfCD//GXPP7CeoxCoqv+qBABKH5AEvHUJZrebl/OHFEUB3S06WoHD0fcTUcvf7WLHbMuTOBLUqdkenuVnq0VK286QubVBwn1Nu1xcIjZvNIwSBkcaAPukBCHicVRDSOv+7AvJS+VmFZbXZ8/DU3Q56Wrbk7DGTVIR8PIjX1VXIdbA2LSMKaNSHFZQPU37YgBzhwI/Yq757AcQMe5RWqxX2xxImntzkThSzkcf2/wlY2W8su1qfkI1lqPbGfymCR6k7iYYp/OvL/nmGH2VIGF2rhQUV7SaeiQBsckPMO+unDpY5HkY1rBpDPGZzEQc4NUBqwYTSvXCq7ehE2keyoH5Ws8xKCuG73TRR9b0xtQjoU76QMSnM7lGFDjFXGSjxIS3PBgom8P5//jBnaEhemjdr/TxY3H/Bw81mn5Tbb70KYLJG+rqQ0aKietbBtG29eGWsESaMrv/PWMUeHIsiVnn41rWVdRJcxadMH9tc76I1a8MIe/Ku7MZUI7tvbQpSOgbmhhmGW5H1yHoAmmNNcOpEqZYObhpRbY0waWplSbmn0KXYRltUtQgOkWI+YStHUYT5huYOiv137dqtizDyqg5+6isYspS3Hj9YqD9nfAa+7aA/vmolUIsoD6YG4Z5GhGW2ioEvg5rH9DiKxCdkYSvjQuf5iE2MuMPtU4gr5UEzbNV1cEVxuQpS8o7CeE5rL11JOGjhj4weLcv1e+uCX2JWK6/sxLPln3nEZCgvIV0tkD9rfBq16hxu2AGvzvCbXxgeEh63qvQnAB5Mexfgb1qdJaSuBpAwYpCsLhWXPBht+SJdjaLitSLx2rDNIZEDykzjnGQuJAfR3ajbkShdciA6MaDG5w6AnvHDKWQAnlQiD8G8hU4OVyc8O6e9gGldrBzx4xe2v33Tt2yhLhV7SEuyVwjq4wvT8blATEB0B95uWU6TgfgbBEFOGu/CUDqQRIBZ5L2x4nXgUIwFHTMn6dok9tXpqB5mlsyRXM89lcJzW8gogmYaFzG+XkSlIqSzOye9YM/HToXjeI0vgw/4xO0sO2dkJFf0NXFsXTqjQukHbk1ResRnYxHivO/3h6TdlFI+0bMuxgIIqcJAR55YySUeps/7h62sxJu2BUs2Yj+On8yCs1agVVbHnSWqBEktcnJgUptU5h+1rHQXU5mMlIYv2MRmeInN1gB7sLSlyACGBsRLA65mYtg6sjZPHGxaEcOrcMRvhZqPBl/IQEiX8cz1F0gLBQ=
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