GCP editors

0

Please login or register to vote for this query.

(click on this box to dismiss)

Poker Meta

Q&A about the site for serious players and enthusiasts of poker

SELECT DISTINCT
    u.Id,
    u.Id AS [User Link],
    u.Reputation,
    u.UpVotes,
    (
        CASE 
            WHEN p.OwnerUserId IS NULL THEN 0
            ELSE ( SELECT COUNT(p.OwnerUserId) FROM Posts p WHERE p.OwnerUserId = u.Id )
        END
    ) AS PostCount,
    (
        SELECT COUNT(OwnerUserId) FROM SuggestedEdits WHERE OwnerUserId = u.Id
    ) AS SuggestedEditCount,
    u.CreationDate AS AccountCreated,
    u.LastAccessDate AS LastSeen
FROM Users u
LEFT JOIN Posts p ON p.OwnerUserId = u.Id
INNER JOIN SuggestedEdits se ON se.OwnerUserId = u.Id
WHERE se.Comment LIKE N'%Belongs to GC%'

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results