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 (select site_global_key from arwiki_p.sites where site_global_key = "arwiki") as "اسم الويكي", site_stats.ss_total_edits as "مجموع التعديلات", site_stats.ss_good_articles as "المقالات الجيدة", site_stats.ss_total_pages as "عدد الصفحات", site_stats.ss_users as "عدد المستخدمين", site_stats.ss_active_users as "عدد المستخدمين النشطين", site_stats.ss_images as "عدد الصور", (select count(*) from arwiki_p.user_groups where ug_group = "sysop") as "عدد الإداريين", (select count(*) from arwiki_p.user_groups where ug_group = "bot") as "عدد البوتات", site_stats.ss_good_articles/ site_stats.ss_total_pages as "نسبة البذور" FROM arwiki_p.site_stats UNION SELECT (select site_global_key from arwikibooks_p.sites where site_global_key = "arwikibooks") as "اسم الويكي", site_stats.ss_total_edits as "مجموع التعديلات", site_stats.ss_good_articles as "المقالات الجيدة", site_stats.ss_total_pages as "عدد الصفحات", site_stats.ss_users as "عدد المستخدمين", site_stats.ss_active_users as "عدد المستخدمين النشطين", site_stats.ss_images as "عدد الصور", (select count(*) from arwikibooks_p.user_groups where ug_group = "sysop") as "عدد الإداريين", (select count(*) from arwikibooks_p.user_groups where ug_group = "bot") as "عدد البوتات", site_stats.ss_good_articles/ site_stats.ss_total_pages as "نسبة البذور" FROM arwikibooks_p.site_stats;
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...