Quality control queries: Difference between revisions

From Black Bibliography Project
Jump to navigation Jump to search
 
(21 intermediate revisions by the same user not shown)
Line 4: Line 4:
Get a list of works that lack an accurate "Literary Form" statement:
Get a list of works that lack an accurate "Literary Form" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Works without accurate Instance of statement.
# Works without accurate Instance of statement.
SELECT ?work ?workLabel
SELECT ?work ?workLabel
Line 18: Line 20:
Get a list of works that lack an "language" statement:
Get a list of works that lack an "language" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Works without Language statement.
# Works without Language statement.
SELECT ?edition ?editionLabel
SELECT ?work ?workLabel
WHERE
WHERE
{
{
     ?edition wdt:P8 wd:Q4 .
     ?work wdt:P8 wd:Q4 .
     MINUS { ?edition wdt:P12 [] } .
     MINUS { ?work wdt:P12 [] } .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
}
ORDER BY ?editionLabel
ORDER BY ?workLabel
</pre>
</pre>


Line 34: Line 38:
Get a list of editions that lack an "edition of" statement:
Get a list of editions that lack an "edition of" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions without Edition of statement.
# Editions without Edition of statement.
SELECT ?edition ?editionLabel
SELECT ?edition ?editionLabel
Line 48: Line 54:
Get a list of editions that lack a "Format" statement:
Get a list of editions that lack a "Format" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions without Format statement.
# Editions without Format statement.
SELECT ?edition ?editionLabel
SELECT ?edition ?editionLabel
Line 54: Line 62:
     ?edition wdt:P8 wd:Q7 .
     ?edition wdt:P8 wd:Q7 .
     MINUS { ?edition wdt:P37 [] } .
     MINUS { ?edition wdt:P37 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel
</pre>
===Missing Series Title Statements===
Get a list of editions that are part of a series, but lack a "Series Title" statement:
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions in series without series title statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 ;
            wdt:P25 [].
    MINUS { ?edition wdt:P26 [] } .
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
   SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
}
Line 65: Line 90:
Get a list of copies that lack an "copy of" statement:
Get a list of copies that lack an "copy of" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Copies without Copy of statement.
# Copies without Copy of statement.
SELECT ?copy ?copyLabel
SELECT ?copy ?copyLabel
Line 80: Line 107:
Get a list of copies that lack an "copy of" statement:
Get a list of copies that lack an "copy of" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Copies without Copy of statement.
# Copies without Copy of statement.
SELECT ?copy ?copyLabel
SELECT ?copy ?copyLabel
Line 91: Line 120:
</pre>
</pre>


==Other==
==Issues==
===Issues===
=== Missing "issue of" statements ===
==== Missing "issue of" statements ====


Get a list of copies that lack an "copy of" statement:
Get a list of copies that lack an "copy of" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Issues without Issue of statement.
# Issues without Issue of statement.
SELECT ?issue ?issueLabel
SELECT ?issue ?issueLabel
Line 108: Line 138:
</pre>
</pre>


===Translations===
==Translations==
==== Missing "translation of" statements ====
=== Missing "translation of" statements ===


Get a list of translated works that lack an "translation of" statement:
Get a list of translated works that lack an "translation of" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Translations without Translation of statement.
# Translations without Translation of statement.
SELECT ?issue ?issueLabel
SELECT ?translation ?translationLabel
WHERE
WHERE
{
{
Line 124: Line 156:
</pre>
</pre>


==== Missing Language Statements ====
=== Missing Language Statements ===


Get a list of translated works that lack a "language" statement:
Get a list of translated works that lack a "language" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Translations without Translation of statement.
# Translations without Translation of statement.
SELECT ?issue ?issueLabel
SELECT ?translation ?translationLabel
WHERE
WHERE
{
{
Line 139: Line 173:
</pre>
</pre>


=== Oration ===
== Oration ==
=== Missing "oration of" statements ===
=== Missing "oration of" statements ===


Get a list of oration that lack an "oration of" statement:
Get a list of oration that lack an "oration of" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Orations without Oration of statement.
# Orations without Oration of statement.
SELECT ?oration ?orationLabel
SELECT ?oration ?orationLabel
Line 159: Line 195:
Get a list of oration that lack an "orator" statement:
Get a list of oration that lack an "orator" statement:
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Orations without Oration of statement.
# Orations without Oration of statement.
SELECT ?oration ?orationLabel
SELECT ?oration ?orationLabel
Line 169: Line 207:
ORDER BY ?orationLabel
ORDER BY ?orationLabel
</pre>
</pre>
==Missing Required Statements==
===Works===


== Missing instance statements (NEEDS REVISION) ==
== Missing instance statements (NEEDS REVISION) ==
Line 194: Line 229:
[http://172.17.10.220:8834/embed.html#prefix%20wbb%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology-beta%23%3E%20%0Aprefix%20wb%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%20%0A%0ASELECT%20%3Flabel%20%3Flink%0AWHERE%0A%7B%0A%20%3Fitem%20rdf%3Atype%20%3Fwbitem%20%3B%0A%20%20%20%20%20%20%20rdfs%3Alabel%20%3Flabel%20.%20%20%20%20%0A%20FILTER%28%3Fwbitem%20in%20%28wbb%3AItem%2C%20wb%3AItem%29%29%0A%20FILTER%28%28LANG%28%3Flabel%29%29%20%3D%20%22en%22%29%0A%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP8%20%3Ftype%20%7D%0A%20BIND%28IRI%28CONCAT%28%27http%3A%2F%2F10.5.32.142%3A8181%2Fwiki%2FItem%3A%27%2C%20REPLACE%28%20str%28%3Fitem%29%20%2C%20%27http%3A%2F%2Fwikibase.svc%2Fentity%2F%27%2C%20%27%27%20%29%29%29%20AS%20%3Flink%20%29%0A%7D%0Aorder%20by%20%3Flabel Try it out!]
[http://172.17.10.220:8834/embed.html#prefix%20wbb%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology-beta%23%3E%20%0Aprefix%20wb%3A%20%3Chttp%3A%2F%2Fwikiba.se%2Fontology%23%3E%20%0A%0ASELECT%20%3Flabel%20%3Flink%0AWHERE%0A%7B%0A%20%3Fitem%20rdf%3Atype%20%3Fwbitem%20%3B%0A%20%20%20%20%20%20%20rdfs%3Alabel%20%3Flabel%20.%20%20%20%20%0A%20FILTER%28%3Fwbitem%20in%20%28wbb%3AItem%2C%20wb%3AItem%29%29%0A%20FILTER%28%28LANG%28%3Flabel%29%29%20%3D%20%22en%22%29%0A%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem%20wdt%3AP8%20%3Ftype%20%7D%0A%20BIND%28IRI%28CONCAT%28%27http%3A%2F%2F10.5.32.142%3A8181%2Fwiki%2FItem%3A%27%2C%20REPLACE%28%20str%28%3Fitem%29%20%2C%20%27http%3A%2F%2Fwikibase.svc%2Fentity%2F%27%2C%20%27%27%20%29%29%29%20AS%20%3Flink%20%29%0A%7D%0Aorder%20by%20%3Flabel Try it out!]


==Missing Wikidata Identifiers==
==Authorities==
 
===Missing Wikidata Identifiers===


===Humans Without a Wikidata Identifier===
====Humans Without a Wikidata Identifier====
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Humans without a Wikidata Identifier.
# Humans without a Wikidata Identifier.
SELECT ?human ?humanLabel
SELECT ?human ?humanLabel
Line 209: Line 248:
</pre>
</pre>


===Corporate Bodies Without a Wikidata Identifier===
====Corporate Bodies Without a Wikidata Identifier====
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Corporate Bodies Without a Wikidata Identifier.
# Corporate Bodies Without a Wikidata Identifier.
SELECT ?corp ?corpLabel
SELECT ?corp ?corpLabel
Line 222: Line 263:
</pre>
</pre>


===Places Without a Wikidata Identifier===
====Places Without a Wikidata Identifier====
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Places without a Wikidata Identifier.
# Places without a Wikidata Identifier.
SELECT ?place ?placeLabel
SELECT ?place ?placeLabel
Line 235: Line 278:
</pre>
</pre>


==Missing Library of Congress Authority IDs==
===Missing Library of Congress Authority IDs===


===Humans Without a Library of Congress Authority ID===
====Humans Without a Library of Congress Authority ID====
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Humans without a LOC Identifier.
# Humans without a LOC Identifier.
SELECT ?human ?humanLabel
SELECT ?human ?humanLabel
Line 250: Line 295:
</pre>
</pre>


===Corporate Bodies Without a Library of Congress Authority ID===
====Corporate Bodies Without a Library of Congress Authority ID====
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Corporate Bodies Without a LOC Identifier.
# Corporate Bodies Without a LOC Identifier.
SELECT ?corp ?corpLabel
SELECT ?corp ?corpLabel
Line 263: Line 310:
</pre>
</pre>


===Places Without a Library of Congress Authority ID===
====Places Without a Library of Congress Authority ID====
<pre>
<pre>
PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Places without a LOC Identifier.
# Places without a LOC Identifier.
SELECT ?place ?placeLabel
SELECT ?place ?placeLabel

Latest revision as of 14:19, 20 June 2025

Missing Required Statements

Works

Missing Literary Form

Get a list of works that lack an accurate "Literary Form" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Works without accurate Instance of statement.
SELECT ?work ?workLabel
WHERE
{
    ?work wdt:P8 wd:Q4 .
    MINUS { ?work wdt:P11 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?workLabel

Missing Language

Get a list of works that lack an "language" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Works without Language statement.
SELECT ?work ?workLabel
WHERE
{
    ?work wdt:P8 wd:Q4 .
    MINUS { ?work wdt:P12 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?workLabel

Editions

Missing "edition of" statements

Get a list of editions that lack an "edition of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions without Edition of statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 .
    MINUS { ?edition wdt:P13 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel

Missing Format Statements

Get a list of editions that lack a "Format" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions without Format statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 .
    MINUS { ?edition wdt:P37 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel

Missing Series Title Statements

Get a list of editions that are part of a series, but lack a "Series Title" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Editions in series without series title statement.
SELECT ?edition ?editionLabel
WHERE
{
    ?edition wdt:P8 wd:Q7 ;
             wdt:P25 [].
    MINUS { ?edition wdt:P26 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?editionLabel

Copies

Missing "copy of" statements

Get a list of copies that lack an "copy of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Copies without Copy of statement.
SELECT ?copy ?copyLabel
WHERE
{
    ?copy wdt:P8 wd:Q8 .
    MINUS { ?copy wdt:P41 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?copyLabel

Missing "Held By" Statements

Get a list of copies that lack an "copy of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Copies without Copy of statement.
SELECT ?copy ?copyLabel
WHERE
{
    ?copy wdt:P8 wd:Q8 .
    MINUS { ?copy wdt:P43 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?copyLabel

Issues

Missing "issue of" statements

Get a list of copies that lack an "copy of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Issues without Issue of statement.
SELECT ?issue ?issueLabel
WHERE
{
    ?issue wdt:P8 wd:Q739 .
    MINUS { ?issue wdt:P111 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?issueLabel

Translations

Missing "translation of" statements

Get a list of translated works that lack an "translation of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Translations without Translation of statement.
SELECT ?translation ?translationLabel
WHERE
{
    ?translation wdt:P8 wd:Q2634 .
    MINUS { ?translation wdt:P130 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?translationLabel

Missing Language Statements

Get a list of translated works that lack a "language" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Translations without Translation of statement.
SELECT ?translation ?translationLabel
WHERE
{
    ?translation wdt:P8 wd:Q2634 .
    MINUS { ?translation wdt:P12 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?translationLabel

Oration

Missing "oration of" statements

Get a list of oration that lack an "oration of" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Orations without Oration of statement.
SELECT ?oration ?orationLabel
WHERE
{
    ?oration wdt:P8 wd:Q8757 .
    MINUS { ?oration wdt:P142 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?orationLabel

Missing "Orator" statements

Get a list of oration that lack an "orator" statement: 

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Orations without Oration of statement.
SELECT ?oration ?orationLabel
WHERE
{
    ?oration wdt:P8 wd:Q8757 .
    MINUS { ?oration wdt:P141 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?orationLabel

Missing instance statements (NEEDS REVISION)

Get a list of Item pages that lack an "instance of" declaration: 

# Return all items that are missing an "instance of" statement
prefix wbb: <http://wikiba.se/ontology-beta#> 
prefix wb: <http://wikiba.se/ontology#> 

SELECT ?label ?link
WHERE
{
 ?item rdf:type ?wbitem ;
       rdfs:label ?label .    
 FILTER(?wbitem in (wbb:Item, wb:Item))
 FILTER((LANG(?label)) = "en")
 FILTER NOT EXISTS { ?item wdt:P8 ?type }
 BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?item) , 'http://wikibase.svc/entity/', '' ))) AS ?link )
}
order by ?label

Try it out!

Authorities

Missing Wikidata Identifiers

Humans Without a Wikidata Identifier

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Humans without a Wikidata Identifier.
SELECT ?human ?humanLabel
WHERE
{
    ?place wdt:P8 wd:Q3 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?humanLabel

Corporate Bodies Without a Wikidata Identifier

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Corporate Bodies Without a Wikidata Identifier.
SELECT ?corp ?corpLabel
WHERE
{
    ?place wdt:P8 wd:Q186 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?corpLabel

Places Without a Wikidata Identifier

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Places without a Wikidata Identifier.
SELECT ?place ?placeLabel
WHERE
{
    ?place wdt:P8 wd:Q10 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?placeLabel

Missing Library of Congress Authority IDs

Humans Without a Library of Congress Authority ID

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Humans without a LOC Identifier.
SELECT ?human ?humanLabel
WHERE
{
    ?place wdt:P8 wd:Q3 .
    MINUS { ?place wdt:P107 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?humanLabel

Corporate Bodies Without a Library of Congress Authority ID

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Corporate Bodies Without a LOC Identifier.
SELECT ?corp ?corpLabel
WHERE
{
    ?place wdt:P8 wd:Q186 .
    MINUS { ?place wdt:P108 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?corpLabel

Places Without a Library of Congress Authority ID

PREFIX wdt: <http://blackbibliog.rutgers.edu/prop/direct/>
PREFIX wd: <http://blackbibliog.rutgers.edu/entity/>
# Places without a LOC Identifier.
SELECT ?place ?placeLabel
WHERE
{
    ?place wdt:P8 wd:Q10 .
    MINUS { ?place wdt:P108 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
ORDER BY ?placeLabel

Checking in on the Andrews List editions (NEEDS REVISION)

# list of editions associated with the Andrews bibliography
SELECT 
?editionLabel
?link 
(group_concat(distinct ?publisherLabel;separator='; ') as ?publishers) 
(group_concat(distinct ?pubPlaceLabel;separator='; ') as ?publishedPlaces)
(group_concat(distinct ?pubDate;separator='; ') as ?publishedDates)

(group_concat(distinct ?printerLabel;separator='; ') as ?printers) 
(group_concat(distinct ?printPlaceLabel;separator='; ') as ?printedPlaces)
(group_concat(distinct ?printDate;separator='; ') as ?printedDates)

WHERE {
 ?edition wdt:P121 wd:Q1176 ; #wd:Q1176 is the Andrews bibliography
          rdfs:label ?editionLabel .
   
  OPTIONAL {?edition wdt:P29 ?publisher . ?publisher rdfs:label ?publisherLabel }.
  OPTIONAL {?edition ?has ?pubStmt . ?pubStmt ps:P29 ?publisher ; pq:P30 ?pubPlace . ?pubPlace rdfs:label ?pubPlaceLabel }.
  OPTIONAL {?edition ?has ?pubStmt . ?pubStmt ps:P29 ?publisher ; pq:P31 ?pubDate }.
  
  OPTIONAL {?edition wdt:P32 ?printer . ?printer rdfs:label ?printerLabel }.
  OPTIONAL {?edition ?has ?printStmt . ?printStmt ps:P32 ?printer ; pq:P30 ?printPlace . ?printPlace rdfs:label ?printPlaceLabel }.
  OPTIONAL {?edition ?has ?printStmt . ?printStmt ps:P32 ?printer ; pq:P31 ?printDate }.
  
  
  BIND(IRI(CONCAT('http://172.17.10.220/wiki/Item:', REPLACE( str(?edition) , 'http://wikibase.svc/entity/', '' ))) AS ?link )
}
group by ?editionLabel ?link

Try it out!

Incorrectly Linked Statements (NEEDS REVISION)

"Edition of" Statements

Get a list of editions that include an "edition of" statement for something other than a work:

"Copy of" Statements

Get a list of copies that include a "copy of" statement for something other than an edition or issue:

"Issue of" Statements

Get a list of serial issues that include an "issue of" statement for something other than a serial:

Retrieved from "http://blackbibliog.rutgers.edu/w/index.php?title=Quality_control_queries&oldid=285373"