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) as "النسبة"
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) as "النسبة"
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) as "النسبة"
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) as "النسبة"
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) as "النسبة"
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) as "النسبة"
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) as "النسبة"
from amwiki_p.site_stats, amwiki_p.sites
where amwiki_p.sites.site_global_key = "amwiki";


select anwiki_p.sites.site_global_key, anwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM anwiki_p.revision
                    INNER JOIN anwiki_p.page ON anwiki_p.revision.rev_page = anwiki_p.page.page_id
                    WHERE anwiki_p.page.page_namespace = 0
                        AND anwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND anwiki_p.revision.rev_parent_id = 0
                        AND anwiki_p.page.page_is_redirect = 0)/anwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from anwiki_p.site_stats, anwiki_p.sites
where anwiki_p.sites.site_global_key = "anwiki";


select angwiki_p.sites.site_global_key, angwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM angwiki_p.revision
                    INNER JOIN angwiki_p.page ON angwiki_p.revision.rev_page = angwiki_p.page.page_id
                    WHERE angwiki_p.page.page_namespace = 0
                        AND angwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND angwiki_p.revision.rev_parent_id = 0
                        AND angwiki_p.page.page_is_redirect = 0)/angwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from angwiki_p.site_stats, angwiki_p.sites
where angwiki_p.sites.site_global_key = "angwiki";


select arwiki_p.sites.site_global_key, arwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM arwiki_p.revision
                    INNER JOIN arwiki_p.page ON arwiki_p.revision.rev_page = arwiki_p.page.page_id
                    WHERE arwiki_p.page.page_namespace = 0
                        AND arwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND arwiki_p.revision.rev_parent_id = 0
                        AND arwiki_p.page.page_is_redirect = 0)/arwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from arwiki_p.site_stats, arwiki_p.sites
where arwiki_p.sites.site_global_key = "arwiki";


select arcwiki_p.sites.site_global_key, arcwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM arcwiki_p.revision
                    INNER JOIN arcwiki_p.page ON arcwiki_p.revision.rev_page = arcwiki_p.page.page_id
                    WHERE arcwiki_p.page.page_namespace = 0
                        AND arcwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND arcwiki_p.revision.rev_parent_id = 0
                        AND arcwiki_p.page.page_is_redirect = 0)/arcwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from arcwiki_p.site_stats, arcwiki_p.sites
where arcwiki_p.sites.site_global_key = "arcwiki";


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)/arzwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from arzwiki_p.site_stats, arzwiki_p.sites
where arzwiki_p.sites.site_global_key = "arzwiki";


select aswiki_p.sites.site_global_key, aswiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM aswiki_p.revision
                    INNER JOIN aswiki_p.page ON aswiki_p.revision.rev_page = aswiki_p.page.page_id
                    WHERE aswiki_p.page.page_namespace = 0
                        AND aswiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND aswiki_p.revision.rev_parent_id = 0
                        AND aswiki_p.page.page_is_redirect = 0)/aswiki_p.site_stats.ss_good_articles*100) as "النسبة"
from aswiki_p.site_stats, aswiki_p.sites
where aswiki_p.sites.site_global_key = "aswiki";


select astwiki_p.sites.site_global_key, astwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM astwiki_p.revision
                    INNER JOIN astwiki_p.page ON astwiki_p.revision.rev_page = astwiki_p.page.page_id
                    WHERE astwiki_p.page.page_namespace = 0
                        AND astwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND astwiki_p.revision.rev_parent_id = 0
                        AND astwiki_p.page.page_is_redirect = 0)/astwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from astwiki_p.site_stats, astwiki_p.sites
where astwiki_p.sites.site_global_key = "astwiki";


select avwiki_p.sites.site_global_key, avwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM avwiki_p.revision
                    INNER JOIN avwiki_p.page ON avwiki_p.revision.rev_page = avwiki_p.page.page_id
                    WHERE avwiki_p.page.page_namespace = 0
                        AND avwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND avwiki_p.revision.rev_parent_id = 0
                        AND avwiki_p.page.page_is_redirect = 0)/avwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from avwiki_p.site_stats, avwiki_p.sites
where avwiki_p.sites.site_global_key = "avwiki";


select aywiki_p.sites.site_global_key, aywiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM aywiki_p.revision
                    INNER JOIN aywiki_p.page ON aywiki_p.revision.rev_page = aywiki_p.page.page_id
                    WHERE aywiki_p.page.page_namespace = 0
                        AND aywiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND aywiki_p.revision.rev_parent_id = 0
                        AND aywiki_p.page.page_is_redirect = 0)/aywiki_p.site_stats.ss_good_articles*100) as "النسبة"
from aywiki_p.site_stats, aywiki_p.sites
where aywiki_p.sites.site_global_key = "aywiki";


select azwiki_p.sites.site_global_key, azwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM azwiki_p.revision
                    INNER JOIN azwiki_p.page ON azwiki_p.revision.rev_page = azwiki_p.page.page_id
                    WHERE azwiki_p.page.page_namespace = 0
                        AND azwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND azwiki_p.revision.rev_parent_id = 0
                        AND azwiki_p.page.page_is_redirect = 0)/azwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from azwiki_p.site_stats, azwiki_p.sites
where azwiki_p.sites.site_global_key = "azwiki";


select bawiki_p.sites.site_global_key, bawiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bawiki_p.revision
                    INNER JOIN bawiki_p.page ON bawiki_p.revision.rev_page = bawiki_p.page.page_id
                    WHERE bawiki_p.page.page_namespace = 0
                        AND bawiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bawiki_p.revision.rev_parent_id = 0
                        AND bawiki_p.page.page_is_redirect = 0)/bawiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bawiki_p.site_stats, bawiki_p.sites
where bawiki_p.sites.site_global_key = "bawiki";


select barwiki_p.sites.site_global_key, barwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM barwiki_p.revision
                    INNER JOIN barwiki_p.page ON barwiki_p.revision.rev_page = barwiki_p.page.page_id
                    WHERE barwiki_p.page.page_namespace = 0
                        AND barwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND barwiki_p.revision.rev_parent_id = 0
                        AND barwiki_p.page.page_is_redirect = 0)/barwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from barwiki_p.site_stats, barwiki_p.sites
