query-5145dd008ec296cf61f9c0b7553a3bb7

rq turtle/ttl

title:New Outdoor gyms videos produced in Sweden SELECT ?publishedDate ?language (SAMPLE(?title) AS ?title) ?youtube (SAMPLE(?item) AS ?WD) (SAMPLE(?OutdoorGym) AS ?OutdoorGym) ?nrviews (SAMPLE(?admin) AS ?admin) WHERE { ?item wdt:P6104 wd:Q107186275; wdt:P17 wd:Q34. OPTIONAL { ?item rdfs:label ?OutdoorGym. FILTER((LANG(?OutdoorGym)) = "en") } OPTIONAL { ?item wdt:P18 ?img. } OPTIONAL { ?item wdt:P131 ?adminId. ?adminId rdfs:label ?admin. FILTER((LANG(?admin)) = "en") } OPTIONAL { ?item wdt:P856 ?www. } {

{?item p:P1651 ?Pyoutubev.
?Pyoutubev ps:P1651 ?youtubev.
OPTIONAL { ?Pyoutubev pq:P1810 ?title. }
OPTIONAL { ?Pyoutubev pq:P407 ?languageid. 
             ?languageid rdfs:label ??language.
             FILTER((LANG(?language)) = "en")
}
OPTIONAL { ?Pyoutubev pq:P5436 ?nrviews. }
OPTIONAL { ?Pyoutubev pq:P577 ?publishedDate. }
}

} BIND(URI(CONCAT("https://www.youtube.com/watch?v=", ?youtubev)) AS ?youtube) OPTIONAL { ?item wdt:P625 ?coord. } } GROUP BY ?youtube ?nrviews ?publishedDate ?language ORDER BY DESC (?publishedDate)

Use at

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 ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
#title:New Outdoor gyms videos produced in Sweden
SELECT ?publishedDate ?language  (SAMPLE(?title) AS ?title) ?youtube (SAMPLE(?item) AS ?WD) (SAMPLE(?OutdoorGym) AS ?OutdoorGym) ?nrviews (SAMPLE(?admin) AS ?admin) WHERE {
  ?item wdt:P6104 wd:Q107186275;
    wdt:P17 wd:Q34.
  OPTIONAL {
    ?item rdfs:label ?OutdoorGym.
    FILTER((LANG(?OutdoorGym)) = "en")
  }
  OPTIONAL { ?item wdt:P18 ?img. }
  OPTIONAL {
    ?item wdt:P131 ?adminId.
    ?adminId rdfs:label ?admin.
    FILTER((LANG(?admin)) = "en")
  }
  OPTIONAL { ?item wdt:P856 ?www. }
  {

    {?item p:P1651 ?Pyoutubev.
    ?Pyoutubev ps:P1651 ?youtubev.
    OPTIONAL { ?Pyoutubev pq:P1810 ?title. }
    OPTIONAL { ?Pyoutubev pq:P407 ?languageid. 
                 ?languageid rdfs:label ??language.
                 FILTER((LANG(?language)) = "en")
    }
    OPTIONAL { ?Pyoutubev pq:P5436 ?nrviews. }
    OPTIONAL { ?Pyoutubev pq:P577 ?publishedDate. }
    }
  }
  BIND(URI(CONCAT("https://www.youtube.com/watch?v=", ?youtubev)) AS ?youtube)
  OPTIONAL { ?item wdt:P625 ?coord. }
}
GROUP BY ?youtube ?nrviews ?publishedDate ?language
ORDER BY DESC (?publishedDate)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v17("?OutdoorGym"):::projected v9("?Pyoutubev") v16("?WD") v17("?admin"):::projected v6("?adminId") v15("?coord") v5("?img") v4("?item"):::projected v8("?language"):::projected v12("?languageid") v13("?nrviews"):::projected v1("?publishedDate"):::projected v16("?title"):::projected v7("?www") v14("?youtube"):::projected v10("?youtubev") c5(["wd:Q34"]):::iri c3(["wd:Q107186275"]):::iri v4 --"p:direct/P6104"--> c3 v4 --"p:direct/P17"--> c5 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."rdfs:label".-> v17 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P18".-> v5 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P131".-> v6 v6 --"rdfs:label"--> v17 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P856".-> v7 end v4 --"p:P1651"--> v9 v9 --"p:statement/P1651"--> v10 subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v9 -."p:qualifier/P1810".-> v16 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v9 -."p:qualifier/P407".-> v12 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; v12 --"rdfs:label"--> v8 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; end union0r <== or ==> union0l end end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v9 -."p:qualifier/P5436".-> v13 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v9 -."p:qualifier/P577".-> v1 end bind0[/"concat('https://www.youtube.com/watch?v=',?youtubev)"/] v10 --o bind0 bind0 --as--o v14 subgraph optional8["(optional)"] style optional8 fill:#bbf,stroke-dasharray: 5 5; v4 -."p:direct/P625".-> v15 end bind5[/"sample(?title)"/] v16 --o bind5 bind5 --as--o v16 bind6[/"sample(?item)"/] v4 --o bind6 bind6 --as--o v16 bind7[/"sample(?OutdoorGym)"/] v17 --o bind7 bind7 --as--o v17 bind8[/"sample(?admin)"/] v17 --o bind8 bind8 --as--o v17