8eQ1zWJkvhHcQuLqeFG17ulVjK/mHGe52q1NqHjBL17WKp7fUx9D5FNEnK8+x6L9oJS2h5qUMEqItyPrJghqvZVN82eNkjS53RfDDj5xRspHjx/4l4mwhBL0ixBb8BO0SQK/f4/zq6xpw6JO1CK7sBMD0KWpJsjx6T8sSae4R0uTBIO55QYfha8vAjNVU+p/xvqsxHiNI2wlcCKlrtV53gZ13qjSbQSGjvf0aUj11iS5G9hznucyIRjJJk5OwbHBjwCDNQwYZI7eMzmX2uROC/q2oW2nbT9HpY9+CwbKoY5/quc9eBHFVY+qomWFx2YybjeBwpSNM76p1BL4N7IWn5zKWWRl6RBvDiUKHuQTz041Qzy65z1CHuFNwf76o/cRpxhseyC1tjetD7/0v2fpwWnl2umQkvMKoLQApPDB5zX0TnAwU25S3y+04F+jAKkuL9NRiQXVDyevmcyguG+xyPbOT+lUKvJaarbioF2LM0tvmEk5Ac/fQXSXfVBNeTIzFzprMEH4l4tlPoiKI4BqhkxKbWh04p9ZBfJ6J6lUi6VsMbzqTMeOI9WIRDFwuB+gn+hbKlaxLLGXC8yhgvqD7eJWfcN4bgJvgg4OGLBk+/0v04TVN/wK9H4hkeDcdoLx+8vTVUFnoPUWzbm8QX+Zcy9QQOSg9Ofk0LoIfrybY8S0fhVejurcqGtlt5L6306D2Zn1nlq2TIZWuk5Gh45MqnplC8YKQl2eks/9wvyhvcVupGbuTXDL2IV+KJvD/OEbRC3z8AcU1Roh4800NqyswoslTMSNylQhFY/5RNPXcz0qUc/hCgM8o+g2SA5PkvdjPmwrDNwioh6WeQJyXDj2bEovRgdqoNWpHe2OR7mO6IBDX7UKWvCQ4BKvW+hfIF7ZVqdaqEgez+YWi35sdSsPMfpQPpPtgBLHR8MbFNkb9yVFX9yHqlcre0+ia4MB1qPmRHJ0MbgxuqJehcudL8GlwxBNZZLYtVANOSnOJPBRsd0KgF2prersS3rn7e2Q7o79fMVpGDgIkLkVho1ZaQYKICKex2keHu//OCHdJqP2KRQd4sIKJpXjMUZNaRjhMpDwyCJbd+RiNFO4PhNM4C6rqjCZAo7dOMSXa/dm9w7+1+nRNmK2Pq1E2Wjn5soV7meBxzCEvng+sw2OUsdf96XiXSzyHvcGp1vQkpRJspuoit1zF0qaPTYPutP0b/2Bo4q+UZHU93+HmRI1JMuPwr7lzB5Nh9uPxhd6A9xOFAreg9bzVA0wek75MttAjGD8sTWQ95luPSdhpVnWo/7Ft1Ze4c+833HG58JC35zwQAfNJFgcJEknRgDTPL/D1NTqYG43ik616etbiwC3O3L6NkRsZl6VML7XS0AC9ANtxMb099EkEGNNCpsZuwML/XQaW+2Dh9egi7yyWSZIwTbniCE9IDQLOTBHpC4SjigqP8bLOss1Qc74T+64vzJVz7Astc4OwpjWaOQmYsW0wXuj/WbQyihQx1kWMp8TH138Q1cxY6K+zYmhTy+TM8No9JbEKCqVUVvNbZiVW46P7d41dmkMUYZw46iNmPmid7Z/h743i/jDkO8dpjurzgR/OCkAtYjDY6NnW5e8dfJU3Lo9h/+VCPeArxiYpCZ1VDrJD3uo41d1L7h2TeC48JxXUxuOHHpMIfxv3ScQDiSMmZ+gEd5WQ0RXEf6gDPYEBQUZxLv+LfpAiVXUuJx0R/OpzyI=
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'
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
ORDER BY (SELECT datePublication FROM emplois e WHERE e.id = et.emploi) DESC LIMIT 100