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.
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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:label { bd: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
|