Untitled query #35487

SQL

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

Checking query status...