where barwiki_p.sites.site_global_key = "barwiki";


select bat_smgwiki_p.sites.site_global_key, bat_smgwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bat_smgwiki_p.revision
                    INNER JOIN bat_smgwiki_p.page ON bat_smgwiki_p.revision.rev_page = bat_smgwiki_p.page.page_id
                    WHERE bat_smgwiki_p.page.page_namespace = 0
                        AND bat_smgwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bat_smgwiki_p.revision.rev_parent_id = 0
                        AND bat_smgwiki_p.page.page_is_redirect = 0)/bat_smgwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bat_smgwiki_p.site_stats, bat_smgwiki_p.sites
where bat_smgwiki_p.sites.site_global_key = "bat_smgwiki";


select bclwiki_p.sites.site_global_key, bclwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bclwiki_p.revision
                    INNER JOIN bclwiki_p.page ON bclwiki_p.revision.rev_page = bclwiki_p.page.page_id
                    WHERE bclwiki_p.page.page_namespace = 0
                        AND bclwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bclwiki_p.revision.rev_parent_id = 0
                        AND bclwiki_p.page.page_is_redirect = 0)/bclwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bclwiki_p.site_stats, bclwiki_p.sites
where bclwiki_p.sites.site_global_key = "bclwiki";


select bewiki_p.sites.site_global_key, bewiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bewiki_p.revision
                    INNER JOIN bewiki_p.page ON bewiki_p.revision.rev_page = bewiki_p.page.page_id
                    WHERE bewiki_p.page.page_namespace = 0
                        AND bewiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bewiki_p.revision.rev_parent_id = 0
                        AND bewiki_p.page.page_is_redirect = 0)/bewiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bewiki_p.site_stats, bewiki_p.sites
where bewiki_p.sites.site_global_key = "bewiki";


select be_x_oldwiki_p.sites.site_global_key, be_x_oldwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM be_x_oldwiki_p.revision
                    INNER JOIN be_x_oldwiki_p.page ON be_x_oldwiki_p.revision.rev_page = be_x_oldwiki_p.page.page_id
                    WHERE be_x_oldwiki_p.page.page_namespace = 0
                        AND be_x_oldwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND be_x_oldwiki_p.revision.rev_parent_id = 0
                        AND be_x_oldwiki_p.page.page_is_redirect = 0)/be_x_oldwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from be_x_oldwiki_p.site_stats, be_x_oldwiki_p.sites
where be_x_oldwiki_p.sites.site_global_key = "be_x_oldwiki";


select bgwiki_p.sites.site_global_key, bgwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bgwiki_p.revision
                    INNER JOIN bgwiki_p.page ON bgwiki_p.revision.rev_page = bgwiki_p.page.page_id
                    WHERE bgwiki_p.page.page_namespace = 0
                        AND bgwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bgwiki_p.revision.rev_parent_id = 0
                        AND bgwiki_p.page.page_is_redirect = 0)/bgwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bgwiki_p.site_stats, bgwiki_p.sites
where bgwiki_p.sites.site_global_key = "bgwiki";


select bhwiki_p.sites.site_global_key, bhwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bhwiki_p.revision
                    INNER JOIN bhwiki_p.page ON bhwiki_p.revision.rev_page = bhwiki_p.page.page_id
                    WHERE bhwiki_p.page.page_namespace = 0
                        AND bhwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bhwiki_p.revision.rev_parent_id = 0
                        AND bhwiki_p.page.page_is_redirect = 0)/bhwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bhwiki_p.site_stats, bhwiki_p.sites
where bhwiki_p.sites.site_global_key = "bhwiki";


select biwiki_p.sites.site_global_key, biwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM biwiki_p.revision
                    INNER JOIN biwiki_p.page ON biwiki_p.revision.rev_page = biwiki_p.page.page_id
                    WHERE biwiki_p.page.page_namespace = 0
                        AND biwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND biwiki_p.revision.rev_parent_id = 0
                        AND biwiki_p.page.page_is_redirect = 0)/biwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from biwiki_p.site_stats, biwiki_p.sites
where biwiki_p.sites.site_global_key = "biwiki";


select bjnwiki_p.sites.site_global_key, bjnwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bjnwiki_p.revision
                    INNER JOIN bjnwiki_p.page ON bjnwiki_p.revision.rev_page = bjnwiki_p.page.page_id
                    WHERE bjnwiki_p.page.page_namespace = 0
                        AND bjnwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bjnwiki_p.revision.rev_parent_id = 0
                        AND bjnwiki_p.page.page_is_redirect = 0)/bjnwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bjnwiki_p.site_stats, bjnwiki_p.sites
where bjnwiki_p.sites.site_global_key = "bjnwiki";


select bmwiki_p.sites.site_global_key, bmwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bmwiki_p.revision
                    INNER JOIN bmwiki_p.page ON bmwiki_p.revision.rev_page = bmwiki_p.page.page_id
                    WHERE bmwiki_p.page.page_namespace = 0
                        AND bmwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bmwiki_p.revision.rev_parent_id = 0
                        AND bmwiki_p.page.page_is_redirect = 0)/bmwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bmwiki_p.site_stats, bmwiki_p.sites
where bmwiki_p.sites.site_global_key = "bmwiki";


select bnwiki_p.sites.site_global_key, bnwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bnwiki_p.revision
                    INNER JOIN bnwiki_p.page ON bnwiki_p.revision.rev_page = bnwiki_p.page.page_id
                    WHERE bnwiki_p.page.page_namespace = 0
                        AND bnwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bnwiki_p.revision.rev_parent_id = 0
                        AND bnwiki_p.page.page_is_redirect = 0)/bnwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bnwiki_p.site_stats, bnwiki_p.sites
where bnwiki_p.sites.site_global_key = "bnwiki";


