# HG changeset patch
# User Matthew Wild <mwild1@gmail.com>
# Date 1679310488 0
# Node ID 444a46eadb7444bef4589113985bb55ac357503a
# Parent  07136e6644cca02aa076dee97ec5aab565be3b03
Add canned query 'implementation_counts'

diff -r 07136e6644cc -r 444a46eadb74 metadata.yml
--- 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"