n659CLR4o7DmPN+GOztu+5G3gvQxZ/dADvs6jCqwJuEiu7RLen2npYPGb9nAlxxpkKeQITdAE23P1uCAz31ym7g8z8eW2tEnhWATBeaFoiaMb8ZsUWk4oZaS7kjjrvPPpl1sY272B+1cXv4fRCEH8tkq6FDUiZ8YYVA084vlLDo1eM5DpCBhoErOMqlFuPXseNdv3ROGIXpO/N3CW1/iAZvz6DihbIu24x6dxzlmtSZOKeD5clp1b18qfl4N+upp/O/nweL2iGj4r9CkQgMWYscDZ0+43cBh+634GAEF5/l7dl2DsFqYq2/u3W93maIA3XLKsdxBotaPjVdmRPRAqoUVP3G3e0Ffji0gIwHclrrxwYOPvEfUyrXvo8PLAa9G0KKVUgBOE97QOaCUZaCRt9bTtI07pGKCO425RuYX2Lk8sWZwc6yAEjQR08XCFkkeCcz6IpELwWezs9KoAGxbUwwnZMWiWFkItXi0maf0ZEAsm0rsll28qy7ajfvJEf+V2WFYwY/r3QQQGL3LHoHpwrk9mFc46SJdLmHFTv8cF/YbTZMztOTB6EF1oqGP5UOs/NT5Gr8loXI277sWKQv01xHvPMMfadQya7Td5GX0ICSkQgY7GmC7K+i0xJ403B5XNlqHtSBz7hnTX18W8fe0ZzregCzfdxIuFZ0dcmlIWyWK+w5aQtU0/y+YwRfz7Q3hudDfiCdNa+xSrEnlIAvLKU5xZ48oQvED7/sczC4RoXIK2ENj6HVdNvczQcC3eqV30L3ux/v5NMAK1hhVuM0sg9GEhmdSfwjqLhpfoNTpCemPls5idPRDOhR7rITcLbRGwAzm96bU7gF83Kv55ffzhCLzhvv52BC15Xpd6CSCAu6HKw04z1Ruo3d26Si+fxXrNMUtFaCT0joudywQ2Qrm/Dayk7L2eL8ifjrjRdRZnxUnj0YwocVz8mxtMmdJCuRu2Bl+L4cr3Z+ZUBjQ/vkz9AI7BDs1NYaMinc4qhqGLD5ChnwdXV5PxxqrtqMUW72YhVnyx8qiiBJS9K/pKm6g6VrAwoCW1vcBsL+WvpYhTi2KGcLWT5QIetfL7dSyJZGUSlZmg5VYFGwNhQ7WFpC1pwk8AK+FuNK3JwoIGMFtXMWp6PRqe8EfUb0OefENtPtW3F7OxtiK8nbNw1AMq8e8/DE4e+gpCaccd2QnBV+5wlME2/VsOtQRLf7z5+aH3wlQNBE2yWBTVuk0a/2uBTv5f9Z8U2dTL2U+iUaLUWFaEh2mTyF/pwSJ+tLHEkyyEnDAkjLZISLI0z7/bIYpM3oozRLLnazWj5PIB4mooVo1ul9NLV/ByUTBKvsvN7O5gci3YMvZz6E+BQbvVZFKGa2OEHUx7mfkLNrGpmp2WJo=
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