tdRJLIhTBccYM8ZS79s/2mShlmlcmlJFXoQ8H/4vn/mdt6gvDx+ko2mEVIO11uu61R0V1wlLyTloIOVkjbLMlVg6GJu4xk6OJG9F1EaLhRX1gBz04Pk/6SZc/pD3ucVlmpNYEE9BBDmpeuTpVYV1wkRdtKvAXG2VuZlJsBx7Lq4Fm8vFpMRD2AcIOiryH7IbfbOcU+x3UROSLCmy2kURrwgetUYoiwJeT8fZ14a4fdKosnzplIK2++ftoHzN/rVXtz0Simvq0C9jb6XjH15A2eBxOfQnc+VjT7rF4KaeovZFSXbzPQs9HJyudFdtnG3AI/WNOU2XhQCqJPvL8dJSMQu1nFP+Tyernb+x+mHUCbKKILYxIkOyFdMYi8e9HBTU8my0pg4qdXKu8LyPwBSV/lPNRyFf5OqJLT2LXBPE48bWe34+ZgIwY1wT6WfQsFy2HIY4HedtDm2nfgyYDkIhuQkpCG9Qs/RG+ad9lhJEOXyV9lI1VG2CvMa/JFNrrDeswzH+unlD0LU3mX5G9GT+BB2rVaHmh7n+4ZopfHVZD6wFB0ESGyEDAPdpshiQMHFelDPabMf+vnS1ENlRNLviY4TNmp2PE67/xlWfs9FG4kxlRJXY3b4WxAKdoUOMIo7jcxEcJ2U1TX1yXUl+/IJ3m2jo+BLz6MJP9P0C3Vc9Qu0nQ2obTak96mr+zAFHQpcbbzIqyBIFlLkeWpPYAzmdPL2h5bxxakrNwnjF3S744UJ5TiZ1S1PLOlxyjyhFA45+vTuNabHXtJrLLzytu5J9fW9fAE5txVZfjDmAIUiANwAdeTjQ3bUEYZWU7oVvxzsNeSB1KJYdF1Uph1x3VBQ5o+je9KgcSqW4koIyJCKpDPvu37WxfafayFgSTwNSEHq5rxFiy6Fedz0d4ujWgvS3XJHuC1jKVogv4kxxRl0bHRLkSNufRm//P718rq4fNCHb1y5Z4ukxGkDybYQ+XZP1UQ6aXNdfMDmmuYUdZhelHpE1DEReNKnrssBP5ObX2aybBbdz5COgPFOzVbJeGhJLWhJ7rZEow7s0Bbejw1IAhulr1Qqtx4TQVafcJf+DQiGdfnOr+zom/S8BYaBmoegBu3BYESyRi1vxmaZ3ea9Q2kIWJI9bzBsssjRRCeaDPaljZnlAnpirFcgLziqpYwQu5cOlEPBZGFRvY3qJYcK26I3ysIrM3pfr5NOyr2tyY7vimTGTRADmlUTU1D9TlqptGTkqnLxreKYS55/SOllJIwmbfSJ8hDE2cYSCfxDq5FWnSo4tP/8JRL2dmRnwScx+xTpGfGGaPH9r86P68/3eOO+AKbDecrNARl46NWu0PnNEwSBr2LIagqWZXP1HzVrbuWZuYhqaMnCTFt/Nbb8=
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