Difference between revisions of "Workdocumentation 2022-08-15"
Jump to navigation
Jump to search
(→Agenda) |
|||
Line 3: | Line 3: | ||
= Agenda = | = Agenda = | ||
* CEUR-WS Volume Browser | * CEUR-WS Volume Browser | ||
+ | * Parser | ||
* Queries | * Queries | ||
Revision as of 09:12, 15 August 2022
Participants
Agenda
- CEUR-WS Volume Browser
- Parser
- Queries
CEUR-WS Volume Browser
Queries
Colocation
SELECT count(colocated)
FROM "volumes"
where colocated is not null
1326
Top Submitters
sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki
SubmittedByGt6ForWiki
query
SELECT count(*) as count,"{{Link|target="||submittedBy||"}}"
FROM "volumes"
GROUP BY submittedBY
HAVING COUNT(*) > 6
ORDER BY 1 DESC