MgzHMi0wugyVTzUZsHM5r1eQsVy1bsYVtcPKvu5dQoa05Ucni8Ev/9rwBus69hJdqtI4OfWZp5bk2WMOKTuKLwQ//JWXV6IPuIJ+wVBYfCerwqQJJyN3DYyBD9meF5ysK188iXdV3HLx/ODehwp9i1YOmr+smMMlZm8K7wYWMKc692pKBfc4VJlpvJYRy8tNY4nKXBcIdOmyci+L9/2TvIWB5xzZ5yxu+hsDJEueX5c8sZTOcDHRNJnqxJZYtxf10FtHLyg30CecG9AplYnzY4c2UAsG7QhelHw2sXI6VD+2MI72iow7MhH1NaVJoxKMAOv+8xvoIH95q/UAZxdv/DKKJloczbfiUoq9OCmFwlvyjYMK32GjarfG+JhjRLeAHc9siy85EXfsfK5QgJTkDf2MquoX3W8JirHQx/fdLhsDVct8oIzz4d/8X8Fuy92LakY1/H9XRXr79ZgxwdSI40EzNUxegAW8IgDfsQcw8o9tJ/UPWhg95hJeS6rbiqf0lNskt5eML/e/luKpkjSaXa0gRzJkvO4uKI6w4SoIyjbnzvvdSc6RmUp1Qzu6VaA0tI1C04gMIIZMkdDT82/rMkyDe7ESl4gQ01Co7bGsKYbxrEHeGMN1MfZGNoFHCpLBxjJsX5GTKE977dyGQpthOY/RAM+xI7+YhO4uLHRoIrSg/ehiebOvPJy6x/QqkhKs5TP2GmSIdzpgJVfD5/HkS0sdHvZxaudYtESMLWb/y2Fr0JzWXsorYnH/Of8mG3S0A4ydYz2cKqCoPMitIgQ4wZtzpCeXqYUCcfCyipS+SR4SuYqEheGep2lmdW+ZDN0iwbTO4OiQRRNF4Nfq8Gn/G5g2BWk8Doh0Q+fAS9DRFG49WcAQh8+R94DEZjQGO+pBNvRRmeFEr0RpRtjp2oSV2HcG8RXGjPFOiORkRWX6X34zeeAM2xtY9BRGFGL2osmCLOweCXggJ4Z1+Ruc6qixISp8zEddUXyL+LqB8Mw/eMBDIoSct010eVSK+rTFSklk8T+6nHSdpxmBg9QXS2B++lULKkmsI1BV3nxToMy30MOetKR1NG1NwUFadIej+uMpnYENRZne4Hm4RlMv2vBMVcGHP06w5zqVJt7US0SYlrAUlxeQFLAndBSvGRUrYVQwEvTXRTxKtwJjW7vXrjkBRbRHPQPxUlZKLVdBRMG3o3of+1sA0nLFaQaRS5eJ4FmXn9wEigUQWCNAdNKcl+44Eavwnb2EDa/QjuOePZKiHRmxIVbL/1++QdkmQdbL6L1TlQYY5InYQI5Mhh1sqZML50yh8vLTP4MlQlIsd+DNatRIghZ711jbdUqD7S7+r/MlimC/84wqGO7YPJG9lLSrWwLI1qLWnfHJB9aE/70428mnX4fjqnjDN4QODCCFeGSWX31doITDNr8OCEd6BMeDiwGArRFvuM17pz869kZ4LOlELEzy5un8KrdwEsJSuT4BTu39xUKN3A0yGz1k6jkeZzkVuCWXN6qb2gf4bB/JbfpsU7jjXrbX+CfS1Y6w2+Jyd6+hS6v8VnwyeCA2ejUP1YM/Iu0NiNp5ooFrbTuzUajYWnWmlijEMSm1KFz1w2myRgaJ6m9S3fvHpdrdMiRWgYPj7ooc3mVa8DkOWNKI5E9O/HprZPMKh2KqtZKiHF9MaBavzKH3Ccnjl8E+vUhM1fRxL8fOlFy00TzynsEGgE982ca3c6jqPbGLEwA=
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