query-6ce72591c516e9b263723a1a9bdf2ade

rq turtle/ttl

Wikipedia research et al. select ?paper ?paper_label ?class_labels ?authors ?venueLabel ?topics ?date ?full_text where { { select ?paper ?paper_label (group_concat(distinct ?classes_label; separator=", ") as ?class_labels) (group_concat(distinct ?author_label; separator=", ") as ?authors) (sample(?published_ins) as ?venue) (group_concat(distinct ?topic_label; separator=", ") as ?topics) (min(?dates_of_publication) as ?date) (sample(?full_texts) as ?full_text) where { { ?paper wdt:P921 wd:Q52 } # Wikipedia union { ?paper wdt:P921 wd:Q195951 } # reliability union { ?paper wdt:P921 wd:Q870337 } # academic studies about Wikipedia union { ?paper wdt:P921 wd:Q23038345 } # Wikipedian union { ?paper wdt:P921 ?wiki . ?wiki wdt:P31 wd:Q10876391 } # Language-version Wikipedia union { ?paper wdt:P921 wd:Q2013 } # Wikidata union { ?paper wdt:P921 wd:Q17002416 } # gender bias on Wikipedia

  optional {
    ?paper rdfs:label ?paper_label .
    filter (lang(?paper_label) = "en")
  }

  optional {
    ?paper wdt:P31 ?classes .
    ?classes rdfs:label ?classes_label .
    filter (lang(?classes_label) = "en")
  }

  { ?paper wdt:P921 ?topic . }
  optional { ?topic rdfs:label ?topic_label . filter (lang(?topic_label) = "en") }

  optional {
    ?paper wdt:P50 ?author .
    ?author rdfs:label ?author_label .
    filter (lang(?author_label) = "en")
  }

  optional { ?paper wdt:P1433 ?published_ins }
  optional { ?paper wdt:P577 ?dates_of_publication }
  optional { ?paper wdt:P953 ?full_texts }

} group by ?paper ?paper_label

} SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
} order by desc(?date)

Use at

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#>
# Wikipedia research et al.
select ?paper ?paper_label ?class_labels ?authors ?venueLabel ?topics ?date ?full_text
where {
  {
    select
      ?paper ?paper_label 
      (group_concat(distinct ?classes_label; separator=", ") as ?class_labels)
      (group_concat(distinct ?author_label; separator=", ") as ?authors)
      (sample(?published_ins) as ?venue)
      (group_concat(distinct ?topic_label; separator=", ") as ?topics)
      (min(?dates_of_publication) as ?date)
      (sample(?full_texts) as ?full_text)
    where {
      { ?paper wdt:P921 wd:Q52 } # Wikipedia
      union { ?paper wdt:P921 wd:Q195951 } # reliability
      union { ?paper wdt:P921 wd:Q870337 } # academic studies about Wikipedia
      union { ?paper wdt:P921 wd:Q23038345 } # Wikipedian
      union { ?paper wdt:P921 ?wiki . ?wiki wdt:P31 wd:Q10876391 } # Language-version Wikipedia
      union { ?paper wdt:P921 wd:Q2013 }  # Wikidata
      union { ?paper wdt:P921 wd:Q17002416 }  # gender bias on Wikipedia

      optional {
        ?paper rdfs:label ?paper_label .
        filter (lang(?paper_label) = "en")
      }

      optional {
        ?paper wdt:P31 ?classes .
        ?classes rdfs:label ?classes_label .
        filter (lang(?classes_label) = "en")
      }

      { ?paper wdt:P921 ?topic . }
      optional { ?topic rdfs:label ?topic_label . filter (lang(?topic_label) = "en") } 

      optional {
        ?paper wdt:P50 ?author .
        ?author rdfs:label ?author_label .
        filter (lang(?author_label) = "en")
      }

      optional { ?paper wdt:P1433 ?published_ins }
      optional { ?paper wdt:P577 ?dates_of_publication }
      optional { ?paper wdt:P953 ?full_texts }

    } group by ?paper ?paper_label
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }        
} order by desc(?date)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?author") v2("?author_label") v15("?authors"):::projected v14("?class_labels"):::projected v8("?classes") v4("?classes_label") v18("?date"):::projected v12("?dates_of_publication") v18("?full_text"):::projected v13("?full_texts") v6("?paper"):::projected v5("?paper_label"):::projected v11("?published_ins") v9("?topic") v3("?topic_label") v17("?topics"):::projected v16("?venue") v7("?wiki") c6(["wd:Q23038345"]):::iri c1(["en"]):::literal c3(["wd:Q52"]):::iri c10(["wd:Q17002416"]):::iri c8(["wd:Q10876391"]):::iri c5(["wd:Q870337"]):::iri c17(["bd:serviceParam"]):::iri c4(["wd:Q195951"]):::iri c9(["wd:Q2013"]):::iri subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; subgraph union1[" Union "] subgraph union1l[" "] style union1l fill:#abf,stroke-dasharray: 3 3; subgraph union2[" Union "] subgraph union2l[" "] style union2l fill:#abf,stroke-dasharray: 3 3; subgraph union3[" Union "] subgraph union3l[" "] style union3l fill:#abf,stroke-dasharray: 3 3; subgraph union4[" Union "] subgraph union4l[" "] style union4l fill:#abf,stroke-dasharray: 3 3; subgraph union5[" Union "] subgraph union5l[" "] style union5l fill:#abf,stroke-dasharray: 3 3; v6 --"wdt:P921"--> c10 end subgraph union5r[" "] style union5r fill:#abf,stroke-dasharray: 3 3; v6 --"wdt:P921"--> c9 end union5r <== or ==> union5l end end subgraph union4r[" "] style union4r fill:#abf,stroke-dasharray: 3 3; v6 --"wdt:P921"--> v7 v7 --"wdt:P31"--> c8 end union4r <== or ==> union4l end end subgraph union3r[" "] style union3r fill:#abf,stroke-dasharray: 3 3; v6 --"wdt:P921"--> c6 end union3r <== or ==> union3l end end subgraph union2r[" "] style union2r fill:#abf,stroke-dasharray: 3 3; v6 --"wdt:P921"--> c5 end union2r <== or ==> union2l end end subgraph union1r[" "] style union1r fill:#abf,stroke-dasharray: 3 3; v6 --"wdt:P921"--> c4 end union1r <== or ==> union1l end end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; v6 --"wdt:P921"--> c3 end union0r <== or ==> union0l end subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v6 -."rdfs:label".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P31".-> v8 v8 --"rdfs:label"--> v4 end v6 --"wdt:P921"--> v9 subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v9 -."rdfs:label".-> v3 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P50".-> v10 v10 --"rdfs:label"--> v2 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P1433".-> v11 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P577".-> v12 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v6 -."wdt:P953".-> v13 end bind6[/"?classes_label"/] v4 --o bind6 bind6 --as--o v14 bind7[/"?author_label"/] v2 --o bind7 bind7 --as--o v15 bind8[/"sample(?published_ins)"/] v11 --o bind8 bind8 --as--o v16 bind9[/"?topic_label"/] v3 --o bind9 bind9 --as--o v17 bind10[/"min(?dates_of_publication)"/] v12 --o bind10 bind10 --as--o v18 bind11[/"sample(?full_texts)"/] v13 --o bind11 bind11 --as--o v18 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c17 --"wikibase:language"--> c1 end