Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
ASammour
.
Toggle Highlighting
SQL
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 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 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 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 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 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 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 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 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 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 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 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 itwiki_p.sites.site_global_key, itwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM itwiki_p.revision INNER JOIN itwiki_p.page ON itwiki_p.revision.rev_page = itwiki_p.page.page_id WHERE itwiki_p.page.page_namespace = 0 AND itwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND itwiki_p.revision.rev_parent_id = 0 AND itwiki_p.page.page_is_redirect = 0)/itwiki_p.site_stats.ss_good_articles*100) as "النسبة" from itwiki_p.site_stats, itwiki_p.sites where itwiki_p.sites.site_global_key = "itwiki"; select jawiki_p.sites.site_global_key, jawiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM jawiki_p.revision INNER JOIN jawiki_p.page ON jawiki_p.revision.rev_page = jawiki_p.page.page_id WHERE jawiki_p.page.page_namespace = 0 AND jawiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND jawiki_p.revision.rev_parent_id = 0 AND jawiki_p.page.page_is_redirect = 0)/jawiki_p.site_stats.ss_good_articles*100) as "النسبة" from jawiki_p.site_stats, jawiki_p.sites where jawiki_p.sites.site_global_key = "jawiki"; select kowiki_p.sites.site_global_key, kowiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM kowiki_p.revision INNER JOIN kowiki_p.page ON kowiki_p.revision.rev_page = kowiki_p.page.page_id WHERE kowiki_p.page.page_namespace = 0 AND kowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND kowiki_p.revision.rev_parent_id = 0 AND kowiki_p.page.page_is_redirect = 0)/kowiki_p.site_stats.ss_good_articles*100) as "النسبة" from kowiki_p.site_stats, kowiki_p.sites where kowiki_p.sites.site_global_key = "kowiki"; select ltwiki_p.sites.site_global_key, ltwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM ltwiki_p.revision INNER JOIN ltwiki_p.page ON ltwiki_p.revision.rev_page = ltwiki_p.page.page_id WHERE ltwiki_p.page.page_namespace = 0 AND ltwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND ltwiki_p.revision.rev_parent_id = 0 AND ltwiki_p.page.page_is_redirect = 0)/ltwiki_p.site_stats.ss_good_articles*100) as "النسبة" from ltwiki_p.site_stats, ltwiki_p.sites where ltwiki_p.sites.site_global_key = "ltwiki"; select lvwiki_p.sites.site_global_key, lvwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM lvwiki_p.revision INNER JOIN lvwiki_p.page ON lvwiki_p.revision.rev_page = lvwiki_p.page.page_id WHERE lvwiki_p.page.page_namespace = 0 AND lvwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND lvwiki_p.revision.rev_parent_id = 0 AND lvwiki_p.page.page_is_redirect = 0)/lvwiki_p.site_stats.ss_good_articles*100) as "النسبة" from lvwiki_p.site_stats, lvwiki_p.sites where lvwiki_p.sites.site_global_key = "lvwiki"; select plwiki_p.sites.site_global_key, plwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM plwiki_p.revision INNER JOIN plwiki_p.page ON plwiki_p.revision.rev_page = plwiki_p.page.page_id WHERE plwiki_p.page.page_namespace = 0 AND plwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND plwiki_p.revision.rev_parent_id = 0 AND plwiki_p.page.page_is_redirect = 0)/plwiki_p.site_stats.ss_good_articles*100) as "النسبة" from plwiki_p.site_stats, plwiki_p.sites where plwiki_p.sites.site_global_key = "plwiki"; select rmywiki_p.sites.site_global_key, rmywiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM rmywiki_p.revision INNER JOIN rmywiki_p.page ON rmywiki_p.revision.rev_page = rmywiki_p.page.page_id WHERE rmywiki_p.page.page_namespace = 0 AND rmywiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND rmywiki_p.revision.rev_parent_id = 0 AND rmywiki_p.page.page_is_redirect = 0)/rmywiki_p.site_stats.ss_good_articles*100) as "النسبة" from rmywiki_p.site_stats, rmywiki_p.sites where rmywiki_p.sites.site_global_key = "rmywiki"; select rowiki_p.sites.site_global_key, rowiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM rowiki_p.revision INNER JOIN rowiki_p.page ON rowiki_p.revision.rev_page = rowiki_p.page.page_id WHERE rowiki_p.page.page_namespace = 0 AND rowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND rowiki_p.revision.rev_parent_id = 0 AND rowiki_p.page.page_is_redirect = 0)/rowiki_p.site_stats.ss_good_articles*100) as "النسبة" from rowiki_p.site_stats, rowiki_p.sites where rowiki_p.sites.site_global_key = "rowiki"; select ruwiki_p.sites.site_global_key, ruwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM ruwiki_p.revision INNER JOIN ruwiki_p.page ON ruwiki_p.revision.rev_page = ruwiki_p.page.page_id WHERE ruwiki_p.page.page_namespace = 0 AND ruwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND ruwiki_p.revision.rev_parent_id = 0 AND ruwiki_p.page.page_is_redirect = 0)/ruwiki_p.site_stats.ss_good_articles*100) as "النسبة" from ruwiki_p.site_stats, ruwiki_p.sites where ruwiki_p.sites.site_global_key = "ruwiki"; select simplewiki_p.sites.site_global_key, simplewiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM simplewiki_p.revision INNER JOIN simplewiki_p.page ON simplewiki_p.revision.rev_page = simplewiki_p.page.page_id WHERE simplewiki_p.page.page_namespace = 0 AND simplewiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND simplewiki_p.revision.rev_parent_id = 0 AND simplewiki_p.page.page_is_redirect = 0)/simplewiki_p.site_stats.ss_good_articles*100) as "النسبة" from simplewiki_p.site_stats, simplewiki_p.sites where simplewiki_p.sites.site_global_key = "simplewiki"; select svwiki_p.sites.site_global_key, svwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM svwiki_p.revision INNER JOIN svwiki_p.page ON svwiki_p.revision.rev_page = svwiki_p.page.page_id WHERE svwiki_p.page.page_namespace = 0 AND svwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND svwiki_p.revision.rev_parent_id = 0 AND svwiki_p.page.page_is_redirect = 0)/svwiki_p.site_stats.ss_good_articles*100) as "النسبة" from svwiki_p.site_stats, svwiki_p.sites where svwiki_p.sites.site_global_key = "svwiki"; select tlwiki_p.sites.site_global_key, tlwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM tlwiki_p.revision INNER JOIN tlwiki_p.page ON tlwiki_p.revision.rev_page = tlwiki_p.page.page_id WHERE tlwiki_p.page.page_namespace = 0 AND tlwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND tlwiki_p.revision.rev_parent_id = 0 AND tlwiki_p.page.page_is_redirect = 0)/tlwiki_p.site_stats.ss_good_articles*100) as "النسبة" from tlwiki_p.site_stats, tlwiki_p.sites where tlwiki_p.sites.site_global_key = "tlwiki"; select trwiki_p.sites.site_global_key, trwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM trwiki_p.revision INNER JOIN trwiki_p.page ON trwiki_p.revision.rev_page = trwiki_p.page.page_id WHERE trwiki_p.page.page_namespace = 0 AND trwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND trwiki_p.revision.rev_parent_id = 0 AND trwiki_p.page.page_is_redirect = 0)/trwiki_p.site_stats.ss_good_articles*100) as "النسبة" from trwiki_p.site_stats, trwiki_p.sites where trwiki_p.sites.site_global_key = "trwiki"; select ukwiki_p.sites.site_global_key, ukwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM ukwiki_p.revision INNER JOIN ukwiki_p.page ON ukwiki_p.revision.rev_page = ukwiki_p.page.page_id WHERE ukwiki_p.page.page_namespace = 0 AND ukwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND ukwiki_p.revision.rev_parent_id = 0 AND ukwiki_p.page.page_is_redirect = 0)/ukwiki_p.site_stats.ss_good_articles*100) as "النسبة" from ukwiki_p.site_stats, ukwiki_p.sites where ukwiki_p.sites.site_global_key = "ukwiki"; select urwiki_p.sites.site_global_key, urwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM urwiki_p.revision INNER JOIN urwiki_p.page ON urwiki_p.revision.rev_page = urwiki_p.page.page_id WHERE urwiki_p.page.page_namespace = 0 AND urwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND urwiki_p.revision.rev_parent_id = 0 AND urwiki_p.page.page_is_redirect = 0)/urwiki_p.site_stats.ss_good_articles*100) as "النسبة" from urwiki_p.site_stats, urwiki_p.sites where urwiki_p.sites.site_global_key = "urwiki"; select yiwiki_p.sites.site_global_key, yiwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM yiwiki_p.revision INNER JOIN yiwiki_p.page ON yiwiki_p.revision.rev_page = yiwiki_p.page.page_id WHERE yiwiki_p.page.page_namespace = 0 AND yiwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND yiwiki_p.revision.rev_parent_id = 0 AND yiwiki_p.page.page_is_redirect = 0)/yiwiki_p.site_stats.ss_good_articles*100) as "النسبة" from yiwiki_p.site_stats, yiwiki_p.sites where yiwiki_p.sites.site_global_key = "yiwiki"; select yowiki_p.sites.site_global_key, yowiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM yowiki_p.revision INNER JOIN yowiki_p.page ON yowiki_p.revision.rev_page = yowiki_p.page.page_id WHERE yowiki_p.page.page_namespace = 0 AND yowiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND yowiki_p.revision.rev_parent_id = 0 AND yowiki_p.page.page_is_redirect = 0)/yowiki_p.site_stats.ss_good_articles*100) as "النسبة" from yowiki_p.site_stats, yowiki_p.sites where yowiki_p.sites.site_global_key = "yowiki"; select zawiki_p.sites.site_global_key, zawiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM zawiki_p.revision INNER JOIN zawiki_p.page ON zawiki_p.revision.rev_page = zawiki_p.page.page_id WHERE zawiki_p.page.page_namespace = 0 AND zawiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND zawiki_p.revision.rev_parent_id = 0 AND zawiki_p.page.page_is_redirect = 0)/zawiki_p.site_stats.ss_good_articles*100) as "النسبة" from zawiki_p.site_stats, zawiki_p.sites where zawiki_p.sites.site_global_key = "zawiki"; select zhwiki_p.sites.site_global_key, zhwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM zhwiki_p.revision INNER JOIN zhwiki_p.page ON zhwiki_p.revision.rev_page = zhwiki_p.page.page_id WHERE zhwiki_p.page.page_namespace = 0 AND zhwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND zhwiki_p.revision.rev_parent_id = 0 AND zhwiki_p.page.page_is_redirect = 0)/zhwiki_p.site_stats.ss_good_articles*100) as "النسبة" from zhwiki_p.site_stats, zhwiki_p.sites where zhwiki_p.sites.site_global_key = "zhwiki"; select zuwiki_p.sites.site_global_key, zuwiki_p.site_stats.ss_good_articles, ((SELECT count(*) FROM zuwiki_p.revision INNER JOIN zuwiki_p.page ON zuwiki_p.revision.rev_page = zuwiki_p.page.page_id WHERE zuwiki_p.page.page_namespace = 0 AND zuwiki_p.revision.rev_user_text like ucase ("%BOT") collate utf8_general_ci AND zuwiki_p.revision.rev_parent_id = 0 AND zuwiki_p.page.page_is_redirect = 0)/zuwiki_p.site_stats.ss_good_articles*100) as "النسبة" from zuwiki_p.site_stats, zuwiki_p.sites where zuwiki_p.sites.site_global_key = "zuwiki";
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
.
Checking query status...