Visual Query Examples over Wikidata

 

Jūlija Ovčiņņikova, Kārlis Čerāns

Institute of Mathematics and Computer Science, University of Latvia

 

Supported by the project lzp2021/1-0389 “Visual Queries in Distributed Knowledge Graphs” by Latvian Council of Science

 

The data set is obtained by means of visualization of existing SPARQL queries

from the Wikidata query example set https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples (downloded on January 2022)..

 

The queries from the following categories have been considered: Simple queries, Lexeme queries, Wikibase Predicates, Wikimedia projects, Entertainment, Computer Science and Technology, Biology and Medicine.

Simple queries

Nr

SPARQL Query

ViziQuer to SPARQL

ViziQuer

Comment

1.        

SELECT ?item ?itemLabel

WHERE

{

  ?item wdt:P31 wd:Q146.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

# ID = 1,

# Question = Cats

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?itemLabel WHERE{

  ?item wdt:P31 wd:Q146.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

2.        

SELECT ?item ?itemLabel

WHERE

{

  ?item wdt:P31 wd:Q2934.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

# ID = 2,

# Question = Goats

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?itemLabel WHERE{

  ?item wdt:P31 wd:Q2934.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

3.        

SELECT DISTINCT ?horse ?horseLabel ?mother ?father (year(?birthdate) as ?birthyear) (year(?deathdate) as ?deathyear) ?genderLabel

WHERE

{

  ?horse wdt:P31/wdt:P279* wd:Q726 .    

  OPTIONAL{?horse wdt:P25 ?mother .}      

  OPTIONAL{?horse wdt:P22 ?father .}      

  OPTIONAL{?horse wdt:P569 ?birthdate .}

  OPTIONAL{?horse wdt:P570 ?deathdate .}    

  OPTIONAL{?horse wdt:P21 ?gender .}      

 

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh"

  }

}

ORDER BY ?horse

# ID = 3,

# Question = Horses (showing some info about them)

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?horse ?mother ?father ?birthyear ?deathyear ?horseLabel ?sex_or_genderLabel WHERE{

  ?horse wdt:P31/wdt:P279* wd:Q726.

  OPTIONAL{?horse wdt:P25 ?mother.}

  OPTIONAL{?horse wdt:P22 ?father.}

  OPTIONAL{?horse wdt:P21 ?sex_or_gender.}

  OPTIONAL{?horse wdt:P569 ?date_of_birth.}

  OPTIONAL{?horse wdt:P570 ?date_of_death.}

  BIND(YEAR(xsd:dateTime(?date_of_birth)) AS ?birthyear)

  BIND(YEAR(xsd:dateTime(?date_of_death)) AS ?deathyear)

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],fr,ar,be,bg,bn,ca,cs,da,de,el,en,es,et,fa,fi,he,hi,hu,hy,id,it,ja,jv,ko,nb,nl,eo,pa,pl,pt,ro,ru,sh,sk,sr,sv,sw,te,th,tr,uk,yue,vec,vi,zh" .}

}

ORDER BY ?horse

OK

4.        

SELECT ?item ?itemLabel ?pic

WHERE

{

?item wdt:P31 wd:Q146 .

?item wdt:P18 ?pic

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

# ID = 4,

# Question = Cats, with pictures

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?image ?itemLabel WHERE{

  ?item wdt:P31 wd:Q146.

  ?item wdt:P18 ?image.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

5.        

SELECT distinct * WHERE {

  ?item wdt:P31/wdt:P279* wd:Q16917;

        wdt:P625 ?geo .

}

# ID = 5,

# Question = Map of hospitals

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT DISTINCT ?item ?coordinate_location WHERE{

  ?item wdt:P31/wdt:P279* wd:Q16917.

  ?item wdt:P625 ?coordinate_location.

}

OK

6.        

SELECT distinct * WHERE {

  ?item wdt:P31 wd:Q1032372;

        wdt:P625 ?geo .

}

# ID = 6,

# Question = Map of hackerspaces

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT DISTINCT ?item ?coordinate_location WHERE{

  ?item wdt:P31 wd:Q1032372.

  ?item wdt:P625 ?coordinate_location.

}

OK

7.        

SELECT (COUNT(*) AS ?count)

WHERE {

  ?item wdt:P31 wd:Q5 .

}

# ID = 7,

# Question = Number of humans in Wikidata

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT (COUNT(*) AS ?count) WHERE{

  ?item wdt:P31 wd:Q5.

}

OK

8.        

SELECT ?human ?humanLabel

WHERE

{

  ?human wdt:P31 wd:Q5 .

  ?human rdf:type wdno:P40 .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

# ID = 8,

# Question = Humans without children

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX wdno: <http://www.wikidata.org/prop/novalue/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?human ?humanLabel WHERE{

  ?human wdt:P31 wd:Q5.

  ?human rdf:type wdno:P40.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

8a

SELECT ?human ?humanLabel

WHERE

{

  ?human wdt:P31 wd:Q5 .

  ?human p:P40 ?childStatement .

  ?childStatement rdf:type wdno:P40 .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" . }

}

# ID = 8a,

# Question = Humans without children A similar query which also gives non-truthy 'no value' statements:

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wdno: <http://www.wikidata.org/prop/novalue/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?human ?humanLabel WHERE{

  ?human wdt:P31 wd:Q5.

  ?human p:P40 ?childStatement.

  ?childStatement rdf:type wdno:P40.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

9.        

select distinct ?item ?itemLabel ?itemDescription ?sitelinks where {

    ?item wdt:P31 wd:Q5

          wdt:P19/wdt:P131* wd:Q60

          wikibase:sitelinks ?sitelinks.

  

    SERVICE wikibase:label { bd:serviceParam wikibase:language "en,nl" }

}

ORDER BY DESC(?sitelinks)

 

# ID = 9,

# Question = Humans born in New York City

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?item ?sitelinks ?itemLabel ?itemDescription WHERE{

  ?item wdt:P31 wd:Q5.

  ?item wdt:P19/wdt:P131* wd:Q60.

  ?item wikibase:sitelinks ?sitelinks.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en,nl" .}

}

ORDER BY DESC(?sitelinks)

OK

 

 

 

 

 

 

 

 

 

 

 

10.    

SELECT ?item ?itemLabel ?article

WHERE

{

  ?article  schema:about ?item ;

            schema:isPartOf <https://species.wikimedia.org/> .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

LIMIT 200

# ID = 10,

# Question = Items with a Wikispecies sitelink

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX schema: <http://schema.org/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?article ?about ?aboutLabel WHERE{

  ?article schema:isPartOf <https://species.wikimedia.org/>.

  ?article schema:about ?about.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

LIMIT 200

OK

11.    

SELECT ?author ?authorLabel (COUNT(?paper) AS ?count)

WHERE

{

  ?article  schema:about ?author ;

            schema:isPartOf <https://species.wikimedia.org/> .

  ?author wdt:P31 wd:Q5.

  ?paper wdt:P50 ?author.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

GROUP BY ?author ?authorLabel

ORDER BY DESC(?count)

LIMIT 200

 

# ID = 11,

# Question = Items about authors with a Wikispecies page

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX schema: <http://schema.org/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?author (COUNT(?paper) AS ?count) ?authorLabel WHERE{

  ?author wdt:P31 wd:Q5.

  ?paper wdt:P50 ?author.

  ?article schema:about ?author.

  ?article schema:isPartOf <https://species.wikimedia.org/>.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?author ?authorLabel

ORDER BY DESC(?count)

LIMIT 200

OK

 

Timeout, both queries

12.    

SELECT ?event ?eventLabel ?date

WHERE

{

  ?event wdt:P31/wdt:P279* wd:Q1190554.

  OPTIONAL { ?event wdt:P585 ?date. }

  OPTIONAL { ?event wdt:P580 ?date. }

  FILTER(BOUND(?date) && DATATYPE(?date) = xsd:dateTime).

 

  BIND(NOW() - ?date AS ?distance).

  FILTER(0 <= ?distance && ?distance < 31).

  OPTIONAL {

    ?event rdfs:label ?eventLabel.

    FILTER(LANG(?eventLabel) = "en").

  }

}

LIMIT 10

 

# ID = 12,

# Question = Recent events

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 xsd: <http://www.w3.org/2001/XMLSchema#>

SELECT ?event ?date ?eventLabel WHERE{

  ?event wdt:P31/wdt:P279* wd:Q1190554.

  OPTIONAL{?event wdt:P585 ?date.}

  OPTIONAL{?event wdt:P580 ?date.}

  OPTIONAL{?event rdfs:label ?eventLabel. FILTER(LANG(?eventLabel) = 'en')}

  BIND(NOW()-?date AS ?distance)

  FILTER(BOUND(?date) && DATATYPE(?date) = xsd:dateTime)

  FILTER(0 <= ?distance && ?distance < 31)

}

LIMIT 10

OK

13.    

SELECT ?eyeColorLabel (COUNT(?human) AS ?count)

WHERE

{

  ?human wdt:P31 wd:Q5.

  ?human wdt:P1340 ?eyeColor.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

GROUP BY ?eyeColorLabel

# ID = 13,

# Question = Popular eye colors among humans

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT (COUNT(?human) AS ?count) ?eye_colorLabel WHERE{

  ?human wdt:P31 wd:Q5.

  ?human wdt:P1340 ?eye_color.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?eye_colorLabel

OK

14.    

SELECT ?human ?humanLabel

WHERE

{

  ?human wdt:P21 ?gender .

  FILTER wikibase:isSomeValue(?gender)

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

 

# ID = 14,

# Question = Humans whose gender we know we don't know

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?human ?humanLabel WHERE{

  ?human wdt:P21 ?sex_or_gender.

  BIND(wikibase:isSomeValue(?sex_or_gender) AS ?expr_1)

  FILTER(?expr_1)

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

 

15.    

SELECT ?wikipedia WHERE {

  ?wikipedia wikibase:wikiGroup "wikipedia".

}

 

# ID = 15,

# Question = URLs of Wikipedia in all languages

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

SELECT ?wikipedia WHERE{

  ?wikipedia wikibase:wikiGroup "wikipedia" .

}

OK

16.    

SELECT DISTINCT ?lang ?name WHERE {

  ?article schema:about wd:Q5 ;

           schema:inLanguage ?lang ;

           schema:name ?name ;

           schema:isPartOf [ wikibase:wikiGroup "wikipedia" ] .

  FILTER(?lang in ('en', 'uz', 'ru', 'ko')) .

  FILTER (!CONTAINS(?name, ':')) .

}

 

# ID = 16,

# Question = Names of Wikipedia articles in multiple languages

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX schema: <http://schema.org/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT DISTINCT ?lang ?name WHERE{

  ?article schema:isPartOf [ wikibase:wikiGroup "wikipedia" ].

  ?article schema:about wd:Q5.

  ?article schema:inLanguage ?lang.

  ?article schema:name ?name.

  FILTER(?lang IN ("en", "uz", "ru", "ko"))

  FILTER(!CONTAINS(?name, ":"))

}

OK

17.    

SELECT

  ?item ?itemLabel

  ?value ?valueLabel

WHERE

{

  ?item wdt:P1800 ?value

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

LIMIT 10

# ID = 17,

# Question = All items with a property

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?Wikimedia_database_name ?itemLabel ?Wikimedia_database_nameLabel WHERE{

  ?item wdt:P1800 ?Wikimedia_database_name.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

LIMIT 10

OK

18.    

SELECT ?lemma ?item WHERE {

  VALUES ?lemma {

    "Wikipedia"@de

    "Wikidata"@de

    "Berlin"@de

    "Technische Universitat Berlin"@de

  }

  ?sitelink schema:about ?item;

            schema:isPartOf <https://de.wikipedia.org/>;

            schema:name ?lemma.

}

# ID = 18,

# Question = Wikidata items of Wikipedia articles

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX schema: <http://schema.org/>

SELECT ?about ?lemma WHERE{

  ?sitelink schema:isPartOf <https://de.wikipedia.org/>.

  ?sitelink schema:about ?about.

  ?sitelink schema:name ?lemma.

  VALUES ?lemma {"Wikipedia"@de "Wikidata"@de "Berlin"@de "Technische Universitat Berlin"@de}

}

OK

19.    

SELECT distinct ?area ?areaLabel (sum(?folkm_ngd) as ?total_folkm)

WHERE {

  ?item wdt:P361 wd:Q297853.

  ?item wdt:P1082 ?folkm_ngd.

  ?area wdt:P31 wd:Q1907114.

  ?area wdt:P527 ?item.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

group by ?area ?areaLabel

 

# ID = 19,

# Question = Total population in the Øresund Region

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?area (SUM(?folkm_ngd) AS ?total_folkm) ?areaLabel WHERE{

  ?area wdt:P31 wd:Q1907114.

  ?item wdt:P1082 ?folkm_ngd.

  ?item wdt:P361 wd:Q297853.

  ?area wdt:P527 ?item.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?area ?areaLabel

OK

20.    

SELECT ?image ?speciesLabel ?mayorLabel ?placeLabel WHERE {

  ?species wdt:P279* wd:Q622852 .

  ?mayor wdt:P31 ?species .

  ?mayor p:P39 ?node .

  ?node ps:P39 wd:Q30185 .

  ?node pq:P642 ?place .

  optional{?mayor wdt:P18 ?image}

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

 

# ID = 20,

# Question = Mayors that are any kind of domesticated animal

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?image ?speciesLabel ?mayorLabel ?ofLabel WHERE{

  ?species wdt:P279* wd:Q622852.

  ?mayor wdt:P31 ?species.

  ?mayor p:P39 ?node.

  ?node ps:P39 wd:Q30185.

  OPTIONAL{?mayor wdt:P18 ?image.}

  ?node pq:P642 ?of.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

21.    

SELECT ?image ?speciesLabel ?mayorLabel ?placeLabel WHERE {

  VALUES ?species {wd:Q144 wd:Q146 wd:Q780}

  ?mayor wdt:P31 ?species .

  ?mayor p:P39 ?node .

  ?node ps:P39 wd:Q30185 .

  ?node pq:P642 ?place .

  optional{?mayor wdt:P18 ?image}

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

 

# ID = 21,

# Question = Mayors that are either a dog, a cat or a chicken

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?image ?mayorLabel ?speciesLabel ?ofLabel WHERE{

  ?mayor wdt:P31 ?species.

  ?mayor p:P39 ?node.

  ?node ps:P39 wd:Q30185.

  OPTIONAL{?mayor wdt:P18 ?image.}

  VALUES ?species {wd:Q144 wd:Q146 wd:Q780}

  ?node pq:P642 ?of.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

 

Lexeme queries

1.        

select ?lemma

WHERE {

  ?lexemeId dct:language wd:Q9027;

            wikibase:lemma ?lemma;

            wdt:P9660 wd:Q1935308.

}

# ID = 1,

# Question = Swedish lexemes missing in SAOB

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?lemma WHERE{

  ?lexemeId dct:language wd:Q9027.

  ?lexemeId wdt:P9660 wd:Q1935308.

  ?lexemeId wikibase:lemma ?lemma.

}

OK

2.        

select ?form ?lemma

WHERE {

  ?lexemeId dct:language wd:Q9027;

            wikibase:lemma ?lemma;

            ontolex:lexicalForm ?form.

  MINUS {

  ?lexemeId p:P5831 ?statement.

  ?statement ps:P5831 ?example;

             pq:P6072 [];

             pq:P5830 ?form_with_example.

  }

}

 

# ID = 2,

# Question = Forms in Swedish that have no example demonstrating them

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?lemma ?lexicalForm WHERE{

  ?lexemeId dct:language wd:Q9027.

  ?lexemeId wikibase:lemma ?lemma.

  ?lexemeId ontolex:lexicalForm ?lexicalForm.

  MINUS{

      ?lexemeId p:P5831 ?statement.

      ?statement pq:P6072 [].

      ?statement ps:P5831 ?usage_example.

      ?statement pq:P5830 ?subject_form.

  }

}

OK

3.        

SELECT DISTINCT ?l ?word ?lemma WHERE {

  VALUES ?word {'bought'@en}

  ?l a ontolex:LexicalEntry ;

       dct:language wd:Q1860 ;

       wikibase:lemma ?lemma ;

       ontolex:lexicalForm ?form .

  ?form ontolex:representation ?word .

}

 

# ID = 3,

# Question = Lemmatize a word in English

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT DISTINCT ?l ?lemma ?word WHERE{

  ?l rdf:type ontolex:LexicalEntry.

  ?l dct:language wd:Q1860.

  ?l ontolex:lexicalForm ?form.

  ?l wikibase:lemma ?lemma.

  VALUES ?word {"bought"@en}

  ?form ontolex:representation ?word.

}

OK

4.        

select ?lexemeId ?lemma WHERE {

  ?lexemeId dct:language wd:Q9027;

            wikibase:lemma ?lemma.

  ?lexemeId wikibase:lexicalCategory wd:Q9788

}

ORDER BY ?lemma

 

# ID = 4,

# Question = The Swedish alphabet

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?lexemeId ?lemma WHERE{

  ?lexemeId dct:language wd:Q9027.

  ?lexemeId wikibase:lexicalCategory wd:Q9788.

  ?lexemeId wikibase:lemma ?lemma.

}

ORDER BY ?lemma

OK

5.        

SELECT ?l ?lemma  WHERE {

  ?l dct:language wd:Q9035;

     wikibase:lemma ?lemma;

     wikibase:lexicalCategory wd:Q184511.

}

 

# ID = 5,

# Question = Danish idioms

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?l ?lemma WHERE{

  ?l dct:language wd:Q9035.

  ?l wikibase:lexicalCategory wd:Q184511.

  ?l wikibase:lemma ?lemma.

}

OK

6.        

SELECT ?l ?lemma ?form ?audio WHERE {

  ?l dct:language wd:Q9027;

     wikibase:lemma ?lemma;

     ontolex:lexicalForm ?form .

  ?form ontolex:representation ?lemma .

  minus {?form wdt:P443 ?audio.}

}

 

# ID = 6,

# Question = All forms in Swedish missing a pronunciation for the form with a representation identical to the lemma of the lexeme

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?l ?lemma ?form WHERE{

  ?l dct:language wd:Q9027.

  ?l ontolex:lexicalForm ?form.

  ?l wikibase:lemma ?lemma.

  ?form ontolex:representation ?lemma.

  MINUS{

      ?form wdt:P443 ?audio.

  }

}

 

OK

7.        

select ?lexemeId ?lemma WHERE {

  ?lexemeId dct:language wd:Q1860;

            wikibase:lemma ?lemma.

  FILTER (regex(?lemma, '^pota.*'))

}

 

# ID = 7,

# Question = Lexemes in English that match an expression

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?lexemeId ?lemma WHERE{

  ?lexemeId dct:language wd:Q1860.

  ?lexemeId wikibase:lemma ?lemma.

  FILTER(REGEX(?lemma, "^pota.*"))

}

OK

8.        

select ?lexemeId ?lemma ?example

WHERE {

  ?lexemeId <http://purl.org/dc/terms/language> wd:Q9027;

            wikibase:lemma ?lemma.

  ?lexemeId p:P5831 ?statement.

  ?statement ps:P5831 ?example;

             pq:P6072 [];

             pq:P5830 [].

}

 

# ID = 8,

# Question = Lexemes in Swedish with usage example that demonstrates both a form and a sense

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?lexemeId ?lemma ?usage_example WHERE{

  ?lexemeId dct:language wd:Q9027.

  ?lexemeId p:P5831 ?statement.

  ?statement pq:P6072 [].

  ?statement pq:P5830 [].

  ?lexemeId wikibase:lemma ?lemma.

  ?statement ps:P5831 ?usage_example.

}

OK

9.        

select distinct ?lexemeId ?lemma ?q_concept ?q_conceptDescription ?picture

WHERE {

  ?lexemeId dct:language wd:Q1860;

            wikibase:lemma ?lemma;

            ontolex:sense ?sense.

  ?sense wdt:P5137 ?q_concept.

  ?q_concept wdt:P18 ?picture.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

order by lcase(?lemma)

 

# ID = 9,

# Question = Pictures of noun lexemes in English (picture dictionary à la Wikidata)

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?lexemeId ?lemma ?q_concept ?image ?q_conceptDescription WHERE{

  ?lexemeId dct:language wd:Q1860.

  ?lexemeId ontolex:sense ?sense.

  ?sense wdt:P5137 ?q_concept.

  ?lexemeId wikibase:lemma ?lemma.

  ?q_concept wdt:P18 ?image.

 

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY (LCASE(?lemma))

OK

10.    

select distinct ?lexemeId ?lemma ?q_concept ?q_conceptDescription ?picture

WHERE {

  ?lexemeId dct:language wd:Q188;

            wikibase:lemma ?lemma;

            ontolex:sense ?sense.

  ?sense wdt:P5137 ?q_concept.

  ?q_concept wdt:P18 ?picture.

 

  MINUS {?q_concept wdt:P31 wd:Q3624078.}.

 

  VALUES ?minus {

  wd:Q47092

  wd:Q198 

  wd:Q124490

  wd:Q170382

  wd:Q1576 

  }.

 

  MINUS {?sense wdt:P5137 ?minus.}.

 

  VALUES ?filter {

  wd:Q8102

  wd:Q545779

  wd:Q1521634

  wd:Q184439}.

  FILTER NOT EXISTS {?sense wdt:P6191 ?filter.}.

 

  SERVICE wikibase:label { bd:serviceParam wikibase:language "de,en". }

}

order by lcase(?lemma)

 

# ID = 10,

# Question = German picture dictionary for young children

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?lexemeId ?lemma ?q_concept ?image ?q_conceptDescription WHERE{

  ?lexemeId dct:language wd:Q188.

  ?lexemeId ontolex:sense ?sense.

  ?sense wdt:P5137 ?q_concept.

  ?lexemeId wikibase:lemma ?lemma.

  VALUES ?minus {wd:Q47092 wd:Q198 wd:Q124490 wd:Q170382 wd:Q1576}

  VALUES ?filter {wd:Q8102 wd:Q545779 wd:Q1521634 wd:Q184439}

  ?q_concept wdt:P18 ?image.

  FILTER NOT EXISTS{

    ?sense wdt:P6191 ?filter.

  }

  MINUS{

      ?q_concept wdt:P31 wd:Q3624078.

  }

  MINUS{

      ?sense wdt:P5137 ?minus.

  }

 

  SERVICE wikibase:label {bd:serviceParam wikibase:language "de,en" .}

}

ORDER BY (LCASE(?lemma))

OK

11.    

SELECT ?languageLabel (COUNT(?example) AS ?count ) WHERE {

  ?l a ontolex:LexicalEntry; dct:language ?language.

  ?l p:P5831 ?statement.

  ?statement ps:P5831 ?example;

             pq:P6072 [];

             pq:P5830 [].

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

GROUP BY ?languageLabel

ORDER BY DESC(?count)

 

# ID = 11,

# Question = Lexeme languages by number of usage examples

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT (COUNT(?example) AS ?count) ?languageLabel WHERE{

  ?l rdf:type ontolex:LexicalEntry.

  ?l p:P5831 ?statement.

  ?statement pq:P6072 [].

  ?statement pq:P5830 [].

  ?l dct:language ?language.

  ?statement ps:P5831 ?example.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?languageLabel

ORDER BY DESC(?count)

OK

12.    

SELECT ?l ?lemma ?languageLabel  WHERE {

  ?l a ontolex:LexicalEntry;

       dct:language ?language;

       wikibase:lemma ?lemma .

  ?l wdt:P31 wd:Q376431.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

ORDER BY ?languageLabel

 

# ID = 12,

# Question = Lexemes describing a color

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?l ?lemma ?languageLabel WHERE{

  ?l wdt:P31 wd:Q376431.

  ?l rdf:type ontolex:LexicalEntry.

  ?l dct:language ?language.

  ?l wikibase:lemma ?lemma.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY ?languageLabel

 

OK

13.    

select ?l ?sense ?lemma ?languageLabel WHERE {

  ?l a ontolex:LexicalEntry ;

       ontolex:sense ?sense ;

       dct:language ?language ;

       wikibase:lemma ?lemma.

  ?sense wdt:P5137 wd:Q29053744 .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

order by (LCASE(?languageLabel))

 

# ID = 13,

# Question = Lexemes that means water ordered by language

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?l ?lemma ?sense ?languageLabel WHERE{

  ?l rdf:type ontolex:LexicalEntry.

  ?l ontolex:sense ?sense.

  ?sense wdt:P5137 wd:Q29053744.

  ?l dct:language ?language.

  ?l wikibase:lemma ?lemma.

 

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY (LCASE(?languageLabel))

OK

14.    

SELECT ?meaning ?meaningLabel (count(?l) as ?count)

WHERE {

   ?l a ontolex:LexicalEntry ;

        ontolex:sense ?sense.

  ?sense wdt:P5137 ?meaning.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"}

}

group by ?meaning ?meaningLabel

order by desc(?count)

limit 100

 

# ID = 14,

# Question = The 100 most translated concepts in the Lexeme namespace

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?P5137 (COUNT(?l) AS ?count) ?P5137Label WHERE{

  ?l rdf:type ontolex:LexicalEntry.

  ?l ontolex:sense ?sense.

  ?sense wdt:P5137 ?P5137.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?P5137 ?P5137Label

ORDER BY DESC(?count)

LIMIT 100

OK

15.    

SELECT ?l ?lemma ?demoPlaceLabel ?coords WHERE {

  ?l a ontolex:LexicalEntry ;

       dct:language ?language ;

       wikibase:lemma ?lemma .

  ?language wdt:P218 'sv'.

  ?l ontolex:sense ?sense.

     ?sense wdt:P6271 ?demoPlace.

  ?demoPlace wdt:P625 ?coords

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

 

# ID = 15,

# Question = Demonyms on map

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?l ?lemma ?coordinate_location ?demoPlaceLabel WHERE{

  ?l rdf:type ontolex:LexicalEntry.

  ?l dct:language ?language.

  ?l ontolex:sense ?sense.

  ?sense wdt:P6271 ?demoPlace.

  ?l wikibase:lemma ?lemma.

  ?language wdt:P218 "sv" .

  ?demoPlace wdt:P625 ?coordinate_location.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

16.    

select ?lexemeId ?lemma ?form ?word WHERE {

  ?lexemeId dct:language wd:Q9288;

            wikibase:lexicalCategory wd:Q1084;

            wikibase:lemma ?lemma.

  ?lexemeId ontolex:lexicalForm ?form .

  ?form wikibase:grammaticalFeature wd:Q499327;

        wikibase:grammaticalFeature wd:Q1775415;

        ontolex:representation ?word .

}

# ID = 16,

# Question = Forms in Hebrew that are both feminine and masculine

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX ontolex: <http://www.w3.org/ns/lemon/ontolex#>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?lexemeId ?lemma ?form ?representation WHERE{

  ?lexemeId dct:language wd:Q9288.

  ?lexemeId wikibase:lexicalCategory wd:Q1084.

  ?lexemeId ontolex:lexicalForm ?form.

  ?form wikibase:grammaticalFeature wd:Q499327.

  ?form wikibase:grammaticalFeature wd:Q1775415.

  ?lexemeId wikibase:lemma ?lemma.

  ?form ontolex:representation ?representation.

}

OK

17.    

select * {

  ?l dct:language [];

     wikibase:statements ?c.

}

order by desc(?c) limit 50

 

# ID = 17,

# Question = Lexemes by number of statements

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX dct: <http://purl.org/dc/terms/>

SELECT ?l ?c WHERE{

  ?l dct:language [].

  ?l wikibase:statements ?c.

}

ORDER BY DESC(?c)

LIMIT 50

OK

 

Wikibase predicates

1.        

SELECT ?property2 ?property2Label ?property1 ?property1Label WHERE {

  ?property1 rdf:type wikibase:Property.

  ?property1 wdt:P1647 ?property2.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

 

# ID = 1,

# Question = Properties grouped by their parent property

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?property1 ?subproperty_of ?property1Label ?subproperty_ofLabel WHERE{

  ?property1 rdf:type wikibase:Property.

  ?property1 wdt:P1647 ?subproperty_of.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

2.        

SELECT DISTINCT ?subProperties ?subPropertiesLabel WHERE {

  ?subProperties wdt:P1647* wd:P276.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

 

# ID = 2,

# Question = Subproperties of location (P276)

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?subProperties ?subPropertiesLabel WHERE{

  ?subProperties wdt:P1647* wd:P276.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

3.        

SELECT (COUNT(?property) as ?pcount ) ?wbtype WHERE {

  ?property rdf:type wikibase:Property.             

  ?property wikibase:propertyType  ?wbtype.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

GROUP BY ?wbtype

ORDER BY DESC(?pcount)

 

# ID = 3,

# Question = Properties grouped by their Wikibase datatype (Q19798645) with number of properties

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

SELECT ?wbtype (COUNT(?property) AS ?pcount) WHERE{

  ?property rdf:type wikibase:Property.

  ?property wikibase:propertyType ?wbtype.

}

GROUP BY ?wbtype

ORDER BY DESC(?pcount)

OK

4.        

SELECT DISTINCT ?propertyRel ?propertyItem ?propertyItemLabel WHERE

{

   ?item ?propertyRel ?standard.

   ?standard wdt:P31 wd:Q317623.

   ?propertyItem wikibase:directClaim ?propertyRel

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

 

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?propertyRel ?propertyItem ?propertyItemLabel WHERE{

  ?standard wdt:P31 wd:Q317623.

  ?item ?propertyRel ?standard.

  ?propertyItem wikibase:directClaim ?propertyRel.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

5.        

SELECT ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel WHERE {

  ?property wikibase:propertyType ?propertyType.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))

 

# ID = 5,

# Question = All properties with descriptions and aliases and types

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?property ?propertyType ?propertyLabel ?propertyAltLabel ?propertyDescription WHERE{

  ?property wikibase:propertyType ?propertyType.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY (xsd:integer(STRAFTER(STR(?property), "P")))

OK

6.        

select ?p ?pLabel (count (*) as ?count) {

  ?s ?pd ?o .

  ?p wikibase:directClaim ?pd .

  ?s wdt:P31/wdt:P279* wd:Q729 .

  ?o wdt:P31/wdt:P279* wd:Q43501 .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

} group by ?p ?pLabel order by desc(?count)

 

# ID = 6,

# Question = Properties connecting items of type zoo (Q43501) with items of type animal (Q729)

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?p (COUNT(*) AS ?count) ?pLabel WHERE{

  ?s wdt:P31/wdt:P279* wd:Q729.

  ?o wdt:P31/wdt:P279* wd:Q43501.

  ?s ?pd ?o.

  ?p wikibase:directClaim ?pd.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?p ?pLabel

ORDER BY DESC(?count)

OK

 

 

7.        

PREFIX hint: <http://aws.amazon.com/neptune/vocab/v01/QueryHints#>

SELECT

  ?p ?pLabel

  (SAMPLE(?url) as ?url_comp2)

WHERE

{

    hint:Query hint:optimizer "None".

    BIND( wd:Q4573 as ?comp1)

    BIND( wd:Q39666 as ?comp2)

    {

        ?comp2 ?wdt ?v .

        ?p wikibase:directClaim ?wdt ; wikibase:propertyType wikibase:ExternalId .

        FILTER NOT EXISTS { ?comp1 ?wdt [] }

        OPTIONAL { ?p  wdt:P1630 ?f }

        BIND(uri(REPLACE(?f,"\\$1",?v)) as ?url)

    }

    UNION { BIND(wd:Q4573 as ?p) }

    UNION { BIND(wd:Q39666 as ?p) }

   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

GROUP BY ?p ?pLabel

ORDER BY ?url_comp2

# ID = 7,

# Question = Identifier properties present on one item, but absent on another

#

# Manually edited.

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?p (SAMPLE(?url) AS ?url_comp2) ?pLabel WHERE{

  {

    BIND(wd:Q39666 AS ?p)

  }

  UNION

  {

    BIND(wd:Q4573 AS ?p)

  }

  UNION

  {

    ?p wikibase:propertyType wikibase:ExternalId.

    ?comp2 ?wdt ?v.

    ?p wikibase:directClaim ?wdt.

    OPTIONAL{?p wdt:P1630 ?f.}

    FILTER NOT EXISTS{

    ?comp1 ?wdt [].

  }

    BIND(URI(REPLACE(?f, "\\$1", ?v)) AS ?url)

  }

  <http://aws.amazon.com/neptune/vocab/v01/QueryHints#Query> <http://aws.amazon.com/neptune/vocab/v01/QueryHints#optimizer> "None" .

  BIND(wd:Q4573 AS ?comp1)

  BIND(wd:Q39666 AS ?comp2)

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?p ?pLabel

ORDER BY ?url_comp2

Manually edited.

 

TO DO: UNION construction

8.        

SELECT ?item ?reference

WHERE {

  ?item wdt:P1343 wd:Q51955019 .

  ?item p:P1343 [ prov:wasDerivedFrom [ pr:P958 ?reference ] ] .

}

 

# ID = 8,

# Question = Content of a reference for a specific statement

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX pr: <http://www.wikidata.org/prop/reference/>

PREFIX prov: <http://www.w3.org/ns/prov#>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?item ?P958 WHERE{

  ?item wdt:P1343 wd:Q51955019.

  ?item p:P1343 _:name0.

  _:name0 prov:wasDerivedFrom [ pr:P958 ?P958].

}

OK

 

Wikimedia projects

1.        

SELECT ?country ?countryLabel ?article WHERE {

 

    ?country wdt:P31 wd:Q3624078 .

    ?article schema:about ?country .

    ?article schema:isPartOf <https://en.wikipedia.org/>.

 

    SERVICE wikibase:label {

       bd:serviceParam wikibase:language "en"

    }

}

# ID = 1,

# Question = Countries that have sitelinks to en.wiki

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX schema: <http://schema.org/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?country ?article ?countryLabel WHERE{

  ?country wdt:P31 wd:Q3624078.

  ?article schema:about ?country.

  ?article schema:isPartOf <https://en.wikipedia.org/>.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

OK

2.        

SELECT ?item ?itemLabel ?cnt WHERE {

{

  SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE {

  ?item wdt:P27|wdt:P205|wdt:P17 wd:Q16 .

  minus {?item wdt:P106 wd:Q488111 .}

  minus {?item wdt:P106 wd:Q3286043 .}

  minus {?item wdt:P106 wd:Q4610556 .} 

  ?sitelink schema:about ?item .

  FILTER NOT EXISTS {

    ?article schema:about ?item .

    ?article schema:isPartOf <https://en.wikipedia.org/> .

  }

  } GROUP BY ?item ORDER BY DESC (?cnt) LIMIT 1000

}

SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,es,de"

} ORDER BY DESC (?cnt)

 

# ID = 2,

# Question = Canadian subjects with no English article in Wikipedia

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX schema: <http://schema.org/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?cnt ?itemLabel WHERE{

  {SELECT ?item (COUNT(?sitelink) AS ?cnt) WHERE{

    ?sitelink schema:about ?item.

    ?item (wdt:P27|wdt:P205|wdt:P17) wd:Q16.

    FILTER NOT EXISTS{

      ?article schema:about ?item.

      ?article schema:isPartOf <https://en.wikipedia.org/>.

    }

    MINUS{

        ?item wdt:P106 wd:Q488111.

    }

    MINUS{

        ?item wdt:P106 wd:Q3286043.

    }

    MINUS{

        ?item wdt:P106 wd:Q4610556.

    }}

    GROUP BY ?item ?cnt

    ORDER BY DESC(?cnt)

    LIMIT 1000

  }

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,fr,es,de" .}

}

ORDER BY DESC(?cnt)

OK

 

3.        

SELECT ?sitelink ?itemLabel WHERE {

  ?item wdt:P31 wd:Q6256.

  ?sitelink schema:isPartOf <https://ru.wikipedia.org/>;

     schema:about ?item;

     wikibase:badge wd:Q17437796 .

    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" } .

} ORDER BY ?itemLabel

 

# ID = 3,

# Question = Countries that have a Featured Article on Russian Wikipedia

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX schema: <http://schema.org/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?sitelink ?itemLabel WHERE{

  ?item wdt:P31 wd:Q6256.

  ?sitelink schema:about ?item.

  ?sitelink schema:isPartOf <https://ru.wikipedia.org/>.

  ?sitelink wikibase:badge wd:Q17437796.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY ?itemLabel

 

OK

4.        

PREFIX hint: <http://aws.amazon.com/neptune/vocab/v01/QueryHints#>

SELECT ?lang (COUNT(DISTINCT ?article) AS ?count) WHERE {

  hint:Query hint:optimizer "None".

  ?item wdt:P1367 ?yp_id .

  ?article schema:about ?item .

  ?article schema:isPartOf / wikibase:wikiGroup "wikipedia" .

  hint:Prior hint:gearing "forward" .

  ?article schema:inLanguage ?lang .

} GROUP BY ?lang

ORDER BY DESC (?count)

 

# ID = 4,

# Question = Numbers of Wikipedia sitelinks for items with Art UK artist ID (P1367) for each language

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX schema: <http://schema.org/>

PREFIX wikibase: <http://wikiba.se/ontology#>

SELECT ?lang (COUNT(DISTINCT ?article) AS ?count) WHERE{

  ?article schema:about ?item.

  ?article schema:isPartOf/wikibase:wikiGroup ?expr.

  ?article schema:inLanguage ?lang.

  ?item wdt:P1367 ?P1367.

  <http://aws.amazon.com/neptune/vocab/v01/QueryHints#Query> <http://aws.amazon.com/neptune/vocab/v01/QueryHints#optimizer> "None" .

  <http://aws.amazon.com/neptune/vocab/v01/QueryHints#Prior> <http://aws.amazon.com/neptune/vocab/v01/QueryHints#gearing> "forward" .

  FILTER(?expr = "wikipedia")

}

GROUP BY ?lang

ORDER BY DESC(?count)

OK

 

5.        

SELECT DISTINCT ?item ?LabelEN ?LabelUK ?page_titleRO WHERE {

  ?item wdt:P31 wd:Q532

  ?item wdt:P17 wd:Q212 .

  ?article schema:about ?item ;

schema:isPartOf <https://ro.wikipedia.org/>schema:name ?page_titleRO .

  ?item rdfs:label ?LabelEN filter (lang(?LabelEN) = "en") .

  ?item rdfs:label ?LabelUK filter (lang(?LabelUK) = "uk") .

}

LIMIT 300

 

# ID = 5,

# Question = Titles of articles about Ukrainian villages on Romanian Wikipedia

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 schema: <http://schema.org/>

SELECT DISTINCT ?item ?LabelEN ?LabelUK ?name WHERE{

  ?item wdt:P31 wd:Q532.

  ?item wdt:P17 wd:Q212.

  ?article schema:about ?item.

  ?article schema:isPartOf <https://ro.wikipedia.org/>.

  ?item rdfs:label ?LabelEN.

  ?item rdfs:label ?LabelUK.

  ?article schema:name ?name.

  FILTER(LANG(?LabelEN) = "en")

  FILTER(LANG(?LabelUK) = "uk")

}

LIMIT 300

OK

6.        

SELECT DISTINCT ?item ?wikisourceSitelink ?wikisourceLanguage WHERE {

  ?wikisourceSitelink schema:isPartOf [ wikibase:wikiGroup "wikisource" ];

                      schema:inLanguage ?wikisourceLanguage;

                      schema:about ?item.

  ?paper wdt:P31 wd:Q13442814;

         wdt:P50 ?item.

}

ORDER BY ?wikisourceLanguage

LIMIT 300

 

# ID = 6,

# Question = Wikisource pages for authors of scientific articles

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX schema: <http://schema.org/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT DISTINCT ?wikisourceSitelink ?wikisourceLanguage ?item WHERE{

  ?paper wdt:P31 wd:Q13442814.

  ?wikisourceSitelink schema:isPartOf [ wikibase:wikiGroup "wikisource" ].

  ?wikisourceSitelink schema:about ?item.

  ?paper wdt:P50 ?item.

  ?wikisourceSitelink schema:inLanguage ?wikisourceLanguage.

}

ORDER BY ?wikisourceLanguage

LIMIT 300

OK

7.        

select ?item ?itemLabel ?gtaa ?_articleEN ?_articleNL where {

  ?item wdt:P1741 ?gtaa.

  OPTIONAL {

    ?_articleEN schema:about ?item.

    ?_articleNL schema:about ?item.

    ?_articleEN schema:isPartOf <https://en.wikipedia.org/>.

    ?_articleNL schema:isPartOf <https://nl.wikipedia.org/>.

  }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,nl". }

}

 

# ID = 7,

# Question = Items with a GTAA id and their articles on the Dutch and English Wikipedia

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX schema: <http://schema.org/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?GTAA_ID ?articleEN ?articleNL ?itemLabel WHERE{

  ?item wdt:P1741 ?GTAA_ID.

  OPTIONAL{

    ?articleEN schema:about ?item.

    ?articleEN schema:isPartOf <https://en.wikipedia.org/>.

    ?articleNL schema:about ?item.

    ?articleNL schema:isPartOf <https://nl.wikipedia.org/>.

  }

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en,nl" .}

}

OK

 

Timeout, both queries

8.        

select ?person ?personLabel ?died ?sitelinks where {

  ?person wdt:P31 wd:Q5;

          wdt:P570 ?died.

  filter (?died >= "2018-01-01T00:00:00Z"^^xsd:dateTime && ?died < "2019-01-01T00:00:00Z"^^xsd:dateTime)

  ?person wikibase:sitelinks ?sitelinks.

  service wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

order by desc(?sitelinks) limit 100

 

# ID = 8,

# Question = People deceased in 2018 ordered by the number of sitelinks

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?person ?died ?sitelinks ?personLabel WHERE{

  ?person wdt:P31 wd:Q5.

  ?person wdt:P570 ?died.

  ?person wikibase:sitelinks ?sitelinks.

  FILTER(?died >= "2018-01-01T00:00:00Z"^^xsd:dateTime && ?died < "2019-01-01T00:00:00Z"^^xsd:dateTime)

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY DESC(?sitelinks)

LIMIT 100

OK

9.        

SELECT ?item ?comm ?p373 ?cat WHERE {

  ?item wdt:P131* wd:Q894107.                             

 

  optional {?comm schema:about ?item ; schema:isPartOf <https://commons.wikimedia.org/> .}

  BIND(replace(wikibase:decodeUri(SUBSTR(STR(?comm), 45)),"_"," ") AS ?comm_decode)

   optional {?item wdt:P373 ?p373 .}

 

 bind(COALESCE(?comm_decode, ?p373) as ?cat) .

 VALUES ?trida { wd:Q1746392 wd:Q108325 wd:Q4989906 wd:Q10861631 wd:Q15077340 wd:Q1516537 wd:Q47008262}   

 ?item wdt:P31/wdt:P279* ?trida.                 

  }

 

# ID = 9,

# Question = List of small monuments with link to Commons category (either from sitelink and P373)

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX schema: <http://schema.org/>

SELECT ?item ?p373 ?cat ?trida ?comm WHERE{

  ?item wdt:P31/wdt:P279* ?trida.

  ?item wdt:P131* wd:Q894107.

  OPTIONAL{?item wdt:P373 ?p373.}

  VALUES ?trida {wd:Q1746392 wd:Q108325 wd:Q4989906 wd:Q10861631 wd:Q15077340 wd:Q1516537 wd:Q47008262}

  OPTIONAL{

    ?comm schema:about ?item.

    ?comm schema:isPartOf <https://commons.wikimedia.org/>.

    BIND(wikibase:decodeUri(SUBSTR(STR(?comm), 45)) AS ?expr_2)

    BIND(REPLACE(?expr_2, "_", " ") AS ?comm_decode)

  }

  BIND(COALESCE(?comm_decode, ?p373) AS ?cat)

}

OK

10.    

SELECT ?person ?personLabel ?parentLabel ?linkcount WHERE {

    ?parent wdt:P106 wd:Q182436 .

    ?parent wdt:P40 ?person .

    ?person wikibase:sitelinks ?linkcount .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,de,es,ar,fr" }

}

GROUP BY  ?linkcount ?person ?personLabel ?parent ?parentLabel

ORDER BY DESC(?linkcount)

 

# ID = 10,

# Question = Most famous child of a librarian

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?person ?linkcount ?parentLabel ?personLabel WHERE{

  ?parent wdt:P106 wd:Q182436.

  ?parent wdt:P40 ?person.

  ?person wikibase:sitelinks ?linkcount.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en,de,es,ar,fr" .}

}

ORDER BY DESC(?linkcount)

OK

11.    

SELECT DISTINCT ?lang_code ?itemLabel ?item

WHERE

{

 

  VALUES ?lang {

    wd:Q34770  

    wd:Q436240 

    wd:Q1288568

    wd:Q33215 

  }

  ?item wdt:P31 ?lang ;

    wdt:P424 ?lang_code .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

} ORDER BY ?lang_code

# ID = 11,

# Question = All languages with a Wikimedia language code (P424)

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?item ?lang_code ?itemLabel WHERE{

  ?item wdt:P31 ?lang.

  ?item wdt:P424 ?lang_code.

  VALUES ?lang {wd:Q34770 wd:Q436240 wd:Q1288568 wd:Q33215}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY ?lang_code

OK

12.    

SELECT ?item ?itemLabel ?website

WHERE

{

  ?item wdt:P856 ?website.

  ?website wikibase:wikiGroup "wikipedia".

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

 

# ID = 12,

# Question = All wikipedia sites

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?website ?itemLabel WHERE{

  ?item wdt:P856 ?website.

  ?website wikibase:wikiGroup "wikipedia" .

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

13.    

SELECT ?lang ?name ?itemLabel ?sitelink ?linkcount ?item WHERE {

  ?item wikibase:sitelinks ?linkcount.

  ?sitelink schema:name ?name;

    schema:inLanguage ?lang;

    schema:about ?item;

    wikibase:badge wd:Q17437796.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

# ID = 13,

# Question = Featured articles of all Wikimedia projects

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX schema: <http://schema.org/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?sitelinks ?sitelink ?name ?inLanguage ?itemLabel WHERE{

  ?sitelink schema:about ?item.

  ?sitelink wikibase:badge wd:Q17437796.

  ?item wikibase:sitelinks ?sitelinks.

  ?sitelink schema:name ?name.

  ?sitelink schema:inLanguage ?inLanguage.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

 

Entertainment

1.        

SELECT ?band ?bandLabel

WHERE

{

  ?band wdt:P31 wd:Q5741069 .

        ?band rdfs:label ?bandLabel .

  FILTER(LANG(?bandLabel) = "en") .

  FILTER(STRSTARTS(?bandLabel, 'M')) .

}

# ID = 1,

# Question = Rock bands that start with 'M'

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#>

SELECT ?band ?bandLabel WHERE{

  ?band wdt:P31 wd:Q5741069.

  ?band rdfs:label ?bandLabel.

  FILTER(LANG(?bandLabel) = "en")

  FILTER(STRSTARTS(?bandLabel, "M"))

}

OK

2.        

SELECT ?film ?filmLabel ?genere ?d WHERE {

  {

    SELECT ?film (GROUP_CONCAT(DISTINCT ?gL; SEPARATOR = ", ") AS ?genere) (MIN(YEAR(?date)) AS ?d) WHERE {

      ?sitelink schema:about ?director;

        schema:isPartOf <https://en.wikipedia.org/>;

        schema:name "Steven Spielberg"@en.

      ?film wdt:P31 wd:Q11424;

            wdt:P136 ?g, ?g.

      ?g rdfs:label ?gL.

      ?film wdt:P57 ?director;

            wdt:P577 ?date.

      FILTER((LANG(?gL)) = "en")

      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

    }

    GROUP BY ?film

  }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

ORDER BY DESC (?d)

# ID = 2,

# Question = Films of directors by their English Wikipedia name

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX schema: <http://schema.org/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?film ?genere ?d ?filmLabel WHERE{

  {SELECT ?film (GROUP_CONCAT(DISTINCT ?gL; SEPARATOR=', ') AS ?genere) (MIN(YEAR(xsd:dateTime(?date))) AS ?d) ?filmLabel WHERE{

    ?film wdt:P31 wd:Q11424.

    ?sitelink schema:about ?director.

    ?film wdt:P57 ?director.

    ?film wdt:P136 ?g.

    ?sitelink schema:isPartOf <https://en.wikipedia.org/>.

    ?sitelink schema:name "Steven Spielberg"@en .

    ?film wdt:P577 ?date.

    ?g rdfs:label ?gL.

    FILTER(LANG(?gL) = "en")

    SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

    }

    GROUP BY ?film ?filmLabel

  }

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

ORDER BY DESC(?d)

OK

3.        

SELECT DISTINCT ?item ?itemLabel ?awardLabel ?time

{

    ?item wdt:P106/wdt:P279* wd:Q3455803 ;

          p:P166 ?awardStat .             

    ?awardStat pq:P805 ?award ;           

               ps:P166 wd:Q103360 .       

    ?award wdt:P585 ?time .               

    SERVICE wikibase:label {              

        bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"

    }

}

ORDER BY DESC(?time)

# ID = 3,

# Question = Winner of the Academy Awards by Award and Time

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?item ?time ?itemLabel ?awardLabel WHERE{

  ?item wdt:P106/wdt:P279* wd:Q3455803.

  ?item p:P166 ?awardStat.

  ?awardStat pq:P805 ?award.

  ?awardStat ps:P166 wd:Q103360.

  ?award wdt:P585 ?time.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY DESC(?time)

OK

4.        

SELECT ?human ?humanLabel ?awardEditionLabel ?awardLabel ?awardWork ?awardWorkLabel ?director ?directorLabel ?time

WHERE

{

  {

    SELECT (SAMPLE(?human) AS ?human) ?award ?awardWork (SAMPLE(?director) AS ?director) (SAMPLE(?awardEdition) AS ?awardEdition) (SAMPLE(?time) AS ?time) WHERE {

      ?award wdt:P31 wd:Q19020 .

      {

        ?human p:P166 ?awardStat .            

        ?awardStat ps:P166 ?award .       

        ?awardStat pq:P805 ?awardEdition .

        ?awardStat pq:P1686 ?awardWork .

        ?human wdt:P31 wd:Q5 .

      } UNION {

        ?awardWork wdt:P31 wd:Q11424 .

        ?awardWork p:P166 ?awardStat .

        ?awardStat ps:P166 ?award .       

        ?awardStat pq:P805 ?awardEdition .

      }

      OPTIONAL {

        ?awardEdition wdt:P585 ?time .

        ?awardWork wdt:P57 ?director .

      }

    }

    GROUP BY ?awardWork ?award

  }

 

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .

  }

}

ORDER BY DESC(?time)

# ID = 4,

# Question = Academy award data

#

# Manually edited.

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?human ?awardWork ?director ?awardEdition ?time ?award ?humanLabel ?awardWorkLabel ?directorLabel ?awardEditionLabel ?awardLabel WHERE{

  {SELECT ?human ?awardStat ?award ?awardEdition ?awardWork (SAMPLE(?human) AS ?human) (SAMPLE(?awardEdition) AS ?awardEdition) (SAMPLE(?time) AS ?time) (SAMPLE(?director) AS ?director) WHERE{

    ?human wdt:P31 wd:Q5.

    {

      ?human wdt:P31 wd:Q5.

      ?human wdt:P31 wd:Q5.

      ?human p:P166 ?awardStat.

      ?awardStat ps:P166 ?award.

      ?awardStat pq:P805 ?awardEdition.

      ?awardStat pq:P1686 ?awardWork.

    }

    UNION

    {

      ?human wdt:P31 wd:Q5.

      ?awardWork wdt:P31 wd:Q11424.

      ?awardWork p:P166 ?awardStat.

      ?awardStat ps:P166 ?award.

      ?awardStat pq:P805 ?awardEdition.

    }

    OPTIONAL{

      ?awardWork wdt:P57 ?director.

      ?awardEdition wdt:P585 ?time.

    }}

    GROUP BY ?human ?awardStat ?award ?awardEdition ?awardWork

  }

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

Manually edited.

 

TO DO: UNION construction, UNIT as main class, OPTIONAL block under UNIT

 

Query is malformed: duplicate variable in projection: human

5.        

SELECT DISTINCT ?Person ?PersonLabel ?NobelPrizeLabel ?AcademyAwardLabel WHERE {

  ?NobelPrize wdt:P279?/wdt:P31? wd:Q7191 .

  ?AcademyAward wdt:P279?/wdt:P31? wd:Q19020 .

  ?Person wdt:P166? ?NobelPrize .             

  ?Person wdt:P166? ?AcademyAward .           

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .

  }

}

# ID = 5,

# Question = People that received both Academy Award and Nobel Prize

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?Person ?NobelPrizeLabel ?PersonLabel ?AcademyAwardLabel WHERE{

  ?NobelPrize wdt:P279?/wdt:P31? wd:Q7191.

  ?Person wdt:P166? ?NobelPrize.

  ?Person wdt:P166? ?AcademyAward.

  ?AcademyAward wdt:P279?/wdt:P31? wd:Q19020.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

6.        

SELECT ?awardCount ?award ?awardLabel WHERE {

  {

    SELECT (COUNT(?award) AS ?awardCount) ?award

    WHERE

    {

      {

        SELECT (SAMPLE(?human) AS ?human) ?award ?awardWork (SAMPLE(?director) AS ?director) (SAMPLE(?awardEdition) AS ?awardEdition) (SAMPLE(?time) AS ?time) WHERE {

          ?award wdt:P31 wd:Q19020 .     

          {

            ?human p:P166 ?awardStat .             

            ?awardStat ps:P166 ?award .       

            ?awardStat pq:P805 ?awardEdition .

            ?awardStat pq:P1686 ?awardWork .

            ?human wdt:P31 wd:Q5 .       

          } UNION {

            ?awardWork wdt:P31 wd:Q11424 .

            ?awardWork p:P166 ?awardStat .

            ?awardStat ps:P166 ?award .       

            ?awardStat pq:P805 ?awardEdition .

          }

          OPTIONAL {

            ?awardEdition wdt:P585 ?time .

            ?awardWork wdt:P57 ?director .

          }

        }

        GROUP BY ?awardWork ?award

      }

    } GROUP BY ?award

    ORDER BY ASC(?awardCount)

  }

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .

  }

}

# ID = 6,

# Question = Number of handed out academy awards per award type

#

# Manually edited

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?awardCount ?award ?awardLabel WHERE{

  {SELECT ?award (COUNT(?award) AS ?awardCount) WHERE{

    {SELECT ?award ?awardWork (SAMPLE(?human) AS ?human) (SAMPLE(?awardEdition) AS ?awardEdition) (SAMPLE(?time) AS ?time) (SAMPLE(?director) AS ?director) WHERE{

      ?award wdt:P31 wd:Q19020.

      {

        ?award wdt:P31 wd:Q19020.

        ?human wdt:P31 wd:Q5.

        ?human p:P166 ?awardStat.

        ?awardStat ps:P166 ?award.

        ?awardStat pq:P805 ?awardEdition.

        ?awardStat pq:P1686 ?awardWork.

      }

      UNION

      {

        ?award wdt:P31 wd:Q19020.

        ?awardWork wdt:P31 wd:Q11424.

        ?awardWork p:P166 ?awardStat.

        ?awardStat ps:P166 ?award.

        ?awardStat pq:P805 ?awardEdition.

      }

      OPTIONAL{

        ?awardEdition wdt:P585 ?time.

        ?awardWork wdt:P57 ?director.

      }}

      GROUP BY ?award ?awardWork

    }}

    GROUP BY ?award

  }

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

Manually edited.

 

TO DO: UNION construction, Multiple unit subqueries,

OPTIONAL block under unit

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

7.        

SELECT ?director ?director_label ?films ?sitelinks ((?films * ?sitelinks) as ?rank)

WHERE {

  {SELECT ?director (count(distinct ?film) as ?films) (count(distinct ?sitelink) as ?sitelinks)

     WHERE {

       ?director wdt:P106 wd:Q2526255 .        

       ?film wdt:P57 ?director .           

       ?sitelink schema:about ?director .      

       } GROUP BY ?director }

SERVICE wikibase:label {

  bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"

?director rdfs:label ?director_label

} ORDER BY DESC(?rank)

LIMIT 100

# ID = 7,

# Question = Film directors ranked by number of sitelinks multiplied by their number of films

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX schema: <http://schema.org/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?director ?films ?sitelinks ?rank WHERE{

  {SELECT ?director (COUNT(DISTINCT ?film) AS ?films) (COUNT(DISTINCT ?sitelink) AS ?sitelinks) WHERE{

    ?film wdt:P57 ?director.

    ?director wdt:P106 wd:Q2526255.

    ?sitelink schema:about ?director.}

    GROUP BY ?director

  }

  BIND(?films * ?sitelinks AS ?rank)

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".

    ?director rdfs:label ?director_label.

  }

 

}

ORDER BY DESC(?rank)

LIMIT 100

OK

8.        

SELECT ?show ?showLabel ?seasonNumber ?episode ?episodeLabel

WHERE {

  BIND(wd:Q886 as ?show) .

  ?season wdt:P361 ?show .

  ?episode wdt:P361 ?season .

  ?season p:P179 [

          pq:P1545 ?seasonNumber] .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

} ORDER BY xsd:integer(?seasonNumber)

# ID = 8,

# Question = The Simpsons television series episodes list by season

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?show ?seasonNumber ?episode ?showLabel ?episodeLabel WHERE{

  ?season p:P179 [ pq:P1545 ?seasonNumber].

  ?episode wdt:P361 ?season.

  ?season wdt:P361 ?show.

  BIND(wd:Q886 AS ?show)

 

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY xsd:integer(?seasonNumber)

OK

9.        

SELECT DISTINCT ?pokemon ?pokemonLabel ?pokedexNumber

WHERE

{

    ?pokemon wdt:P31/wdt:P279* wd:Q3966183 .

    ?pokemon p:P1685 ?statement.

    ?statement ps:P1685 ?pokedexNumber;

              pq:P972 wd:Q20005020.

    FILTER (! wikibase:isSomeValue(?pokedexNumber) )

    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

ORDER BY (?pokedexNumber)

# ID = 9,

# Question = Pokémon!

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?pokemon ?pokedexNumber ?pokemonLabel WHERE{

  ?pokemon wdt:P31/wdt:P279* wd:Q3966183.

  ?pokemon p:P1685 ?statement.

  ?statement pq:P972 wd:Q20005020.

  ?statement ps:P1685 ?pokedexNumber.

  FILTER(!wikibase:isSomeValue(?pokedexNumber))

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY ?pokedexNumber

OK

10.    

SELECT (SAMPLE(?seasonNumber) AS ?seasonNumber) (SAMPLE(?episodeNumber) AS ?episodeNumber) (SAMPLE(?title) AS ?title) (MIN(?pubDate) AS ?pubDate) ?episode

{

 

?episode wdt:P31 wd:Q21191270;

           wdt:P179 wd:Q321423.

  OPTIONAL {

    ?episode p:P179 [

      ps:P179/p:P179 [

        ps:P179 wd:Q321423;

                pq:P1545 ?seasonNumber

      ] ;

      pq:P1545 ?episodeNumber

    ]

  }

  OPTIONAL { ?episode wdt:P1476 ?title. }

  OPTIONAL { ?episode wdt:P577 ?pubDate. }

}

GROUP BY ?episode

ORDER BY IF(BOUND(?seasonNumber), xsd:integer(?seasonNumber), 1000) xsd:integer(?episodeNumber) ?title

# ID = 10,

# Question = Law & Order episodes

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX p: <http://www.wikidata.org/prop/>

SELECT ?episode (SAMPLE(?seasonNumber) AS ?seasonNumber) (SAMPLE(?episodeNumber) AS ?episodeNumber) (SAMPLE(?title) AS ?title) (MIN(?publication_date) AS ?pubDate) WHERE{

  ?episode wdt:P31 wd:Q21191270.

  ?episode wdt:P179 wd:Q321423.

  OPTIONAL{?episode wdt:P1476 ?title.}

  OPTIONAL{?episode wdt:P577 ?publication_date.}

  OPTIONAL{

    ?episode p:P179 _:name0. _:name0 pq:P1545 ?episodeNumber.

    _:name0 ps:P179/p:P179 _:name1. _:name1 pq:P1545 ?seasonNumber.

    _:name1 ps:P179 wd:Q321423.

  }

  BIND(xsd:integer(?seasonNumber) AS ?expr_0)

 

}

GROUP BY ?episode xsd:integer(?episodeNumber)

ORDER BY (IF(BOUND(?seasonNumber), ?expr_0, 1000))  xsd:integer(?episodeNumber)  ?title

OK

11.    

SELECT DISTINCT ?episode ?ordinal ?episodeLabel ?subject ?subjectLabel

WHERE {

  ?episode wdt:P31/wdt:P279* wd:Q1983062;

           p:P179 ?statement.

  OPTIONAL{ ?episode wdt:P921 ?subject }

  ?statement ps:P179 wd:Q3577037;

             pq:P1545 ?ordinal

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

} ORDER BY xsd:integer(?ordinal)

# ID = 11,

# Question = Main subjects of West Wing episodes

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?episode ?main_subject ?ordinal ?episodeLabel ?main_subjectLabel WHERE{

  ?episode wdt:P31/wdt:P279* wd:Q1983062.

  ?episode p:P179 ?statement.

  ?statement ps:P179 wd:Q3577037.

  OPTIONAL{?episode wdt:P921 ?main_subject.}

  ?statement pq:P1545 ?ordinal.

 

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY xsd:integer(?ordinal)

OK

12.    

SELECT ?item ?itemLabel (MIN(?date) AS ?firstReleased) ?image

WHERE {

  ?item wdt:P161 wd:Q221074;

        wdt:P577 ?date

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

  OPTIONAL { ?item wdt:P18 ?image. }

} GROUP BY ?item ?itemLabel ?image

ORDER BY (?date)

# ID = 12,

# Question = Movies with Bud Spencer

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?image (MIN(?date) AS ?firstReleased) ?itemLabel WHERE{

  ?item wdt:P161 wd:Q221074.

  ?item wdt:P577 ?date.

  OPTIONAL{?item wdt:P18 ?image.}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?item ?image ?itemLabel

ORDER BY ?date

OK

13.    

SELECT ?char ?charName (GROUP_CONCAT(DISTINCT ?typeLabel;separator=", ") AS ?types) (GROUP_CONCAT(DISTINCT ?universeLabel;separator=", ") AS ?universes)

WHERE {

  ?char wdt:P1080 wd:Q931597;

          wdt:P31 ?type ;

          wdt:P1080 ?universe .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".

     ?char rdfs:label ?charName .

     ?universe rdfs:label ?universeLabel .

     ?type rdfs:label ?typeLabel .}

} GROUP BY ?char ?charName

# ID = 13,

# Question = Fictional subjects of the Marvel Universe

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?char ?charName (GROUP_CONCAT(DISTINCT ?typeLabel; SEPARATOR=', ') AS ?types) (GROUP_CONCAT(DISTINCT ?universeLabel; SEPARATOR=', ') AS ?universes) WHERE{

  ?char wdt:P1080 wd:Q931597.

  ?char wdt:P31 ?type.

  ?char wdt:P1080 ?universe.

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".

    ?char rdfs:label ?charName.

    ?universe rdfs:label ?universeLabel.

    ?type rdfs:label ?typeLabel.

  }

 

}

GROUP BY ?char ?charName

OK

14.    

SELECT ?item ?itemLabel ?itemDescription (SAMPLE(?img) AS ?image) (SAMPLE(?dob) AS ?dob) ?sl

WHERE {

  ?item wdt:P106 wd:Q33999 ;

          wdt:P27 wd:Q668 ;

          wdt:P21 wd:Q6581072 .

  MINUS { ?item wdt:P570 [] }

  OPTIONAL { ?item wdt:P18 ?img }

  OPTIONAL { ?item wdt:P569 ?dob }

  OPTIONAL { ?item wikibase:sitelinks ?sl }

    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en"}

} GROUP BY ?item ?itemLabel ?itemDescription ?sl

ORDER BY DESC(?sl)

# ID = 14,

# Question = Contemporary Indian actresses

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?sl (SAMPLE(?image) AS ?image) (SAMPLE(?date_of_birth) AS ?dob) ?itemLabel ?itemDescription WHERE{

  ?item wdt:P106 wd:Q33999.

  ?item wdt:P27 wd:Q668.

  ?item wdt:P21 wd:Q6581072.

  OPTIONAL{?item wikibase:sitelinks ?sl.}

  OPTIONAL{?item wdt:P18 ?image.}

  OPTIONAL{?item wdt:P569 ?date_of_birth.}

  MINUS{

      ?item wdt:P570 [].

  }

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?item ?sl ?itemLabel ?itemDescription

ORDER BY DESC(?sl)

OK

15.    

SELECT ?sitelink

WHERE

{

    ?item wdt:P21 wd:Q6581072 .

    { ?item wdt:P27 wd:Q843 }

    { ?item wdt:P106 wd:Q33999 }

    { ?sitelink schema:about ?item . ?sitelink schema:inLanguage "pa" }

    ?item wdt:P31 wd:Q5 .

}

LIMIT 5000

# ID = 15,

# Question = Articles on Punjabi (Gurmukhi) Wikipedia about Pakistani actresses

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX schema: <http://schema.org/>

SELECT ?sitelink WHERE{

  ?item wdt:P31 wd:Q5.

  ?item wdt:P21 wd:Q6581072.

  ?item wdt:P27 wd:Q843.

  ?item wdt:P106 wd:Q33999.

  ?sitelink schema:about ?item.

  ?sitelink schema:inLanguage "pa" .

}

LIMIT 5000

OK

16.    

SELECT ?doctor ?doctorLabel ?ordinal ?performer ?performerLabel

WHERE {

  ?doctor wdt:P31 wd:Q47543030 .

  OPTIONAL { ?doctor wdt:P1545 ?ordinal }

  OPTIONAL { ?doctor p:P175 / ps:P175 ?performer }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

ORDER BY ASC(xsd:integer(?ordinal) )

# ID = 16,

# Question = All Dr. Who performers

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?doctor ?ordinal ?performer ?doctorLabel ?performerLabel WHERE{

  ?doctor wdt:P31 wd:Q47543030.

  OPTIONAL{?doctor wdt:P1545 ?ordinal.}

  OPTIONAL{

    ?doctor p:P175/ps:P175 ?performer.

  }

 

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

ORDER BY xsd:integer(?ordinal)

OK

17.    

SELECT ?movie ?movieLabel ?narrative_location ?narrative_locationLabel ?coordinates WHERE {

   ?movie wdt:P840 ?narrative_location ;

          wdt:P31 wd:Q11424 .

   ?narrative_location wdt:P625 ?coordinates .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

# ID = 17,

# Question = Movies and their narrative location on a map

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?movie ?narrative_location ?coordinate_location ?movieLabel ?narrative_locationLabel WHERE{

  ?movie wdt:P31 wd:Q11424.

  ?movie wdt:P840 ?narrative_location.

  ?narrative_location wdt:P625 ?coordinate_location.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

18.    

SELECT DISTINCT ?item ?itemLabel WHERE {

  ?item wdt:P31 wd:Q11424.

  ?item wdt:P577 ?pubdate.

  FILTER((?pubdate >= "2017-01-01T00:00:00Z"^^xsd:dateTime) && (?pubdate <= "2017-12-31T00:00:00Z"^^xsd:dateTime))

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

# ID = 18,

# Question = Movies released in 2017

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?item ?itemLabel WHERE{

  ?item wdt:P31 wd:Q11424.

  ?item wdt:P577 ?pubdate.

  FILTER(?pubdate >= "2017-01-01T00:00:00Z"^^xsd:dateTime && ?pubdate <= "2017-12-31T00:00:00Z"^^xsd:dateTime)

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

19.    

SELECT DISTINCT ?human ?humanLabel

WHERE

{

    VALUES ?professions {wd:Q177220 wd:Q639669}

    ?human wdt:P31 wd:Q5 .

    ?human wdt:P106 ?professions .

    ?human wdt:P136 ?genre .

    ?human wikibase:statements ?statementcount .

    ?genre rdfs:label ?genreLabel

    FILTER CONTAINS(?genreLabel, "rock") .

    FILTER (?statementcount > 50 ) .

    SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }

}

ORDER BY ?humanLabel

LIMIT 50

# ID = 19,

# Question = Musicians or singers that have a genre containing 'rock'

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?human ?humanLabel WHERE{

  ?human wdt:P31 wd:Q5.

  ?human wdt:P106 ?professions.

  ?human wdt:P136 ?genre.

  ?human wikibase:statements ?statements.

  VALUES ?professions {wd:Q177220 wd:Q639669}

  ?genre rdfs:label ?label.

  FILTER(?statements > 50)

  FILTER(CONTAINS(?label, "rock"))

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

ORDER BY ?humanLabel

LIMIT 50

OK

20.    

SELECT DISTINCT ?character ?characterLabel  ?birth ?death WITH {

  SELECT ?fictiontype WHERE {

    ?fictiontype wdt:P279* wd:Q95074. hint:Prior hint:gearing "forward".

  }

} AS %i

WHERE

{

  INCLUDE %i

  ?character wdt:P31 ?fictiontype.

  { ?character wdt:P569 ?birth . }

  UNION { ?character wdt:P570 ?death . }

  BIND(xsd:integer(YEAR(NOW())/10) as ?actual_decade).

  FILTER(xsd:integer(YEAR(?birth)/10) = ?actual_decade || xsd:integer(YEAR(?death)/10) = ?actual_decade)

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .

  }

} ORDER BY ?birth ?death

 

 

Unsupported construction:

INCLUDE %i

 

Computer Science and Technology

1.        

SELECT DISTINCT ?idExtension ?extension ?mediaType ?idExtensionLabel

WHERE

{

  ?idExtension wdt:P31 wd:Q235557;

               wdt:P1195 ?extension .

  OPTIONAL { ?idExtension wdt:P1163 ?mediaType }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }

}

ORDER BY ?extension ?mediaType

# ID = 1,

# Question = List of computer files formats

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?idExtension ?extension ?mediaType ?idExtensionLabel WHERE{

  ?idExtension wdt:P31 wd:Q235557.

  ?idExtension wdt:P1195 ?extension.

  OPTIONAL{?idExtension wdt:P1163 ?mediaType.}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

ORDER BY ?extension  ?mediaType

OK

2.        

SELECT DISTINCT ?standard ?standardLabel ?website

WHERE

{

        ?standard wdt:P1462 wd:Q37033 .

        OPTIONAL{ ?standard wdt:P856 ?website }

        SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }

}

ORDER BY ?standardLabel

# ID = 2,

# Question = List of W3C standards

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?standard ?official_website ?standardLabel WHERE{

  ?standard wdt:P1462 wd:Q37033.

  OPTIONAL{?standard wdt:P856 ?official_website.}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

ORDER BY ?standardLabel

OK

3.        

SELECT ?software ?softwareLabel ?date (ROUND((NOW() - ?date)/365.2425) AS ?age)

{

  ?software wdt:P31/wdt:P139* wd:Q7397.

  OPTIONAL { ?software wdt:P571 ?date. }

  OPTIONAL { ?software p:P348/pq:P577 ?date. }

  FILTER(BOUND(?date)).

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

ORDER BY ?date

LIMIT 10

# ID = 3,

# Question = Oldest software

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?software ?date ?age ?softwareLabel WHERE{

  ?software wdt:P31/wdt:P139* wd:Q7397.

  OPTIONAL{?software wdt:P571 ?date.}

  OPTIONAL{

    ?software p:P348/pq:P577 ?date.

  }

  BIND(ROUND(xsd:decimal((NOW()-?date))/xsd:decimal("365.2425"^^xsd:decimal)) AS ?age)

  FILTER(BOUND(?date))

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

ORDER BY ?date

LIMIT 10

OK

 

4.        

SELECT DISTINCT ?instance_of ?instance_ofDescription ?instance_ofLabel ?official_website WHERE {

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

  ?instance_of (wdt:P31/(wdt:P279*)) wd:Q341.

  OPTIONAL { ?instance_of wdt:P856 ?official_website. }

  ?instance_of wdt:P277 wd:Q37227.

}

# ID = 4,

# Question = Software written in Go programming language

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?instance_of ?official_website ?instance_ofLabel ?instance_ofDescription WHERE{

  ?instance_of wdt:P31/wdt:P279* wd:Q341.

  ?instance_of wdt:P277 wd:Q37227.

  OPTIONAL{?instance_of wdt:P856 ?official_website.}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

5.        

SELECT DISTINCT ?instance_of ?instance_ofDescription ?instance_ofLabel ?official_website WHERE {

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

  ?instance_of wdt:P31/wdt:P279* wd:Q341

  OPTIONAL { ?instance_of wdt:P856 ?official_website. }

  ?instance_of wdt:P277 wd:Q37227.

}

# ID = 5,

# Question = Free and open-source software written in Go programming language

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?instance_of ?official_website ?instance_ofLabel ?instance_ofDescription WHERE{

  ?instance_of wdt:P31/wdt:P279* wd:Q341.

  ?instance_of wdt:P277 wd:Q37227.

  OPTIONAL{?instance_of wdt:P856 ?official_website.}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

6.        

SELECT ?lang ?langLabel ?human ?humanLabel ?educatedat ?educatedatLabel ?coords

{

  ?lang wdt:P31/wdt:P279* wd:Q9143 .

  ?human wdt:P31 wd:Q5 .

  { ?lang wdt:P287 ?human }

  UNION

  { ?lang wdt:P170 ?human }

  UNION

  { ?lang wdt:P943 ?human }

  UNION

  { ?lang wdt:P178 ?human } .

 

  ?human wdt:P69 ?educatedat .

  ?educatedat wdt:P625 ?coords .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en,fr" }

}

LIMIT 100

# ID = 6,

# Question = Universities of main programming language authors

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?lang ?human ?educatedat ?coordinate_location ?langLabel ?humanLabel ?educatedatLabel WHERE{

  ?lang wdt:P31/wdt:P279* wd:Q9143.

  ?human wdt:P31 wd:Q5.

  ?lang wdt:P287|wdt:P170|wdt:P943|wdt:P178 ?human.

  ?human wdt:P69 ?educatedat.

  ?educatedat wdt:P625 ?coordinate_location.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en,fr" .}

}

LIMIT 100

OK

 

7.        

SELECT ?database ?databaseLabel ?license ?licenseLabel ?value WHERE {

  ?database ?p ?wds .

  OPTIONAL { ?database wdt:P275 ?license }

  ?wds ?v ?value.

  ?wdP wikibase:statementProperty ?v.

  ?wdP wikibase:claim ?p.

  ?wds pq:P31 wd:Q27075870.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

} ORDER BY ASC(?databaseLabel)

 

# ID = 7,

# Question = Websites with OpenAPI endpoints

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?database ?copyright_license ?databaseLabel ?copyright_licenseLabel WHERE{

  ?database ?p ?wds.

  ?wds pq:P31 wd:Q27075870.

  OPTIONAL{?database wdt:P275 ?copyright_license.}

  ?wds ?v ?value.

  ?wdP wikibase:statementProperty ?v.

  ?wdP wikibase:claim ?p.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

ORDER BY ?databaseLabel

OK

8.        

SELECT ?ereader ?ereaderLabel

 

WHERE {

  ?ereader wdt:P31  wd:Q726235 .

  ?ereader wdt:P1072 wd:Q1941622 .

 

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "en" .

  

}

  }

# ID = 8,

# Question = E-Readers that support the mobipocket file format

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?ereader ?ereaderLabel WHERE{

  ?ereader wdt:P31 wd:Q726235.

  ?ereader wdt:P1072 wd:Q1941622.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

OK

9.        

SELECT ?app ?appLabel (COUNT(?format) AS ?count)

WHERE {

  ?app (p:P31/ps:P31/wdt:P279) wd:Q7397 .

  ?app wdt:P1072 ?format .

           

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "en" .

  }

}

 

GROUP BY ?app ?appLabel

ORDER BY DESC(?count)

 

# ID = 9,

# Question = Software applications ranked in descending order by the number of writable file formats

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?app (COUNT(?format) AS ?count) ?appLabel WHERE{

  ?app wdt:P1072 ?format.

  ?app p:P31/ps:P31/wdt:P279 wd:Q7397.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

GROUP BY ?app ?appLabel

ORDER BY DESC(?count)

OK

10.    

SELECT DISTINCT ?mediaType (COUNT (?ff) as ?count)

WHERE

{

  ?ff wdt:P31/wdt:P279* wd:Q235557.

  ?ff wdt:P1163 ?mediaType.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }

}

 

GROUP BY ?mediaType

ORDER BY DESC (?count)

# ID = 10,

# Question = Return a bubble chart of mediatypes by count of file formats

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?mediaType (COUNT(?ff) AS ?count) WHERE{

  ?ff wdt:P31/wdt:P279* wd:Q235557.

  ?ff wdt:P1163 ?mediaType.

}

GROUP BY ?mediaType

ORDER BY DESC(?count)

OK

11.    

SELECT  ?personLabel  ?image ?Erdos

 

WHERE {

  ?person wdt:P485 wd:Q964035 .

  ?person wdt:P18 ?image .

  ?person wdt:P2021 ?Erdos

  SERVICE wikibase:label {

    bd:serviceParam wikibase:language "en" .

  }

}

 

# ID = 11,

# Question = Erdos Numbers and images of people who have oral histories in the Computer History Museum's collection

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?image ?Erds_number ?personLabel WHERE{

  ?person wdt:P485 wd:Q964035.

  ?person wdt:P18 ?image.

  ?person wdt:P2021 ?Erds_number.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

OK

 

Biology and Medicine

1.        

SELECT ?disease ?doid ?enLabel (count(?language) as ?languages)

WHERE

{

  ?disease wdt:P699 ?doid ;

           rdfs:label ?label ;

           rdfs:label ?enLabel .

    FILTER (lang(?enLabel) = "en")

    BIND (lang(?label) AS ?language)

}

group by ?disease ?doid ?enLabel

order by desc(?languages)

# ID = 1,

# Question = The number of existing translations for diseases in Wikidata

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

SELECT ?disease ?doid ?enLabel (COUNT(?language) AS ?languages) WHERE{

  ?disease wdt:P699 ?doid.

  ?disease rdfs:label ?enLabel.

  ?disease rdfs:label ?label_1.

  BIND(LANG(?label_1) AS ?language)

  FILTER(LANG(?enLabel) = "en")

}

GROUP BY ?disease ?doid ?enLabel

ORDER BY DESC(?languages)

OK

2.        

SELECT DISTINCT ?item ?itemLabel ?rgb ?link

WHERE

{

  VALUES ?toggle { true false }

  ?disease wdt:P699 ?doid;

           wdt:P279+ wd:Q18123741;

           wdt:P2176 ?drug.

  ?drug rdfs:label ?drugLabel.

    FILTER(LANG(?drugLabel) = "en").

  ?disease rdfs:label ?diseaseLabel.

    FILTER(LANG(?diseaseLabel) = "en").

  BIND(IF(?toggle,?disease,?drug) AS ?item).

  BIND(IF(?toggle,?diseaseLabel,?drugLabel) AS ?itemLabel).

  BIND(IF(?toggle,"FFA500","7FFF00") AS ?rgb).

  BIND(IF(?toggle,"",?disease) AS ?link).

}

# ID = 2,

# Question = A network of Drug-disease interactions on infectious diseases (Source: Disease Ontology, NDF-RT and ChEMBL)

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT DISTINCT ?item ?itemLabel ?rgb ?link WHERE{

  ?disease wdt:P279+ wd:Q18123741.

  ?disease wdt:P2176 ?drug.

  ?disease wdt:P699 ?Disease_Ontology_ID.

  ?disease rdfs:label ?diseaseLabel.

  VALUES ?toggle {true false}

  ?drug rdfs:label ?drugLabel.

  BIND(IF(?toggle, ?disease, ?drug) AS ?item)

  BIND(IF(?toggle, ?diseaseLabel, ?drugLabel) AS ?itemLabel)

  BIND(IF(?toggle, "FFA500", "7FFF00") AS ?rgb)

  BIND(IF(?toggle, "", ?disease) AS ?link)

  FILTER(LANG(?diseaseLabel) = "en")

  FILTER(LANG(?drugLabel) = "en")

}

OK

3.        

SELECT (COUNT(?disease) AS ?total) (SUM(?ref) AS ?byDO) (100*?byDO/?total AS ?percent)

WHERE

{

  {?disease wdt:P31 wd:Q12136 }

  UNION

  {?disease wdt:P279 wd:Q12136 .}

  OPTIONAL {

    ?disease p:P699 ?statement.

    BIND(1 AS ?ref).

  }

}

# ID = 3,

# Question = The number of Wikidata items on Diseases and the percentage of those with a pointer to the Disease Ontology,

#

# Manually edited

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX p: <http://www.wikidata.org/prop/>

SELECT ?percent (COUNT(?disease) AS ?total) (SUM(?ref) AS ?byDO) WHERE{

  {

    ?disease wdt:P31 wd:Q12136.

  }

  UNION

  {

    wd:Q12136 wdt:P279 ?disease.

  }

  OPTIONAL{

    ?disease p:P699 ?statement.

    BIND(1 AS ?ref)

  }

  BIND(xsd:decimal((100 * ?byDO))/xsd:decimal(?total) AS ?percent)

}

GROUP BY ?percent

Manually edited.

 

TO DO: to add UNIT class as main, UNION block, OPTIONAL block

 

4.        

SELECT DISTINCT ?item ?ncbi_gene ?date_modified

WHERE

{

  ?item wdt:P351 ?ncbi_gene ;

          wdt:P703 wd:Q15978631 ;

          schema:dateModified ?date_modified .

    BIND (now() - ?date_modified as ?date_range)

    FILTER (?date_range < 8)

}

# ID = 4,

# Question = Human genes updated this week

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX schema: <http://schema.org/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT DISTINCT ?item ?Entrez_Gene_ID ?date_modified WHERE{

  ?item wdt:P703 wd:Q15978631.

  ?item wdt:P351 ?Entrez_Gene_ID.

  ?item schema:dateModified ?date_modified.

  BIND(NOW()-?date_modified AS ?date_range)

  FILTER(?date_range < 8)

}

OK

5.        

SELECT  ?variant_typeLabel (count(?variant_typeLabel) as ?counts)

WHERE

{

  ?item wdt:P3329 ?civic_id ;

        wdt:P31 ?variant_type .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

GROUP BY ?variant_typeLabel

ORDER BY ?counts

# ID = 5,

# Question = Counts of gene-variant types sourced from the CIViC database

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT (COUNT(?variant_typeLabel) AS ?counts) ?variant_typeLabel WHERE{

  ?item wdt:P3329 ?CIViC_variant_ID.

  ?item wdt:P31 ?variant_type.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?variant_typeLabel

ORDER BY ?counts

OK

6.        

SELECT ?geneLabel ?variantLabel

WHERE

{

  VALUES ?disease {wd:Q188874}

  ?variant wdt:P3358 ?disease ;

           wdt:P3433 ?gene .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

# ID = 6,

# Question = Which variant of which gene predicts a positive prognosis in colorectal cancer

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?variantLabel ?biological_variant_ofLabel WHERE{

  ?variant wdt:P3358 ?disease.

  ?variant wdt:P3433 ?biological_variant_of.

  VALUES ?disease {wd:Q188874}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

7.        

SELECT DISTINCT ?civic_id ?item ?itemLabel

WHERE

{

  VALUES ?property {

     wdt:P3356

     wdt:P3357

     wdt:P3358

     wdt:P3359

  }

  ?item wdt:P3329 ?civic_id .

  {?item  ?property wd:Q1164529.}

  UNION

  {?item p:P3354 ?o .

    ?o pq:P2175 wd:Q1164529 .}

  UNION

  {?item p:P3354 ?o .

     ?o pq:P2175 wd:Q1164529 .}

    

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

# ID = 7,

# Question = Variants that are associated with renal cell carcinoma

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX pq: <http://www.wikidata.org/prop/qualifier/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?item ?CIViC_variant_ID ?itemLabel WHERE{

  {

    ?item ?property wd:Q1164529.

  }

  UNION

  {

    ?item p:P3354 ?o.

    ?o pq:P2175 wd:Q1164529.

  }

  UNION

  {

    ?item p:P3354 ?o.

    ?o pq:P2175 wd:Q1164529.

  }

  ?item wdt:P3329 ?CIViC_variant_ID.

  VALUES ?property {wdt:P3356 wdt:P3357 wdt:P3358 wdt:P3359}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

8.        

SELECT DISTINCT  ?reference ?referenceLabel ?pmid

WHERE

{

  ?item wdt:P3329 ?civicId ;

        ?property  ?object .

  ?object prov:wasDerivedFrom ?provenance .

  ?provenance pr:P248 ?reference .

  ?reference wdt:P31 wd:Q13442814 ;

             wdt:P698 ?pmid .

  

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

# ID = 8,

# Question = PubMed references in CIViCdb

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX pr: <http://www.wikidata.org/prop/reference/>

PREFIX prov: <http://www.w3.org/ns/prov#>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?reference ?PubMed_ID ?referenceLabel WHERE{

  ?reference wdt:P31 wd:Q13442814.

  ?item ?property ?object.

  ?object prov:wasDerivedFrom ?provenance.

  ?provenance pr:P248 ?reference.

  ?item wdt:P3329 ?CIViC_variant_ID.

  ?reference wdt:P698 ?PubMed_ID.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

9.        

SELECT  ?propertyLabel (count(?prognostic_type) as ?counts)

WHERE

{

  VALUES ?prognostic_type {wdt:P3354 wdt:P3355 wdt:P3356 wdt:P3357 wdt:P3358 wdt:P3359}

    ?item wdt:P3329 ?civic_id ;

          ?prognostic_type ?prognostic_value .

    ?property wikibase:directClaim ?prognostic_type .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }

}

GROUP BY ?propertyLabel ?prognostic_typeLabel

ORDER BY ?counts

# ID = 9,

# Question = Variant counts by predictor type

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT (COUNT(?prognostic_type) AS ?counts) ?propertyLabel WHERE{

  ?property wikibase:directClaim ?prognostic_type.

  VALUES ?prognostic_type {wdt:P3354 wdt:P3355 wdt:P3356 wdt:P3357 wdt:P3358 wdt:P3359}

  ?item wdt:P3329 ?CIViC_variant_ID.

  ?item ?prognostic_type ?prognostic_value.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?propertyLabel

ORDER BY ?counts

OK

10.    

SELECT ?item ?itemLabel ?uniprotid

WHERE

{

  ?item wdt:P352 ?uniprotid ;

        wdt:P703 wd:Q15978631 .

  

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }

}

# ID = 10,

# Question = Get Wikidata - UniprotId mappings for homo sapiens

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?UniProt_protein_ID ?itemLabel WHERE{

  ?item wdt:P703 wd:Q15978631.

  ?item wdt:P352 ?UniProt_protein_ID.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

OK

11.    

PREFIX pr: <http://www.wikidata.org/prop/reference/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX prov: <http://www.w3.org/ns/prov#>

 

SELECT ?compound ?compoundLabel ?speciesLabel ?sourceLabel ?doi ?wpid WHERE {

  ?compound wdt:P31 wd:Q11173.

  MINUS { ?compound wdt:P31 wd:Q8054. }

  ?compound p:P703 ?statement.

  ?statement rdf:type wikibase:BestRank.

  ?statement ps:P703 ?species.

  OPTIONAL {

    ?statement (prov:wasDerivedFrom/pr:P248) ?source.

    OPTIONAL { ?source wdt:P2410 ?wpid. }

    OPTIONAL { ?source wdt:P356 ?doi. }

  }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

ORDER BY ASC(?compound)

# ID = 11,

# Question = Metabolites and the species where they are found in

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX ps: <http://www.wikidata.org/prop/statement/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX prov: <http://www.w3.org/ns/prov#>

PREFIX pr: <http://www.wikidata.org/prop/reference/>

PREFIX p: <http://www.wikidata.org/prop/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?compound ?WikiPathways_ID ?DOI ?compoundLabel ?found_in_taxonLabel ?sourceLabel WHERE{

  ?compound wdt:P31 wd:Q11173.

  ?compound p:P703 ?statement.

  ?statement rdf:type wikibase:BestRank.

  ?statement ps:P703 ?found_in_taxon.

  OPTIONAL{

    ?statement prov:wasDerivedFrom/pr:P248 ?source.

    OPTIONAL{?source wdt:P2410 ?WikiPathways_ID.}

    OPTIONAL{?source wdt:P356 ?DOI.}

  }

  MINUS{

      ?compound wdt:P31 wd:Q8054.

  }

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

ORDER BY ?compound

OK

 

Timeout, both queries

12.    

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wp:    <http://vocabularies.wikipathways.org/wp#>

PREFIX dcterms: <http://purl.org/dc/terms/>

SELECT DISTINCT ?wpid ?metaboliteLabel ?pKa ?pKa2 ?metabolite2Label ?wpid2

WITH {

  SELECT ?wpid ?source_pathway ?metabolite ?pKa ?pKa2 ?metabolite2 ?wpid2

  WHERE {

    ?pathway wdt:P2410 ?wpid ;

             wdt:P527 ?metabolite ;

             wdt:P2888 ?source_pathway .

    ?metabolite wdt:P1117 ?pKa .

 

    SERVICE <http://sparql.wikipathways.org/sparql> {

      ?wp_mb1 wp:bdbWikidata ?metabolite .

      ?wp_mb1 dcterms:isPartOf ?interaction .

      ?interaction rdf:type wp:Interaction .

      ?wp_mb2 dcterms:isPartOf ?interaction .

      ?wp_mb2 wp:bdbWikidata ?metabolite2 .

      FILTER (?wp_mb1 != ?wp_mb2)

    }

  }

} AS %result

WHERE {

  INCLUDE %result

  ?metabolite2 wdt:P1117 ?pKa2 .

  ?pathway2 wdt:P2410 ?wpid2 ;

             wdt:P527 ?metabolite2 ;

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

 

 

Unsupported construction:

 

WITH {…} AS %result

 

INCLUDE %i

13.    

PREFIX gas: <http://www.bigdata.com/rdf/gas#>

 

SELECT ?item ?itemLabel ?pic ?linkTo

WHERE

{

  SERVICE gas:service {

    gas:program gas:gasClass "com.bigdata.rdf.graph.analytics.SSSP" ;

               gas:in wd:Q1968598;

               gas:traversalDirection "Reverse";

               gas:out ?item ;

               gas:out1 ?depth ;

               gas:maxIterations 3 ;

               gas:linkType wdt:P171 .

  }

  OPTIONAL { ?item wdt:P171 ?linkTo }

  OPTIONAL { ?item wdt:P18 ?pic }

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }

}

# ID = 13,

# Question = Asterophryinae parent taxon reverse graph

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?parent_taxon ?image ?itemLabel WHERE{

  SERVICE <http://www.bigdata.com/rdf/gas#service> {

      <http://www.bigdata.com/rdf/gas#program> <http://www.bigdata.com/rdf/gas#out> ?item.

      <http://www.bigdata.com/rdf/gas#program> <http://www.bigdata.com/rdf/gas#in> wd:Q1968598.

      <http://www.bigdata.com/rdf/gas#program> <http://www.bigdata.com/rdf/gas#out1> ?depth.

      <http://www.bigdata.com/rdf/gas#program> <http://www.bigdata.com/rdf/gas#linkType> wdt:P171.

      <http://www.bigdata.com/rdf/gas#program> <http://www.bigdata.com/rdf/gas#maxIterations> 3 .

      <http://www.bigdata.com/rdf/gas#program> <http://www.bigdata.com/rdf/gas#gasClass> "com.bigdata.rdf.graph.analytics.SSSP" .

      <http://www.bigdata.com/rdf/gas#program> <http://www.bigdata.com/rdf/gas#traversalDirection> "Reverse" .

    }

  OPTIONAL{?item wdt:P171 ?parent_taxon.}

  OPTIONAL{?item wdt:P18 ?image.}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

OK

14.    

SELECT ?pathway ?pathwayLabel ?wpid WHERE {

   ?pathway wdt:P2410 ?wpid ;

            wdt:P703 wd:Q15978631 .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

# ID = 14,

# Question = All human pathways from Wikipathways

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?pathway ?WikiPathways_ID ?pathwayLabel WHERE{

  ?pathway wdt:P703 wd:Q15978631.

  ?pathway wdt:P2410 ?WikiPathways_ID.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

OK

15.    

prefix void<http://rdfs.org/ns/void#>

prefix pav:   <http://purl.org/pav/>

prefix xsd:   <http://www.w3.org/2001/XMLSchema#>

prefix freq<http://purl.org/cld/freq/>

prefix biopax: <http://www.biopax.org/release/biopax-level3.owl#>

prefix skos<http://www.w3.org/2004/02/skos/core#>

prefix rdfs<http://www.w3.org/2000/01/rdf-schema#>

prefix rdf:   <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

prefix gpml<http://vocabularies.wikipathways.org/gpml#>

prefix wp:    <http://vocabularies.wikipathways.org/wp#>

prefix dcterms: <http://purl.org/dc/terms/>

prefix wprdf: <http://rdf.wikipathways.org/>

prefix prov<http://www.w3.org/ns/prov#>

prefix foaf<http://xmlns.com/foaf/0.1/>

prefix dc:    <http://purl.org/dc/elements/1.1/>

 

SELECT DISTINCT ?biomarkerLabel ?proteinLabel ?geneID ?WP_gene ?PathwayID ?PathwayName

WHERE {

  VALUES ?biomarker {wd:Q420633 wd:Q27125809 wd:Q422462}

  ?biomarker wdt:P31 wd:Q11173.

  ?biomarker wdt:P638 ?pdbID

  ?protein wdt:P31 wd:Q8054 .

  ?protein wdt:P638 ?pdbID .

  ?protein wdt:P702 ?gene .

  ?gene wdt:P703 wd:Q15978631 .

  ?gene wdt:P2888 ?geneID .

    BIND(                     

        IRI(                  

          CONCAT(             

               "https",       

               SUBSTR(        

                 STR(?geneID),

                 5)           

        )) AS ?newIRI

    )

   

  SERVICE <http://sparql.wikipathways.org/sparql> {

     ?WP_pathway a wp:Pathway .

     ?WP_pathway wp:organismName "Homo sapiens".

     ?WP_pathway dc:identifier ?PathwayID .

     ?WP_pathway dc:title ?PathwayName .

     ?WP_gene a wp:Protein .

     ?WP_gene wp:bdbEntrezGene ?newIRI .

     ?WP_gene dcterms:isPartOf ?WP_pathway .

   }

 OPTIONAL{?biomarker rdfs:label ?biomarkerLabel.

 FILTER(LANG(?biomarkerLabel) = "en").

}

OPTIONAL {?protein rdfs:label ?proteinLabel.

FILTER(LANG(?proteinLabel) = "en").

}

}

ORDER BY DESC (?biomarkerLabel)

# ID = 15,

# Question = Biomarkers in Wikidata which interact with proteins in human pathways from Wikipathways

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 dc: <http://purl.org/dc/elements/1.1/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX dct: <http://purl.org/dc/terms/>

SELECT DISTINCT ?biomarkerLabel ?WP_gene ?identifier ?title ?proteinLabel ?geneID WHERE{

  ?biomarker wdt:P31 wd:Q11173.

  ?protein wdt:P31 wd:Q8054.

  SERVICE <http://sparql.wikipathways.org/sparql> {

      ?WP_pathway rdf:type <http://vocabularies.wikipathways.org/wp#Pathway>.

      ?WP_gene dct:isPartOf ?WP_pathway.

      ?WP_gene rdf:type <http://vocabularies.wikipathways.org/wp#Protein>.

      ?WP_gene <http://vocabularies.wikipathways.org/wp#bdbEntrezGene> ?newIRI.

      ?WP_pathway dc:identifier ?identifier.

      ?WP_pathway dc:title ?title.

      ?WP_pathway <http://vocabularies.wikipathways.org/wp#organismName> "Homo sapiens" .

    }

  ?protein wdt:P702 ?gene.

  ?gene wdt:P703 wd:Q15978631.

  ?gene wdt:P2888 ?geneID.

  ?biomarker wdt:P638 ?pdbID.

  VALUES ?biomarker {wd:Q420633 wd:Q27125809 wd:Q422462}

  OPTIONAL{?biomarker rdfs:label ?biomarkerLabel. FILTER(LANG(?biomarkerLabel) = 'en')}

  ?protein wdt:P638 ?pdbID.

  OPTIONAL{?protein rdfs:label ?proteinLabel. FILTER(LANG(?proteinLabel) = 'en')}

  BIND(IRI(CONCAT("https", SUBSTR(STR(?geneID), 5))) AS ?newIRI)

}

ORDER BY DESC(?biomarkerLabel)

OK

16.    

SELECT ?citation ?citationLabel (count(?pathway) as ?times_cited) WHERE {

  ?pathway wdt:P2410 ?WikiPathwaysID ;

           wdt:P2860 ?citation .

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

  }

GROUP BY ?pathway ?citation ?citationLabel

# ID = 16,

# Question = Ranking of most cited work in WikiPathways

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?citation (COUNT(?pathway) AS ?times_cited) ?citationLabel WHERE{

  ?pathway wdt:P2410 ?WikiPathways_ID.

  ?pathway wdt:P2860 ?citation.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

GROUP BY ?pathway ?citation ?citationLabel

OK

17.    

SELECT ?path ?genes ?metabolites ?pathway WHERE {

  {SELECT DISTINCT ?path (COUNT(?pwPart) AS ?genes) WHERE {

      ?path wdt:P2410 ?WikipathsID.

      ?path wdt:P527 ?pwPart.

      ?pwPart wdt:P31 wd:Q7187.

      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

    }

    GROUP BY ?path ?genes

  }

  {SELECT DISTINCT ?path (COUNT(?pwPart) AS ?metabolites) WHERE {

      ?path wdt:P2410 ?WikipathsID.

      ?path wdt:P527 ?pwPart.

      ?pwPart wdt:P31 wd:Q11173.

      SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

    }

    GROUP BY ?path ?metabolites

  }

  OPTIONAL { ?path rdfs:label ?pathway. }

}

ORDER BY DESC(?genes)

# ID = 17,

# Question = Gene and metabolite counts per pathway

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?path ?label ?genes ?metabolites WHERE{

  {SELECT ?path (COUNT(?pwPart) AS ?genes) WHERE{

    ?pwPart wdt:P31 wd:Q7187.

    ?path wdt:P527 ?pwPart.}

    GROUP BY ?path ?genes

  }

  {SELECT ?path (COUNT(?pwPart) AS ?metabolites) WHERE{

    ?pwPart wdt:P31 wd:Q11173.

    ?path wdt:P527 ?pwPart.}

    GROUP BY ?path ?metabolites

  }

  OPTIONAL{?path rdfs:label ?label.}

}

ORDER BY DESC(?genes)

OK

18.    

SELECT ?pathway ?pathwayLabel ?WikiPathways ?Reactome (COUNT(DISTINCT ?protein) as ?count) WHERE {

  VALUES ?pathwayType {wd:Q4915012 wd:Q2996394 }

  ?pathway wdt:P31 ?pathwayType .

  { ?pathway wdt:P527/wdt:P688 ?protein . }    

  UNION

  { ?pathway wdt:P527 ?protein . }

  ?protein wdt:P638 ?PDBID .

  OPTIONAL { ?pathway wdt:P2410 ?WikiPathways }

  OPTIONAL { ?pathway wdt:P3937 ?Reactome }

  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

} GROUP BY ?pathway ?pathwayLabel ?WikiPathways ?Reactome

  ORDER BY DESC(?count)

# ID = 18,

# Question = Biological pathways with protein structures in the PDB database

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?pathway ?WikiPathways ?Reactome (COUNT(DISTINCT ?protein) AS ?count) ?pathwayLabel WHERE{

  ?pathway wdt:P31 ?pathwayType.

  ?pathway wdt:P527/wdt:P688|wdt:P527 ?protein.

  ?protein wdt:P638 ?PDB_structure_ID.

  VALUES ?pathwayType {wd:Q4915012 wd:Q2996394}

  OPTIONAL{?pathway wdt:P2410 ?WikiPathways.}

  OPTIONAL{?pathway wdt:P3937 ?Reactome.}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

GROUP BY ?pathway ?WikiPathways ?Reactome ?pathwayLabel

ORDER BY DESC(?count)

OK

 

Timeout, both queries

19.    

SELECT DISTINCT ?pathway ?pathwayLabel ?pwpart ?pwpartLabel ?variant ?variantLabel ?disease?diseaseLabel WHERE {

 

   VALUES ?predictor {p:P3354 p:P3355 p:P3356 p:P3357 p:P3358 p:P3359}

   VALUES ?predictorQualifier {pq:P2175}

   VALUES ?wpID {"WP2828"}

 

   ?pathway wdt:P2410 ?wpID ;

            wdt:P527 ?pwpart .

   ?disease wdt:P279+ wd:Q504775

   ?variant wdt:P3329 ?civicID ;

            ?predictor ?node ;

            wdt:P3433 ?pwpart

   {?node ?predictorStatement ?drug_label ;

          ?predictorQualifier ?disease .}

   UNION

   {

      ?node ?predictorStatement ?disease  .

   }

   SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

# D = 19,

# Question = Get known variants reported in CIViC database (Q27612411) of genes reported in a Wikipathways pathway: Bladder cancer (Q30230812)

#

# Manually edited

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?predictor ?predictorQualifier ?wpID ?pathway ?disease ?pwpart ?variant ?pathwayLabel ?diseaseLabel ?pwpartLabel ?variantLabel WHERE{

  {

    ?node ?predictorStatement ?drug_label.

    ?node ?predictorStatement ?disease.

  }

  UNION

  {

    ?node ?predictorQualifier ?disease.

  }

  ?disease wdt:P279+ wd:Q504775.

  ?pathway wdt:P527 ?pwpart.

  ?variant wdt:P3433 ?pwpart.

  ?variant ?predictor ?node.

  VALUES ?predictor {p:P3354 p:P3355 p:P3356 p:P3357 p:P3358 p:P3359}

  VALUES ?predictorQualifier {pq:P2175}

  VALUES ?wpID {"WP2828"}

  ?pathway wdt:P2410 ?wpID.

  ?variant wdt:P3329 ?civicID.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" .}

}

Manually edited.

 

TO DO: UNION construction, with multiple nodes from parent query

20.    

PREFIX dcterms: <http://purl.org/dc/terms/>

PREFIX wp: <http://vocabularies.wikipathways.org/wp#>

SELECT DISTINCT ?interaction_type WHERE {

  VALUES ?wpid {"WP716"}

  ?item wdt:P2410 ?wpid ;

        wdt:P2888 ?source_pathway .

 

  SERVICE <http://sparql.wikipathways.org/sparql> {

     ?wp_pathway dc:identifier ?source_pathway .

     ?s dcterms:isPartOf ?wp_pathway, ?interaction .

     ?interaction rdf:type wp:Interaction .

     ?interaction rdf:type ?interaction_type .

     ?interaction wp:participants ?participants.

  }

}

# ID = 20,

# Question = Known interaction types in Wikipathways for a pathway with Identifier WP716 (federated query)

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>

PREFIX dct: <http://purl.org/dc/terms/>

PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT ?type WHERE{

  SERVICE <http://sparql.wikipathways.org/sparql> {

      ?wp_pathway dc:identifier ?source_pathway.

      ?s dct:isPartOf ?wp_pathway.

      ?s dct:isPartOf ?interaction.

      ?interaction rdf:type <http://vocabularies.wikipathways.org/wp#Interaction>.

      ?interaction <http://vocabularies.wikipathways.org/wp#participants> ?participants.

      ?interaction rdf:type ?type.

    }

  ?item wdt:P2888 ?source_pathway.

  ?item wdt:P2410 ?wpid.

  VALUES ?wpid {"WP716"}

}

OK

 

21.    

PREFIX dcterms: <http://purl.org/dc/terms/>

PREFIX wp: <http://vocabularies.wikipathways.org/wp#>

SELECT DISTINCT ?item ?pw_annotation  WHERE {

  VALUES ?wpid {"WP716"}

  ?item wdt:P2410 ?wpid ;

        wdt:P2888 ?source_pathway .

 

  SERVICE <http://sparql.wikipathways.org/sparql> {

     ?wp_pathway dc:identifier ?source_pathway .

     ?wp_pathway wp:ontologyTag ?pw_annotation .

   }

}

# ID = 21,

# Question = Local annotations from Wikipathways using Federated query on a Pathway with identifier WP716 (federated query)

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX dc: <http://purl.org/dc/elements/1.1/>

SELECT DISTINCT ?item ?pw_annotation WHERE{

  SERVICE <http://sparql.wikipathways.org/sparql> {

      ?wp_pathway dc:identifier ?source_pathway.

      ?wp_pathway <http://vocabularies.wikipathways.org/wp#ontologyTag> ?pw_annotation.

    }

  ?item wdt:P2888 ?source_pathway.

  ?item wdt:P2410 ?wpid.

  VALUES ?wpid {"WP716"}

}

OK

 

22.    

SELECT ?drugLabel ?geneLabel ?biological_processLabel ?diseaseLabel

WHERE {

  ?drug wdt:P129 ?gene_product .  

  ?gene wdt:P688 ?gene_product

  ?disease wdt:P2293 ?gene .

  ?disease wdt:P279*  wd:Q12078 .

  ?gene_product wdt:P682 ?biological_process .

 

   ?biological_process (wdt:P361|wdt:P279)* wd:Q14818032

    SERVICE wikibase:label {

        bd:serviceParam wikibase:language "en" .

  }

}

LIMIT 1000

# ID = 22,

# Question = Find drugs for cancers that target genes related to cell proliferation

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?drugLabel ?biological_processLabel ?geneLabel ?diseaseLabel WHERE{

  ?drug wdt:P129 ?gene_product.

  ?gene_product wdt:P682 ?biological_process.

  ?biological_process (wdt:P361|wdt:P279)* wd:Q14818032.

  ?gene wdt:P688 ?gene_product.

  ?disease wdt:P2293 ?gene.

  ?disease wdt:P279* wd:Q12078.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

LIMIT 1000

OK

23.    

SELECT ?item ?itemLabel ?pic ?linkTo

WHERE

{

  wd:Q42196 wdt:P171* ?item

  OPTIONAL { ?item wdt:P171 ?linkTo }

  OPTIONAL { ?item wdt:P18 ?pic }

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }

}

# ID = 23,

# Question = Parent taxons of Blue Whale

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?item ?parent_taxon ?image ?itemLabel WHERE{

  wd:Q42196 wdt:P171* ?item.

  OPTIONAL{?item wdt:P171 ?parent_taxon.}

  OPTIONAL{?item wdt:P18 ?image.}

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

OK

24.    

SELECT ?item ?taxonname WHERE {

  ?item wdt:P31 wd:Q16521 ;

        wdt:P105 wd:Q7432 ;

        wdt:P171* wd:Q7367 ;

        wdt:P225 ?taxonname .

}

# ID = 24,

# Question = Mosquito species

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?item ?taxon_name WHERE{

  ?item wdt:P31 wd:Q16521.

  ?item wdt:P105 wd:Q7432.

  ?item wdt:P171* wd:Q7367.

  ?item wdt:P225 ?taxon_name.

}

OK

25.    

SELECT ?taxon ?eponym ?taxonName ?eponymLabel

WHERE

{

  ?taxon wdt:P31 wd:Q16521;

         wdt:P225 ?taxonName;

         wdt:P138 ?eponym.

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

ORDER BY ?eponym

# ID = 25,

# Question = Taxons and what they are named after

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?taxon ?taxon_name ?eponym ?eponymLabel WHERE{

  ?taxon wdt:P31 wd:Q16521.

  ?taxon wdt:P225 ?taxon_name.

  ?taxon wdt:P138 ?eponym.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

ORDER BY ?eponym

OK

 

Timeout, both queries

26.    

SELECT DISTINCT ?personLabel (CONCAT("https://twitter.com/",?twitterName) AS ?twitterlink) ?pic

WHERE {

  ?person wdt:P2002 ?twitterName ;

          wdt:P106 ?occupation .

  OPTIONAL { ?person wdt:P18 ?pic . }

  ?occupation wdt:P279* wd:Q864503 .

   SERVICE wikibase:label {

     bd:serviceParam wikibase:language "en"

   }

}

# ID = 26,

# Question = Biologists with Twitter accounts

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT DISTINCT ?image ?twitterlink ?personLabel WHERE{

  ?person wdt:P106 ?occupation.

  ?occupation wdt:P279* wd:Q864503.

  ?person wdt:P2002 ?twitterName.

  OPTIONAL{?person wdt:P18 ?image.}

  BIND(CONCAT("https://twitter.com/", ?twitterName) AS ?twitterlink)

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

OK

27.    

SELECT * WHERE {

  {

    SELECT ?cell_line ?cell_line_name WHERE {

      ?cell_line wdt:P31 wd:Q21014462;

                 rdfs:label ?cell_line_name.

          FILTER(LANG(?cell_line_name) = "en").

          Filter REGEX(STR(?cell_line_name), "^[\\w\\-\\.]+\\.[A-z]+$")

    }

  }

  ?tld wdt:P31/wdt:P279* wd:Q14296;

       rdfs:label ?tld_name.

  FILTER(LANG(?tld_name) = "en").

  FILTER REGEX(STR(?cell_line_name), CONCAT(REPLACE(?tld_name, "\\.", "\\\\."), "$"), "i")

  BIND(URI(CONCAT("http://", ?cell_line_name)) as ?url)

}

 

# ID = 27,

# Question = Cell lines with names that could also be URLs (Internet of Cell Lines).

#

# Manually edited

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#>

SELECT ?tld_name ?cell_line ?cell_line_name ?tld ?url WHERE{

  ?tld wdt:P31/wdt:P279* wd:Q14296.

  {SELECT DISTINCT ?tld ?cell_line_name ?cell_line WHERE{

    ?cell_line wdt:P31 wd:Q21014462.

    ?cell_line rdfs:label ?cell_line_name.

    FILTER(LANG(?cell_line_name) = "en")

    FILTER(REGEX(STR(?cell_line_name), "^[\\w\\-\\.] + \\.[A - z] + $"))}

  }

  ?tld rdfs:label ?tld_name.

  BIND(URI(CONCAT("http://", ?cell_line_name)) AS ?url)

  FILTER(LANG(?tld_name) = "en")

  FILTER(REGEX(STR(?cell_line_name), CONCAT(REPLACE(?tld_name, "\\.", "\\\\."), "$"), "i"))

}

Manually edited.

 

TO DO: to mark link as subquery link

 

28.    

SELECT ?moleculeLabel ?formule ?picture ?molecule

WHERE

{

  ?molecule  wdt:P31 wd:Q12140;

             wdt:P274 ?formule;

             wdt:P117 ?picture

  SERVICE wikibase:labelbd:serviceParam wikibase:language "en, de" . }

}

ORDER BY ?moleculeLabel

# ID = 28,

# Question = List of pharmaceutical drugs with picture

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wd: <http://www.wikidata.org/entity/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?molecule ?chemical_formula ?chemical_structure ?moleculeLabel WHERE{

  ?molecule wdt:P31 wd:Q12140.

  ?molecule wdt:P274 ?chemical_formula.

  ?molecule wdt:P117 ?chemical_structure.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en, de" .}

}

ORDER BY ?moleculeLabel

OK

29.    

SELECT ?organism_name

WHERE

  ?organism_item wdt:P276 wd:Q5880;

                 rdfs:label ?organism_name .

  ?gene wdt:P703 ?organism_item;

        wdt:P1056 wd:Q319541 .

  FILTER (LANG(?organism_name) = "en") .  

}

# ID = 29,

# Question = Organisms that are located in the female urogential tract and that have a gene with product indole

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>

PREFIX wd: <http://www.wikidata.org/entity/>

SELECT ?organism_name WHERE{

  ?organism_item wdt:P276 wd:Q5880.

  ?gene wdt:P703 ?organism_item.

  ?gene wdt:P1056 wd:Q319541.

  ?organism_item rdfs:label ?organism_name.

  FILTER(LANG(?organism_name) = "en")

}

OK

30.    

SELECT ?animal ?scientific_names ?common_names ?statusLabel where

{

   {

      SELECT DISTINCT ?animal (GROUP_CONCAT(distinct ?scientific_name; separator=", ") as ?scientific_names)  (GROUP_CONCAT(distinct ?common_name; separator=", ") as ?common_names) WHERE

      {

 

        ?animal wdt:P141 ?status;

                wdt:P225 ?scientific_name;

                wdt:P1843 ?common_name.

        filter( ?status

           IN (

               wd:Q11394

               wd:Q219127,

               wd:Q278113

              )

          ).

        FILTER(LANGMATCHES(LANG(?common_name), "en"))

      }

      group by ?animal

   }.

   ?animal wdt:P141 ?status.

   SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

# ID = 30,

# Question = Threatened Species of Animals as per IUCN Classification

#

# Manually edited

PREFIX wdt: <http://www.wikidata.org/prop/direct/>

PREFIX wikibase: <http://wikiba.se/ontology#>

PREFIX bd: <http://www.bigdata.com/rdf#>

SELECT ?animal ?scientific_names ?common_names ?statusLabel WHERE{

  {SELECT ?status ?animal (GROUP_CONCAT(DISTINCT ?scientific_name; SEPARATOR=', ') AS ?scientific_names) (GROUP_CONCAT(DISTINCT ?common_name; SEPARATOR=', ') AS ?common_names) WHERE{

    ?animal wdt:P1843 ?common_name.

    ?animal wdt:P225 ?scientific_name.

    ?animal wdt:P141 ?status.

    FILTER(?status IN (<http://www.wikidata.org/entity/Q11394>, <http://www.wikidata.org/entity/Q219127>, <http://www.wikidata.org/entity/Q278113>))

    FILTER(LANGMATCHES(LANG(?common_name), "en"))}

    GROUP BY ?status ?animal

  }

  ?animal wdt:P141 ?status.

  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .}

}

Manually edited.

 

TO DO: subquery with more than one node from parent query