Difference between revisions of "Workdocumentation 2022-08-15"
Jump to navigation
Jump to search
(→Agenda) |
|||
| Line 9: | Line 9: | ||
= Queries = | = Queries = | ||
| + | == Colocation == | ||
| + | <source lang='bash'> | ||
| + | SELECT count(colocated) | ||
| + | FROM "volumes" | ||
| + | where colocated is not null | ||
| + | </source> | ||
| + | 1326 | ||
| + | |||
== Top Submitters == | == Top Submitters == | ||
sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki | sqlquery -en ceurws -qp ceurws.yaml -qn SubmittedByGt6 -f mediawiki | ||
Revision as of 10:11, 15 August 2022
Participants
Agenda
- CEUR-WS Volume Browser
- 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