gj0EeIqZMBzdiyTZTKlSO4d9szLjCcPK+gBPzSO5xS3c5Jw59TuQCeT7n/IoUNa4ptqSqe1woqX6dMpeCiPl2mRxnONuqzWHpTunc/qHywUqhYiqHFLasTaKfz6b228yQUBn2SDZyiJrexTA8y3JCAI0v+7D01+fkRdOFoF6RaSyjXCMsAXRm8RP8aPvdf5ZKelkh2/G5Bheahspdq+Tlz3DEe5zm1dXnOm23MicsGjPKQRrFrrHOGQ/CoyOqLg/w196r8kIuukTSMcv3LMXY35e643X5sXdVg/8k8q7BdrIjsaRokfzY8jP0By95+sadm5A9CEAwHpM/M8/Vf63zEqARHXjOckLNTaho3kyos7y1C6rZ2G4IrKuWMMzEI6BXN7UZCdzwdUoPYJbKJH1hUFWHCKo739c4PXymUivYiWUZ5ubstFMXPa2dym43Ck0V92ohKJ+Ntk9o4Liu0kMAmz06gCZBD2pCqhjt2ehT2TZMoRlntnH13obhdZ6rq0TbFrruW9mYOEiwVZzNPwO/BIFOnvengXlsTMixNzOBvsUj37S9ijs7dG6dAlrQO/3TQKzKkt1CyEILXMQwQWZSBhv+UQb+uic7ndMX48a3Zez6j//5XqaOiBGvd938imQ6nLEAbFSXtsYX/q+LtUWFfMytRn1qVzCjUyH73U7KopTxdRaYnI5LEJI0wCN9Jpo65wuoshur+MDA2h47BcXoxGKGHRcd6KxSzB50iP8Yy36QWMc7VHAXjwf8v8pUEcRMVaHjS+544AyQfrA4Bx5sJ/3viaNOTW28Qe9dHVWAO8RCELT4O2SfCUkbAltSNKTvASaXlK/YE6cHqmshvmilOu8PIgMm2/4Ida03FC9Q4ybThhr7mMtHSt6xP3Vn4WhGhp9F9/Mkghi33HlNEiLmdEarnoqrX+jsvuso9pL/YUmX5JIe/iR2fhe29bcmuI6cRELMIVlOmCI9vEyJih8XPa/g6GcsIz8vPFdFtZhW9vHHLnNW+4j3PTwW4qSiirP2RQI3+NKOX7N/1rryvb15XhAXhwRIEY22KIWxlfFQkKblEPklc6xhvmFtusH5PQAWDrt48BWpvM2KNV9/u2t6UUSAS2x1hdTmvZpLEzAqos96cNPCSp2eP1n6wJULS5ZazjtKsTz/pj/sAYKmh8av6OJG+w8fRCSImDJ9XIPJNK4OrUEycyKhZR2uQPq4u0jmqMj64wkVO89279AsgypKnOkehPb7G8NGqJfqzh9Muvcvq+j0H9QehbgoSUWhXAXxOqQHMUGKp7iQdDGzS0JTGw5wVKCytm/PQtAJpwlbh4yc5bepCu5pxnyxhXOYTleNNBfRDTkzryLuZWzLhDB62WeUXShmL28u37mwSM=
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