0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for community managers, administrators, and moderators

SELECT displayname, id, reputation, downvotes, upvotes
FROM Users u
WHERE Downvotes > 20
AND Reputation < 500
AND EXISTS (SELECT 1
              FROM PostTags pt
              INNER JOIN posts p
              ON pt.postid = p.id
              WHERE p.owneruserid = u.id
              AND pt.tagid = (SELECT id FROM tags WHERE tagname = 'delphi'))
              
ORDER BY Downvotes DESC

view current version

edited jan 12 12

created jan 12 12 JNK