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

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;
SQL

Checking query status...
