3eR4P0N2J8tFHKRmAZWto3i4G+ZAyCt3XuxqoVVvs8ttBo/P1BFAuGiUzNsf6TWjXukPsrvEcftdM2JfpLh3oeCvlUMN3Xwi5dnnmC1YXw8jrzq6jA72GOw5btzEjL+5mGSihoOw9hRqa+lD+xKgBYlzpc61r3Hig8X6cR7fJfY8sd0NbN7nAuHc3l1zW0irUjk005t/9Lw8qJ/usdFpvvjxwOe1Tq12RJQIn/sJ0g0J74wk1237Wp9hGrM8yCLl1wq/NmamAL6Y61l+IOM02jspBriP5QhaKbgtFfrWfXiSIW7dEeyzoJx5oYUXedtk71+GGUi8RROa176R5hMZVhm2by1xp01qCtghuW8JAakmGJm4NI41C5VXZXy3n+7EqmiGy+AzINviNlQmxQa8sim2XG1/AXIYfwgklmJrthkL1v6+Ie6u3m/pdrS/EnCfHFuWvNSoTL/9VKkNVEv7vk9OoxpW0qN6fLYWGpn7NdE2eD5ajq4RlxAO/yMnMv5oTGuVVZpwqpGdkjVBY/maWSjggZezaAbmLrL/4NrNpDYO2JsHl13WYRTLMrIkINbS2VcbgId3+SNdss/ypN2ghANNYZ9MFZHHJYFRWA5bOwvS9KRQJiDn6t4sdd4iW6N3zcmTW8ugBF0W9eJTWGQGF7jxIiJk5iIef3nxD9psEgeD3iv4GJ/HVLExb5FYDiw9fNN09M8jOFDYmLtt7O9+S7yRBJhovWuGDVQv1rDI1RrG1EWeKEvgRfCOUHzSlgZHwPzfOnI+phSqh3jyael2nm4TEEeHzWfQAM/E5zLFPe6+hm2pOiC4ZQKOqhGsGDkaUkBPgDcAeYvWLeDCR2+z++JxWSLXOi4nn/vAuuUKzyHgiMK/qcjTG+8wyMjniiX+C07qJ420Saxj3l0cbrEHjw1AJNY+gcxqX3iVSRim0EwcySvyMMggX07YVLU94cXA4LAhTlzoAKw2dZ6Ffcz1yt7/vMDEZ3v/YHUoCIAgXPw6vPzeMJDFN1Ka7hqBKbxp9WoN2oiK97mhcSl4L3D7jVhMFgluCGvZAtyE5IgYmAWAw4nsHfxU0P1At0jzrqecvboQB4KX1TNWNViVupDey93SG4Ubo2ktfgyJLtI/jeZb7ksR5KHsTKQbmDFCv9eBD1PE1LpRC6wn21Fmh/xVxJC+tA86rc1UrWhrqMr6dkGPdQLL4BTWl2KLfCmvqRwVuy8KjzS//cUUnjsOiTl0qRpqXtV+qlsUEH7t6fvbR2RbUehOr7qmoMzUlxkqY8Fj4C83zMBYescL2Cm9iP/uGfeba/5E7AI4KkF+aQHnyWrgiOaS535pQa0C5urVWHdhXTWL7SKFzCifmzlg82Ps68Lm/FwquFNDEFE9Mu4=
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