gvAQRUcbiNdU6LCfwHN/qNCKbIEHgWBMRTenc2QydQIpH8nKjC5HxQT1tWT9qxmFiwylwaegFA3+zU3VndqIfSJG6G/r9KR5nPaToaubwRfiMk1Q0oZF3H836zsgwwqWb/PAYMBCH8N4CnPxxjyA6Lg83E2SMtMpDTGaO5w1RWAVAQSuo5/2NWVMkdAXc3BbgtxiBHKTfeJ8XwMj/qhu4VQPP/JyYnNJUmt80xHhQEjX2JHY8ZUkV2XZqE96BglSyNobDOwZnx7VUXOXh1/l8/xWa9xx4siNqFPak7SOYx9EVz93RVBIe58wP1lqaEnqsZeeRiqGXaupQ73GSn3f5RJNnyw7yJjPAEWt8nh7XwT2o7g6vjURv7/5qcRx0KkhJsx3SxQYH0CgrPYwoAFzgGhNZpfx9qVka/npUNu8eUB6H0kpiBcM8l6iKywLnd5D2HBxDDryHL4zDVhsENmPsjJisv827277csda7f9uB4XKB2FiDK1zNa+ISyn/Xk6UDGio30EygADJuq88T3Qg8DUW9veXsA3v300Y6rfTEKZbfCwc+qqZwdsUi7AoxatKJXQtXb0i47V04OjICXh7jLf+7l5k/x7/FkBGpj5x2huLX4+KjXZ8XYU783kDIp+kZGFUuvGr0aj3e3UaElJLmaAuifFqsRP1DkduTIPno2MT/2LaZFkXZIpz61YhWNpgBiMmsMoZt/Wi0Dy9R1B8+AXAZOb0bRzKUugcgkMsI/Bcl/1V4b2oSVOvFHhNc0HlUhUTETc46pweivD9lhOOt/6CaIDBDuTNWKoNbEmHOJOqWAkM3YgcwJXZbgK+ha9qfDf4cTt4xcFztQqjIVclOvtsXZ1He+JORDCr2Y1bHzy+iqUeSNdgcYBRKkLJdiQCEAbGRBswanit8Hl3tocb0G7sHa28sDIF2k7pSDuElnifcuDB6Vk7PQqjGZ/Ln6LX6ZuA8yBET17RI0K4LCkSMtNPuAvIN4kUPWpDKE9mbIQt1XfdaZF2OuR/Qym1AUdQ9ZHsBqmuBJ5v2vdb1T3LlUbj87qFSuuD0JbZ/S9dYrpueu+l7WYPV1LTslw/oyn6j94J2q/RavicNzWmM+fzu38iSD6F+4VCN/zeacNJUJl7O0mmABQTvjaIbbwywz5gY2kwBlyl4IFgfuTwi5xPTtYTSAlKvoofDmNPt704yyX03vmPTONawCBiHmJZk5mUt7J6afBJ/JB4yXPvNdKp+VUbcHjimsMrp0Tmp6ayPRuxbq5sh225lEsieMJ64xWVpOz0uwW6KXhD8cLCS/rl2xIMz9ULvYBYqGziqJNbtMic4/SaaujA8xUnRE++Gz/CvXmBflU6/kJUMvTkXb6rjc76kgw8WmZaVxGUZAg=
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