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
#GROUP BY ll_from 
#ORDER BY RAND() 
#LIMIT 10;



USE simplewiki_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...
