gla0G5CyUhZTueXutH1ep2IaFTEP0+urAum1qexonRIfpdau22lplhkNrt5fj4Ipd4co+Tcp82SxXbClClzwVAFX0cuuBN/K9pJhHtgulbLx2uPMiRyT3pih31IpZ2b9vi4bfzaX799CqNESnw87Nt38BUzT6Nur0VjcnXw8tfBOkQC7mkft+GXJrgoDFFW7RfYsrReNMmykkowDHZQvhFZ7Ri3Bd0K9OBL+MngUqDDtXQbIkJSwIU2RzUTkIE5DLWoJ0/fL8glbp9HGIa82JBqU4RsW17DlTNZrOA5gVwJnLU6rgbVKxN8l2TVPfk9Vehg3ttOKkH9QurBlOLG1+SDu5c6ewUf8bpzQJRVI8+5gyNLrmeZHfFW+DPfiOVxyuqNGSK28zFaBPUrencISVm48Ln2/n1HmVgk92+oQMlc8QIdOy/0+3oov6/O1aPvP7MrbHMd2ZCmEn+S0ahEIQYMsW51vaOexj4HKHxKaGX7o3qwjf3VPv3j2t19S/kP7Eww1XS7VBeyGzVOKtMFOSKHUZ9tsjcJ/oRO4JvMj3pjCII8KGw5fx3bcvICNRfHy/Aaq+/ZIPPqw7X6fnGCjEoZGTM6qF1pN3gmMq73pT68vMelYLv5fb85oh+HoJzDRh4zSDNqIHiKuh4DBnjaeipvISGvnL3txqYYt5l8t85Ds4GALop6OJ35p3GckXof4TRUHNudhnQ/5fxu+Iex1UczoY3HCRc4GmwFP+BmwiFZdZJKLXxaAENiy0V8Npg1zxu9lRU5JvAxPmOdn7zA3Co50IxVQRDNVaq8RchxxQR/kEtK1V7DVDgHLi+72PiKGCULMoyfz34/GjqDq0ezb5HfqC7H/B1/idsPvs3X5pyMnr8TlNaAyfuCwL5E1mm+nbCXloCVUmif7b3nI+Kb7L2LwVxpWSiRbUOF9FQR7LGNMqmeWJ7KxXEPlJqaLJg35fMnpkLL5Xg6lEfh0P8c635sacRWOOL6BWu0wAezJM78v6QJwLYA/vXPNvfaiMl6Ra+LYaRef/GE1QDQEEtZTXxPf1AD8Dcll+3n5dygNWsGiTow9gKhmPi93WxoGcj95hCbsvaBOadVS/IAWIz1leTJQExaDo0SQITs0YXVvCDaOwHj4iKscsPUHBcj8mHd/061Emp8NiQ6VjaJr1kW7lUAreYyaZ541gaDgqXnmrqy0yR/+NFfK5j4New3QDSuwv4oMnVBCgI0JdHwTRFru9XcGvVAHQhUzG6njOGSnYpHmWzw+XmZCj2ZyHWz6mGEu2TrsUHJHAEAj2vLgEixbWti7XplPxsAC7f7sewzHir0spbhFXDYI6N/UBKuby/HyuYvLagrgqZDlo+VVqCENl+3MTIfaUxmceZsORGQ=
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