Untitled query #25631

SQL

USE ruwiki_p;
SELECT ll_from, COUNT(DISTINCT ll_title) AS links, 
rev_page, rev_user, COUNT(DISTINCT rev_user) AS editors, COUNT(rev_id) AS edits, 
page_id
FROM langlinks JOIN revision on rev_page = ll_from
JOIN page ON page_id = rev_page
#WHERE page_namespace = "0"
#AND page_is_redirect = "FALSE"
#AND rev_user NOT LIKE "%bot%" AND rev_user NOT LIKE "%Bot%" AND rev_user NOT LIKE "%bOt%" AND rev_user NOT LIKE "%boT%" AND rev_user NOT LIKE "%BOt%" AND rev_user NOT LIKE "%BoT%" AND rev_user NOT LIKE "%bOT%" AND rev_user NOT LIKE "%BOT%”
GROUP BY ll_from ORDER BY RAND() LIMIT 10;
SQL

Checking query status...
