xpD3phxDSVzTLvPhzrJojiIuEw1B37Y+leQEzp8NMvlXCwFXMqacx8qADOj150bQD7jfd6/MW3MWgmXRtb8mpzstH8QpEkV0aCFhc5L+O/TJVROgBuSEovjCUk91H7HSWBRxuP+TktXKj6qqd/05L6nEB6Sl3yzK0vbG4RzTRIca4OSfAX60c2SL86Iq3wET7bcSS/kXP4QiN9k0LxkOUDF0rSYYDEc0PL1YvIMeKquyIHafMZ7I6695r/rsygpeATrQgtNOXoCT3k9XF9GaYaI6SKxwO09KY3tx2MHkLzmQOSEDedmWWGiRjdxP1Ckr/4SxEWkvr9wVwQA9iAITDPxN8/D8k6pEexc0J59Q35ag3IEuXvcNMXTKmz86O8LKf2qfRqoz1WQ+9pO99/znVxuqne2iG0qXSb3TBi8BOotbsAh+5ebJLhRF9iA+pozof23XbAeDdqld8Xdrl3J6R8OQ9kt+f+RP9kaeGvijniNKRUJFCoJ2Apsdt3ob/dJr04tFTPnX9eHeGRApAL5luoKSYGRjTolhZrNcHCX4DWsXHZ3spoRMPUmyv0JI6F/gv0GcMMsrvOaEvNvYxaZOCO3JeZI8PolIAxCNvQk4iOlnyN3YEbBQM4tVLGh4CLPMlzBr3//sE+oXrXD411w/AMNazqMpUWrKyeWNFY/D3bMgWymnPvZUPIuAkVt7BjlMkrO8Bn5Z1De4/dLAIX8ENTwnvxBgvwnz3JcFP6AyN1R0sNGv+ytIq1i/BehzMDuvcApTQjfG1Z+eCcb3cGe2Gz1lsl5M9iql4iApSPEiy5vSVVJ1KBNez9CCMA4hd/cNsRbKvCWPfH4KbqWgZFigJU360RArSdt19Oq+uac427dvqKiMzy6W8zmnaAHgL+u3qZ5G9NMD8VPksNA6pQxrJv7l5wvUlNT/GhjqTluj/L7oZGFcVmXbZmZB1Xc7QJCEutppjjd6mR+vHX3J4HmYE13nSChYkkKzyobmTL0wAchYiR4hq6F0UmeSP2+JrNMBkOXPzA5zWUj1lx5/smtGDslEfJaY9UuR+4aNOOCz6fp5ptvPV1xuZ1zbNZTuLNsWwucY9Ad+tpEgC0Ck62+DtBhOoltx+rqIBhp6Sxcvhx96tnQa4jZAZQGfTNCJvLa7s1AfmyRbk4uo62kaQLv3sD1RQidvLT7jNnDo1PUmbShXlqBEuq9EaTS9gZxNeO8o6R91hUEw74/0tSzjetp0BnCxbct4OeXgWsGKzvMrR/qlhdsK3cB4STVwG4POD1OiKXZVLiS2f0qEkgglB8vDP60Kg3xOU6blijFGpeRwODhXddvaYt0YK6M8HKhWOkcSNMu8BTO+IN89QoCPYYUIcilYC1shbQs7SHOvQuw=
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