Open main menu

Wikidata:WikiProject Ancient Greece/Queries

Ancient Greek literatureEdit

#Ancient lyric fragments
SELECT ?fragment ?authorLabel ?fragmentLabel ?genreLabel ?dialectLabel
WHERE {
  { ?fragment wdt:P136/wdt:P279* wd:Q1885775 . }
  UNION { ?fragment wdt:P136 wd:Q3906966 . }
  UNION { ?fragment wdt:P136 wd:Q3164714 . }
  ?fragment wdt:P50 ?author .
  ?fragment wdt:P136 ?genre .
  ?fragment wdt:P407 ?dialect .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "it,grc" }    
} ORDER BY ?authorLabel ?fragmentLabel

Try it!

#Metrical feet
SELECT
   ?item ?itemLabel ?metricalPattern
  (GROUP_CONCAT(DISTINCT ?instanceLabel; separator=", ") as ?i)
WHERE {
  ?item wdt:P31/wdt:P279* wd:Q1651051 .
  ?item wdt:P31 ?instance . 
  ?item wdt:P2552 ?metricalPattern .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "it" . ?instance rdfs:label ?instanceLabel . ?item rdfs:label ?itemLabel }
} GROUP BY ?item ?itemLabel ?metricalPattern

Try it!

Ancient Greek theatreEdit

Ancient Greek tragedyEdit

#Ancient Greek tragedies and satyr plays
SELECT ?play ?authorLabel ?playLabel ?genreLabel ?title
WHERE {
  ?play wdt:P31 wd:Q25379 .
  { ?play wdt:P136 wd:Q34620 . }
  UNION { ?play wdt:P136 wd:Q1050848 . }
  ?play wdt:P50 ?author .
  ?play wdt:P136 ?genre .
  ?play wdt:P1476 ?title .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "it,grc" }    
} ORDER BY ?authorLabel

Try it!

#Works by Aeschylus
SELECT ?item ?itemLabel ?instanceLabel ?genreLabel ?title
WHERE {
  { ?item wdt:P31 wd:Q25379 . } UNION { ?item wdt:P31 ?c .
  ?c wdt:P279 wd:Q17851719 . } .
  ?item wdt:P50 wd:Q40939 .
  ?item wdt:P31 ?instance .
  ?item wdt:P136 ?genre .
  ?item wdt:P1476 ?title .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "it,grc"  }    
}

Try it!

Ancient Greek comedyEdit

#Ancient Greek comedies
SELECT ?play ?authorLabel ?playLabel ?genreLabel ?title
WHERE {
  ?play wdt:P31 wd:Q25379 .
  { ?play wdt:P136 wd:Q1100736 }
  UNION { ?play wdt:P136 ?instance .
  ?instance wdt:P279 wd:Q1100736 . }
  ?play wdt:P50 ?author .
  ?play wdt:P136 ?genre .
  ?play wdt:P1476 ?title .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "it,grc" }    
} ORDER BY ?authorLabel

Try it!

#Attic comic poets
SELECT ?item ?itemLabel ?movementLabel
WHERE {
  { ?item wdt:P135 ?instance .
  ?instance wdt:P279 wd:Q1100736 .}
  ?item wdt:P135 ?movement .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "it" }    
} ORDER BY ?movementLabel

Try it!

#Works by Aristophanes
SELECT ?item ?itemLabel ?genreLabel (CONCAT(str(1+YEAR(?date)*-1), "BC") as ?yearBC) ?title
WHERE {
  ?item wdt:P50 wd:Q43353 .
  ?item wdt:P136 ?genre .
  ?item wdt:P1191 ?date .
  ?item wdt:P1476 ?title .
	SERVICE wikibase:label { bd:serviceParam wikibase:language "it,grc" }    
} ORDER BY ?date

Try it!

Greek mythologyEdit

#All Greek mythological characters
SELECT ?item ?itemLabel {
  ?item (wdt:P31/wdt:P279*)?/wdt:P361 wd:Q34726 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}

Try it!