Editing QAWiki:Curation/Quality Control Queries

== Quality Control Queries ==

The following is a list of queries intended to help detect specific quality issues on QAWiki using its [http://query.qawiki.org/ SPARQL Query Service]. Not all answers returned are necessarily problematic.

=== Untyped questions === 

[http://query.qawiki.org/#%23%20untyped%20questions%0ASELECT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP11%20%3Fobj%20.%0A%20%20MINUS%20%7B%0A%20%20%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%20%0A%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 Link]

=== Questions with no queries ===

[http://query.qawiki.org/#%23%20questions%20with%20no%20queries%0ASELECT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%20%0A%20%20MINUS%20%7B%0A%20%20%20%20%3Fsbj%20wdt%3AP11%20%3Fobj%20.%0A%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 Link]

=== Questions with no entity mentions ===

[http://query.qawiki.org/#%23%20questions%20with%20no%20entity%20mentions%0ASELECT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%20%0A%20%20MINUS%20%7B%0A%20%20%20%20%3Fsbj%20wdt%3AP47%2a%2Fwdt%3AP38%20%3Fobj%0A%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 Link] (not all results are necessarily problematic)

=== Questions with mentions without Wikidata link ===

[http://query.qawiki.org/#%23%20mentions%20with%20no%20Wikidata%20item%20ID%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj%20.%20%3Fobj%20ps%3AP38%20%3Fmention%20.%0A%20%20MINUS%20%7B%20%3Fobj%20pq%3AP17%7Cpq%3AP18%7Cpq%3AP45%7Cpq%3AP48%7Cpq%3AP49%7Cpq%3AP51%7Cpq%3AP52%7Cpq%3AP55%7Cpq%3AP56%7Cpq%3AP58%7Cpq%3AP59%20%3Fobj2%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 Link]

=== Items with some label but not in (e.g.) Spanish ===

[http://query.qawiki.org/#%23%20items%20with%20labels%20but%20no%20Spanish%20label%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20%3Fo%20.%0A%20%20%3Fsbj%20rdfs%3Alabel%20%3Flab%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20rdfs%3Alabel%20%3Flab2%20.%20FILTER%28lang%28%3Flab2%29%3D%22es%22%29%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link] (can change <code>es</code> to other languages)

=== Questions with some mentions but not in (e.g.) Spanish ===

[http://query.qawiki.org/#%23%20questions%20with%20no%20Spanish%20mentions%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%0A%20%20%3Fsbj%20wdt%3AP38%20%3Fmention%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20wdt%3AP38%20%3Fobj%20.%20FILTER%28lang%28%3Fobj%29%20%3D%20%22es%22%29%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link] (can change <code>es</code> to other languages)

=== Queries with no dataset specified ===

[http://query.qawiki.org/#%23%20queries%20with%20no%20dataset%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20p%3AP11%20%3Fobj%20.%20%3Fobj%20pq%3AP13%20%3Fd%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]

=== Queries with no query language specified ===

[http://query.qawiki.org/#%23%20queries%20with%20no%20query%20language%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP1%20wd%3AQ1%20.%0A%20%20MINUS%20%7B%20%3Fsbj%20p%3AP11%20%3Fobj%20.%20%3Fobj%20pq%3AP12%20%3Fd%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]

=== Wikidata item IDs that do not start with <code>Q</code> ===

[http://query.qawiki.org/#%23%20Wikidata%20item%20IDs%20not%20starting%20with%20Q%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Flink%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj%20.%20%3Fobj%20pq%3AP17%20%3Flink%20.%20%3Fobj%20ps%3AP38%20%3Fmention%20.%0A%20%20FILTER%28%21strstarts%28str%28%3Flink%29%2C%22Q%22%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]

=== Wikidata property IDs that do not start with <code>P</code> ===

[http://query.qawiki.org/#%23%20Wikidata%20item%20IDs%20not%20starting%20with%20Q%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Flink%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj%20.%20%3Fobj%20pq%3AP18%7Cpq%3AP45%7Cpq%3AP48%7Cpq%3AP49%7Cpq%3AP50%7Cpq%3AP51%7Cpq%3AP52%7Cpq%3AP55%7Cpq%3AP56%7Cpq%3AP58%7Cpq%3AP59%20%3Flink%20.%20%3Fobj%20ps%3AP38%20%3Fmention%20.%0A%20%20FILTER%28%21strstarts%28str%28%3Flink%29%2C%22P%22%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]

=== Mentions not contained in question label or alias with the same language ===

[http://query.qawiki.org/#%23%20Mentions%20not%20contained%20in%20a%20label%20or%20alias%20with%20the%20same%20language%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Fmention%0AWHERE%20%7B%0A%20%20%3Fsbj%20wdt%3AP38%20%3Fmention%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%0A%20%20%20%20%3Fsbj%20rdfs%3Alabel%7Cskos%3AaltLabel%20%3Ffull%20.%0A%20%20%20%20FILTER%28lang%28%3Ffull%29%3Dlang%28%3Fmention%29%20%26%26%20contains%28str%28%3Ffull%29%2Cstr%28%3Fmention%29%29%29%0A%20%20%7D%0A%20%20FILTER%28%21contains%28str%28%3Fmention%29%2C%22%2a%22%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D Link]

=== Same mentions across languages with different Wikidata IDs ===
[https://query.qawiki.org/#%23%20Same%20mentions%20across%20languages%20with%20different%20Wikidata%20IDs%0ASELECT%20DISTINCT%20%3Fsbj%20%3FsbjLabel%20%3Fmention1%20%3Fmention2%20%3Fwd1%20%3Fwd2%0AWHERE%20%7B%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj1%20.%20%3Fobj1%20ps%3AP38%20%3Fmention1%20.%20%3Fobj1%20pq%3AP17%20%3Fwd1%20.%0A%20%20%3Fsbj%20p%3AP38%20%3Fobj2%20.%20%3Fobj2%20ps%3AP38%20%3Fmention2%20.%0A%20%20FILTER%28%3Fobj1%20%21%3D%20%3Fobj2%20%26%26%20STR%28%3Fmention1%29%20%3D%20STR%28%3Fmention2%29%29%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fobj2%20pq%3AP17%20%3Fwd1%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 Link]

=== Check that all inverse relations are provided ===
[https://query.qawiki.org/#%23%20query%20to%20check%20that%20all%20inverses%20are%20provided%0ASELECT%20%3Fs%20%3Fpd%20%3Fo%20%3Fpdi%20WHERE%20%7B%0A%20%20%3Fp%20a%20wikibase%3AProperty%20.%0A%20%20%3Fp%20wikibase%3AdirectClaim%20%3Fpd%20.%0A%20%20%3Fp%20wdt%3AP31%20%3Fpi%20.%0A%20%20%3Fpi%20wikibase%3AdirectClaim%20%3Fpdi%20.%0A%20%20%3Fs%20%3Fpd%20%3Fo%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fo%20%3Fpdi%20%3Fs%20%7D%0A%7D Link]

=== Check that all symmetric relations are provided ===
[https://query.qawiki.org/#%23%20query%20to%20check%20that%20all%20symmetric%20relations%20are%20provided%0ASELECT%20%3Fs%20%3Fpd%20%3Fo%20%3Fpdi%20WHERE%20%7B%0A%20%20%3Fp%20a%20wikibase%3AProperty%20.%0A%20%20%3Fp%20wikibase%3AdirectClaim%20%3Fpd%20.%0A%20%20%3Fp%20wdt%3AP1%20wd%3AQ62%20.%0A%20%20%3Fs%20%3Fpd%20%3Fo%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fo%20%3Fpd%20%3Fs%20.%20%7D%0A%7D Link]