uMatYMFWUwFCxUOVeKdhuwGbohp9WaWpV3CBUfRAHYwZvGnyWbY1DGxoYC/stSXkyrjj5Mxj7iJBfuO0c95NumCANHp2PRxEsBpIrMm3K3hqpnvK6FnVaDyhHiyAXHLPSt5Ma2CoisJoJ9ZsaxOggmitsfJK80KGZNIUNoCi6jVHZ1ie+Nze4R/V/gOCZlxkv6OVrf72yLIvtFYER29oT5jveCm8tkFKCiHhvyhKvbDmzFrdPwBnv24hRrSe1rJN1+vRZKS0DEp0FzACmvJsXuU4wNh67a+bLe/DnHejvhqT6Nyllhikx/lkMLQc6+5SYU1mcCsacI8IYvhNbw6Cf/LstO315mUxr4Gnhn71Fo+tpdwrFqdmgca6EY736jguMuraPKg7DbOxWC+BaHJPBV5yixINUdRV2XzJDaVqBOHA3zBhtbhzEr8FYKzaWEoyhnTp73TOwpO3pJW45xmw7VYZNFsAa4+NQ9fq9/CWbJEk/am+fnXsjx6BXo5QkKUWx/2scnm6n1p2QxzMO75i8QvBuAs4Q/ymLgMBu0ox851XoOw6rjA2UO1Kkz++DPPu3xL4ZuHbXIorqmMyOA37MPM3WtJuVZap1SkfP4OJcp4vXP+MMACTnpeC5tTcK5Gs4lmj/52mzUiRvWPeOlaGk0id53vXg0PF/QdQhIrKh/NEWc9YCz/wvwavVzUe1TvcFmFKk0UXmhWnZNdAGnnH4eD32fyJvTL2QKKjt68OB3p6+iK2U61908Gj8DcvLsIi0INGCB6aSK7kdNbtEgJQDA1NLYYATL4t5+FyWOESwWS1xA81i65mEB6HKC2BnE7RwFnzgbAKUuSLxA+s+3CUdQJFn65ztVzupUEwLwMqKMry9Q8TMrnbyCpjvRMLPkleH7hi7Y4zc2gxYdHONfZhYEH3o2a3m9YTqCNbHkYl+y91f8ekwPlV8a8CsC5JJz9E5+myTdEWNDhsnzuuvzhwZXC5DdigEntVqYEZEYGE4ynbG+MRmnR4EKb05X0Wm0TtD3qYs9RA3ew+fXpiKqG/KkwNIetWvGtVBAilQhB1VJUN9vj4clMTj9662Mmx0xE05BHrvQmEtq6bA7nI0U3KGtEerE0RxDBVsopig4o25cXfEsq3PcgV6gj2AwxsXBQobpPa4HmWJTcPa1wIvfjJJiptRLOAXpg4W0y+9sVIEIaM9iJaKyah6u7vde3byGY59o1lHh0yV7TBiH8nqETFPaduS1+MNrQvwwlQHkzthhdky72OmCvABil8kpPsUvyB/coKe9oNC0HZSenkpmHEN5jIldb+EOSIgSMCRr5LAyt2SDjdxdkASHePaoIx2e8qI69G+XeJMWvs44YVIUhANuPh2vMGjk07jVPXOnQ=
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