query-fabd9ecc71e64f520dbc8a41536d9bed

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

SELECT (SAMPLE(?matchNR) AS ?matchNR) ?match ?matchLabel (SAMPLE(?pit) AS ?day) (CONCAT(?teamNameA," vs. ",?teamNameB) AS ?teams) (CONCAT(STR(SAMPLE(?scoreA)),":",STR(SAMPLE(?scoreB))) AS ?score) (SUBSTR(SAMPLE(?stage),16,100) AS ?stage) (SAMPLE(?winnerName) AS ?winner) ?refereeLabel WHERE {
  ?match wdt:P361 ?partof . ?partof rdfs:label ?stage . FILTER(lang(?stage) = "en")
  ?match p:P179 ?matchSeries . ?matchSeries v:P179 wd:Q189571 . ?matchSeries pq:P1545 ?matchNR .
  OPTIONAL{?match wdt:P585 ?pit}
  OPTIONAL{?match wdt:P1346 ?winner . ?winner wdt:P1532 ?wCountry . ?wCountry rdfs:label ?winnerName . FILTER(lang(?winnerName) = "en")}
  OPTIONAL{?match wdt:P1652 ?referee}
  OPTIONAL{
    ?match p:P1923 ?teamAStatement . ?teamAStatement v:P1923 ?teamA . ?teamAStatement pq:P794 wd:Q24633211 . OPTIONAL{?teamAStatement pq:P1351 ?scoreA} . ?teamA wdt:P1532 ?CountryA . ?CountryA rdfs:label ?teamNameA . FILTER(lang(?teamNameA) = "en") .
    ?match p:P1923 ?teamBStatement . ?teamBStatement v:P1923 ?teamB . ?teamBStatement pq:P794 wd:Q24633216 . OPTIONAL{?teamBStatement pq:P1351 ?scoreB} . ?teamB wdt:P1532 ?CountryB . ?CountryB rdfs:label ?teamNameB . FILTER(lang(?teamNameB) = "en") .
  }
  SERVICE wikibase:label{bd:serviceParam wikibase:language "en,de"}
}
GROUP BY ?match ?matchLabel ?teamNameA ?teamNameB ?referee ?refereeLabel
ORDER BY ASC(xsd:integer(?matchNR))

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v15("?CountryA") v18("?CountryB") v21("?day") v6("?match"):::projected v21("?matchNR"):::projected v8("?matchSeries") v7("?partof") v9("?pit"):::projected v12("?referee") v23("?score") v19("?scoreA") v20("?scoreB") v24("?stage") v14("?teamA") v13("?teamAStatement") v17("?teamB") v16("?teamBStatement") v2("?teamNameA"):::projected v3("?teamNameB"):::projected v22("?teams") v11("?wCountry") v24("?winner") v4("?winnerName"):::projected c15(["wd:Q24633211"]):::iri c21(["en,de"]):::literal c16(["wd:Q24633216"]):::iri c19(["bd:serviceParam"]):::iri c6(["wd:Q189571"]):::iri f0[["?stage = 'en'"]] f0 --> v24 v6 --"p:direct/P361"--> v7 v7 --"rdfs:label"--> v24 v6 --"p:P179"--> v8 v8 --"p:statement/P179"--> c6 v8 --"p:qualifier/P1545"--> v21 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P585".-> v9 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P1346".-> v24 v24 --"p:direct/P1532"--> v11 v11 --"rdfs:label"--> v4 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:direct/P1652".-> v12 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v6 -."p:P1923".-> v13 v13 --"p:statement/P1923"--> v14 v13 --"p:qualifier/P794"--> c15 v14 --"p:direct/P1532"--> v15 v15 --"rdfs:label"--> v2 v6 --"p:P1923"--> v16 v16 --"p:statement/P1923"--> v17 v16 --"p:qualifier/P794"--> c16 v17 --"p:direct/P1532"--> v18 v18 --"rdfs:label"--> v3 subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v13 -."p:qualifier/P1351".-> v19 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v16 -."p:qualifier/P1351".-> v20 end end subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c19 --"wikibase:language"--> c21 end bind7[/"sample(?matchNR)"/] v21 --o bind7 bind7 --as--o v21 bind8[/"sample(?pit)"/] v9 --o bind8 bind8 --as--o v21 bind9[/"concat(?teamNameA,' vs. ',?teamNameB)"/] v2 --o bind9 v3 --o bind9 bind9 --as--o v22 bind10[/"concat(str(),':',str())"/] null --o bind10 null --o bind10 bind10 --as--o v23 bind11[/"substring(,'16^^xsd:integer','100^^xsd:integer')"/] null --o bind11 bind11 --as--o v24 bind12[/"sample(?winnerName)"/] v4 --o bind12 bind12 --as--o v24