Untitled query #35487

This query is marked as a draft This query has been published by ASammour.
SQL

select aawiki_p.sites.site_global_key, aawiki_p.site_stats.ss_good_articles, (SELECT count(*)
                    FROM aawiki_p.revision
                    INNER JOIN aawiki_p.page ON aawiki_p.revision.rev_page = aawiki_p.page.page_id
                    WHERE aawiki_p.page.page_namespace = 0
                        AND aawiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND aawiki_p.revision.rev_parent_id = 0
                        AND aawiki_p.page.page_is_redirect = 0)/aawiki_p.site_stats.ss_good_articles*100
from aawiki_p.site_stats, aawiki_p.sites
where aawiki_p.sites.site_global_key = "aawiki";
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";
select acewiki_p.sites.site_global_key, acewiki_p.site_stats.ss_good_articles, (SELECT count(*)
                    FROM acewiki_p.revision
                    INNER JOIN acewiki_p.page ON acewiki_p.revision.rev_page = acewiki_p.page.page_id
                    WHERE acewiki_p.page.page_namespace = 0
                        AND acewiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND acewiki_p.revision.rev_parent_id = 0
                        AND acewiki_p.page.page_is_redirect = 0)/acewiki_p.site_stats.ss_good_articles*100
from acewiki_p.site_stats, acewiki_p.sites
where acewiki_p.sites.site_global_key = "acewiki";
select afwiki_p.sites.site_global_key, afwiki_p.site_stats.ss_good_articles, (SELECT count(*)
                    FROM afwiki_p.revision
                    INNER JOIN afwiki_p.page ON afwiki_p.revision.rev_page = afwiki_p.page.page_id
                    WHERE afwiki_p.page.page_namespace = 0
                        AND afwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND afwiki_p.revision.rev_parent_id = 0
                        AND afwiki_p.page.page_is_redirect = 0)/afwiki_p.site_stats.ss_good_articles*100
from afwiki_p.site_stats, afwiki_p.sites
where afwiki_p.sites.site_global_key = "afwiki";
select akwiki_p.sites.site_global_key, akwiki_p.site_stats.ss_good_articles, (SELECT count(*)
                    FROM akwiki_p.revision
                    INNER JOIN akwiki_p.page ON akwiki_p.revision.rev_page = akwiki_p.page.page_id
                    WHERE akwiki_p.page.page_namespace = 0
                        AND akwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND akwiki_p.revision.rev_parent_id = 0
                        AND akwiki_p.page.page_is_redirect = 0)/akwiki_p.site_stats.ss_good_articles*100
from akwiki_p.site_stats, akwiki_p.sites
where akwiki_p.sites.site_global_key = "akwiki";
select alswiki_p.sites.site_global_key, alswiki_p.site_stats.ss_good_articles, (SELECT count(*)
                    FROM alswiki_p.revision
                    INNER JOIN alswiki_p.page ON alswiki_p.revision.rev_page = alswiki_p.page.page_id
                    WHERE alswiki_p.page.page_namespace = 0
                        AND alswiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND alswiki_p.revision.rev_parent_id = 0
                        AND alswiki_p.page.page_is_redirect = 0)/alswiki_p.site_stats.ss_good_articles*100
from alswiki_p.site_stats, alswiki_p.sites
where alswiki_p.sites.site_global_key = "alswiki";
select amwiki_p.sites.site_global_key, amwiki_p.site_stats.ss_good_articles, (SELECT count(*)
                    FROM amwiki_p.revision
                    INNER JOIN amwiki_p.page ON amwiki_p.revision.rev_page = amwiki_p.page.page_id
                    WHERE amwiki_p.page.page_namespace = 0
                        AND amwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND amwiki_p.revision.rev_parent_id = 0
                        AND amwiki_p.page.page_is_redirect = 0)/amwiki_p.site_stats.ss_good_articles*100
from amwiki_p.site_stats, amwiki_p.sites
where amwiki_p.sites.site_global_key = "amwiki";
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
