SELECT id, data, valor
FROM pagamento
WHERE WEEK(data ,7) = WEEK(NOW())
  AND reftype = 'credito'
  AND status != 99