5T9fdv29kk67Re+tiduPMxy5j1NNuAFVrGuS1KtxUNrQZ0h8FrQp1WjN0iebL0SInk+oZWchSSpfc/GXs11We5hyuNXNEqZ3hmTfBI8icsBhwuQhItjrxRocXjgTFZKg9X8cDtuSeWoCQm6bcJZ+W7r30lRPpbwLI3ckTZGaU59Z9Y3y13csbhpshY0+rJbUxiueecbaDm718LId9QWSr59A957N7S7ghbUsi3hLSAqDlkbb3VnEXY/ZyEOu2JK6WFDchzqXjtSnTEON0Fh2d8D54QHfm7DulHcLV3amDRtoFQzcOmb089stcI9gZC8rluJqTAhnzruM9Gcijprn3XireaXxCyzN6WXIosNGBtwxLgax3BkSiqwLwh8etfroAamRpENsmmypMQ6BT7YwOYICjMVXRkLWR4AzTGb62kjMoO+5LO+PEa+KG8v7oCp8YezLUnqiEh0EsJth5sOOHLostroVnTa03BDhGBW9GuppCmJM1/PL12G6qY5KxvpGOlUra30SosgoP8kdTnH0GRwCqntWsuVcDLFmX4lq0d3ghzCAsK/kgCM3mhu2VUjy+jjo7X5+Hu55eI9ChUwAarNhmoCyTI0wD917azRCD7wWeK9rJ7w8yNRYKikhovPWAw+Yov4HINDLi2SxwlzUgkh2LTXq8roH3QNvqrX3l06MvTZTSDwF006n7xZiY/ZYHAb7sR3yDa2kUpwJPnzTZ5NmqLU0x0/nF5FAD/QbxlRPyvu55BH6JM2/kxkCGYU0Ee5OB5kzDbMfxhDZLZy6K9OybX08fPKotF5w+ZfoWpa3pH38EWEIw1o2/+wBE91VEi5Nf0Xud02lgNzx01TwN79ZMZYPX1MEEu/TlXHHDjT2e+cdQmYYwmjn9nzFb/Rronzl9YCrKSHCJVyBHyLEPikfpwjc8TbL/G/eNaLEA0G4eOFp7cwAc61vYW0/ETdXI4cFBna+zXxr5/vg3J1va74zcr40DyzsY51OorIOZ7GJ0z5cwIfJkjQqvJ2+9LGLI0kGzRWj4AkJ4lFlfrBh2HYjpURlEjWe1dlujKv375qbaf/xZrN3B2lNGIrVLDJGANQnJhJZxKZC7IDK53UWVO2PRcdSC7MhsD5rS19bdapPfoovBqCkxGElQK3AzmvenY5W61z7gV1950SGX6zHoKyKmjFplkxTaDxW1LWRiwt66bfeE8ERwjtaxPJjzGGJcJNYP+Odv4NwOUwlEOTlQMwjT7pVS8hI+EFj/9ShmJaGp7DOayNU0YR4bTGSCdSpNHhx+OJj9mGKfzWrYFSqZugwLsB21KQYfvpGc6IJ6db9tBrghJknE7veeojAaK2eeVKF5NSd6v8it3o2aoG3DkA/NvfBmvBDrnOhhaQ=
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