User:Sannita/Constraint violations/P396 single value
Jump to navigation
Jump to search
This list is periodically updated by a bot. Manual changes to the list will be removed on the next update!
WDQS | PetScan | TABernacle | Find images | Recent changes | Query:SELECT DISTINCT ?item ?itemLabel ?count ?sample1 ?sample2 ?exception WHERE { { SELECT ?item (COUNT(?value) AS ?count) (MIN(?value) AS ?sample1) (MAX(?value) AS ?sample2) { ?item wdt:P396 ?val . OPTIONAL { wd:P396 wdt:P1630 ?formatter } . BIND( IF( BOUND( ?formatter ), URI( REPLACE( ?formatter, '\\$1', ?val ) ), ?val ) AS ?value ) . } GROUP BY ?item HAVING ( ?count > 1 ) LIMIT 100 } . OPTIONAL { wd:P396 p:P2302 [ ps:P2302 wd:Q19474404; pq:P2303 ?exc ] . FILTER( ?exc = ?item ) . } . BIND( BOUND( ?exc ) AS ?exception ) . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } . }End of automatically generated list.