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

SQL

AخA
 
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 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;
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
All SQL code is licensed under CC0 License.

Checking query status...