select bowiki_p.sites.site_global_key, bowiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bowiki_p.revision
                    INNER JOIN bowiki_p.page ON bowiki_p.revision.rev_page = bowiki_p.page.page_id
                    WHERE bowiki_p.page.page_namespace = 0
                        AND bowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bowiki_p.revision.rev_parent_id = 0
                        AND bowiki_p.page.page_is_redirect = 0)/bowiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bowiki_p.site_stats, bowiki_p.sites
where bowiki_p.sites.site_global_key = "bowiki";


select bpywiki_p.sites.site_global_key, bpywiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bpywiki_p.revision
                    INNER JOIN bpywiki_p.page ON bpywiki_p.revision.rev_page = bpywiki_p.page.page_id
                    WHERE bpywiki_p.page.page_namespace = 0
                        AND bpywiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bpywiki_p.revision.rev_parent_id = 0
                        AND bpywiki_p.page.page_is_redirect = 0)/bpywiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bpywiki_p.site_stats, bpywiki_p.sites
where bpywiki_p.sites.site_global_key = "bpywiki";


select brwiki_p.sites.site_global_key, brwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM brwiki_p.revision
                    INNER JOIN brwiki_p.page ON brwiki_p.revision.rev_page = brwiki_p.page.page_id
                    WHERE brwiki_p.page.page_namespace = 0
                        AND brwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND brwiki_p.revision.rev_parent_id = 0
                        AND brwiki_p.page.page_is_redirect = 0)/brwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from brwiki_p.site_stats, brwiki_p.sites
where brwiki_p.sites.site_global_key = "brwiki";


select bswiki_p.sites.site_global_key, bswiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bswiki_p.revision
                    INNER JOIN bswiki_p.page ON bswiki_p.revision.rev_page = bswiki_p.page.page_id
                    WHERE bswiki_p.page.page_namespace = 0
                        AND bswiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bswiki_p.revision.rev_parent_id = 0
                        AND bswiki_p.page.page_is_redirect = 0)/bswiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bswiki_p.site_stats, bswiki_p.sites
where bswiki_p.sites.site_global_key = "bswiki";


select bugwiki_p.sites.site_global_key, bugwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bugwiki_p.revision
                    INNER JOIN bugwiki_p.page ON bugwiki_p.revision.rev_page = bugwiki_p.page.page_id
                    WHERE bugwiki_p.page.page_namespace = 0
                        AND bugwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bugwiki_p.revision.rev_parent_id = 0
                        AND bugwiki_p.page.page_is_redirect = 0)/bugwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bugwiki_p.site_stats, bugwiki_p.sites
where bugwiki_p.sites.site_global_key = "bugwiki";


select bxrwiki_p.sites.site_global_key, bxrwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM bxrwiki_p.revision
                    INNER JOIN bxrwiki_p.page ON bxrwiki_p.revision.rev_page = bxrwiki_p.page.page_id
                    WHERE bxrwiki_p.page.page_namespace = 0
                        AND bxrwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND bxrwiki_p.revision.rev_parent_id = 0
                        AND bxrwiki_p.page.page_is_redirect = 0)/bxrwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from bxrwiki_p.site_stats, bxrwiki_p.sites
where bxrwiki_p.sites.site_global_key = "bxrwiki";


select cawiki_p.sites.site_global_key, cawiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cawiki_p.revision
                    INNER JOIN cawiki_p.page ON cawiki_p.revision.rev_page = cawiki_p.page.page_id
                    WHERE cawiki_p.page.page_namespace = 0
                        AND cawiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cawiki_p.revision.rev_parent_id = 0
                        AND cawiki_p.page.page_is_redirect = 0)/cawiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cawiki_p.site_stats, cawiki_p.sites
where cawiki_p.sites.site_global_key = "cawiki";


select cbk_zamwiki_p.sites.site_global_key, cbk_zamwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cbk_zamwiki_p.revision
                    INNER JOIN cbk_zamwiki_p.page ON cbk_zamwiki_p.revision.rev_page = cbk_zamwiki_p.page.page_id
                    WHERE cbk_zamwiki_p.page.page_namespace = 0
                        AND cbk_zamwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cbk_zamwiki_p.revision.rev_parent_id = 0
                        AND cbk_zamwiki_p.page.page_is_redirect = 0)/cbk_zamwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cbk_zamwiki_p.site_stats, cbk_zamwiki_p.sites
where cbk_zamwiki_p.sites.site_global_key = "cbk_zamwiki";


select cdowiki_p.sites.site_global_key, cdowiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cdowiki_p.revision
                    INNER JOIN cdowiki_p.page ON cdowiki_p.revision.rev_page = cdowiki_p.page.page_id
                    WHERE cdowiki_p.page.page_namespace = 0
                        AND cdowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cdowiki_p.revision.rev_parent_id = 0
                        AND cdowiki_p.page.page_is_redirect = 0)/cdowiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cdowiki_p.site_stats, cdowiki_p.sites
where cdowiki_p.sites.site_global_key = "cdowiki";


select cewiki_p.sites.site_global_key, cewiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cewiki_p.revision
                    INNER JOIN cewiki_p.page ON cewiki_p.revision.rev_page = cewiki_p.page.page_id
                    WHERE cewiki_p.page.page_namespace = 0
                        AND cewiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cewiki_p.revision.rev_parent_id = 0
                        AND cewiki_p.page.page_is_redirect = 0)/cewiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cewiki_p.site_stats, cewiki_p.sites
where cewiki_p.sites.site_global_key = "cewiki";


select cebwiki_p.sites.site_global_key, cebwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cebwiki_p.revision
                    INNER JOIN cebwiki_p.page ON cebwiki_p.revision.rev_page = cebwiki_p.page.page_id
                    WHERE cebwiki_p.page.page_namespace = 0
                        AND cebwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cebwiki_p.revision.rev_parent_id = 0
                        AND cebwiki_p.page.page_is_redirect = 0)/cebwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cebwiki_p.site_stats, cebwiki_p.sites
where cebwiki_p.sites.site_global_key = "cebwiki";


