Mercurial > xmpp-ecosystem-data / changeset

--- a/metadata.yml	Mon Mar 13 18:27:00 2023 +0000
+++ b/metadata.yml	Mon Mar 20 11:08:08 2023 +0000
@@ -37,6 +37,26 @@
             join software on implementations.software_id == software.id
           where
             xep_version != xeps.version
+      implementation_counts:
+        title: "XEPs: Ranked by implementation count"
+        description: "XEPs ranked by the number of known implementations"
+        sql: |-
+          select
+            xeps.number,
+            xeps.title,
+            (
+              select
+                count(*)
+              from
+                implementations
+              where
+                implementations.xep_id == xeps.id
+            ) as implementation_count
+          from
+            xeps
+          order by
+            implementation_count desc,
+            xeps.number asc
       unusual_compliance:
         title: "XEPs: Unusual compliance requirements"
         description: "Find XEPs in undesired states that are required by current compliance suites"