metacat/src/package-count.sql @ 5553
1 |
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 |
/
|