select chwiki_p.sites.site_global_key, chwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM chwiki_p.revision
                    INNER JOIN chwiki_p.page ON chwiki_p.revision.rev_page = chwiki_p.page.page_id
                    WHERE chwiki_p.page.page_namespace = 0
                        AND chwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND chwiki_p.revision.rev_parent_id = 0
                        AND chwiki_p.page.page_is_redirect = 0)/chwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from chwiki_p.site_stats, chwiki_p.sites
where chwiki_p.sites.site_global_key = "chwiki";


select chowiki_p.sites.site_global_key, chowiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM chowiki_p.revision
                    INNER JOIN chowiki_p.page ON chowiki_p.revision.rev_page = chowiki_p.page.page_id
                    WHERE chowiki_p.page.page_namespace = 0
                        AND chowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND chowiki_p.revision.rev_parent_id = 0
                        AND chowiki_p.page.page_is_redirect = 0)/chowiki_p.site_stats.ss_good_articles*100) as "النسبة"
from chowiki_p.site_stats, chowiki_p.sites
where chowiki_p.sites.site_global_key = "chowiki";


select chrwiki_p.sites.site_global_key, chrwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM chrwiki_p.revision
                    INNER JOIN chrwiki_p.page ON chrwiki_p.revision.rev_page = chrwiki_p.page.page_id
                    WHERE chrwiki_p.page.page_namespace = 0
                        AND chrwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND chrwiki_p.revision.rev_parent_id = 0
                        AND chrwiki_p.page.page_is_redirect = 0)/chrwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from chrwiki_p.site_stats, chrwiki_p.sites
where chrwiki_p.sites.site_global_key = "chrwiki";


select chywiki_p.sites.site_global_key, chywiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM chywiki_p.revision
                    INNER JOIN chywiki_p.page ON chywiki_p.revision.rev_page = chywiki_p.page.page_id
                    WHERE chywiki_p.page.page_namespace = 0
                        AND chywiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND chywiki_p.revision.rev_parent_id = 0
                        AND chywiki_p.page.page_is_redirect = 0)/chywiki_p.site_stats.ss_good_articles*100) as "النسبة"
from chywiki_p.site_stats, chywiki_p.sites
where chywiki_p.sites.site_global_key = "chywiki";


select ckbwiki_p.sites.site_global_key, ckbwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM ckbwiki_p.revision
                    INNER JOIN ckbwiki_p.page ON ckbwiki_p.revision.rev_page = ckbwiki_p.page.page_id
                    WHERE ckbwiki_p.page.page_namespace = 0
                        AND ckbwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND ckbwiki_p.revision.rev_parent_id = 0
                        AND ckbwiki_p.page.page_is_redirect = 0)/ckbwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from ckbwiki_p.site_stats, ckbwiki_p.sites
where ckbwiki_p.sites.site_global_key = "ckbwiki";


select cowiki_p.sites.site_global_key, cowiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cowiki_p.revision
                    INNER JOIN cowiki_p.page ON cowiki_p.revision.rev_page = cowiki_p.page.page_id
                    WHERE cowiki_p.page.page_namespace = 0
                        AND cowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cowiki_p.revision.rev_parent_id = 0
                        AND cowiki_p.page.page_is_redirect = 0)/cowiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cowiki_p.site_stats, cowiki_p.sites
where cowiki_p.sites.site_global_key = "cowiki";


select crwiki_p.sites.site_global_key, crwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM crwiki_p.revision
                    INNER JOIN crwiki_p.page ON crwiki_p.revision.rev_page = crwiki_p.page.page_id
                    WHERE crwiki_p.page.page_namespace = 0
                        AND crwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND crwiki_p.revision.rev_parent_id = 0
                        AND crwiki_p.page.page_is_redirect = 0)/crwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from crwiki_p.site_stats, crwiki_p.sites
where crwiki_p.sites.site_global_key = "crwiki";


select crhwiki_p.sites.site_global_key, crhwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM crhwiki_p.revision
                    INNER JOIN crhwiki_p.page ON crhwiki_p.revision.rev_page = crhwiki_p.page.page_id
                    WHERE crhwiki_p.page.page_namespace = 0
                        AND crhwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND crhwiki_p.revision.rev_parent_id = 0
                        AND crhwiki_p.page.page_is_redirect = 0)/crhwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from crhwiki_p.site_stats, crhwiki_p.sites
where crhwiki_p.sites.site_global_key = "crhwiki";


select cswiki_p.sites.site_global_key, cswiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cswiki_p.revision
                    INNER JOIN cswiki_p.page ON cswiki_p.revision.rev_page = cswiki_p.page.page_id
                    WHERE cswiki_p.page.page_namespace = 0
                        AND cswiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cswiki_p.revision.rev_parent_id = 0
                        AND cswiki_p.page.page_is_redirect = 0)/cswiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cswiki_p.site_stats, cswiki_p.sites
where cswiki_p.sites.site_global_key = "cswiki";


select csbwiki_p.sites.site_global_key, csbwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM csbwiki_p.revision
                    INNER JOIN csbwiki_p.page ON csbwiki_p.revision.rev_page = csbwiki_p.page.page_id
                    WHERE csbwiki_p.page.page_namespace = 0
                        AND csbwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND csbwiki_p.revision.rev_parent_id = 0
                        AND csbwiki_p.page.page_is_redirect = 0)/csbwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from csbwiki_p.site_stats, csbwiki_p.sites
where csbwiki_p.sites.site_global_key = "csbwiki";


select cuwiki_p.sites.site_global_key, cuwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cuwiki_p.revision
                    INNER JOIN cuwiki_p.page ON cuwiki_p.revision.rev_page = cuwiki_p.page.page_id
                    WHERE cuwiki_p.page.page_namespace = 0
                        AND cuwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cuwiki_p.revision.rev_parent_id = 0
                        AND cuwiki_p.page.page_is_redirect = 0)/cuwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cuwiki_p.site_stats, cuwiki_p.sites
where cuwiki_p.sites.site_global_key = "cuwiki";


select cvwiki_p.sites.site_global_key, cvwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cvwiki_p.revision
                    INNER JOIN cvwiki_p.page ON cvwiki_p.revision.rev_page = cvwiki_p.page.page_id
                    WHERE cvwiki_p.page.page_namespace = 0
                        AND cvwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cvwiki_p.revision.rev_parent_id = 0
                        AND cvwiki_p.page.page_is_redirect = 0)/cvwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cvwiki_p.site_stats, cvwiki_p.sites
