వాడుకరి:Arjunaraoc/SQLQueries

PAGE EDIT Counts for Top 25 users (example Page prefix to beused with % as wildcard)

http://quarry.wmflabs.org/query/3549

SELECT
  user_name,
  COUNT(*) As Edits
FROM user
LEFT JOIN revision
      ON rev_user = user_id
LEFT JOIN page
      ON page_id = rev_page
WHERE page_title LIKE 'Abaddhala%'
GROUP BY user_name
HAVING COUNT(*) > 0
ORDER BY Edits DESC LIMIT 25;

MAIN PAGES EDIT Counts for Top 25 users (example Main page prefix to beused with % as wild card)

http://quarry.wmflabs.org/query/3550

SELECT
  user_name,
  COUNT(*) As Edits
FROM user
LEFT JOIN revision
      ON rev_user = user_id
LEFT JOIN page
      ON page_id = rev_page
WHERE page_title LIKE 'ఆంధ్ర\_రచయితలు%'
GROUP BY user_name
HAVING COUNT(*) > 0
ORDER BY Edits DESC LIMIT 25;