[android-studio] Tag Removal Leaderboard

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT 
  UserId as [User Link],
  COUNT(*) as Removals
FROM (
  SELECT
    orig.PostId as PostId,
    new.UserId as UserId
  FROM
    PostHistory orig
  INNER JOIN PostHistory new ON
    orig.PostId = new.PostId AND
    new.CreationDate > orig.CreationDate
  WHERE
    (orig.PostHistoryTypeId = 3 OR orig.PostHistoryTypeId = 6) AND
    new.PostHistoryTypeId = 6 AND
    orig.Text LIKE '%<android-studio>%' AND
    new.Text NOT LIKE '%<android-studio>%'
  GROUP BY
    orig.PostId,
    new.UserId
) as post_user_data
GROUP BY
  UserId
ORDER BY
  COUNT(*) DESC

Enter Parameters

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