SELECT IFNULL( sum( dr.BesarRefund ) , 0 ) AS BesarRefund
FROM masterrefund mr
INNER JOIN detailrefund dr ON mr.KodeRefund = dr.KodeRefund
INNER JOIN detailpenjualan dp ON dp.IdBarang = dr.IdBarang
INNER JOIN masterpenjualan mp ON mp.NoNotaJual = dp.NoNotaJual
WHERE dp.StatusJual <> 'B'
AND date( TanggalRefund ) >= '2010-10-25'
AND date( TanggalRefund ) <= '2010-10-25'
AND date( mp.TanggalJual ) < '2010-10-25'