HrK1WxlSxDdm9k/pNEZbFLp4ek4+nsWUpwZWYZAylJKZzD7Kzf8h86wFUL/qgOhRZo2mgF9JthcciPj9tOt1CfkafIebJfaxTsh1R3b3VVgKSIv9oH0614fnJsO29dUFRKciLgkHekuU2/FsJiiBDUm0B5tY3/gWrTF+F8Sg6Dc5kIYmvLuVBzlunxP6u61NMCZq3OA5Y9ETXJZSVOYILPoVHNkS1CgL76anJkFLfYI/PMZYfuGaK5WZ/WorYfT3ESw9GOfB4ydNdSDDlgCa6lPMlO7LuCN40mF14l+hUO3m2Zip4jr6dml8XMVxY9+y5akiUAsHTgrhzuCKKjm52N5vnKodkYhCSVGCh6g3SjNQQLTmIcd4vKRq+IJ3kF7VALq3QzrJFY6gBp2fedeZtbwCjFPni5+xpkaZJii8Hhit5DeDtKne/+jtLDHaf5D3heF4B97OI6vAzNTuV1SCINZp6AwYB6np8uc0HEFUh+HRAWcYGnb3A2ri8th49E1QFEkoYvo8IUJek5fdDs9OAnRS4qx5nL2FU86UBCLDTui4ROc4NVJDT0dvzuR/53MdrGHnxki6IQnqtXSBSKEDFE8R+4RuaIJayM3B+/nFqYpKnwn7qaJq1VdGgAhvfNcGAd2V9EKl4VHKuyx9MiskA7r0bh5rA0C2aKOIU/wHCe9StMzy1gqMtvuZd5kYEQ80rKOXqwgpI4Laavx4/zEXGn+pZspovTjrhXJZhHbA1CcRYUvz3yp74PnooHnA3+amH+6I7kRLLeprema731dFHVSDpUe9qsI7NsO5ZUTY+piirCO2nXFa1dNSwG7nDXVJELR0twGn2Zr8OSHBAc1oG5xCuB7ryA7jpuBG6dehiqi7jbkQVDgJA375d2doO+nAPb87cNypcoflD4GWLB0kU1U6wxw4lwMnVYFlKo27/xcy9WAUasz2xbGw9HckNrlSLZnSS3p7O4izkBB+b+P5cTvOJlTJywFBJZTMBGbWtsKrvtasMY1bRiJz1XWLQC65EDe/M18/sg0CHLoT2WCIApzSmznl91ePE8Lk5T3uNA/BzgCoTRwXXU187O8Cv7Y71iYM6t0Uu/FdV8D7A4eCNhTa74yYRy5N1NpN5VcERQv9cz8DhYyzaENtUAD/yQN0x6KWE5L7XELXgPsLnBGqpUFKzxOjgUQJ3lhSGAZ9zW0z/7ntMzzOpVieEj6F+DPUxS802hFcgmTv5yJUQdS88O1xyg/NFbgRx5Wn2cu/iIyuZcqATeGBgIR9G+w0FajzsBlkiFkDwGDU0KOePv0zw//LQ69AQ/lPK/pP607YHhQxtBJiVC0o0kuluqWO/E8xGzIEpDL08olYZlmW26gQEgwG1V2h5dznF7Wn6Fc=
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