0r2cUq2REN4fvBQEBwr7CHPo/pb/+WObcbLsmDjXWK5K69QCbd1cWjf7PQJlR6F+dlt+g/1jiS1TtzKApbcw/tR1mr9CZK3HypoqU7LuqZs4PJyJ0hgNoEWOeIASyVlD8P45NSsjU+l696/8ufnU1MFZWVAF1tPhFCe07zvzgpCw8S1986nE4ONlLIZuVXjsYMUMnkOxcboPpJbcUaoCGazqU6DLPM0UqGCEn2wN435pETacPzFPXXAiMed9zj5wUwV9vuH9ln+czOtazNVAzSZD3dbHSQwqfxQeffmWwUfdvumvSlywdb8o7+kQ34+xdcMZwnUCNBAdt0eaADrNf43dsYhf7b6I+utEf/fDFX9VOd1HpW/3OXMcOugEodkvMOz/ysO/ftj3MOyaKNxWy7exqAUbRYB4LKM2Qe6QiWKFiMLbdyKDgjjZV6El6efT65ExGaiGqr2zZArapt/32fpMFrj77G9BHMebLSI1asYCClygXUkxcWIqPtX0FxXdlnMVFFkRXuAqKSgKSWRlKByVg+9Tb/PvHZOX2pDE+V1rWRMVhKrziH6BWIYjFXLMC/eIDp/80epVAMYQm+38cgewuwEYwdjmV7CCH7CuXoZiFrkEWAZtqrRFTWCx9w8OKthy2u9wnt8AoWeS3sgoyF5m4GL4HwVTn4AswSMriI1sElbyVCCA0PYyPO11jph0kvMnI2wKWxnIx24WpIt/rcx07SZ+Crm6Y9pJmgr8S3ix2r2omLPzBINc4WLDbuVSHYvR20eS3Xbp8tELJpemhAbk/tBmdAVBa/EZRT4bivP31wxYhZEuE1G5ayyup5ZmKbSvzsPJGoZGxTsd2W9cSKhENzuIm+dyCp3I2A0wZm61YOcbmdEiX8MvrRnig2AlBaQknMl+yaBbi1QjI/EVFgkS4Cy3AFf1RDOOsJJr2nnZStcupnbpUE5G2DNGwL0h3Ex8ce4grhvn5rNfM0IM7zgnLavASoAFLgntiqQK/4iKc9KPAhMoDUDyfbzxxx1wJVI92LsmfRF1FButnfIgwepl2Zh/5WHhFY9AUnU41NPcrQdgPjcTEOuRB/xvQuMUpwKGx+V/ZeqhZC0IQ+CJEaeMyOruusPlDhMEYA2tYSV+wSZL/aiisgy2+SQl1kusGMZVknUoiStghZaeaAbsPw5iFyZnXinMNFgqW/EDROmqP3hoM3GDUer2xHvOJ+w/CgRXSUcR9euOJbI5+iN2Hfiqb+TzpWK3nZF3/Gw0pss8pf95P4DrUE3u+Dc8LK62LeEx1iBMnAIwWyoyNYbwocLzCVdKMXFahfFRnL7nZdgW1XalEynYxwclqV996GJ0aCmUjWpKzG+F8vQ+8VqXCwncTc5pG8tkSQfg/4Q=
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 et.bottin = 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
LIMIT 100