Untitled query #25541

SQL

# Specifies the Pashtun Wikipedia language edition for data collection
USE pswiki_p;
 
# Collects data for the U, E and L variables
SELECT rev_user, rev_page,
COUNT(DISTINCT rev_user) AS U,
COUNT(rev_id) AS E,
page_len AS L FROM revision
JOIN page ON page_id = rev_page
JOIN user ON user_id = rev_user

# Specifies the entire article for which length will be measured
WHERE page_namespace = "0"

# Excludes redirects
AND page_is_redirect = "FALSE"

# Filters out bots
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%"

# Organizes and specifies sample size
GROUP BY rev_page
ORDER BY RAND()
LIMIT 1000;
SQL

Checking query status...
