వాడుకరి:Arjunaraoc/SQLQueries
PAGE EDIT Counts for Top 25 users (example Page prefix to beused with % as wildcard)[మార్చు]
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)[మార్చు]
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;