Cn6hQD1VykmR2jRsQKAKCrKfGNt4PoakhiptOY7B1xfwam5NE8x5BL7Hmujw4J1vvwELy8+Ly08gjZi/cKT7K5rB3eLyHUNuEbewDNtWbQwdZDsBEHoAuEaqRKoq37FDxKeDmm/jiiJW/mUVX12SUWSI/HRF20oFXYz860k0Qws+vkb444fKtYDumv0GE7UJ66hCc1iv9gG8EDH+34EBGHjI3UnwytO2CreE/PPl3/3Lc71QA0ItIgS6CvnqXPK5ac22a4/q9/eltkW71Lv0/eqkN1KpLgYnOqMi4B2igiAqADaGC4XWtdGQl57X+/79inFd5UWqpflK7OddVAzJIuDGuZblXUGQ5RM0wHkicouJjr2DexD62VO5AvI1ZnDMevsxKDuiuqPVNFSl6Kj0KGs9JWJbcGHGJk9SAnXeAhO/D9VKRbIRS/nVokf8jtrqz35xP981SYZ6KwdvSaj+/8QzoEFjrZtY3+PF24136YLG7/tYJ/TgiANkkUpAYGeqG2ttoG012D5SwRZ6NMKviGHQFfjbKrJPNe6qG0LTz1h/x/bUtTiCKcg9CQIZvdaYYoxSRLrN0isO8i4HSfn5qqmXSEccfgN3zkp6BNrtTSLoNKBofBlKW+F6/j+8nE3mdzTLAAJUB30QIqns08hUV6wCu0vwKhF0JXAfg0ehd3njtVHUxV6LxveXtHAWlDu6uKbxYvjjNyiHMsZuH+DKcoSlRzZdqSh/pNHggFP0+7BKr+1C1wZWyWE1N7D97X7BaK/P0MDfxrzMzjSW0+EPKEIa2Mx56dkXABIxE6hI7/bJjnnoMToIfYYsT5yq+O0JVqyDFL/AEVRzFrmRYOG9O1BOFiiRYxGAPZWVR9X5c1Nv/DTiL34b1Dfi1lGFRQVmbrA22+5V1gynmkw+aQPMZ74WNSJQbTHsJ/fbhaiPJHipMJ4ET1fWeXb+DorUr5E+G2yOFjqGHfO5dohcnpoJeXypqCkQhvf84fy7RCnaVWfhTNM3GOKYEy+WjJvQUUcXWX0NLYhrdaeAFUskBHAmc+qP54mGb4COfuVTVGkKN+GTpkXBr7ltBx9qve/3ujx9xYQbgm+nDLncxk4ukBygdyCWg3mT5I95ddy1bE+Pja+fX7GlUMCUIdv6RYTRz+Be9NKBVKXd984e/8gshIOPHourGDBfFPIeHi7hAl94K6gkBkkGwmdGWTUeVc1on212r8UHwKdjbH46r8qgWC8PJA73iKxRekN3M9toNamxDOMqPLayzkrYuBZMT+BbcG0rleW0mTqu0hNLMFgL4CiB3gvPaoEWG2W4EDBTxcwE5tlAf61bWqyCCIhumFGPFpbzTmrqFxyF1cZZa+0pSzOAQPrZA7bRYCXbats0/8Q=
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