KRav049dc9qFxBM1S2K9wbcmpiJ/PPPnR0UFWrZEgbbNmG81qvccYtOmAYU4tlIIb6fNuOl0kOsJRNN6WzImGyOhi9fxacNtZpOV8xk8YWPAdjMcDBpBvy9tc505J6Bl1coD2HLA45d3FgMZpjqQb5sYPWBpflIQOjyt0y1JupLnQJskboG73PvMnuONUmGt9LJdoCuXGLpiPVIe+vPFf9JAqRxFFayQpeQfzFpMdKe/MUSytXhCn1/hy2dl0homidTzVyzKR9eZRgk2TOIFM2Z8k8ZjjbHZQIwVA9NTHIHO3veI1amcsjetDPcj+/IFMNNPthVrzmMCCzkPOJI2SCZb3AkMdr4Gd6XpEaKCi8XUDlstH/0VLbiBWvH7wlGqZDMGimlCpXwlkv9ySBVx0AIKHv6QZoioeIZs+g1arLnwxyq7eM3inz6JcQBDlzZlWUhPCsc4bLrWukk6xN1Fjk0bGRaS9+tJhIWsAoJYErRPZK28tf6GqRiXZQBExtjFf2t2YoalStCsjO01JryvW2cwCmKLMf/gc++Tawi0PIUmGYh3eGX59nrUqQtLZdxDoes6h1BVMy2rsNhUtNnQPdB80FxCeKI2l2LPW99Djp7ilMFtvmFJPOuOJ/6MD2VpSVLJXDlxEEJCEOOfQGDXrFy13JlBDRDoJMncVzj6ek4nollCMAC9S29+lBHbjKe1gE2zDb5jGNc/FMvOS7wcr6jnB8UKkeWHyqQ2PfKqwYod4MgBUySRJZpScgOul4sxy6kb3NgtTIUArtJk9vftr032AkF8cDHRqPbwlLer7hnMJJdT0836gffs7R1S+CNpELlJPWlZN7TvlmHpzIP4I48B32UAoV0gG0Buvncm2ar9pzPaVCOrAr7CaADNtnAFF/YsyHITbA9US/XUWCD/c2ePNgJgLXv2pyQNE7TrpoDGw195gz120S8hHaElLdXEMtr9mPMdD6QNwM1jdgD6W0eHecwDKfbFkqT4GGs1GAx/ShqDDn5Aeh/X0VNszJ925OuDCnPrUmSlIb3M4QiMP/MZwnmMRyY4mzA27S2mpZqO09ri6adKZ8rvFlwEZ+MRrYKG9XSR8z/ZsP5A9IzMt+VR4X/ur02+99P12TKOs1yb9eBoKnNHwX5qe2PMCfUM3/57Lu6QXHA9qkrzDqYaXHYmL3pFxNkBUQYYpi4ulgMYopJeuBb/0/Yn5yXazSB05psmuu2i+zB2GnzXDq02+YnY
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 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