Wikidata:WikiProject Ancient Rome/Queries

Latin literature edit

#Latin authors, as in PHI + DigilibLT + Musisque Deoque
SELECT ?item ?itemLabel 
  (GROUP_CONCAT(DISTINCT ?phi1; separator=", ") as ?Phi)
  (GROUP_CONCAT(DISTINCT ?digilib1; separator=", ") as ?Digilib)
  (GROUP_CONCAT(DISTINCT ?mqdq1; separator=", ") as ?Mqdq)
  (GROUP_CONCAT(DISTINCT ?cc1; separator=", ") as ?Corpuscorporum)
  (GROUP_CONCAT(DISTINCT ?ciris1; separator=", ") as ?Ciris)
  (GROUP_CONCAT(DISTINCT ?dll1; separator=", ") as ?Dll)
  (GROUP_CONCAT(DISTINCT ?pc1; separator=", ") as ?Perseuscatalog)
  (GROUP_CONCAT(DISTINCT ?viaf1; separator=", ") as ?Viaf)
WHERE
{
   { ?item wdt:P6941 ?phi1 . } UNION { ?item wdt:P6862 ?digilib1 . } UNION { ?item wdt:P6999 ?mqdq1 . }
   OPTIONAL { ?item wdt:P7935 ?cc1 . }
   OPTIONAL { ?item wdt:P8065 ?ciris1 . }
   OPTIONAL { ?item wdt:P8122 ?dll1 . }
   OPTIONAL { ?item wdt:P7041 ?pc1 . }
   OPTIONAL { ?item wdt:P214 ?viaf1 . }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "it,en" . }
}
GROUP BY ?item ?itemLabel
ORDER BY ?itemLabel
Try it!