3Pe+X4O3X6YjbfhHOz7kv3cf1tuztIZhFj53X3C9KGK7gQ/5jF2YHD7dEpCym4JvdU/hva3MSiYwEuf+quwcmG0r32alEuFTILnLLIqVqs8HKKitcGrLgmNZ70RPKkWvV7UvIT9tcwFtkkSI291POkX8TVfyt7ddKe3XQBNrhK7DgTJseNtxTPwi5yL6zk26N4WwZ0cd9ySFbbu2LB6GWiIsHujnJAlpR4U9ROUXA3MXfodIJpfhOm0pSqadO620HVSMe9mqeWuqX1VSh+ZLcYcnr3rYVxHekwiSRVwNOuSdehRie8yDFTJTZ9CLnm/HiaUPyM7BB5xs08qEBvyTDIufXAOOUc8MqCF2VqvGn53SEKB5oYZ9aM+nSWWNQ0DjGoieCoZXMO0a7tNYZ/1OvmEMPrcFxWT8XhjN/NhG3gWOz/EfNYZuBHmJABclClPrhUwrHL6A4sVAoW3y8ufzHhv1YFaHcoVmswe3mamBjGoketLdqoIqdaPcKB29wUBsORX7dE07scnZhPIs7kK9cGdnlaCJWVrExJwDtmM09mGbM1yUf1NzyBbxSR/IvGElle1NIGGAJNtEVHy65MNgJ/TuS3qcYdP0vfW+PrSS+SdBEsf4uukVnFlBDOFPFcWuOxX/0JySAQGjxEZPnBJlNpzkvBxbsE4oB/hgvGS4tR7Kn6SRDVC3Mqi40aPV1KWpn42BFkhLvWzhraFE0e4x2wn6UwU4sdgbh8zycK320EZSkFPELAhC2d1T1fRhikMhCNW9to6cEUhFzWoqkTcFb5ZT2UCsZs8YOnB7X2dUmMY49Grj3K9UPSPGLkCNh5Rpq6FTR2393D9Fz4joUJn90jo2HCtb4cmj6Ec4vrxHXA2uvcLy3aMmwx3nqEKsV9WsQWdOgSUdfM7afxMiBjNKy7ajUuei+oH1wKl7dRCqc7HsPJrfDHMoGBux7tWiGzl9pAgjpM0roUID55UJDD0NjjGZN9WineNF68nr7YzTJORr8bIwYdHcSzwL9U7qjoISMMKrYdvq3MZ7Lz/cXPV+/jRFIhMwijuCljarEb3pRXCPB4t/0TsrIIIlcVhpgkBZbUFl7MoN0iPuc49AcjctDALWH35YyYZwr+iLp1fmbIHt/Q+svhDzjgfCgXW1f43YXgTigStOFzVXRgG2c3mmGIZKd8jlyApbdzS1bywa9Jvpgr57crqUlio9V+I3t+6J/DgF0+cvTtFhhhz5CLVD0rJC1RFEllOln4x/w0HmraB0DuLvsKJjrfKFErkabAsT9Ere4lUy7w3NkAhUfDTnojVuJKWIJWlzFu9bOz+H5cSQGwrMcZ3qvOVc9QfnC6yXA+GBiM7KPvlhZjv+P6ugbn4XlHX0itLpc9Y46vs=
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