Mon, 20 Mar 2023 11:08:08 +0000
Add canned query 'implementation_counts'
metadata.yml | file | annotate | diff | comparison | revisions |
--- 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"