Mercurial > xmpp-ecosystem-data / file comparison
comparison: metadata.yml
metadata.yml
- changeset 4
- 444a46eadb74
- parent 3
- 07136e6644cc
- child 6
- 266242703b38
equal
deleted
inserted
replaced
| 3:07136e6644cc | 4:444a46eadb74 |
|---|---|
| 35 implementations | 35 implementations |
| 36 join xeps on implementations.xep_id == xeps.id | 36 join xeps on implementations.xep_id == xeps.id |
| 37 join software on implementations.software_id == software.id | 37 join software on implementations.software_id == software.id |
| 38 where | 38 where |
| 39 xep_version != xeps.version | 39 xep_version != xeps.version |
| 40 implementation_counts: | |
| 41 title: "XEPs: Ranked by implementation count" | |
| 42 description: "XEPs ranked by the number of known implementations" | |
| 43 sql: |- | |
| 44 select | |
| 45 xeps.number, | |
| 46 xeps.title, | |
| 47 ( | |
| 48 select | |
| 49 count(*) | |
| 50 from | |
| 51 implementations | |
| 52 where | |
| 53 implementations.xep_id == xeps.id | |
| 54 ) as implementation_count | |
| 55 from | |
| 56 xeps | |
| 57 order by | |
| 58 implementation_count desc, | |
| 59 xeps.number asc | |
| 40 unusual_compliance: | 60 unusual_compliance: |
| 41 title: "XEPs: Unusual compliance requirements" | 61 title: "XEPs: Unusual compliance requirements" |
| 42 description: "Find XEPs in undesired states that are required by current compliance suites" | 62 description: "Find XEPs in undesired states that are required by current compliance suites" |
| 43 sql: |- | 63 sql: |- |
| 44 select | 64 select |