where cvwiki_p.sites.site_global_key = "cvwiki";


select cywiki_p.sites.site_global_key, cywiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM cywiki_p.revision
                    INNER JOIN cywiki_p.page ON cywiki_p.revision.rev_page = cywiki_p.page.page_id
                    WHERE cywiki_p.page.page_namespace = 0
                        AND cywiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND cywiki_p.revision.rev_parent_id = 0
                        AND cywiki_p.page.page_is_redirect = 0)/cywiki_p.site_stats.ss_good_articles*100) as "النسبة"
from cywiki_p.site_stats, cywiki_p.sites
where cywiki_p.sites.site_global_key = "cywiki";


select dawiki_p.sites.site_global_key, dawiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM dawiki_p.revision
                    INNER JOIN dawiki_p.page ON dawiki_p.revision.rev_page = dawiki_p.page.page_id
                    WHERE dawiki_p.page.page_namespace = 0
                        AND dawiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND dawiki_p.revision.rev_parent_id = 0
                        AND dawiki_p.page.page_is_redirect = 0)/dawiki_p.site_stats.ss_good_articles*100) as "النسبة"
from dawiki_p.site_stats, dawiki_p.sites
where dawiki_p.sites.site_global_key = "dawiki";


select dewiki_p.sites.site_global_key, dewiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM dewiki_p.revision
                    INNER JOIN dewiki_p.page ON dewiki_p.revision.rev_page = dewiki_p.page.page_id
                    WHERE dewiki_p.page.page_namespace = 0
                        AND dewiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND dewiki_p.revision.rev_parent_id = 0
                        AND dewiki_p.page.page_is_redirect = 0)/dewiki_p.site_stats.ss_good_articles*100) as "النسبة"
from dewiki_p.site_stats, dewiki_p.sites
where dewiki_p.sites.site_global_key = "dewiki";


select diqwiki_p.sites.site_global_key, diqwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM diqwiki_p.revision
                    INNER JOIN diqwiki_p.page ON diqwiki_p.revision.rev_page = diqwiki_p.page.page_id
                    WHERE diqwiki_p.page.page_namespace = 0
                        AND diqwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND diqwiki_p.revision.rev_parent_id = 0
                        AND diqwiki_p.page.page_is_redirect = 0)/diqwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from diqwiki_p.site_stats, diqwiki_p.sites
where diqwiki_p.sites.site_global_key = "diqwiki";


select dsbwiki_p.sites.site_global_key, dsbwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM dsbwiki_p.revision
                    INNER JOIN dsbwiki_p.page ON dsbwiki_p.revision.rev_page = dsbwiki_p.page.page_id
                    WHERE dsbwiki_p.page.page_namespace = 0
                        AND dsbwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND dsbwiki_p.revision.rev_parent_id = 0
                        AND dsbwiki_p.page.page_is_redirect = 0)/dsbwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from dsbwiki_p.site_stats, dsbwiki_p.sites
where dsbwiki_p.sites.site_global_key = "dsbwiki";


select dvwiki_p.sites.site_global_key, dvwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM dvwiki_p.revision
                    INNER JOIN dvwiki_p.page ON dvwiki_p.revision.rev_page = dvwiki_p.page.page_id
                    WHERE dvwiki_p.page.page_namespace = 0
                        AND dvwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND dvwiki_p.revision.rev_parent_id = 0
                        AND dvwiki_p.page.page_is_redirect = 0)/dvwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from dvwiki_p.site_stats, dvwiki_p.sites
where dvwiki_p.sites.site_global_key = "dvwiki";


select dzwiki_p.sites.site_global_key, dzwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM dzwiki_p.revision
                    INNER JOIN dzwiki_p.page ON dzwiki_p.revision.rev_page = dzwiki_p.page.page_id
                    WHERE dzwiki_p.page.page_namespace = 0
                        AND dzwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND dzwiki_p.revision.rev_parent_id = 0
                        AND dzwiki_p.page.page_is_redirect = 0)/dzwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from dzwiki_p.site_stats, dzwiki_p.sites
where dzwiki_p.sites.site_global_key = "dzwiki";


select eewiki_p.sites.site_global_key, eewiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM eewiki_p.revision
                    INNER JOIN eewiki_p.page ON eewiki_p.revision.rev_page = eewiki_p.page.page_id
                    WHERE eewiki_p.page.page_namespace = 0
                        AND eewiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND eewiki_p.revision.rev_parent_id = 0
                        AND eewiki_p.page.page_is_redirect = 0)/eewiki_p.site_stats.ss_good_articles*100) as "النسبة"
from eewiki_p.site_stats, eewiki_p.sites
where eewiki_p.sites.site_global_key = "eewiki";


select elwiki_p.sites.site_global_key, elwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM elwiki_p.revision
                    INNER JOIN elwiki_p.page ON elwiki_p.revision.rev_page = elwiki_p.page.page_id
                    WHERE elwiki_p.page.page_namespace = 0
                        AND elwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND elwiki_p.revision.rev_parent_id = 0
                        AND elwiki_p.page.page_is_redirect = 0)/elwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from elwiki_p.site_stats, elwiki_p.sites
where elwiki_p.sites.site_global_key = "elwiki";


select emlwiki_p.sites.site_global_key, emlwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM emlwiki_p.revision
                    INNER JOIN emlwiki_p.page ON emlwiki_p.revision.rev_page = emlwiki_p.page.page_id
                    WHERE emlwiki_p.page.page_namespace = 0
                        AND emlwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND emlwiki_p.revision.rev_parent_id = 0
                        AND emlwiki_p.page.page_is_redirect = 0)/emlwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from emlwiki_p.site_stats, emlwiki_p.sites
where emlwiki_p.sites.site_global_key = "emlwiki";


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)/enwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from enwiki_p.site_stats, enwiki_p.sites
where enwiki_p.sites.site_global_key = "enwiki";


