VlAo+4S654L7lWgTmfQX/OwAfVVo2zyPBb6jFHDjWcPjhzSngTZY5HVL1leE/5hYw/eIn+bjohx6x9EQ4eQw4K5mBQnCZ9XqbqI//8CoB46mJBq0Luyr8Ooco96K/58+o05//TDDefqe2tYDgIENj4pFU7ZULJV5J8XlzUW37y/cKlfehteEeib8repikMixAHYryvpSkRO8h1Ecr3i88LcvzUod3QYPIdS3VtHuP4t/xsqu9OKuaM5mbfYb/Pcz3aJPXl+5th3Aidzatv1BwDMJMDKUOKgf5y8/KqdTHYrBKlYvK8G4U/mzU6CjFR74Eg57ceZJkfHC+Xiov3FHA2+im5E+gA0cdQjL4PwMZ/y7PHGOl7FfSmyzqk9K1RD17/S8lS593oidxLD++tgEB7YO2HBxvqprP59oRLCV0bhhE9RI4UqOMx3/Hc84yMIxKo+2v+ryrsvTe/phYEQZrtYQ3dvimmkl+TfBvxIDiWXgQqFe/c1GFvKlAclsNW4dbxEIUJ1/KyvYzp+zO1lrxO8e91ztcR7/mqwAyFP3KZdOex/i/BZFv4QxPKFUuSjZX7FRUxgVtpA8FSfz3y24gfUVu/gsXAAiE8HeaRUI1ECqcGImyFBk2alEGL1pgmhTBqSpvvqHtZCPmvtx2/LOQKXMwBYgMFkUl0Gx7+BdZYQNAcaP0pAQb2m8M7z04yRzHOjSSxnaduH88bPgDwddNOdYlBnUwjXYfjBOw19fJTOVbJ39yp6Rvy/YJz0qY5fq9skrxMCn8T1zXnB4VQzwDj6X2H2dIDRQg2xVTwtUHs6qSsIRKTVnw3aClFbr0WayuZYcMoFKsTJYcGIx8rMOMjOjt9VaPo/x2qboshlIBI6sm8ojx8arLL5S/e8MTJhNIVN7ag0jE0NE8Q/pK2xj5KC9IaIA/9He7xV9sUI1vHao1ximwn9vxi+mWIm67Lu6JizmRM/WHFz4WVIqoiBTQXeAnBBJyMa2Oj4AWszOMH+MebpW0qJ7KDKVWpCXxe4lVWDvsQIokFPvyVB5f+BNFL7XoZtsG8rA7BQAJgDxrlSqlYPaptxl2hKU2dOglNjWsTQ312CQ0lnmuMyqUQdgC36VTd9OB1oUkO/msFLJKiHutO8M4siyyTF10RCadYJTfuJK0RtLq8yFS2qU3Flwh7qktXTNHrcXHn+PjZX/Y8FY5Kz1aU47QauSXNBHEFigYXrQntvqNu36V1VG2eLrG4LLHqrBzbnagC+ejZxwqoG16cPw28A46FAjrzMAy7epvJ8uN/Jzum9XNuJeLeVXeH+tu+Z5hYlESljoJl8Bb5tNvenKQDlY9gPuDKnp455KnL/dnJ3U1XeOoNRlBpfYPaHRiF6QUFzkmDuEpfc=
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