RSysJhQOMH2o0vO63EL76BhD1evJex6baGXWIlnZZwmsfq7mPicYkpDdc31J1nQzDyHIteXaR5E72BCiYUUbK1AAZueZLdbZuc85VoYlBTks0dBn1nzDsvxQ1b1PFZx6jyRUtajGnwWqIVrcnXVRDe847xRkamDyQdloVis0MUSTSxOKyJ1BKmvBFxmJctWtAAQY+KUk3JKNtNQg8yio6tL9FVaIFC5ncM3My9zO0Fd+4yaGEeZpZad3i9yh57LSimmxyf//QJP6K4DTqTLloWEwlzDONFXD9AVwXjJdtTcTC4BI9nTCFe8Vz+5sIEPuK4SJQSuM1r9ck0N6Ydf44xW4HDdPE8Mf96iR3JHAHpDNvMyOFosAa3EECmkW3j315t0u7TJmxg3dyoc6v4p1+gvCLsILYHwlH6h8qbMveSWNjiyxWL8HvKliG70RN/dORVTHI9x/cE7gZ4F4GODYyKA/o4MfHSV1STJYRUo0TybHTrJ5T4aFTlkjV5CndYGd4tFwkqef+ic+AHw91y7rJ9HWxG/h1uTrygbVSJgZzX9HHM8DB+NINxWx5sydQn2oVjB4fl3ktCnh01+VpmwZfo6u6muQoyb987GELCVvQRQsYC6ZRD9QIeCm4KBuTU+IaZcKYR1mRd7eF345epuXeKuocdV2nexE1qqZUBik5Rajpa7aW/Yg0bhVJYjSrqYR8tT9r/Ep3EoJ6iNp24efOQ8iO/6fQqaXsusb9a7c9JcYMylQzm9y1aG45d5tXCO4n5dsE/oCm9s/AbMl6N+lBq2atJvHKdr913Ui54Im5URYaC5DSQ810BqeSyox1ayMU3Mwkh9VGyR8vFyRk+OiJkP+6wSGJ83cwdc29Sll3PLkQ2c3i1orHo/GJ55+tHjN3XMlC/3xifheHTS0DlHKcHCtovt3M7dqEdHBdOQOs5nGgvrqDZUjop6CVRTDuwk+MWCx8EkOIfh5mtU/T+iingirBmWkPZAAFg3JOSnugPzYulcunw34LVNPgiOJXVy6gRD9noxzElnLsQjuY+2mj4m1bxDcjECJhqXGw+mKapx4rLurFxt0nQI1DDEgeYZkbXR+4FDgr34b+hZwdv6seqmF8TIPyqbFDL7U+9Q1Q4xomsgpdpfji0w+hRn1PO3jKVNvoPb/Oos0tmfxcLzNcFC66GAu1w/VHi2lmZ+BRnmltiYO3gcMNSKBOVvlByMBp2HtA9e26FergghlnawJm2PLqVBtSemzKhF6d3hVDvgpNL022QsEOpSlwJqxLqJ6iXLiDxmSugPEBwx6O+Omm6H46X5FX4kP8zUYZ92lXDCWLNSjWgwjDIeRupQ+4VT0myMMlbQ7WSCaRgeAEb+lM8MRP37uICcSWp99fHs=
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