0

Please login or register to vote for this query.

(click on this box to dismiss)

Any edit summary comment from random♦ that's over 100 characters is sure to be an interesting read.

Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT COUNT(u.id)
FROM users u
WHERE NOT EXISTS (SELECT 1 
                  FROM PostHistory a
                  INNER JOIN posts p
                  ON p.id = a.postid
                  AND p.owneruserid <> a.userid
                  WHERE a.userid = u.id
                  AND a.posthistorytypeid IN (4,5,6))
AND u.reputation > 5000

fork query

edited may 31 12 anonymous

created mar 22 12 jadarnel27