mS66N4AjB4gKQ5pIxLGDSK+EsGouOffrRbEsAEHDqaulRUdoJoZgvfRt7o/kMh0yeFpaWw/aSphfJSqoGrwx2z9VsR74nPXmzZc8i7sYDFNIHP38JHfiQWAx4JoSNCeLzOdV/Hhx+EPHWJn9xoYFd6vxScfLJTN0MmrRQPO9sTwIN1Xwp3ODDFpBsplnqNUX3M6HlFFneTH++j2E3CMfLaPC05qdZZTalk1R+8O6eymcL8C9Aqx2TTZ1hXCpwfbiOYi3uFPAXcS2Ijy92Gm4D/2JerwWwINjUGksJSzHL5FRB+jFU8ieEsNgl02JMxPKEqyon20CtgcJ5VbJ+wGrmY3Fip04ikXeKYdRh2nXnL1YGEp8Um3dVjz8cgXBllpEAutBm7vwJ8hnaPpuxUoeLeEh19kaJooWKIuHGWcykzS1czzXZ3z7ZvBxRDm79uOvB0d8ce0IGtzehhFQsaaLAUPNzydkb2gbPnJJFq2bgSpkU9UMOk/tujszLab65n61mXkDz/mIuYFlVdinPBkNXjwhotdOkpSq23NUVhrwQNDJkccuJvt9OmSm1YuSlBjXlz44If1M0ujiuW1dRPmpz6DGf2J9W1sOWRv7Znp50jGw0BaszWM7MOhlsMWVHIw/Vh+Hb7KfIEK5KuIzffa/OCjrlO3mhAiuCAEtWT6B+ry8tbd6zmIbf2S0sIkG8wUcC4gLOE4WwqiQtzDJzFcMWsz1UOR3CRhHg4Sdtap3kNtoIqg0TazRhsINeWxxV8ZauQE5LdSy0zfGSJ5cFjHFo/6vwZ1b/aS23MUW0dcCiQqJ7pcHgX03YWFfE2iomx/z+OvTRv7JdMsNXJB032xn/n8NHUeYxmDk7es+2y5zDippXXOuJGIR+XrhqM2nt3vYZfwm2bphJlvYSgQl6VFrzlDmLKq4yJjhaqHjLqgC7/3P41wZsmipJqosOMygD+i75K3jdhdtxsaujIULeK2jlHibhceurGA4LhtmSpJG7FI0GhoTd1/fauhGPym95v5IZisNUuz6LCsoobwCMkwPSLJzF0cP/cfteeDT57YTzgb4HE6ipIdnb4tJ5XErwC9mmNnzKvRm9m3wIQQgMFKYrz6MEmZwJ5/xJzlTS8GYY67AL32MB4uVOF1NU+k0g2h1ULySqn34iP8GXaZMxsqwDjyzQZoN0Ax5c5+WBC3+a4AEqoV6ygMO3eehcSyCb+lZijzt0L2UEgiy+jgKoKs5tl0qnklhBu8W1F4AiipWlS2YL+jT+aDxrf3k9TXxYeEIHudIPOYy+7E2GOycd2d4Ut2GMlrmSrxfDs5jg2YbXjRDbG8lTo3TrdA/AcaQLDVE44sE+AwzPvZXMWYYQYoovSOQcIwI2GSSPK8iiHY=
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