select eowiki_p.sites.site_global_key, eowiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM eowiki_p.revision
                    INNER JOIN eowiki_p.page ON eowiki_p.revision.rev_page = eowiki_p.page.page_id
                    WHERE eowiki_p.page.page_namespace = 0
                        AND eowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND eowiki_p.revision.rev_parent_id = 0
                        AND eowiki_p.page.page_is_redirect = 0)/eowiki_p.site_stats.ss_good_articles*100) as "النسبة"
from eowiki_p.site_stats, eowiki_p.sites
where eowiki_p.sites.site_global_key = "eowiki";


select eswiki_p.sites.site_global_key, eswiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM eswiki_p.revision
                    INNER JOIN eswiki_p.page ON eswiki_p.revision.rev_page = eswiki_p.page.page_id
                    WHERE eswiki_p.page.page_namespace = 0
                        AND eswiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND eswiki_p.revision.rev_parent_id = 0
                        AND eswiki_p.page.page_is_redirect = 0)/eswiki_p.site_stats.ss_good_articles*100) as "النسبة"
from eswiki_p.site_stats, eswiki_p.sites
where eswiki_p.sites.site_global_key = "eswiki";


select etwiki_p.sites.site_global_key, etwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM etwiki_p.revision
                    INNER JOIN etwiki_p.page ON etwiki_p.revision.rev_page = etwiki_p.page.page_id
                    WHERE etwiki_p.page.page_namespace = 0
                        AND etwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND etwiki_p.revision.rev_parent_id = 0
                        AND etwiki_p.page.page_is_redirect = 0)/etwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from etwiki_p.site_stats, etwiki_p.sites
where etwiki_p.sites.site_global_key = "etwiki";


select euwiki_p.sites.site_global_key, euwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM euwiki_p.revision
                    INNER JOIN euwiki_p.page ON euwiki_p.revision.rev_page = euwiki_p.page.page_id
                    WHERE euwiki_p.page.page_namespace = 0
                        AND euwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND euwiki_p.revision.rev_parent_id = 0
                        AND euwiki_p.page.page_is_redirect = 0)/euwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from euwiki_p.site_stats, euwiki_p.sites
where euwiki_p.sites.site_global_key = "euwiki";


select extwiki_p.sites.site_global_key, extwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM extwiki_p.revision
                    INNER JOIN extwiki_p.page ON extwiki_p.revision.rev_page = extwiki_p.page.page_id
                    WHERE extwiki_p.page.page_namespace = 0
                        AND extwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND extwiki_p.revision.rev_parent_id = 0
                        AND extwiki_p.page.page_is_redirect = 0)/extwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from extwiki_p.site_stats, extwiki_p.sites
where extwiki_p.sites.site_global_key = "extwiki";


select fawiki_p.sites.site_global_key, fawiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM fawiki_p.revision
                    INNER JOIN fawiki_p.page ON fawiki_p.revision.rev_page = fawiki_p.page.page_id
                    WHERE fawiki_p.page.page_namespace = 0
                        AND fawiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND fawiki_p.revision.rev_parent_id = 0
                        AND fawiki_p.page.page_is_redirect = 0)/fawiki_p.site_stats.ss_good_articles*100) as "النسبة"
from fawiki_p.site_stats, fawiki_p.sites
where fawiki_p.sites.site_global_key = "fawiki";


select ffwiki_p.sites.site_global_key, ffwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM ffwiki_p.revision
                    INNER JOIN ffwiki_p.page ON ffwiki_p.revision.rev_page = ffwiki_p.page.page_id
                    WHERE ffwiki_p.page.page_namespace = 0
                        AND ffwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND ffwiki_p.revision.rev_parent_id = 0
                        AND ffwiki_p.page.page_is_redirect = 0)/ffwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from ffwiki_p.site_stats, ffwiki_p.sites
where ffwiki_p.sites.site_global_key = "ffwiki";


select fiwiki_p.sites.site_global_key, fiwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM fiwiki_p.revision
                    INNER JOIN fiwiki_p.page ON fiwiki_p.revision.rev_page = fiwiki_p.page.page_id
                    WHERE fiwiki_p.page.page_namespace = 0
                        AND fiwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND fiwiki_p.revision.rev_parent_id = 0
                        AND fiwiki_p.page.page_is_redirect = 0)/fiwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from fiwiki_p.site_stats, fiwiki_p.sites
where fiwiki_p.sites.site_global_key = "fiwiki";


select fiu_vrowiki_p.sites.site_global_key, fiu_vrowiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM fiu_vrowiki_p.revision
                    INNER JOIN fiu_vrowiki_p.page ON fiu_vrowiki_p.revision.rev_page = fiu_vrowiki_p.page.page_id
                    WHERE fiu_vrowiki_p.page.page_namespace = 0
                        AND fiu_vrowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND fiu_vrowiki_p.revision.rev_parent_id = 0
                        AND fiu_vrowiki_p.page.page_is_redirect = 0)/fiu_vrowiki_p.site_stats.ss_good_articles*100) as "النسبة"
from fiu_vrowiki_p.site_stats, fiu_vrowiki_p.sites
where fiu_vrowiki_p.sites.site_global_key = "fiu_vrowiki";


select fjwiki_p.sites.site_global_key, fjwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM fjwiki_p.revision
                    INNER JOIN fjwiki_p.page ON fjwiki_p.revision.rev_page = fjwiki_p.page.page_id
                    WHERE fjwiki_p.page.page_namespace = 0
                        AND fjwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND fjwiki_p.revision.rev_parent_id = 0
                        AND fjwiki_p.page.page_is_redirect = 0)/fjwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from fjwiki_p.site_stats, fjwiki_p.sites
where fjwiki_p.sites.site_global_key = "fjwiki";


select fowiki_p.sites.site_global_key, fowiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM fowiki_p.revision
                    INNER JOIN fowiki_p.page ON fowiki_p.revision.rev_page = fowiki_p.page.page_id
                    WHERE fowiki_p.page.page_namespace = 0
                        AND fowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND fowiki_p.revision.rev_parent_id = 0
                        AND fowiki_p.page.page_is_redirect = 0)/fowiki_p.site_stats.ss_good_articles*100) as "النسبة"
