إحصاءات المشاريع العربية مجتمعة ويكي، اقتباس، مصدر، أخبار، كتب، ويكاموس، الجامعة

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

SELECT (select concat ("[ar.wikipedia.org",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.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
