2NGIKJiM4CXBFDm5ADPFYDapYjL8RFHnoKyZvT36Snc9yORXzmfZ6k4eKaQ+vv7Ffw39sBltfheH9AKYMxw0urOkrGL9oQ566EJUdl9JBWZVd9ZFly+GOR7gQpBJe5VP2/GohOG4ZxTU/gh6KDV8zVJN/ainyA1XeJemKqNEMjiDnC+AzqSJDlyfAl/L2k7VhkM/j4BxCRTp4JYi8NAnLpBgImw1OQhB/4CrdbwclNjN4XQEPF4qmNcAtF7eLy8qoIJ5Mj30qHhHOELCOnmF+eV650vgPZLprVW5VtkwzqMA1Q0lcQsi2UT2FXrFBGF3F4xhOUkx1it8OZd8xkPf1/eV+KOAJbymX6HkAR2URyHo67snLBxEgO1C+E+6V1ie30hK/Vyr/cVb5OG/bf/he7562XnH9b82ags79kp+TB1WdX2lWWj9Xrn53K9i80XquBfp6jBJdmyGk4kShZaaUmyDnUuxBTv2X0vyW9MwcrAVAEj77mA94OZFCiSibkeBe+vjG24f5FvWQXjhw0xR3xOosO+SUq2p4o/eik7R9kj7bIWAz93mWQMghSi+GhYNGeakvEk3D4Wq1r617BJ/uqxXFHCgNuoFAxGVFY9u4lljkY3LUfc29krRt3i5bo2+Ov7PYQSM/6IHcZ3Ez8tiAhIKvjJuGDnH7VGesxwy2zv04WW11QUvQ5pzYe8SD5iotRPjy3PvgJWBWBvhpWIJSWKy88Us+bbk/kZZ3r5GKU8MoR+ALng8xYWLVL+pc7Us/H3Jb/mKPB6qwpJHK+3GYRtTAjTTNqLJ9FgMd+gARYRYCRdr/8vo2YdHaapbq7wNoSqfmFcfDeuFmDoausuDRcr44UZA369l7vOZgjvmJukrg0wXJofEykl2LwQkBebgU8sQIHfHaHXDlk0s5UoPB5xinZBpWmPlOSFGd4FQKpgwY6Gfpi8q55lNem4z2UtHjZBQs+TMdEVBYZ4i0dKXKjYS7+2xlwyuz1ZIl3qBRlQH4LkIqG6ooHCT4GEeo/dSdkeEh44E6DIxTO6+Z1zhUXQmDWx9y/LKwUkwAIEKuSpbrkyXqG1WGpNXeNIEDwq07ptyt220RbCZBgDto5FYRTZwfrBKgIvEu7zjAcQrfBdQsOYCO4y8nC+iVGq76d8ww7BibyRf2gmLr3OXVqwMgOmFoJRkkJbK1yfXqQF4EOwo/7n5gJGQudvsrz0g3n0+XO0b7UFadR5mcaNVCk37+4jOjtgn3BXusT3k+n7ksWdONO+Q8dyMo86Z/aqf/i5g9IS6uK2/AySstAzusZ1fUSRMsmEnByA5PAUlrnl+5NAeYRlXhnKsOnZvcL7hPgKFvRlQqGeuCAvGwh2nCNx5j0gxfRlsZDZQtB5I3Hc=
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