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 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
UNION
SELECT (select site_global_key from arwikinews_p.sites where site_global_key = "arwikinews") 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 arwikinews_p.user_groups where ug_group = "sysop") as "عدد الإداريين",
(select count(*) from arwikinews_p.user_groups where ug_group = "bot") as "عدد البوتات",
site_stats.ss_good_articles/ site_stats.ss_total_pages as "نسبة البذور"
FROM arwikinews_p.site_stats
UNION
SELECT (select site_global_key from arwikisource_p.sites where site_global_key = "arwikisource") 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 arwikisource_p.user_groups where ug_group = "sysop") as "عدد الإداريين",
(select count(*) from arwikisource_p.user_groups where ug_group = "bot") as "عدد البوتات",
site_stats.ss_good_articles/ site_stats.ss_total_pages as "نسبة البذور"
FROM arwikisource_p.site_stats
UNION
SELECT (select site_global_key from arwikiquote_p.sites where site_global_key = "arwikiquote") 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 arwikiquote_p.user_groups where ug_group = "sysop") as "عدد الإداريين",
(select count(*) from arwikiquote_p.user_groups where ug_group = "bot") as "عدد البوتات",
site_stats.ss_good_articles/ site_stats.ss_total_pages as "نسبة البذور"
FROM arwikiquote_p.site_stats
UNION
SELECT (select site_global_key from arwiktionary_p.sites where site_global_key = "arwiktionary") 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 arwiktionary_p.user_groups where ug_group = "sysop") as "عدد الإداريين",
(select count(*) from arwiktionary_p.user_groups where ug_group = "bot") as "عدد البوتات",
site_stats.ss_good_articles/ site_stats.ss_total_pages as "نسبة البذور"
FROM arwiktionary_p.site_stats
UNION
SELECT (select site_global_key from arwikiversity_p.sites where site_global_key = "arwikiversity") 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 arwikiversity_p.user_groups where ug_group = "sysop") as "عدد الإداريين",
(select count(*) from arwikiversity_p.user_groups where ug_group = "bot") as "عدد البوتات",
site_stats.ss_good_articles/ site_stats.ss_total_pages as "نسبة البذور"
FROM arwikiversity_p.site_stats
UNION
SELECT (select site_global_key from arwikimedia_p.sites where site_global_key = "arwikimedia") 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 arwikimedia_p.user_groups where ug_group = "sysop") as "عدد الإداريين",
(select count(*) from arwikimedia_p.user_groups where ug_group = "bot") as "عدد البوتات",
site_stats.ss_good_articles/ site_stats.ss_total_pages as "نسبة البذور"
FROM arwikimedia_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.
All SQL code is licensed under CC0 License.