TlK7bNC/btJemi3Da84rCTg7Qp6Xzua9UWXtMmkaZlLBfYcxhGsM/iSgH3Uhqx2geR/HjgisDNlDwwQXXwq3P+BmPPuFiGSFI5dSNtmrb0ozXVasxrlWdrs10CYoVUJRRW2jS90kBMXhVbU6K+s4BSHJ8b8+YHufekjZJFBmokwOtwzrtEVoXgTUMJG8Wik6xRCwEFHAi4O0cbWHMXq7YYipQ0HIR7bLbK3mC+isqJmlNFz0eg5QF7TnQ25Ag73HPrHI1MgjC3xz4QgajZep3cN6WhENVtHZQpCuHe+A0q6+ZpPa2kBpPrq/7sIjvb3WT7Yu4BbXj6++PZv3kIv3Vr/yL9x9xXMbFFPs/rUiafYXrPUCW9UZlUDfk7hl73rBK6jcHQN8VHZ6G4USoWFtc071k3os/2ifeHEM3+CejGEzuHDuC58QZReaddoRG/RI6zXWS3d96QLGi5UOcYVvNUdR8qUSILo9I0s95FQf3J5uoa0BEgd7BErV4SplEwoM2h3ZW2MRtGAbbLLRKpIMMDvDOOKz668qqY+3IRqfeR872GVOEN1HtpRjwxIdUyCSfU+daxypQMzgr+OfwzLUB+mMClkr9ofIzqfbYS20BdDrWGr9rK2AD0oQtXiaym3Vcmw3Wuyuu1UXmaPYPsiNUg2HLo4r+zsnmW2uw/6BN6AK5O6aQKQdQk6w4MZIpyai4nCsj+gaHI+9uF2mlqeiU7SjdhmCjGlMoKhmcgO9dRtxJHMiRuA5Pvxx/EmpwsmW4AnrB25QPFlHfPny+kb6nmYzPorv4RFstd/mWIPGV4DIlvh4vtY/8gHdJXeok0wPQepK8ggzxeZUiyQmgnIAp/xXI4dRNZpvOXQ+3sCVmeOpdHHh690XsbgIskynWjJ7M6VK92KrAU0ibP/oNJebgAXqCZXDvEAZBlBewkEilpzkbg35RKKwL6767N7KlYXqVfzanwyCiXo4oGdvwQ3t2QDqnq3CHs/iZmVZPL/qlQXrNjPio+qqgUnr+lB7Xyo42Jqb7SPGTotzSS+S0Z6CggLpV4Yo7Nyqls69EHVQVC4cVGN+mAlC33ndWR1BXaS6bLCf32+T/xI6LtUopY0zT1Dez1Bqt0nmCR6Fb2VWcTXFgomiTmpPwRxPDr+yULrFSV+wyVGoC6+LzMZua0C2HeVQwdeAfX1lw1inAn9lOpbKxGzzqA1raXAW+y4uApy9sZvkG2okoirGpgDBUKck2XJUZIQoB9RRaOkgqtrqrMMlvxlVqI44Y+ImGUWxg/T6xMvrOckdIhpdPqpA4nKnznBnSJ2Q8HcWCZx486NA1IcDBwYPFV3BL795NX20wNduec1Lc/RLkdyeLnGmHX1pYZJomA==
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 (SELECT groupe FROM residences r WHERE r.id = et.residence AND r.emplois_masques = '0') = AND (SELECT confidentiel FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '0' AND (r2.emplois_masques != '1' OR r2.emplois_masques IS NULL) AND
((SELECT approuve FROM emplois e WHERE e.id = et.emploi AND e.datePublication <= NOW()) = '1' 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'
GROUP BY et.id
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100