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