bPQuCvLJ0B0nQXyEnmDcKGCwDGhdZM1kVIcI5GvbOhuyQeVKnDjMtS/gspJEl5a6uidBzfJSEt66ChvKvi+2P7TE2Y2ciPx19tAudRPQVebO0tLAq3WS/pQVI2NdJ6jCr18NKp3D5DosgkTv3o4LJesdqAaM22UN538pLFtVXVPO4hnmUSSlxVWAkOL3weBgWM5iPFgLWPRqNV/dmT/FiyTW6GxCn5mxyylNu1YKhchOONDkVl3UIpaLVMP4BU2N1H/ainttYv0tFE9dvZXuZCKj2diYtI884NwLg75UsuTy26yoseasRX2XnmAfOURA1ehB4/5OpIkCYCfbSwphFgWg6T5tSmuNaecO5gciijlFgtcWuwuOK1sMXgfUEDF9c5ViyFK0e6vZPEkuIgtT4cNmrTwbZjv7QpoL3MLfDNzsMJ9svaFXxBMbLiSNwZgmcLQERH59BiNv58Ci06ItYijvL0bSA6ioSSlkBqoo5H9YcZAkrdEn6wYOWN25zfVZxJoBe+Tb9JUPfuDVSTP34P6pdh1GAa4QRw0fqYR8dW7uh3WWFKr/gMXdT9ra6IaXkbFgUvlRmBX/V4zBeNH9dydGRDPVmlyc9kh7KYMQDIDwrKtp2x93LEQysWtRfzFPoSurafA/3+SepHAJcIT9GM/s8P3v5p2TqqOhRx7MaUJnTQzo86c0I+64pxuNKlT8oqMxMi3bdI2X5R+KQJV/WZGj/Lpez/2sR/tgNj9zIGAKNhuwJIflDO9TRVfdLw3rIAYI2H1mtL1CdrMGYFODyC0euIk9v4yQuyegMyM9UhgZOJ2SYSsM1cZo/w7C5KwoEzd6kqlz/Am9asjfPs7UMGA4Zhaxc94QpmxVUj7TRxAMEhW/9nKA2wiiiBy/vA7gTOSk9eV/Gd+trVUnC9gptnSLc00GgmTHi4lB3htoa7qVkWfLh0jiXQXlB7nWVENT9qEAbNfyCVKo8aGEndAKJDizRmnLKztzaPM8jwKiys4DlCqLhj9QwtANQMrT3hK4UE9LbfosbBJhfpe2iAFSQlcP1BPyG7e9k3W2+xBk6+3TcMWlPXPlmVlsxXlSQkMAk8UGIRis8+LpCvGdL1kJSi+QiibjOkXac2N27mdNElx4SufgUCrezwkFbpcfH4XURrVDvAZvlI1aORU9zze58B6orzet/q281mGuagAi+w1Cf2JnX9DBhAiz6iq8LOIAGRJXySBIR05EcB2M2CLSygpsQD0U2FQpN76RuK0vo+8NapwNLNUt6qyOBK9hjFepeTaimOp4vJ5Ym3pLHtMj16Ix/o25ekqiRaC/2FllFbO6su2ypR92jQJyR+6o9geTr1/Vr2qUBtQWBnU8h26icARy+goX0l4zjic4tZE=
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