Untitled query #25541

SQL

# Specifies the Pashtun Wikipedia language edition for data collection
USE pswiki_p;
 
SELECT rev_user, rev_page AS pg, COUNT(DISTINCT rev_user) AS usercounts, COUNT(rev_id) AS editcounts, 
page_len AS pagelength FROM revision
JOIN page ON page_id = rev_page
JOIN user ON user_id = rev_user
WHERE page_namespace = "0" AND page_is_redirect = "FALSE" AND
user_name NOT LIKE "%bot%" AND user_name NOT LIKE "%Bot%" 
AND user_name NOT LIKE "%bOt%"AND user_name NOT LIKE "%boT%"
AND user_name NOT LIKE "%BOt%" AND user_name NOT LIKE "%BoT%"
AND user_name NOT LIKE "%bOT%" AND user_name NOT LIKE "%BOT%"
GROUP BY pg ORDER BY RAND() LIMIT 1000;
SQL

Checking query status...
