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