from fowiki_p.site_stats, fowiki_p.sites
where fowiki_p.sites.site_global_key = "fowiki";


select frwiki_p.sites.site_global_key, frwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM frwiki_p.revision
                    INNER JOIN frwiki_p.page ON frwiki_p.revision.rev_page = frwiki_p.page.page_id
                    WHERE frwiki_p.page.page_namespace = 0
                        AND frwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND frwiki_p.revision.rev_parent_id = 0
                        AND frwiki_p.page.page_is_redirect = 0)/frwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from frwiki_p.site_stats, frwiki_p.sites
where frwiki_p.sites.site_global_key = "frwiki";


select frpwiki_p.sites.site_global_key, frpwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM frpwiki_p.revision
                    INNER JOIN frpwiki_p.page ON frpwiki_p.revision.rev_page = frpwiki_p.page.page_id
                    WHERE frpwiki_p.page.page_namespace = 0
                        AND frpwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND frpwiki_p.revision.rev_parent_id = 0
                        AND frpwiki_p.page.page_is_redirect = 0)/frpwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from frpwiki_p.site_stats, frpwiki_p.sites
where frpwiki_p.sites.site_global_key = "frpwiki";


select frrwiki_p.sites.site_global_key, frrwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM frrwiki_p.revision
                    INNER JOIN frrwiki_p.page ON frrwiki_p.revision.rev_page = frrwiki_p.page.page_id
                    WHERE frrwiki_p.page.page_namespace = 0
                        AND frrwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND frrwiki_p.revision.rev_parent_id = 0
                        AND frrwiki_p.page.page_is_redirect = 0)/frrwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from frrwiki_p.site_stats, frrwiki_p.sites
where frrwiki_p.sites.site_global_key = "frrwiki";


select furwiki_p.sites.site_global_key, furwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM furwiki_p.revision
                    INNER JOIN furwiki_p.page ON furwiki_p.revision.rev_page = furwiki_p.page.page_id
                    WHERE furwiki_p.page.page_namespace = 0
                        AND furwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND furwiki_p.revision.rev_parent_id = 0
                        AND furwiki_p.page.page_is_redirect = 0)/furwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from furwiki_p.site_stats, furwiki_p.sites
where furwiki_p.sites.site_global_key = "furwiki";


select fywiki_p.sites.site_global_key, fywiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM fywiki_p.revision
                    INNER JOIN fywiki_p.page ON fywiki_p.revision.rev_page = fywiki_p.page.page_id
                    WHERE fywiki_p.page.page_namespace = 0
                        AND fywiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND fywiki_p.revision.rev_parent_id = 0
                        AND fywiki_p.page.page_is_redirect = 0)/fywiki_p.site_stats.ss_good_articles*100) as "النسبة"
from fywiki_p.site_stats, fywiki_p.sites
where fywiki_p.sites.site_global_key = "fywiki";


select gawiki_p.sites.site_global_key, gawiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM gawiki_p.revision
                    INNER JOIN gawiki_p.page ON gawiki_p.revision.rev_page = gawiki_p.page.page_id
                    WHERE gawiki_p.page.page_namespace = 0
                        AND gawiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND gawiki_p.revision.rev_parent_id = 0
                        AND gawiki_p.page.page_is_redirect = 0)/gawiki_p.site_stats.ss_good_articles*100) as "النسبة"
from gawiki_p.site_stats, gawiki_p.sites
where gawiki_p.sites.site_global_key = "gawiki";


select gagwiki_p.sites.site_global_key, gagwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM gagwiki_p.revision
                    INNER JOIN gagwiki_p.page ON gagwiki_p.revision.rev_page = gagwiki_p.page.page_id
                    WHERE gagwiki_p.page.page_namespace = 0
                        AND gagwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND gagwiki_p.revision.rev_parent_id = 0
                        AND gagwiki_p.page.page_is_redirect = 0)/gagwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from gagwiki_p.site_stats, gagwiki_p.sites
where gagwiki_p.sites.site_global_key = "gagwiki";


select ganwiki_p.sites.site_global_key, ganwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM ganwiki_p.revision
                    INNER JOIN ganwiki_p.page ON ganwiki_p.revision.rev_page = ganwiki_p.page.page_id
                    WHERE ganwiki_p.page.page_namespace = 0
                        AND ganwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND ganwiki_p.revision.rev_parent_id = 0
                        AND ganwiki_p.page.page_is_redirect = 0)/ganwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from ganwiki_p.site_stats, ganwiki_p.sites
where ganwiki_p.sites.site_global_key = "ganwiki";


select gdwiki_p.sites.site_global_key, gdwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM gdwiki_p.revision
                    INNER JOIN gdwiki_p.page ON gdwiki_p.revision.rev_page = gdwiki_p.page.page_id
                    WHERE gdwiki_p.page.page_namespace = 0
                        AND gdwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND gdwiki_p.revision.rev_parent_id = 0
                        AND gdwiki_p.page.page_is_redirect = 0)/gdwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from gdwiki_p.site_stats, gdwiki_p.sites
where gdwiki_p.sites.site_global_key = "gdwiki";


select glwiki_p.sites.site_global_key, glwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM glwiki_p.revision
                    INNER JOIN glwiki_p.page ON glwiki_p.revision.rev_page = glwiki_p.page.page_id
                    WHERE glwiki_p.page.page_namespace = 0
                        AND glwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND glwiki_p.revision.rev_parent_id = 0
                        AND glwiki_p.page.page_is_redirect = 0)/glwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from glwiki_p.site_stats, glwiki_p.sites
where glwiki_p.sites.site_global_key = "glwiki";


select glkwiki_p.sites.site_global_key, glkwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM glkwiki_p.revision
                    INNER JOIN glkwiki_p.page ON glkwiki_p.revision.rev_page = glkwiki_p.page.page_id
                    WHERE glkwiki_p.page.page_namespace = 0
                        AND glkwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND glkwiki_p.revision.rev_parent_id = 0
                        AND glkwiki_p.page.page_is_redirect = 0)/glkwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from glkwiki_p.site_stats, glkwiki_p.sites
