Untitled query #35487

SQL

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

Checking query status...
