rEWfXLGPKYvczewsgDelxbPV+6nuIAsY/4DjfZU6LCbf+3MvLaitDh2nv1abMsSusg4RZOs/YVWDrXeoiecD5rto59ipcB8n2PVWt6L5ZUyEfHnswzzK2Zu4Uj928JJmO75cMLDa8F9yBK9yuLXGgMikFabsOMzcH6riU9yF8MLaBVWs3QNsJHzdtOACITQ0p/dMU1uQhxYWsIwASUcOYMQc4U+WU4haaCiEbmwwvwQPYXaFTZJLNGLkI7yQ2OtUyfGjpXts/me212m/c0uZ039Ct4cc8CA0ssy/pjR96QPBhbFpV0R9ZkjGkU27N/JsEcKTfsorTvOVwGm7L5ovGMfsUUKEDEQf96w1bRqbL77KykTFcG+nutI2HHnzKUsE0+iifHQorfSd3vEH2Z5akajq2/8nBHqzoyJrcqeX7VKjCUMnfPv9guoQbhHkx8mqNKAjeagFZu9e1Js61bfD5L5ibQdT5bibUo0UsGH8gwKTn26cDqpFVa8GiBlTtQy8smJrv1TTW8qrWVBrLkrnddYtQBPBxolGtZpCo6YtOjj6Nqp+GfGZtl0zcgA4xqDviRhqzX168oLiq0B3AUi3ehZkUtw4VvJybR/kL6uvVXzaomud0OBeK8Ad4UXcJyCciPyntxgQNqKRTwUd+PIJSCEn7K2V9xE637dF7/B0mnI01GuvYqLsz5YpicIc5IcxAQ3P9JFLlIacP+rRnSfU9voMASqx5AsPa4VDFR+Fn2JwmlPNbRD+AsKBPsrBBfQI/MSnr7mJiU9AvyVJnimWyHiRXBqGi2AJL75CUunmFBlSyHLjF5lYdmUYH5T4v/fh70hOHITMifICKm05raCUJqPST/dU4QWWfl855YmUrcbbhl9zzjfqH5NbXe1kMZWVXuQ9npqY2JUEmgSafHSELLBpLHzqW/vPwM9dq+gXCWkcqgCsuvUCpl954sSLhOES5gNiTHggE6pARcsoO55s/hVuadA1pSZMP0zxpQXwEhbiZu7zf2ol+YQdAp1RR799y80nNXvIV/QlC0Lv9gCcZk0Prg/Xe+UDzSo7Sv1Hu0hYLp1p9tRLpt2guMpSpyNIxeiibIffrZrO4b7CtWoJgahzxtu4dyjzehaCZBWSwxkDEUnNBgMX3nMUUEHYiN3/aKj4u6a5kwLA5WHzLD0nadnefl9UIqwjgie6P2Sk8Bwj1JzefciDn+sYTSwltjQrX32ruuMSVuemsm/7WGhapZ+hivtw0k0xc2+wTJEYmMoegiUs2Wp9azM2qL/CBi44AnwmO9aRYH8mIRK9/veNc8zXypDw0yHFhrQiYpd5FePK4UssJ0WTjgn+uPr9jwLACwu5f5EJQ7JzCXA9yXRz36Xci8nmSK+q6aN+uEs=
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