where glkwiki_p.sites.site_global_key = "glkwiki";


select gnwiki_p.sites.site_global_key, gnwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM gnwiki_p.revision
                    INNER JOIN gnwiki_p.page ON gnwiki_p.revision.rev_page = gnwiki_p.page.page_id
                    WHERE gnwiki_p.page.page_namespace = 0
                        AND gnwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND gnwiki_p.revision.rev_parent_id = 0
                        AND gnwiki_p.page.page_is_redirect = 0)/gnwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from gnwiki_p.site_stats, gnwiki_p.sites
where gnwiki_p.sites.site_global_key = "gnwiki";


select gotwiki_p.sites.site_global_key, gotwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM gotwiki_p.revision
                    INNER JOIN gotwiki_p.page ON gotwiki_p.revision.rev_page = gotwiki_p.page.page_id
                    WHERE gotwiki_p.page.page_namespace = 0
                        AND gotwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND gotwiki_p.revision.rev_parent_id = 0
                        AND gotwiki_p.page.page_is_redirect = 0)/gotwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from gotwiki_p.site_stats, gotwiki_p.sites
where gotwiki_p.sites.site_global_key = "gotwiki";


select guwiki_p.sites.site_global_key, guwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM guwiki_p.revision
                    INNER JOIN guwiki_p.page ON guwiki_p.revision.rev_page = guwiki_p.page.page_id
                    WHERE guwiki_p.page.page_namespace = 0
                        AND guwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND guwiki_p.revision.rev_parent_id = 0
                        AND guwiki_p.page.page_is_redirect = 0)/guwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from guwiki_p.site_stats, guwiki_p.sites
where guwiki_p.sites.site_global_key = "guwiki";


select gvwiki_p.sites.site_global_key, gvwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM gvwiki_p.revision
                    INNER JOIN gvwiki_p.page ON gvwiki_p.revision.rev_page = gvwiki_p.page.page_id
                    WHERE gvwiki_p.page.page_namespace = 0
                        AND gvwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND gvwiki_p.revision.rev_parent_id = 0
                        AND gvwiki_p.page.page_is_redirect = 0)/gvwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from gvwiki_p.site_stats, gvwiki_p.sites
where gvwiki_p.sites.site_global_key = "gvwiki";


select hawiki_p.sites.site_global_key, hawiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM hawiki_p.revision
                    INNER JOIN hawiki_p.page ON hawiki_p.revision.rev_page = hawiki_p.page.page_id
                    WHERE hawiki_p.page.page_namespace = 0
                        AND hawiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND hawiki_p.revision.rev_parent_id = 0
                        AND hawiki_p.page.page_is_redirect = 0)/hawiki_p.site_stats.ss_good_articles*100) as "النسبة"
from hawiki_p.site_stats, hawiki_p.sites
where hawiki_p.sites.site_global_key = "hawiki";


select hakwiki_p.sites.site_global_key, hakwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM hakwiki_p.revision
                    INNER JOIN hakwiki_p.page ON hakwiki_p.revision.rev_page = hakwiki_p.page.page_id
                    WHERE hakwiki_p.page.page_namespace = 0
                        AND hakwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND hakwiki_p.revision.rev_parent_id = 0
                        AND hakwiki_p.page.page_is_redirect = 0)/hakwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from hakwiki_p.site_stats, hakwiki_p.sites
where hakwiki_p.sites.site_global_key = "hakwiki";


select hawwiki_p.sites.site_global_key, hawwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM hawwiki_p.revision
                    INNER JOIN hawwiki_p.page ON hawwiki_p.revision.rev_page = hawwiki_p.page.page_id
                    WHERE hawwiki_p.page.page_namespace = 0
                        AND hawwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND hawwiki_p.revision.rev_parent_id = 0
                        AND hawwiki_p.page.page_is_redirect = 0)/hawwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from hawwiki_p.site_stats, hawwiki_p.sites
where hawwiki_p.sites.site_global_key = "hawwiki";


select hewiki_p.sites.site_global_key, hewiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM hewiki_p.revision
                    INNER JOIN hewiki_p.page ON hewiki_p.revision.rev_page = hewiki_p.page.page_id
                    WHERE hewiki_p.page.page_namespace = 0
                        AND hewiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND hewiki_p.revision.rev_parent_id = 0
                        AND hewiki_p.page.page_is_redirect = 0)/hewiki_p.site_stats.ss_good_articles*100) as "النسبة"
from hewiki_p.site_stats, hewiki_p.sites
where hewiki_p.sites.site_global_key = "hewiki";


select hiwiki_p.sites.site_global_key, hiwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM hiwiki_p.revision
                    INNER JOIN hiwiki_p.page ON hiwiki_p.revision.rev_page = hiwiki_p.page.page_id
                    WHERE hiwiki_p.page.page_namespace = 0
                        AND hiwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND hiwiki_p.revision.rev_parent_id = 0
                        AND hiwiki_p.page.page_is_redirect = 0)/hiwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from hiwiki_p.site_stats, hiwiki_p.sites
where hiwiki_p.sites.site_global_key = "hiwiki";


select hifwiki_p.sites.site_global_key, hifwiki_p.site_stats.ss_good_articles, ((SELECT count(*)
                    FROM hifwiki_p.revision
                    INNER JOIN hifwiki_p.page ON hifwiki_p.revision.rev_page = hifwiki_p.page.page_id
                    WHERE hifwiki_p.page.page_namespace = 0
                        AND hifwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci
                        AND hifwiki_p.revision.rev_parent_id = 0
                        AND hifwiki_p.page.page_is_redirect = 0)/hifwiki_p.site_stats.ss_good_articles*100) as "النسبة"
from hifwiki_p.site_stats, hifwiki_p.sites
where hifwiki_p.sites.site_global_key = "hifwiki";


select howiki_p.sites.site_global_key, howiki_p.site_stats.ss_good_articles, ((SELECT count(*)
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...
