EChO IMAGES:SPARQL/examples: Difference between revisions

Add links
From EChO_IMAGES
VisualWikitext
Created page with "=ParVoices Entries= ==ParVO all entries == <sparql tryit="1"> #This is a list of ParVO entries PREFIX wdt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct> PREFIX wd: <https://wikibase.echoimages.labs.wikimedia.pt/entity/> SELECT ?item ?itemLabel ?Image ?itemImage ?logo ?value ?valueLabel ?valueImage ?edgeLabel WHERE { ?item wdt:P6 ?itemImage. ?item ?wdt ?value . ?edge a wikibase:Property; wikibase:propertyType wikibas..."
 
wb (first query)
 
(7 intermediate revisions by one other user not shown)
Line 1: Line 1:
=ParVoices Entries=
=Queries=
==ParVO all entries ==
==Inventors==
{{SPARQL|query=
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". }
}
}}
 
===wikidata===
 
SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
  ?item wdt:P31 wd:Q172839 .
 
  OPTIONAL { ?item wdt:P61 ?inventor . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
 
==image location==
<sparql tryit="1">
<sparql tryit="1">
#This is a list of ParVO entries
PREFIX wdt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct/>
PREFIX wdt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct>
PREFIX wd: <https://wikibase.echoimages.labs.wikimedia.pt/entity/>
PREFIX wd: <https://wikibase.echoimages.labs.wikimedia.pt/entity/>


SELECT ?item ?itemLabel ?Image ?itemImage ?logo ?value ?valueLabel ?valueImage ?edgeLabel
  WHERE {
    ?item wdt:P6 ?itemImage.
     
         
    ?item ?wdt ?value .
  ?edge a wikibase:Property;
        wikibase:propertyType wikibase:WikibaseItem; # note: to show all statements, removing this is not enough, the graph view only shows entities
        wikibase:directClaim ?wdt.


SELECT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE {
  ?item wdt:P3 wd:Q56 .
    ?item wdt:P6 ?image .
  ?item wdt:P10 ?location .
  ?item wdt:P13 ?inception .
    ?item wdt:P28 ?method .
  OPTIONAL { ?item wdt:P16 ?creator . }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
}
</sparql>
</sparql>
===wikidata===
SELECT DISTINCT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE {
  ?item wdt:P31/wdt:P279* wd:Q125191 .
  ?item wdt:P18 ?image .
  ?item wdt:P625 ?location .
  ?item wdt:P571 ?inception .
    ?item wdt:P2079 ?method .
 
OPTIONAL { ?item wdt:P170 ?creator . }
 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
==Industry==
===Wikidata===
SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE {
  ?item wdt:P452 wd:Q1439700 .
 
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }
}
==Women in photography==
===wikidata===


==ParVO entries Ornitorrinco ==
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". }
}

Latest revision as of 09:21, 8 June 2026

Queries

Inventors

<templatestyles src="SPARQL/styles.css" />

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". }
}
Try it!

wikidata

SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE { 

 ?item wdt:P31 wd:Q172839 .
 
 OPTIONAL { ?item wdt:P61 ?inventor . }
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

image location

<sparql tryit="1"> PREFIX wdt: <https://wikibase.echoimages.labs.wikimedia.pt/prop/direct/> PREFIX wd: <https://wikibase.echoimages.labs.wikimedia.pt/entity/>


SELECT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE { 

 ?item wdt:P3 wd:Q56 .
   ?item wdt:P6 ?image .
 ?item wdt:P10 ?location . 
 ?item wdt:P13 ?inception .
   ?item wdt:P28 ?method .
 OPTIONAL { ?item wdt:P16 ?creator . }
 SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }

}

</sparql>

wikidata

SELECT DISTINCT ?image ?item ?itemLabel ?creator ?creatorLabel ?method ?methodLabel ?inception ?location WHERE { 

 ?item wdt:P31/wdt:P279* wd:Q125191 .
 ?item wdt:P18 ?image .
 ?item wdt:P625 ?location . 
 ?item wdt:P571 ?inception .
   ?item wdt:P2079 ?method .

OPTIONAL { ?item wdt:P170 ?creator . } 

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

}


Industry

Wikidata

SELECT ?item ?itemLabel ?inventor ?inventorLabel WHERE { 

 ?item wdt:P452 wd:Q1439700 .
 

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

}

Women in photography

wikidata

SELECT DISTINCT ?image ?item ?itemLabel ?birth ?country ?countryLabel WHERE { 

 ?item wdt:P106 wd:Q33231 .
 ?item wdt:P27 ?country .

?item wdt:P18 ?image .
  1. ?item wdt:P625 ?location .
  2. ?item wdt:P571 ?inception .
  3. ?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)
  1. OPTIONAL { ?item wdt:P170 ?creator . }
 SERVICE wikibase:label { bd:serviceParam wikibase:language "en". }

}

Retrieved from "https://wikibase.echoimages.labs.wikimedia.pt/w/index.php?title=EChO_IMAGES:SPARQL/examples&oldid=2768"