Pasted

--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;