NJ4yfYugxzf2NqqYYZ02v48yyzd00RdziT7IRyUp08gCIp4TVpeXUozVr+YpeLA0GexrJ5FmSx2q68vHutLEjp3VxXmwtzxG+Fvkl6OOON0k0IKPFPNbrhXFUQ9G6eNjX1ppiXt6RqcmIupJDkHpAysCl2DqGEkRfr94XTb/hIkV27/06a8Xg8qBFkLmfZomoKyt0NJF8FeVR1cY3w4sQEsF3m+iBBnP/V8N3aMt4k0jcHAdi5HP0KKviAMRtynPa8GnbakhPFu5iUn/7yDYyi30jj69d2RdUuYYcD3AVyOCDLaxxxefCsPktUwuITqTlnsCtWfVgkvgvkS7OSpoaO/+eL/vlTIGMsXB1R6jRQCGyuvXv7GF1BRQdpi7v5We0o6Kc9/aERIv1Ibp9TxhSSTwacDf6IjhbuoP2z2X7FxhW6Bh6TL61R3Vb2QQgPvUNUqSw8T+2UXUURNFYeWRzMyS83kQ9wkjvbJDP1Khi7lHza5hLmxsj8R5o8pJvjvGmzUizNxPEaS5PRW44nK/RVJJqN0nRAdvzEE8gTZGLg3Tqj7oMcLRz6PJUrY2DtebuJK/bdUM5OWfsCBIa942X22bcrXjABBl86ANfJatjdw5T0cPVY7JTCj+XAfk3P1juFES9u8LWQUDVOGIMcnNIZE0Mx67HLMeQhGg4r5LcUwHFmRaC4abuf02Iego7X365kUMV3faixZSzIzMX40NL4gKUZ4AipYwc2thFwgfYweRcGo4teICAtgF/XpaVbd1AyPTm81wkR4fQGZ8qp+FPNWlamAuFCKv417mVS0u+LNQ/v9s6kW94FVNHQcogmmUDnslvPpqOVfuO0mcureys3WcZ3bPiXzxPiFDLOhgU0O7R+EM2ErcaA5jHJQX/zr3N8LnGsGy1hhqFGNNi5qX2KxJ6oaWwn8P6C4ecQTcFu1r6kR91KekZOOqXnJ9OoXNWtVVJY5GGpG0q7bgVba2ty623BFrmUvvgiTbU6L0AEXtZuCuVC21KyTl2AnMJyq3VeO+e/52SS2QgqAL3uoogHAXDb4QD81YHz2LMhNR8suKim0wl2Qd6jaOGBbEZbn35RJTwTNBINPOFjDgz5WHsr4WSPkET9aStO+ExYv4/DFw5dt0Ba4gAqNhNom7vb89zbsEBeceT/yMKmGoZzc5/s39NlToIv9s3DvCT64KPxdTddWJhgGsAioOtNwkRxmpGJSnGqcrauKVJ6ZMNPIBN6Jjx3gMWs32hW+5g0PMEMT6b602FvvXoXjr96Ya9IZULIqEaM4GGGHVTb1rOpc/OKBQ44itYCb+SHgXDpX7zt92xzrc5WkLU1I8FA9DblzVGIQx0Etmnb+o/tK73xC82JSut3xoBHgCLpOwqKU=
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