LiH5k7fpc/ZG+iOxhndGIxB8urwHuU7MCCEptcWGrAOOMMAEZSyofw8oetJn++vBEgmBE2+NqPy9nwYIhDr+e+tuKXCWWP3WqRsqF8ty3xjV999f4/VxfDVOmLd/6qvRp0OqwrbVYiaJNMis2RlpBCUVtaNymrhHYHs8hKgTselqVp/HdQcAlAeoBoqjtZaxPExkhk4aCm+ncQd9Jrg4QfZyGwBrCEzknv23+V6Z6iR86LkmvYQcnHD9UlD3tsw0lmV1Q+BW7zAPfe3aCMLq4Les3ApHq9jUGobOH8K8qcTyFpHp1afa/zbB1qHVKBgZ526z0xblXL90D+AYwt9XveCDRT3epdIm1+KAl1USMpJQ1W/hx2mBo429JYdlzT5rsDuSvQbqKRak2zTrrU/1KpSuO/2Quow2QvuClnh+SitVS9FfxxinWoXMXla9nWtfALoB1bIN5vLKDOUlsHmZTAO6PcXB6Q1NMehcmeqNj8nr9/Oel+wsRNC+qcj++ynGA/ldVpHdMaRn8uxdXm1cYB1cqsqjeAeAI0KwI2Rn0rbjE7KxnYjdRT1lGcGMfzkHYfmOqNX2Wo9fYmiur0gkN0JtVL+A1YBeOsZU8WOcVo/FiYGeMx9Oo0FGjuha8nLK1sGk0rsOxmkBm8zWkYIdyBjIlCDfW2em2STFoJX4FOUBx6nAnKJRb0mVoqST3/sy1devIWHpezoM3foP5dDTTrTXhz1tJMNNb93RiapXu2VXp33fBlTOYRc79AKF1GhR6ODXVYeGlOmhRXwd9gPaMzU9r+pn80ql8QrdennyjmRys2JQQjF6k/R+RsJKPsnzLsVV53at1cmn3/pyuo07eafAtgq6wyORWWxFq8qDeaqhs3MDib7KgI0ONGnt3F7gB0MyOmsg58UCP3HquB712zyqM9G/bUPf3BdeUTXlCdLCtABwMvzgzWjQWbk6Oht4cjuBODxn0GDxYhRdLGD3bhN5SS5lUIIVMwJXmjr2TTxM06XkaHILQnEFDEcJg3j7KYlIo+vMeS3Tn0Ck4Y1k35yuUgvQZvHIbSHDi7RuVwlzcjKfCT1zrT4s4Z04lBhuhfrYtMqWYNSHF6U2dUVcWIo9HH3j4nMf8Nqqo+P8RrVzeDbg3RnY/KC1LW+VOGzQEsylaGpnqbUoNpREYUOHcXjOhWyjmcn0vl1/2QI+kZE2UJPZ+NAd7joHj8RM9X68J/snav1py4gqm29zEknLzze7bTFmOGdR+T3rjTYyK4+q/iXcDUQKKZEpDjLozAKTxx1+HuW0QcNHSzggzL3P5iYSpUpWR6P15XHmmS1kNbyrXvLFb3rr1c0e3N68bsv/BQ+XvKqsRVbM0NfDqnyEpUlqE5HGA50+hE35XOY6fTuhNgX7J9uXKXZAASShb1x7HFdpkzYFddz/7/PoXOwsWXMXCSwXVZQdrtun+o7sJqn32U8OCjlXGA5Wr0HNZSzeB8P8Jdoz6xMiK54mHJ+WSDJ4mIkvII4CSA0stFxYdNgkzBVEBL4iYjtPhtc/n4qdXGQrUZy65epaGwhYHpghdulbLTOQ7wkIVWyLEIFtyFvIvF621WGlDS8jeGVrZoXCyEposSysMsAIKWSj7H341XsNFg/HJu3tFD1Wa1oYrpvuQ68fnwXAC/nL8T2Kj1GUN7HDLZ9G/tjRbhcLQbWpmxDqBewxanbFsj6EmaV6hM/iGI6+1lP5t/y1TQ4=
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