jzu9Y3GXQnYnOqCwfotRH6MvHCI6flRSA1HiDkM9SX6h+M1KVouEp2NemEm4Q7kjAy++npHcxOtsMdV5qy9RwG6ioseyED6dcwHdIOWIU2PETRX4TjQ3Ms0qi2GahYALYLGNppqipDb3+IIhWiVKbCc9h5tYspLkev0SLmzTZ0A9bOGsA+bVnI9QjrT/cJb8ZnVEoLgROmduiLBqmAQhUlbj5UiNxcY5+ixwfQ5gn2Ci3wy4LMbBvRivWUid+5NCGVsbAVZtt+LzDA/y74BtI1U6IjkVEVkgJJAUX7UgYNoYufDpcDRsySFQgQcjAs1UrhPkH2iwe89E0a+BvyBEQ1WkNKHgSUgIxIsmgjg30RNHeph+eCcaLAvZ7AUHiu3mWEalH1XuS/KY4oR5gBDDDSbnnMonXQZbqdM+A+/CRWpHFb36vzbG2j5s0Qu+4LCppP7zeB7zkZ473bravJ7PenxZ025XswfloOLZK94t29L+iWYUaSSHJ1GTiOXjo99EHUnT3Bb/4pn9OsdRg15qvcq3g6KpddR0dwkhD17vavQr66bU/TACYULx7Iyh5q/Cf3rUyZ5R14S3TmCRAVdsobcnFuR9T36dygzQHdTrBmSgywhaCT4ICzIDSPTP7IIS7TEF8yoT67AuxxTB79+oA45NfsMCMbHuimLniasQh3Wyt61dCgaZaKcbMhKDuJN3e+ugdpG9hVZ6+jou8iIKwUyO9MTmoPy+rRwu5sx6yuDeX1OnAV5oIMHp1IaDL6osA61uQD5Jj2JjnJGmWwaIAzVHQMSJQ3WPdCWfALMQDescobw1G9beRPac7HXf9L4UNGBqBIy1SPe9jYYj5Q/yQsn98c8ryrHqEdQBOZ9kVmhSuS2vlU0AVonk549WFzvqJtdee0vnvbRdfA2CGdtBbs6SaaTihiM0st6U0G4oDRfrgDggsLuLOrj3ixO+F6tuuuK+GdNBr75PBDs6xoi4ZWqXTPaChc5tBpVs6S2CnxSEn/0FVykaNbghXvGOihTCAvV5Wcl92Z3ytAmkja/zKrjGrWK2gilQj3VfEl2NLu1yeFu9+xbEZo4pDKx0ClfhQ3H4peO8ABKEtaewpTlPG1jVSxhvIAhaFH+Z2ESI8pRoxACa+NCVnAR1phJKohExg0wLFU73x9g9gv6oDtH7w/D+b9NfdBGJ7XCwcHhZH99NrjcDR5ACsdcUUq9ouVT3l5h04jGH7pQNSUEj5B1xlBri9XvBiljb+KSf5Mip4VjkMlYtrF5f/B9VmQdg2eWtuBv2NRgw6OeqmUIvXMhToVGImqyXJ1gF3Y6p6tXLrF5Vym6k7r7jivpaorbDIKltohMR2H7Stn096VQmq397bMpXgld6+ibHGcDq1oI=
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