tc0vsRwjVwFKBe0FmQZri+9h9d/Gjq7e5DWFZl0ttakv4g8YrBUPlGTR6W8D5b3ITMCCQW4xh4GyxGN68zLk/44iew29OQsrIn8tDH6layD4YESLjYtk4xue6k9GFK75TjlZYO3NerPRxNJKp5lg8TbX3o9hbYbZYukuM2ddpMNcPbIlhTQJDtaPEi8MVK24dQ+D21Y4fDmFB8D9GAYf7aHmTdqZskm0726PAnk8+gquVkTMQucvc/n/+omh2iSUukGfKICrlbhwOtdfw366fosSn//UXzpw3EYm10hs2gH5SO0/ZYqeTcg9S+W2YhvIgQT3SjKLog90qWpVXXtsP6ehqYY7cle7cEsuEDQ9t6VXHpWVEADPE4pMaO6m0Im9otBduTe0l3FdmlGl2u39dzpA0bdmf/DPaKHaLbY5sSKW0KALBllHMFLgQS0g7Rqv4KsDJkEEiVC2S99Cas00kUg19E30GtESBOiZeCroebGunrauTTF8IXwRFuHbAd5ZQYfQCUHij+OlCnQUkYf/uDVpEEwBbAU2h7bEM+jMw8hdTSYuGoTNeFEKKxLiC/ADv96gJNSxhurNuMhqSjg7+/K1RKISZjJ1/r12533fr+2zozeTzD+T1iKig+xsV/tVRP7/q0dkWLEVrk6aj/pXlV4NqL494EdEWJhERkfhH72bV8BZAciRtfMpTF6WQBd/XY2QXNyzCWsKMnz7g8TILP4NYBQtRlG/iq/RNWvr24pBpNKLHwQF2t21zGo0WxvkjNJehVNrPoiuBaAEfc6ame6L/ZKLKYj1SoW+KmLKgWzSj1qQAc20f8U27Z2PiJ4QzSqMIBNNTxxQvR3WNDitMjBC+KTaE+lMlpOHZgHpDbh+hygueT6mP+KDp3YfOZ7OESAHSRUG/eazLrSnJGq72cUE3aiGX4MK5JJ2/ahyGxsL7FdrDWhOeBoHWGR76yvfGn7Lua8sw5qt72BnFOXN4L+Yb8OHmuNpEDFSAP9z1IfFx8HKaVrxBK/fXoopXOl0KoFGMJXOzeXrFRtlpmT6/TYtgQ1HDoowRYu7ef/yhNBqoLq7cjgQAntFVwals0jfqVvtHpGVQeQpSPxfZMKPBM/APfHt0UQIjd/97ecm7q3vxkcGBD1T6rRQkelyUetV4KgwEO17/75xhDLeKJ6Nl4PI46IiKLkFPO0levBxnWy77VZ8ywLEev/yK4unWLl/eHhICG3JFj7pTvL4DDRc+vm7qXtnhrd2Ecn+faAZEhOZYSO6n7ZUl9KV56heDF03HCjuNh8OAIPApZNf1u2lvJBuHHHCAvsCxufpPTmlPhlgjm3CpYQLQ8G0EreP2crOl1KHgEmI4djgCBa9b2MmPpOVxf5aRPX4a231JXkITgiLH3eg5lMMT8PyoXPNMgVjaQ8/GcVDS0RdfE3YJC68dKBvShfOpKdeTukZdvkZQMxz6o5ApZ4ogjJrvB5ihcPIV036yeLXL5cFcTctNHHnb6LzBzGIys8ecwwR6gomEgLJK1IWOmY8zgAmY1hQtiNXFWb13lwlRN8UL1fAvV+fU0RgWa5oM1zWnVq0yH/Fc6u1D3rQTKqwRg8nmGWZAs4HFLfnOLEpgCOurKpk/CMDNRPNWg1LltYyksHuXE1qgrQMumAgtxR1srL7iFKj+mNw985cj8vdkqw+igzoTagQzjOpDIQ7CySHhjOwFFiEBCTU+CzhL1kwbsSA0sA=
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