Untitled query #35487

SQL

select enwiki_p.sites.site_global_key, enwiki_p.site_stats.ss_good_articles, (SELECT count(*)
                    FROM enwiki_p.revision
                    INNER JOIN enwiki_p.page ON enwiki_p.revision.rev_page = enwiki_p.page.page_id
                    WHERE enwiki_p.page.page_namespace = 0
                        AND enwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND enwiki_p.revision.rev_parent_id = 0
                        AND enwiki_p.page.page_is_redirect = 0) as "bot", bot/enwiki_p.site_stats.ss_good_articles*100
from enwiki_p.site_stats, enwiki_p.sites
where enwiki_p.sites.site_global_key = "enwiki";
SQL

Checking query status...
