metacat/src/package-count.sql @ 7118
1 | 2283 | jones | column doctype format a50; |
---|---|---|---|
2 | SELECT doctype, count(*) cnt |
||
3 | FROM xml_documents |
||
4 | WHERE doctype IN ( |
||
5 | 'eml://ecoinformatics.org/eml-2.0.1', |
||
6 | '-//ecoinformatics.org//eml-dataset-2.0.0beta4//EN', |
||
7 | '-//ecoinformatics.org//eml-dataset-2.0.0beta6//EN', |
||
8 | 'eml://ecoinformatics.org/eml-2.0.0'
|
||
9 | )
|
||
10 | GROUP BY doctype |
||
11 | ORDER BY cnt DESC |
||
12 | /
|