gY5TGgkZsbW+MtLA8G4XMw8wiT7X+FvAA67AHOPmmXsC7t3JiV5YcBVigwrlRaOz1U7Q3dVK8WWGb1dAWwPY0eqpWTI9cuDZlhBV4mPhyTMO+ya8aN10FTxFzEdVK+MAKrlHWbf+nUbuviarnFQF3Z+xAAEqUXxh2an/1WGekmMHnjPiewqU/0H5vzIdLbMsSvG6lNL+pjPrbRDmLi2bS7USkIrJDHp+t4xq/LGEwnUDDWk70oXfsEorD/1Sfc+6/FPjcxlvnG3L5Hg2qNDUrgsl/eZuJbGjg6LCi0r7T52lDsznZt2FWp5pMaN4D/kYaNHkpQRyt8oQRMjpQd1eovMox3v1bAsPwY0p9PZCqtGK+2j8c2UqZIr4OobwL+Zw4oHj0G/DVwup/6kuiAloPLpjgdvu4JZohqDBm5FGOZf08bJ8f4SLIkWdYuO6bU1gQogocPDIA8ZYov56+xLNGTPetMQwU08mFB8aA9aKx0nGvEhqp6woTQ78OqADC4+nN7Inl6x/yq+Ok0ItakNTicb0cs66HnFSRfbMPEPGXOPcVp7nh5gtxqZgtR/Gd6J12k7yUCNRR0VneMZyQ2xZxxITj6A12Cqbb78k6QSYq0jaoevGggCIm8JMFMclw/ktKaM270dlGaP92bN2Xd4goKYk7TurG61CURaMNJMT8rB8rr+v+Kk5QnhgVewZ0j6HPNN/fAk++JtScQW03ycopBHSqcusUIfH4CLRGuYsErbztXm6CVUeIWsNjl/utCtgiuQn/WvVvm4tiTBd3ITZy79vXQetfhpGxLAuc1NX2oiI1PgFudyApDHTqlKmeKVyKB5hg8kOsC9139l6Et16PP4gCRYihI2Goz9X4MXUlJ9LGV+C2NijzI5ehRJFHMjT/fhzBwetLb6YB2tiRcV4jTCuIORmOV0JaXlpvlHr9Jryt6xdOmDuhgDzW0jmUZ25/8X4UEAxHg9Ye0D0fPMMu0mjrOrqFcSTuBfUGJ6s92dE5UFA7dPGPXSvEcXIvO+KDkZpffBufhrVxCdag37psDSdgQ+C97CcjkAhUWTsNW5DqF7gVD9M+zZTvEc3DfJOwqambMG+kr+0RIUgEjTQYGKfVhLThWmytevn3FybttL/c+JG4QP86KWr/F4H42hNTKLUvsca8IJ0MLk3l+1DHQ0laC+9Hq+WWWCfSIRvKjHnbBh9mDOyudrmTJszRSQgXSFj27Aa8Vf0dtUJCgi9PFripyG4bWkR87QyMOLlrasS80WgOBKtd0z/BMWeBmSyTmP5bEY8riERA+VCh1Zsx1u/qU8p6FIBi90MQliHfXP6A1Sy7171iY2yrub4s37b9mjZUcaSFBvVzeJbalVnyJ1C7JhIDXSiPhmiitk=
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