qVCAdT0iR5GcoGu2LqBZ0SyzGRlZ3JVxEHO3SS6JUxmkwHL3rMUmJO08E6MHK4RFjJSKxOPQNaC3UXTPpRug9B0BcY3JL/0khsD9/tdN9IAc5WTXSHFQFIVKaCWmUwk6r/NbLVSEZHZkGjn1Mif7X1mPlm63CsrQn6B4yozPKsaF/LIbU2+tQMyUTzOnjvNaEG38j2J9naDNC0+0iPlrk1GYeJjw8Zgb8e+ctHNyz7bLVu3OuVxSpJd7wGnd40CtVB3W4hfo8+Q+nxOPJUrXnFo3Hck2JCyJH8OE3zlPdx/zs+P4sPbURYV5lCI/JND5h7QySDUPh4rdhQJxS/RiJZr5kfEoIBD9XVV+sieVoY1Ir0UsLFrc/pdEuPkVZVL3SfiIDdVdlo9kriO+gt2+hkucc1XM8zJK+zO+D/BAMwdGfqzfsvrNzZtEqFLaFmODwMFYp9bpNmRl6LDhe4MnwoaBWEeXjgUpoWAt2vya+UMK8jkoCmpw5bit5JCg7vuXDA8blX+gvMDbKM1jPSoDNHZYcJnrrbzyDMsot+elVSpCmSOmZB6hgP9K8GYLbiSjX9If4TkUGfpOakmbUnrU95WpaFSKUMP6onPtHprQLmuJFMOxpXLfl7V5ObdTUAPmhXHhA4Q9BJBbJgOnjIuJnGbXvpra0aSIK0xU9JJJrinnokXitSjLX4VkTTtnQzEiX4eBzFPqJzjvIFowXN/MKbfLpzOk+WjH0zR7vsCstztuP3U5beb1QVjLE9baoEynlLxkhqVJp9xS1YCLaqPbQAXrOgIifaBaLeFFRQoOEeLMVI6A09vR9ez3YFE9Y4kti7hSNZuOqTB1a5yNEKBQul9opENDuA/pw5vy2BbO71cECvGNlSKvaEhU9c3IJd7pH9TrZcS1k6axBfUWi9JRlm5VOS4Oa4GHWGe+HOh0wujQHQ5UussPfmEWebA3yvFwuccZzGhupTgYJVw4Z0ZlBU42QLeJfak1gLMP1IwLdQEF8pcnQJqRWjdKtF/jofWZrCoO1XGMRSYihYUiPHr1G2BKc/norYNmzszBVeiY5B4Tsxcb6EQzzkrINH37rWz2oH2UNltjW2LQGrmqk8TP2efdVkHp8VMLav/VPLyODSQmkHCuk/wwIJwsigDqWnwQx7ztWir7bFzrsxq3eG+Pic6QwmEYqVQDU8XAPczYGi/XtyQj+c3i0+fTN09KK4GKme6R6DRGNO47XnyJIkldGe/ezrSXh+YpFQycqr+HjogS/6Rz1ZNEPhVRUQvnep9w8RpuIjr5oAOSzyIWXIJfzAYBkq3vT3amU6fKkPPbeG6fuQO0PYZVNwbocXRLsHFDXhcHuKczmzWEiN3ZfqidOFXTeVG18ec30TEa7bY=
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