SELECT COUNT(*) Total, COUNT(v.IsDupe) Dupes FROM Posts a...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Retrocomputing Meta

Q&A about the site for vintage-computer hobbyists interested in restoring, preserving, and using the classic computer and gaming systems of yesteryear

SELECT
  COUNT(*) Total,
  COUNT(v.IsDupe) Dupes
FROM Posts a
CROSS APPLY (
    SELECT MIN(1)
    FROM PostLinks pl
    WHERE pl.PostId = a.ParentId
 ) v(IsDupe)
WHERE a.OwnerUserId = 3627607
  AND a.PostTypeId = 2

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results