Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F31783527
repeatedQueries_Filter50.csv
GoranSMilovanovic (GoranSM)
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
GoranSMilovanovic
Apr 27 2020, 10:35 PM
2020-04-27 22:35:00 (UTC+0)
Size
52 KB
Referenced Files
None
Subscribers
None
repeatedQueries_Filter50.csv
View Options
"","uniqueSparqlId","sparql","Num_Observations","mean_query_time","median_query_time","stdev_query_time","Percent"
"1",15300,"SELECT DISTINCT ?item \n WHERE { \n ?item wdt:P570 ?date . \n BIND(NOW() - ?date AS ?days) . \n FILTER(?days >= 0 && ?days <= 5) . \n FILTER EXISTS {?w schema:about ?item . ?w schema:isPartOf <https://es.wikipedia.org/>} \n }",142,60374.25,60242.5,520.05,0.013346
"2",509,"\n PREFIX q: <http://www.wikidata.org/prop/qualifier/> \n SELECT DISTINCT ?s WHERE { \n BIND (p:P348 as ?prop) \n ?s ?prop ?st . \n # One claim with point-in-time \n ?st q:P585 ?t . \n # Normal rank \n ?st wikibase:rank wikibase:NormalRank. \n ?st a wikibase:BestRank . \n # Another claim \n ?s ?prop ?st2 . \n FILTER(?st2 != ?st) \n # with a point-in-time time \n ?st2 q:P585 ?t3 . \n # and it's not a dead person \n OPTIONAL { ?s wdt:P570 ?d } \n FILTER(!bound(?d)) \n # and not abolished \n OPTIONAL { ?s wdt:P576 ?ab } \n FILTER(!bound(?ab)) \n # st2 is normal rank and normal is best \n # ?st2 wikibase:rank wikibase:NormalRank. \n # ?st2 a wikibase:BestRank . \n \n } LIMIT 20 \n",91,60005.68,60002,33.71,0.008553
"3",32349,"PREFIX schema: <http://schema.org/> SELECT ?item ?imdb ?date_update WHERE { ?item wdt:P345 ?imdb. FILTER(STRSTARTS(?imdb, """"""""""""""""tt"""""""""""""""")) ?item wdt:P31 ?instanceOf. FILTER (?instanceOf IN (wd:Q11424, wd:Q15416 ) ) ?item schema:dateModified ?date_update. BIND (now() - ?date_update as ?date_range) FILTER (?date_range < 7) ?item wdt:P577 ?publication_date. BIND (now() - ?publication_date as ?publication_range) FILTER (?publication_range < 1000) } ORDER BY DESC(?date_update)",165,29141.81,28017,10901.27,0.015508
"4",19445,"\n SELECT ?item ?prefix ?regex ?suffix ?url WHERE { \n { \n ?item p:P1630 [ps:P1630 ?url]. \n } UNION { \n ?item p:P3303 [ps:P3303 ?url]. \n } UNION { \n ?item p:P7250 [ps:P7250 ?url]. \n } \n ?item wdt:P1793 ?regex. \n \n BIND( strbefore( ?url, """"""""""""""""$1"""""""""""""""" ) as ?prefix ) \n BIND( strafter( ?url, """"""""""""""""$1"""""""""""""""" ) as ?suffix ) \n } ORDER BY DESC(strlen(str(?prefix))) \n",60,17406.8,15097,9660.09,0.005639
"5",11821,"SELECT ?item WHERE { \n ?item wdt:P31 wd:Q5 . \n ?item wdt:P21 wd:Q6581072 . \n ?item wdt:P106 wd:Q1028181 . \n ?item wdt:P569 ?time0 . \n FILTER ( ?time0 >= """"""""""""""""1780-01-01T00:00:00Z""""""""""""""""^^xsd:dateTime && ?time0 <= """"""""""""""""1782-01-01T00:00:00Z""""""""""""""""^^xsd:dateTime ) \n } \n LIMIT 10 \n #TOOL: legacy code",83,1557.29,1226,902.44,0.007801
"6",10087,"SELECT ?item WHERE { \n ?item wdt:P31 wd:Q5 . \n ?item wdt:P21 wd:Q6581072 . \n ?item wdt:P106 wd:Q1028181 . \n ?item wdt:P569 ?time0 . \n FILTER ( ?time0 >= """"""""""""""""1780-01-01T00:00:00Z""""""""""""""""^^xsd:dateTime && ?time0 <= """"""""""""""""1783-01-01T00:00:00Z""""""""""""""""^^xsd:dateTime ) \n } \n LIMIT 10 \n #TOOL: legacy code",50,1370.52,1124.5,749.86,0.004699
"7",10353,"SELECT (?smartphone_model AS ?url) ?smartphone_modelLabel (GROUP_CONCAT(DISTINCT(?altLabel); separator = """""""""""""""","""""""""""""""") AS ?aliases) WHERE { \n SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } \n ?smartphone_model wdt:P31 wd:Q19723451. \n OPTIONAL { \n ?smartphone_model skos:altLabel ?altLabel filter (lang(?altLabel) = """"""""""""""""en""""""""""""""""). \n } \n OPTIONAL { \n ?smartphone_model wdt:P279 ?subclass_of. \n ?subclass_of wdt:P31 ?instance_of_subclass. \n } \n FILTER(?instance_of_subclass!=wd:Q19723451 || !BOUND(?instance_of_subclass)). \n } \n group by ?smartphone_model ?smartphone_modelLabel",183,1324.18,996,1001.66,0.017199
"8",11608,"SELECT DISTINCT ?state ?stateLabel ?id WHERE { \n ?state wdt:P31/wdt:P279* wd:Q3624078; \n p:P463 ?memberOfStatement. \n ?memberOfStatement a wikibase:BestRank; \n ps:P463 wd:Q1065. \n MINUS { ?memberOfStatement pq:P582 ?endTime. } \n MINUS { ?state wdt:P576|wdt:P582 ?end. } \n BIND(STRAFTER(STR(?state), STR(wd:)) AS ?id) \n SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""en"""""""""""""""". } \n } ORDER BY ?stateLabel",69,1074.75,927,670.81,0.006485
"9",21119,"SELECT DISTINCT ?item ?itemLabel ?itemDescription ?coord ?von ?bis (GROUP_CONCAT(DISTINCT ?instance; separator=""""""""""""""""|"""""""""""""""") as ?instances) where { ?item (wdt:P17|wdt:P19|wdt:P20|wdt:P27|wdt:P36|wdt:P119|wdt:P131|wdt:P159|wdt:P180|wdt:P189|wdt:P276|wdt:P279|wdt:P291|wdt:P361|wdt:P551|wdt:P740|wdt:P915|wdt:P840|wdt:P921|wdt:P937|wdt:P1001|wdt:P1071|wdt:P1269|wdt:P1376|wdt:P1416|wdt:P2341|wdt:P2541|wdt:P2647|wdt:P2650)/(wdt:P31*|wdt:P361*|wdt:P131*|wdt:P279*) wd:Q329618 . ?item wdt:P625 ?coord. ?item wdt:P31 ?instance. ?position_statement ps:P625 ?coord. OPTIONAL { ?position_statement pq:P580 ?v} OPTIONAL { ?position_statement pq:P582 ?b} bind(YEAR(?v) as ?von). bind(YEAR(?b) as ?bis). SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""de,en"""""""""""""""". } } group by ?item ?itemLabel ?itemDescription ?coord ?von ?bis order by ?item",85,967.82,875,418.81,0.007989
"10",5523,"\n SELECT (COUNT(*) AS ?count) WHERE { \n ?wikidata (wdt:P106/wdt:P279*) wd:Q36834. \n } \n",126,856.44,820,231.45,0.011842
"11",4840,"PREFIX schema: <http://schema.org/> \n PREFIX p: <http://www.wikidata.org/prop/> \n PREFIX pq: <http://www.wikidata.org/prop/qualifier/> \n PREFIX bd: <http://www.bigdata.com/rdf#> \n PREFIX ps: <http://www.wikidata.org/prop/statement/> \n PREFIX wdt: <http://www.wikidata.org/prop/direct/> \n PREFIX wds: <http://www.wikidata.org/entity/statement/> \n PREFIX wikibase: <http://wikiba.se/ontology#> \n PREFIX wdv: <http://www.wikidata.org/value/> \n PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> \n PREFIX wd: <http://www.wikidata.org/entity/> \n \n SELECT DISTINCT ?editionLabel ?urlLienWikisource ?ark ?badge \n WHERE \n { ?urlLienWikisource \n schema:about ?edition ; \n schema:isPartOf <https://fr.wikisource.org/> \n OPTIONAL \n { ?urlLienWikisource \n wikibase:badge ?badge \n } \n SERVICE wikibase:label \n { bd:serviceParam \n wikibase:language """"""""""""""""fr,en"""""""""""""""" \n } \n ?edition wdt:P4258 ?ark \n } \n",92,819.41,609,592.7,0.008647
"12",3252,"SELECT DISTINCT ?label ?gnd WHERE { \n ?person wdt:P31 wd:Q5. \n ?person p:P166 ?statement. \n ?person rdfs:label ?name. \n ?statement ps:P166 wd:Q47170. \n OPTIONAL { ?statement pq:P585 ?date. BIND(YEAR(?date) AS ?year)}. \n OPTIONAL { ?person wdt:P227 ?gnd}. \n BIND(CONCAT(STR(?name), """""""""""""""" ("""""""""""""""", str(?year) ,"""""""""""""""")"""""""""""""""" ) AS ?label ). \n FILTER (LANG(?name) = """"""""""""""""en""""""""""""""""). \n } ORDER BY ASC(?awardLabel) DESC(?year)",69,674.48,486,491.02,0.006485
"13",847,"SELECT ?wiki WHERE { ?wiki wdt:P31/wdt:P279* wd:Q33120876 . ?wiki wdt:P856 ?site . FILTER REGEX(STR(?site), """"""""""""""""https://ru.wikipedia.org/"""""""""""""""") }",130,486.35,400,399.38,0.012218
"14",3839,"SELECT ?OSM_key ?formatter_URL WHERE { \n { ?item wdt:P1282 ?OSM_key. } \n FILTER(STRSTARTS(?OSM_key, 'Key:')) . \n \n { \n { ?item wdt:P1630 ?formatter_URL. } \n UNION \n { ?item wdt:P3303 ?formatter_URL. } \n } \n } \n",57,452.14,329,433.95,0.005357
"15",420458,"SELECT DISTINCT ?pmidWD \n WHERE { ?work <http://www.wikidata.org/prop/direct/P921> ?virus ; \n <http://www.wikidata.org/prop/direct/P698> ?pmidWD . \n FILTER (?virus = <http://www.wikidata.org/entity/Q278567>) }",54,368.89,264.5,330.14,0.005075
"16",8167,"SELECT ?urls WHERE { \n { wd:Q21980377 p:P856 [wikibase:rank wikibase:PreferredRank; ps:P856 ?urls]. } \n }",57,268.26,205,321.29,0.005357
"17",17521,"SELECT DISTINCT ?type WHERE { wd:Q5296 wdt:P31 ?childClass . ?childClass wdt:P279* ?type }",78,267.73,148.5,405.9,0.007331
"18",8,"prefix schema: <http://schema.org/> SELECT * WHERE {<http://www.wikidata.org> schema:dateModified ?y}",4614,236.21,113,431.76,0.433651
"19",32618,"SELECT DISTINCT ?artwork ?artworkLabel ?location ?image WHERE { ?artwork wdt:P136/wdt:P279* ?genre ; wdt:P625 ?location ; wdt:P170 ?creator . VALUES ?genre { wd:Q557141 wd:Q219423 wd:Q17516 wd:Q326478 wd:Q2740415 } VALUES ?creator { } OPTIONAL { ?artwork wdt:P18 ?image . } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""fr, en"""""""""""""""" . }}",50,199.8,164,160.28,0.004699
"20",217973,"#Tool: wdi_core fastrun \n SELECT ?id ?item ?mrt WHERE {?item p:P1709 ?s . \n ?s ps:P1709 ?id . \n OPTIONAL {?s pq:P4390 ?mrt} \n }",1432,180.07,112.5,231.28,0.134588
"21",32744,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P662) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",54,158.83,26.5,581.79,0.005075
"22",42530,"SELECT ?item WHERE { ?item wdt:P21 wd:Q6581072. ?item wdt:P106 ?occ. ?occ wdt:P279* wd:Q2374149 } \n LIMIT 10 \n #TOOL: legacy code",65,130.57,76,204.04,0.006109
"23",348,"\n SELECT ?urls WHERE { \n { wd:Q21980377 p:P856 [wikibase:rank wikibase:PreferredRank; ps:P856 ?urls]. } \n } \n",440,127.31,51.5,292.54,0.041354
"24",5303,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P352) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",65,113.72,31,216.18,0.006109
"25",14807,"\n PREFIX schema: <http://schema.org/> \n PREFIX wd: <http://www.wikidata.org/entity/> \n PREFIX wdt: <http://www.wikidata.org/prop/direct/> \n \n #Tool: PBB_core fastrun \n \n SELECT ?article WHERE { \n ?cid wdt:P351 '1017'. \n ?cid wdt:P703 wd:Q15978631 . \n OPTIONAL { ?cid rdfs:label ?label filter (lang(?label) = """"""""""""""""en"""""""""""""""") .} \n ?article schema:about ?cid . \n ?article schema:inLanguage """"""""""""""""en"""""""""""""""" . \n FILTER (SUBSTR(str(?article), 1, 25) = """"""""""""""""https://en.wikipedia.org/"""""""""""""""") . \n FILTER (SUBSTR(str(?article), 1, 38) != """"""""""""""""https://en.wikipedia.org/wiki/Template"""""""""""""""") \n } \n limit 1 \n",56,108.68,47,224.09,0.005263
"26",3755,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P5573) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",96,103.66,26,345.14,0.009023
"27",24480,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P699) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",62,101.37,25,321.97,0.005827
"28",3519,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P1417) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",128,98.91,29,297.98,0.01203
"29",94803,"#Tool: wdi_core fastrun \n SELECT ?id ?item ?mrt WHERE {?item p:P1628 ?s . \n ?s ps:P1628 ?id . \n OPTIONAL {?s pq:P4390 ?mrt} \n }",1516,97.21,42,198.3,0.142483
"30",1744,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P227) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",234,96.88,34,223.21,0.021993
"31",371462,"SELECT DISTINCT ?pmid1 \n WHERE { ?work <http://www.wikidata.org/prop/direct/P921> ?virus ; \n <http://www.wikidata.org/prop/direct/P698> ?pmid1 . \n FILTER (?virus = <http://www.wikidata.org/entity/Q82069695>) } \n LIMIT 1",72,95.35,37.5,151.29,0.006767
"32",1663,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P214) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",704,93.44,37,204.46,0.066166
"33",590048,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""BRI"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""BRI"""""""""""""""" . } }",74,91.35,18.5,260.29,0.006955
"34",40909,"SELECT DISTINCT ?label WHERE { \n wd: p:P166 ?statement. \n ?statement ps:P166 ?award. \n ?award wdt:P31 wd:Q17701409. \n ?award rdfs:label ?name. \n OPTIONAL { ?statement pq:P585 ?date. BIND(YEAR(?date) AS ?year) } \n SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""en"""""""""""""""" } \n BIND(CONCAT(STR(?year), """""""""""""""" - """""""""""""""", str(?name) ,"""""""""""""""""""""""""""""""" ) AS ?label ). \n FILTER (LANG(?name) = """"""""""""""""en""""""""""""""""). \n } ORDER BY ASC(?awardLabel) ASC(?year)",67,89.6,28,196.17,0.006297
"35",18810,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P349) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",54,89.59,33.5,163.39,0.005075
"36",24239,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P2924) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",59,87.69,29,184.5,0.005545
"37",1384,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P244) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",248,87.3,37,156.44,0.023308
"38",790880,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""SGO"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""SGO"""""""""""""""" . } }",53,86.98,20,271.57,0.004981
"39",1713,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P1296) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",99,84.7,29,265.91,0.009305
"40",593647,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""COL"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""COL"""""""""""""""" . } }",154,80.06,28,221.02,0.014474
"41",1561,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P213) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",138,78.78,38,134.79,0.01297
"42",17073,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P442) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",95,78.65,26,243.89,0.008929
"43",1568,"SELECT ?s \n WHERE { \n ?s wdt:P646 """"""""""""""""/m/03g09t"""""""""""""""" . \n } \n",81,78.52,16,239.16,0.007613
"44",733978,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""MEXU"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""MEXU"""""""""""""""" . } }",96,77.98,21,237.98,0.009023
"45",89369,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""BISH"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""BISH"""""""""""""""" . } }",251,77.44,18,282.5,0.02359
"46",16225,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P6366) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",68,75,28,176.65,0.006391
"47",13134,"SELECT ?s \n WHERE { \n ?s wdt:P646 """"""""""""""""/m/01jwgf"""""""""""""""" . \n } \n",71,73.41,18,247.99,0.006673
"48",6119,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P2163) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",55,73.29,32,116.27,0.005169
"49",803157,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""UC"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""UC"""""""""""""""" . } }",95,72.68,44,73.96,0.008929
"50",40110,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P2581) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",58,71.97,27,165.6,0.005451
"51",16895,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P6671) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",52,70.5,30,121.56,0.004887
"52",73,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P646) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",517,70.44,28,173.63,0.048591
"53",6276,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P268) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",172,69.52,34.5,90.22,0.016166
"54",11899,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P691) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",116,69.41,27,119.05,0.010902
"55",631275,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""H"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""H"""""""""""""""" . } }",151,69.3,17,250.75,0.014192
"56",4609,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""A"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""A"""""""""""""""" . } }",309,68.85,25,181.63,0.029042
"57",5104,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P1616) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",60,67.18,26,162.48,0.005639
"58",33464,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P374) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",83,67,32,105.78,0.007801
"59",719843,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""NDG"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""NDG"""""""""""""""" . } }",108,65.67,16.5,189,0.01015
"60",610,"SELECT distinct ?gsid ?orcid ?repec ?nobelid ?ssrn ?tw ?scopus WHERE { \n OPTIONAL {wd: wdt:P1960 ?gsid}. \n OPTIONAL {wd: wdt:P496 ?orcid}. \n OPTIONAL {wd: wdt:P2428 ?repec}. \n #OPTIONAL {wd: wdt:P213 ?isni}. \n OPTIONAL {wd: wdt:P3188 ?nobelid}. \n OPTIONAL {wd: wdt:P3747 ?ssrn}. \n OPTIONAL {wd: wdt:P2002 ?tw}. \n OPTIONAL {wd: wdt:P1153 ?scopus}. \n \n }",68,65.65,21.5,115.76,0.006391
"61",564833,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""KE"""""""""""""""" . }",66,64.83,16,222.76,0.006203
"62",12811,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P402) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",358,64.28,30,143.11,0.033647
"63",3414,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P1566) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",371,64.17,29,125.58,0.034869
"64",71892,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""AT"""""""""""""""" . }",55,63.29,20,151.11,0.005169
"65",2646,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P6766) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",272,62.88,26,154.37,0.025564
"66",78262,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""NP"""""""""""""""" . }",143,62.5,15,266.83,0.01344
"67",83684,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""CD"""""""""""""""" . }",302,61.87,15,226.27,0.028384
"68",794259,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""TUB"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""TUB"""""""""""""""" . } }",83,60.08,25,184.02,0.007801
"69",218866,"PREFIX owl: <http://www.w3.org/2002/07/owl#> \n PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> \n PREFIX schema: <http://schema.org/> \n PREFIX wikibase: <http://wikiba.se/ontology#> \n \n SELECT * WHERE { \n FILTER (false) \n OPTIONAL { \n BIND(""""""""""""""""WikidataID"""""""""""""""" AS ?Property) \n ?Entity owl:sameAs? ?Value . \n BIND(wikibase:WikibaseItem AS ?ValueType) \n OPTIONAL { \n ?Value rdfs:label ?ValueLabel . \n FILTER (lang(?ValueLabel) = """"""""""""""""en"""""""""""""""") \n } \n OPTIONAL { \n ?Value schema:description ?ValueDescription . \n FILTER (lang(?ValueDescription) = """"""""""""""""en"""""""""""""""") \n } \n } \n }",8914,59.34,22,182.63,0.83779
"70",7592,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P704) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",61,58.75,25,170.11,0.005733
"71",261820,"SELECT ?isdead WHERE { \n SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } \n optional { wd:Q180589 wdt:P570 ?dod }. \n BIND(if(bound(?dod), """"""""""""""""yes"""""""""""""""", """"""""""""""""no"""""""""""""""") as ?isdead) \n } \n",2292,58.37,19,179.23,0.215416
"72",50980,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P269) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",76,58.37,31,93.45,0.007143
"73",2491,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P3417) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",144,58.31,31,82.3,0.013534
"74",11931,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""AU"""""""""""""""" . }",1281,57.87,16,206.41,0.120396
"75",19013,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""NC"""""""""""""""" . }",180,57.57,16,195.33,0.016917
"76",47473,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""AR"""""""""""""""" . }",563,56.35,15,169.64,0.052914
"77",587182,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""E"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""E"""""""""""""""" . } }",818,55.94,21,171.22,0.07688
"78",57876,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""GR"""""""""""""""" . }",91,55.25,15,202.24,0.008553
"79",4443,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""PH"""""""""""""""" . }",472,54.92,16,189.45,0.044361
"80",721956,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""M"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""M"""""""""""""""" . } }",575,54.3,20,156.33,0.054042
"81",597680,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""G"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""G"""""""""""""""" . } }",1482,54.19,17,192.81,0.139287
"82",794537,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""UBT"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""UBT"""""""""""""""" . } }",57,53.28,25,84.93,0.005357
"83",93821,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""CM"""""""""""""""" . }",216,52.97,15,223.12,0.020301
"84",88006,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""SI"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""SI"""""""""""""""" . } }",311,52.93,17,181.19,0.02923
"85",809,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P7859) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",234,52.86,26,97.6,0.021993
"86",4887,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P982) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",83,52.83,26,86.4,0.007801
"87",52541,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""CL"""""""""""""""" . }",407,52.64,16,183.49,0.038252
"88",724090,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""LL"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""LL"""""""""""""""" . } }",69,52,21,94.97,0.006485
"89",632021,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""JE"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""JE"""""""""""""""" . } }",340,51.92,16,189.8,0.031955
"90",45638,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""IR"""""""""""""""" . }",247,51.81,16,169.33,0.023215
"91",139,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P351) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",71,51.54,25,64.35,0.006673
"92",721550,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""NY"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""NY"""""""""""""""" . } }",1271,51.34,18,159.96,0.119456
"93",48597,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""IN"""""""""""""""" . }",569,51.21,15,190.35,0.053478
"94",61575,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""FR"""""""""""""""" . }",196,51.19,15,190.89,0.018421
"95",576613,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""EG"""""""""""""""" . }",51,51.14,16,159.48,0.004793
"96",590868,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""DAO"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""DAO"""""""""""""""" . } }",58,50.72,21,112.59,0.005451
"97",48529,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""PE"""""""""""""""" . }",496,50.66,16,149.35,0.046617
"98",51962,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""TH"""""""""""""""" . }",133,50.53,16,156.26,0.0125
"99",755665,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""PERTH"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""PERTH"""""""""""""""" . } }",72,50.24,16,153.4,0.006767
"100",629997,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""GH"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""GH"""""""""""""""" . } }",578,49.7,17,155.62,0.054324
"101",127824,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""MG"""""""""""""""" . }",422,49.54,15,172.99,0.039662
"102",588588,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""F"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""F"""""""""""""""" . } }",577,49.15,18,136.82,0.05423
"103",564826,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""NG"""""""""""""""" . }",61,49.15,16,112.14,0.005733
"104",9701,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P2427) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",128,49.06,27.5,58.08,0.01203
"105",720688,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""MEL"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""MEL"""""""""""""""" . } }",283,48.95,20,135.5,0.026598
"106",4751,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""PA"""""""""""""""" . }",151,48.38,16,162.84,0.014192
"107",630670,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""GOET"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""GOET"""""""""""""""" . } }",163,47.69,17,150.34,0.01532
"108",50515,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""ES"""""""""""""""" . }",192,47.6,16,121.87,0.018045
"109",27788,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P1225) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",62,47.18,29,42.94,0.005827
"110",794406,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""U"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""U"""""""""""""""" . } }",120,47.03,21.5,90.71,0.011278
"111",589790,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""SD"""""""""""""""" . }",64,46.94,17,80.07,0.006015
"112",590260,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""CANB"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""CANB"""""""""""""""" . } }",93,46,26,51.17,0.008741
"113",4397,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""US"""""""""""""""" . }",2378,45.82,15,150.01,0.223498
"114",2042,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""CN"""""""""""""""" . }",633,45.81,16,159.86,0.059493
"115",49454,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""BO"""""""""""""""" . }",326,45.66,17.5,126.04,0.030639
"116",792809,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""RM"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""RM"""""""""""""""" . } }",59,45.36,15,193.17,0.005545
"117",50527,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""ET"""""""""""""""" . }",287,45.21,15,154.14,0.026974
"118",48936,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""BR"""""""""""""""" . }",2154,44.97,16,143.45,0.202446
"119",87800,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""GY"""""""""""""""" . }",124,44.78,16,148.08,0.011654
"120",70893,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""IT"""""""""""""""" . }",117,44.56,19,64.91,0.010996
"121",20645,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""MX"""""""""""""""" . }",1418,44.5,16,122.42,0.133272
"122",723672,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""MA"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""MA"""""""""""""""" . } }",410,44.1,18,108.58,0.038534
"123",44091,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""CO"""""""""""""""" . }",792,43.93,16,116.79,0.074437
"124",98541,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""PR"""""""""""""""" . }",71,43.89,16,103.06,0.006673
"125",695059,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""LD"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""LD"""""""""""""""" . } }",71,43.72,16,207.76,0.006673
"126",46565,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""VE"""""""""""""""" . }",338,43.54,16,106.45,0.031767
"127",77120,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""MA"""""""""""""""" . }",211,43.54,15,125.58,0.019831
"128",3951,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P594) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",116,43.33,25,40.85,0.010902
"129",127656,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""JM"""""""""""""""" . }",112,43.2,16,96.58,0.010526
"130",37649,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""TR"""""""""""""""" . }",297,42.67,15,149.1,0.027914
"131",19151,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""MY"""""""""""""""" . }",356,42.64,16,140.84,0.033459
"132",641514,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""GZU"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""GZU"""""""""""""""" . } }",66,42.42,16,135.2,0.006203
"133",52976,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""PY"""""""""""""""" . }",232,41.97,15.5,122.51,0.021805
"134",47710,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""LK"""""""""""""""" . }",129,41.91,16,177.14,0.012124
"135",721061,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""LINN"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""LINN"""""""""""""""" . } }",388,41.82,16,141.48,0.036467
"136",603406,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""BOL"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""BOL"""""""""""""""" . } }",148,41.78,17,107.76,0.01391
"137",790199,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""S"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""S"""""""""""""""" . } }",722,41.64,17,136.65,0.067858
"138",206771,"#Tool: wdi_core fastrun \n SELECT * WHERE { \n ?item ?prop <http://www.w3.org/2002/07/owl#equivalentProperty> . \n ?item <http://wikiba.se/ontology#directClaim> ?prop . \n }",1496,41.59,16,140.04,0.140603
"139",632445,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""K"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""K"""""""""""""""" . } }",3351,41.41,16,143.31,0.314947
"140",719960,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""NBG"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""NBG"""""""""""""""" . } }",54,41,16.5,65.68,0.005075
"141",51054,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""VN"""""""""""""""" . }",151,40.9,15,141.82,0.014192
"142",755677,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""PH"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""PH"""""""""""""""" . } }",493,40.72,16,152.25,0.046335
"143",4344,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""ZZ"""""""""""""""" . }",1213,40.61,15,136.9,0.114005
"144",598628,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""C"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""C"""""""""""""""" . } }",175,40.59,20,55.26,0.016448
"145",589279,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""FI"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""FI"""""""""""""""" . } }",139,40.58,17,168.55,0.013064
"146",70894,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""AO"""""""""""""""" . }",199,40.21,16,147.7,0.018703
"147",563504,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""SR"""""""""""""""" . }",69,39.93,17,61.56,0.006485
"148",794008,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""TCD"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""TCD"""""""""""""""" . } }",159,39.7,22,56.51,0.014944
"149",556657,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""MM"""""""""""""""" . }",84,39.61,15,188.87,0.007895
"150",15556,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""ZA"""""""""""""""" . }",1274,39.48,15,136.31,0.119738
"151",45106,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""NZ"""""""""""""""" . }",137,39.18,15,116.29,0.012876
"152",76977,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""RU"""""""""""""""" . }",119,39.06,17,104.41,0.011184
"153",754590,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""P"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""P"""""""""""""""" . } }",2127,39.04,17,121.95,0.199908
"154",680677,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""L"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""L"""""""""""""""" . } }",461,38.92,16,133.39,0.043327
"155",119345,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""TZ"""""""""""""""" . }",241,38.58,15,132.37,0.022651
"156",761041,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""JBRJ"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""JBRJ"""""""""""""""" . } }",82,38.39,15,113.67,0.007707
"157",4616,"#Tool: wdi_core fastrun \n SELECT (STRAFTER(STR(?property), 'entity/') as ?id) ?property ?propertyType ?propertyLabel ?propertyDescription ?propertyAltLabel (STRAFTER(STR(?propertyType), '#') as ?value_type) ?formatter_url WHERE { VALUES (?property) { (wd:P2115) } ?property wikibase:propertyType ?propertyType . OPTIONAL { ?property wdt:P1630 ?formatter_url. } SERVICE wikibase:label { bd:serviceParam wikibase:language """"""""""""""""[AUTO_LANGUAGE],en"""""""""""""""". } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?property), 'P')))",52,38.37,25,24.62,0.004887
"158",88990,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""BM"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""BM"""""""""""""""" . } }",1279,38.09,17,120.01,0.120208
"159",88319,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""BR"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""BR"""""""""""""""" . } }",822,37.94,17,108.11,0.077256
"160",789956,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""US"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""US"""""""""""""""" . } }",1108,37.7,17,88.35,0.104136
"161",48885,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""CR"""""""""""""""" . }",176,37.31,15,84.35,0.016542
"162",594195,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""CORD"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""CORD"""""""""""""""" . } }",122,37.25,18,47.66,0.011466
"163",67807,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""FJ"""""""""""""""" . }",60,37.02,16.5,77.02,0.005639
"164",2015,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""CU"""""""""""""""" . }",279,36.76,16,103.38,0.026222
"165",4399,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""ID"""""""""""""""" . }",493,36.68,15,111.01,0.046335
"166",590217,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""CAS"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""CAS"""""""""""""""" . } }",146,36.42,20,33.66,0.013722
"167",631423,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""HAL"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""HAL"""""""""""""""" . } }",128,36.37,17,74.37,0.01203
"168",68268,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""JP"""""""""""""""" . }",163,35.75,16,60.56,0.01532
"169",45168,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""AMES"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""AMES"""""""""""""""" . } }",54,35.69,17,87.3,0.005075
"170",720892,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""MICH"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""MICH"""""""""""""""" . } }",180,35.63,18,62.08,0.016917
"171",558647,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""SE"""""""""""""""" . }",95,35.33,15,62.81,0.008929
"172",720501,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""LE"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""LE"""""""""""""""" . } }",170,35.22,16,95.62,0.015978
"173",45578,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""IQ"""""""""""""""" . }",57,33.89,17,57.51,0.005357
"174",719328,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""MPU"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""MPU"""""""""""""""" . } }",347,32.21,16,69.31,0.032613
"175",720346,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""NSW"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""NSW"""""""""""""""" . } }",61,32.16,16,46.27,0.005733
"176",795482,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""W"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""W"""""""""""""""" . } }",147,32.06,16,81.11,0.013816
"177",792829,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""RSA"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""RSA"""""""""""""""" . } }",191,31.81,17,72.42,0.017951
"178",11856,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""MU"""""""""""""""" . }",50,30.92,15,77.03,0.004699
"179",11934,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""PG"""""""""""""""" . }",259,30.4,17,46.14,0.024342
"180",45649,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""DE"""""""""""""""" . }",168,30.27,15,36.52,0.01579
"181",585257,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""DZ"""""""""""""""" . }",74,30.09,16.5,31.31,0.006955
"182",46932,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""EC"""""""""""""""" . }",333,30.04,15,52.61,0.031297
"183",568341,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""GF"""""""""""""""" . }",55,29.42,15,41.86,0.005169
"184",85690,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""AF"""""""""""""""" . }",59,29.34,15,42.35,0.005545
"185",632054,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""ILL"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""ILL"""""""""""""""" . } }",79,29.15,16,31.92,0.007425
"186",91377,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""GB"""""""""""""""" . }",129,28.4,15,46.15,0.012124
"187",790696,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""SAV"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""SAV"""""""""""""""" . } }",68,27.78,16,49.11,0.006391
"188",20007,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""CA"""""""""""""""" . }",109,27.49,16,37.5,0.010244
"189",719344,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""MO"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""MO"""""""""""""""" . } }",333,27.45,16,30.32,0.031297
"190",686206,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""WAG"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""WAG"""""""""""""""" . } }",74,27.39,15,40.88,0.006955
"191",639051,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""HBG"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""HBG"""""""""""""""" . } }",173,27.23,16,69.4,0.01626
"192",761011,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""R"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""R"""""""""""""""" . } }",61,27.2,16,31.45,0.005733
"193",795491,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""VEN"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""VEN"""""""""""""""" . } }",62,26.79,16,35.2,0.005827
"194",572454,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""GP"""""""""""""""" . }",50,26.52,15.5,39.86,0.004699
"195",558936,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""CH"""""""""""""""" . }",72,25.79,14,33.08,0.006767
"196",123807,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""GA"""""""""""""""" . }",79,25.3,15,26.1,0.007425
"197",59929,"SELECT ?item WHERE { ?item wdt:P297 """"""""""""""""GT"""""""""""""""" . }",119,24.64,15,27.93,0.011184
"198",45543,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""B"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""B"""""""""""""""" . } }",77,22.19,16,12.82,0.007237
"199",758163,"SELECT ?item WHERE { { ?item wdt:P5818 """"""""""""""""PRE"""""""""""""""" . } UNION { ?item wdt:P5858 """"""""""""""""PRE"""""""""""""""" . } }",151,21.13,16,14.07,0.014192
File Metadata
Details
Attached
Mime Type
text/plain
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
8393496
Default Alt Text
repeatedQueries_Filter50.csv (52 KB)
Attached To
Mode
T248308: Analyse a small sample of the most often used query patterns on WDQS
Attached
Detach File
Event Timeline
Log In to Comment