Jump to content

Wikibase:SPARQL/examples

Add links
From wikibase

Queries on EChO IMAGES

Inventors

{{#if:|
[[:Template:If]][[:Template:If]][[:Template:If]][[:Template:If]]
}}PREFIX wbt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct/>
PREFIX wb: <https://wikibase.echoimages.labs.wikimedia.pt/entity/>

SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
  ?item wbt:P3 wb:Q66 .
  OPTIONAL { ?item wdt:P79 ?inventor . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
[{{#switch:wb|wb=//query.echoimages.labs.wikimedia.pt/|wd=//query.wikidata.org/|sdc=//commons-query.wikimedia.org/|{{{project}}}}}{{#ifeq: | yes |embed.html | }}#%7B%7B%23if%3A%7C%0A%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%0A%7D%7DPREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fwikibase.echoimages.labs.wikimedia.pt%2Fprop%2Fdirect%2F%3E%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fwikibase.echoimages.labs.wikimedia.pt%2Fentity%2F%3E%0A%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Finventor%20%3FinventorLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wbt%3AP3%20wb%3AQ66%20.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP79%20%3Finventor%20.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D {{#if: ||}}] {{#if: | (https://w.wiki/{{{shortURL}}}) }}

Wikidata

{{#if:|
[[:Template:If]][[:Template:If]][[:Template:If]][[:Template:If]]
}}PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
  ?item wdt:P31 wd:Q172839 .
  
  OPTIONAL { ?item wdt:P61 ?inventor . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
[{{#switch:wd|wb=//query.echoimages.labs.wikimedia.pt/|wd=//query.wikidata.org/|sdc=//commons-query.wikimedia.org/|wd}}{{#ifeq: | yes |embed.html | }}#%7B%7B%23if%3A%7C%0A%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%0A%7D%7DPREFIX%20wdt%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2F%3E%0ASELECT%20%3Fitem%20%3FitemLabel%20%3Finventor%20%3FinventorLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ172839%20.%0A%20%20%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP61%20%3Finventor%20.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D {{#if: ||}}] {{#if: | (https://w.wiki/{{{shortURL}}}) }}

image location

{{#if:|
[[:Template:If]][[:Template:If]][[:Template:If]][[:Template:If]]
}}PREFIX wbt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct/>
PREFIX wb: <https://wikibase.echoimages.labs.wikimedia.pt/entity/>


SELECT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE {
  ?item wbt:P3 wb:Q56 .
    ?item wbt:P6 ?image .
  ?item wbt:P10 ?location . 
  ?item wbt:P13 ?inception .
    ?item wbt:P28 ?method .
  OPTIONAL { ?item wbt:P16 ?creator . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
[{{#switch:wb|wb=//query.echoimages.labs.wikimedia.pt/|wd=//query.wikidata.org/|sdc=//commons-query.wikimedia.org/|{{{project}}}}}{{#ifeq: | yes |embed.html | }}#%7B%7B%23if%3A%7C%0A%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%0A%7D%7DPREFIX%20wbt%3A%20%3Chttps%3A%2F%2Fwikibase.echoimages.labs.wikimedia.pt%2Fprop%2Fdirect%2F%3E%0APREFIX%20wb%3A%20%3Chttps%3A%2F%2Fwikibase.echoimages.labs.wikimedia.pt%2Fentity%2F%3E%0A%0A%0ASELECT%20%3Fimage%20%3Fitem%20%3FitemLabel%20%3Fcreator%20%3FcreatorLabel%20%3Fmethod%20%3FmethodLabel%20%3Finception%20%3Flocation%20WHERE%20%7B%0A%20%20%3Fitem%20wbt%3AP3%20wb%3AQ56%20.%0A%20%20%20%20%3Fitem%20wbt%3AP6%20%3Fimage%20.%0A%20%20%3Fitem%20wbt%3AP10%20%3Flocation%20.%20%0A%20%20%3Fitem%20wbt%3AP13%20%3Finception%20.%0A%20%20%20%20%3Fitem%20wbt%3AP28%20%3Fmethod%20.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20wbt%3AP16%20%3Fcreator%20.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D {{#if: ||}}] {{#if: | (https://w.wiki/{{{shortURL}}}) }}

Wikidata

{{#if:|
[[:Template:If]][[:Template:If]][[:Template:If]][[:Template:If]]
}}SELECT DISTINCT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location ?depicoord WHERE {
  ?item wdt:P31/wdt:P279* wd:Q125191 .
  ?item wdt:P18 ?image .
 # ?item wdt:P625 ?location .
  ?item wdt:P9149 ?depicoord .
 ?item wdt:P571 ?inception .
   ?item wdt:P2079 ?method .
  
OPTIONAL { ?item wdt:P170 ?creator . }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
[{{#switch:wd|wb=//query.echoimages.labs.wikimedia.pt/|wd=//query.wikidata.org/|sdc=//commons-query.wikimedia.org/|wd}}{{#ifeq: | yes |embed.html | }}#%7B%7B%23if%3A%7C%0A%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%0A%7D%7DSELECT%20DISTINCT%20%3Fimage%20%3Fitem%20%3FitemLabel%20%3Fcreator%20%3FcreatorLabel%20%3Fmethod%20%3FmethodLabel%20%3Finception%20%3Flocation%20%3Fdepicoord%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ125191%20.%0A%20%20%3Fitem%20wdt%3AP18%20%3Fimage%20.%0A%20%23%20%3Fitem%20wdt%3AP625%20%3Flocation%20.%0A%20%20%3Fitem%20wdt%3AP9149%20%3Fdepicoord%20.%0A%20%3Fitem%20wdt%3AP571%20%3Finception%20.%0A%20%20%20%3Fitem%20wdt%3AP2079%20%3Fmethod%20.%0A%20%20%0AOPTIONAL%20%7B%20%3Fitem%20wdt%3AP170%20%3Fcreator%20.%20%7D%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D {{#if: ||}}] {{#if: | (https://w.wiki/{{{shortURL}}}) }}

Industry

Wikidata

{{#if:|
[[:Template:If]][[:Template:If]][[:Template:If]][[:Template:If]]
}}SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
  ?item wdt:P452 wd:Q1439700 .
  

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
[{{#switch:wd|wb=//query.echoimages.labs.wikimedia.pt/|wd=//query.wikidata.org/|sdc=//commons-query.wikimedia.org/|wd}}{{#ifeq: | yes |embed.html | }}#%7B%7B%23if%3A%7C%0A%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%0A%7D%7DSELECT%20%3Fitem%20%3FitemLabel%20%3Finventor%20%3FinventorLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP452%20wd%3AQ1439700%20.%0A%20%20%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D {{#if: ||}}] {{#if: | (https://w.wiki/{{{shortURL}}}) }}

Women in photography

Wikidata

{{#if:|
[[:Template:If]][[:Template:If]][[:Template:If]][[:Template:If]]
}}SELECT DISTINCT ?image ?item ?itemLabel ?birth ?country ?countryLabel WHERE {
  ?item wdt:P106 wd:Q33231 .
  ?item wdt:P27 ?country .
 
 ?item wdt:P18 ?image .
# ?item wdt:P625 ?location . 
#  ?item wdt:P571 ?inception .
#   ?item wdt:P2079 ?method .
  
 ?item wdt:P569 ?birth;
                wdt:P21 wd:Q6581072;  
  FILTER (?birth > "1790-01-01"^^xsd:dateTime && ?birth < "2026-01-01"^^xsd:dateTime)
  
# OPTIONAL { ?item wdt:P170 ?creator . }
  
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
[{{#switch:wd|wb=//query.echoimages.labs.wikimedia.pt/|wd=//query.wikidata.org/|sdc=//commons-query.wikimedia.org/|wd}}{{#ifeq: | yes |embed.html | }}#%7B%7B%23if%3A%7C%0A%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%5B%5B%3ATemplate%3AIf%5D%5D%0A%7D%7DSELECT%20DISTINCT%20%3Fimage%20%3Fitem%20%3FitemLabel%20%3Fbirth%20%3Fcountry%20%3FcountryLabel%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP106%20wd%3AQ33231%20.%0A%20%20%3Fitem%20wdt%3AP27%20%3Fcountry%20.%0A%20%0A%20%3Fitem%20wdt%3AP18%20%3Fimage%20.%0A%23%20%3Fitem%20wdt%3AP625%20%3Flocation%20.%20%0A%23%20%20%3Fitem%20wdt%3AP571%20%3Finception%20.%0A%23%20%20%20%3Fitem%20wdt%3AP2079%20%3Fmethod%20.%0A%20%20%0A%20%3Fitem%20wdt%3AP569%20%3Fbirth%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP21%20wd%3AQ6581072%3B%20%20%0A%20%20FILTER%20%28%3Fbirth%20%3E%20%221790-01-01%22%5E%5Exsd%3AdateTime%20%26%26%20%3Fbirth%20%3C%20%222026-01-01%22%5E%5Exsd%3AdateTime%29%0A%20%20%0A%23%20OPTIONAL%20%7B%20%3Fitem%20wdt%3AP170%20%3Fcreator%20.%20%7D%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D {{#if: ||}}] {{#if: | (https://w.wiki/{{{shortURL}}}) }}

Queries on Wikidata

Retrieved from "https://wikibase.tools.labs.wikimedia.pt/w/index.php?title=Wikibase:SPARQL/examples&oldid=5928"