User:Infovarius/numbers
Jump to navigation
Jump to search
Try it!
Try it!
About sitelinks: User_talk:Bigbossfarin#Big_numbers
Wikidata:WikiProject Mathematics/integers
long and short scales (Q725503)=short scale (Q19202120) or long scale (Q19202121)
All entered data:
SELECT distinct ?itemLabel ?shortname ?longname ?sq2Label ?sq3Label ?sq4Label ?sq5Label ?sq6Label ?sq7Label ?sq8Label
# Can be added but don't fit: ?item ?number ?_image
WHERE {
?item wdt:P31/wdt:P279* wd:Q184611.
?item wdt:P31 ?type.
OPTIONAL{?item p:P31 [ ps:P31 wd:Q50705;
wikibase:rank ?rank ;
pq:P642 ?sq2 ] .}
OPTIONAL{?item p:P31 [ ps:P31 wd:Q861555;
wikibase:rank ?rank ;
pq:P642 ?sq3 ] .}
OPTIONAL{?item p:P31 [ ps:P31 wd:Q840676;
wikibase:rank ?rank ;
pq:P642 ?sq4 ] .}
OPTIONAL{?item p:P31 [ ps:P31 wd:Q10549775;
wikibase:rank ?rank ;
pq:P642 ?sq5 ] .}
OPTIONAL{?item p:P31 [ ps:P31 wd:Q37947496;
wikibase:rank ?rank ;
pq:P642 ?sq6 ] .}
OPTIONAL{?item p:P31 [ ps:P31 wd:Q37947505;
wikibase:rank ?rank ;
pq:P642 ?sq7 ] .}
OPTIONAL{?item p:P31 [ ps:P31 wd:Q84752530;
wikibase:rank ?rank ;
pq:P642 ?sq8 ] .}
OPTIONAL {?item p:P2561 [ ps:P2561 ?shortname ;
pq:P1013 wd:Q19202120 ].
FILTER (lang(?shortname) = "ru")}
OPTIONAL {?item p:P2561 [ ps:P2561 ?longname ;
pq:P1013 wd:Q19202121 ].
FILTER (lang(?longname) = "ru")}
?item wdt:P1181 ?number.
OPTIONAL {?item wdt:P7316 ?digits.}
SERVICE wikibase:label {
bd:serviceParam wikibase:language "ru" .
}
OPTIONAL { ?item wdt:P18 ?_image. }
}
ORDER BY ASC(?number)
Names:
SELECT distinct ?item ?itemLabel ?name ?runame ?shortnumLabel ?longnumLabel ?number
WHERE {
?item wdt:P31/wdt:P279* wd:Q63116 .
OPTIONAL{?item p:P31 [ ps:P31 wd:Q50705;
wikibase:rank ?rank ;
pq:P642 ?sq2 ] .}
?item wdt:P1705 ?name .
OPTIONAL {?item p:P1705 [ps:P1705 ?runame]
FILTER (lang(?runame) = "ru")}
OPTIONAL {?item p:P1269 [ ps:P1269 ?shortnum ;
pq:P3005 wd:Q19202120 ].}
OPTIONAL {?item p:P1269 [ ps:P1269 ?longnum ;
pq:P3005 wd:Q19202121 ].}
OPTIONAL { ?item wdt:P1181 ?number.}
# FILTER (?name!=?runame) #uncomment to throw off non-systematical
FILTER (?item!=wd:Q199)
SERVICE wikibase:label {
bd:serviceParam wikibase:language "ru" .
}
OPTIONAL { ?item wdt:P18 ?_image. }
}
ORDER BY ASC(?number)