Modelling/Events and activities/Conferences: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 5: | Line 5: | ||
PREFIX wb: <https://metabase.wikibase.cloud/entity/> | PREFIX wb: <https://metabase.wikibase.cloud/entity/> | ||
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/> | ||
SELECT ?item ?itemLabel ?when ?wikipage (GROUP_CONCAT(DISTINCT ?personLabel; SEPARATOR = ", ") AS ?persons) (GROUP_CONCAT(DISTINCT ?mainsubjectLabel; SEPARATOR = ", ") AS ?topics) | SELECT ?item ?itemLabel (GROUP_CONCAT(DISTINCT ?typeLabel; SEPARATOR = ", ") AS ?types) ?when ?wikipage (GROUP_CONCAT(DISTINCT ?personLabel; SEPARATOR = ", ") AS ?persons) (GROUP_CONCAT(DISTINCT ?mainsubjectLabel; SEPARATOR = ", ") AS ?topics) | ||
WHERE | WHERE | ||
{ | { | ||
?item wbt:P17 wb:Q22660. | ?item wbt:P17 wb:Q22660. | ||
?item wbt:P5 ?type. | |||
OPTIONAL {?item wbt:P23 ?when} | OPTIONAL {?item wbt:P23 ?when} | ||
OPTIONAL {?item wbt:P32 ?person} # leader, eg in a workshop | OPTIONAL {?item wbt:P32 ?person} # leader, eg in a workshop | ||
Line 20: | Line 21: | ||
?person rdfs:label ?personLabel. | ?person rdfs:label ?personLabel. | ||
?mainsubject rdfs:label ?mainsubjectLabel. | ?mainsubject rdfs:label ?mainsubjectLabel. | ||
?type rdfs:label ?typeLabel. | |||
} | } | ||
} | } | ||
GROUP BY ?item ?itemLabel ?when ?wikipage | GROUP BY ?item ?itemLabel ?types ?when ?wikipage | ||
ORDER BY ? | ORDER BY ?itemLabel | ||
</SPARQL> | </SPARQL> | ||
[[Category:Documentation|C]] | [[Category:Documentation|C]] |
Revision as of 07:17, 19 April 2024
Modeling a conference
SPARQL
PREFIX wb: <https://metabase.wikibase.cloud/entity/>
PREFIX wbt: <https://metabase.wikibase.cloud/prop/direct/>
SELECT ?item ?itemLabel (GROUP_CONCAT(DISTINCT ?typeLabel; SEPARATOR = ", ") AS ?types) ?when ?wikipage (GROUP_CONCAT(DISTINCT ?personLabel; SEPARATOR = ", ") AS ?persons) (GROUP_CONCAT(DISTINCT ?mainsubjectLabel; SEPARATOR = ", ") AS ?topics)
WHERE
{
?item wbt:P17 wb:Q22660.
?item wbt:P5 ?type.
OPTIONAL {?item wbt:P23 ?when}
OPTIONAL {?item wbt:P32 ?person} # leader, eg in a workshop
OPTIONAL {?item wbt:P33 ?person} # speaker, eg in a presentation
OPTIONAL {?item wbt:P19 ?person} # author, eg of a video
OPTIONAL {?item wbt:P11 ?wikipage}
OPTIONAL {?item wbt:P15 ?mainsubject}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "en,sv,es".
?item rdfs:label ?itemLabel.
?person rdfs:label ?personLabel.
?mainsubject rdfs:label ?mainsubjectLabel.
?type rdfs:label ?typeLabel.
}
}
GROUP BY ?item ?itemLabel ?types ?when ?wikipage
ORDER BY ?itemLabel