cXO+HR4mVpoVtRyGDFT5WWjUFQV73q3s21/wgm/XRKJtSLhiZmd8uefBjhftHN1aufBQ5zz921zpG+sQWda3+QD+qD7Xne0nAKg0yV9dbyYwR79XGtghWgrc+UfTfLsg6C4Pc9LcHYo3klwTjeB51Au1CKveFXviOuy881vjkwqQA/LySnHnIgpp61YAsEw3cYWRix+gUhqsEcprkHwK40f7vZiQlN9PPhLS30tvWhPwNrRsUNWdd9/CkCjhDa33HPzcp47HqGdmWafmZXZ/CQYvm6SIK9ixGfyn0AQkLGLcgEtb/dWKu12SoLrIAwGYBeCrFVVur+OIYWII9mghTq32yhXb2cu08LOiQMzI4kc0y4xvS4jH3m9CVqT5MhOozv52NvwIaLdSiOXgTGd2dwUfSYC1U9ZEHoaPoBbZc3rjjv24BNdiPXt9WttdOAg11YCo7gn9QEcmevY8ijPpxnYrJvsr/6D7W+phn1jwl8MbgVahvuiJn5SLg8yier2btNiNphDzTcAKEymfdCMQBb4K8WAi26DbCAoaDHXFW7K3IN3/moOwepJJz9ITqwwMhMPsxjZzg7dNh3wIVUEg+RXHJH3rbJ1LFurB1b7pXSVmHsMlx/3doG9m4AIXs5K2oq9YWV2F6BAHdlNijP8Clhkj3I3h3RQnU5eVtVp4jhzXzXd5C8Fxue15JnHPYFNbvHbPmU7cuwKncHmLNWWj8gihIR35FjSWhvpP/T1r33i1SmOLD1DZy7RQdKa6Sgp6eKgyxS5uCrIysshz8xGKId508EfR8vZv1ZaAuZnGUtFFz0XLNXBFrGJVsTnhpRyutD1TqWobqvvWExVvjTTMM43t+XQf3AAodMJb8Koj/6cg/Tpxvz8FMxTn795DL14AYzsqtCcYNpepFjdt4WmSrN9SaTR1sN9zz+LVplFWPQ7OxYNtB62PObKox/RQ02LM6hi0OoCQfHXmp00c7jOdhfWanVJj5cI5BGpdjRzyV4trq3cPcKObnwtD/dJFvRIxvtFkPuqGJAqh7n/uOrsfBQHK/5OsXdCEsMfT7ntp7SvNsrwQaOZmRsiFH67TYRHwMGhXAb+/mGosw9pQyn1DqPq0O4sYDOHsnEq32NpaTXe6tL3CKUhi2Bk3Jfp3otEfaOArGdioaFIVIkdj3BdLZB6fRMx+1KeN0i2NC6HnRllur9aHy6wbzUJ4KEeZ5PBqvn2NZT30l5r0eqndAEE3qW43rSfC7Je8nPmKJuMiZWVGMJWQnAJFNpA7LVkOtmHni/E5Vf7DgPJqqYuk08sBVYVJ8fqU7LT6H5WsXZXHs8Eiufc9wlrPrtPNUoFogF3YzuPzU2JlZNZonFk7jMdaAbjCeRy8xdQJCOVh5Js=
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