--refcnt -vs- actual for specific provider id
select pv.providerid, pv.refcnt, count(*) actual
  from dtreecore d
  join dversdata dv on d.dataid = dv.docid and d.deleted =0
  join providerdata pv on dv.providerid = pv.providerid
  where dv.providerid = 501576
  group by pv.providerid, pv.refcnt;

--any refcnt lower than actual right now?
select * from (
select pv.providerid, pv.refcnt, count(*) actual
from dtree d
join dversdata dv on d.dataid = dv.docid
join providerdata pv on dv.providerid = pv.providerid
group by pv.providerid, pv.refcnt ) data
where data.refcnt < data.actual;