CINXE.COM

<!DOCTYPE html> <html class="client-nojs" lang="en" dir="ltr"> <head> <meta charset="UTF-8"> <title>User:MisterSynergy/rowing/queries - Wikidata</title> <script>(function(){var className="client-js";var cookie=document.cookie.match(/(?:^|; )wikidatawikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""],"wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"e8c9fb15-6662-4c90-b772-4d76c7561e73","wgCanonicalNamespace":"User","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":2,"wgPageName":"User:MisterSynergy/rowing/queries","wgTitle":"MisterSynergy/rowing/queries","wgCurRevisionId":1250025433,"wgRevisionId":1250025433,"wgArticleId":65710095,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName" :null,"wgUserGroups":["*"],"wgCategories":[],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"User:MisterSynergy/rowing/queries","wgRelevantArticleId":65710095,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgRelevantUserName":"MisterSynergy","wgNoticeProject":"wikidata","wgCiteReferencePreviewsActive":true,"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":true,"wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":false,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":20000,"wgCentralAuthMobileDomain":false,"wgEditSubmitButtonLabelPublish":true,"wgULSPosition":"personal","wgULSisCompactLinksEnabled":true,"wgVector2022LanguageInHeader":false,"wgULSisLanguageSelectorEmpty":false, "wgCheckUserClientHintsHeadersJsApi":["brands","architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"]};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.pygments":"ready","skins.vector.styles.legacy":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","codex-search-styles":"ready","ext.uls.pt":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["ext.pygments.view","site","mediawiki.page.ready","mediawiki.toc","skins.vector.legacy.js","wikibase.ui.entitysearch","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.gadget.Search","ext.gadget.ProtectionIndicators","ext.gadget.imagelinks","ext.gadget.NewSection","ext.gadget.formWizard","ext.urlShortener.toolbar","ext.centralauth.centralautologin","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.eventLogging", "ext.wikimediaEvents","ext.wikimediaEvents.wikibase","ext.navigationTiming","ext.uls.compactlinks","ext.uls.interface","ext.checkUser.clientHints"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=en&modules=codex-search-styles%7Cext.pygments%2CwikimediaBadges%7Cext.uls.pt%7Cext.visualEditor.desktopArticleTarget.noscript%7Cskins.vector.styles.legacy&only=styles&skin=vector"> <script async="" src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector"> <meta name="generator" content="MediaWiki 1.44.0-wmf.4"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="noindex,follow,max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//m.wikidata.org/wiki/User:MisterSynergy/rowing/queries"> <link rel="alternate" type="application/x-wiki" title="Edit" href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit"> <link rel="apple-touch-icon" href="/static/apple-touch/wikidata.png"> <link rel="icon" href="/static/favicon/wikidata.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="Wikidata (en)"> <link rel="EditURI" type="application/rsd+xml" href="//www.wikidata.org/w/api.php?action=rsd"> <link rel="canonical" href="https://www.wikidata.org/wiki/User:MisterSynergy/rowing/queries"> <link rel="license" href="/wiki/Wikidata:Copyright"> <link rel="alternate" type="application/atom+xml" title="Wikidata Atom feed" href="/w/index.php?title=Special:RecentChanges&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="//login.wikimedia.org"> </head> <body class="skin-vector-legacy mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-2 ns-subject mw-editable page-User_MisterSynergy_rowing_queries rootpage-User_MisterSynergy skin-vector action-view"><div id="mw-page-base" class="noprint"></div> <div id="mw-head-base" class="noprint"></div> <div id="content" class="mw-body" role="main"> <a id="top"></a> <div id="siteNotice"></div> <div class="mw-indicators"> </div> <h1 id="firstHeading" class="firstHeading mw-first-heading">User:MisterSynergy/rowing/queries</h1> <div id="bodyContent" class="vector-body"> <div id="siteSub" class="noprint">From Wikidata</div> <div id="contentSub"><div id="mw-content-subtitle"><div class="subpages">< <bdi dir="ltr"><a href="/wiki/User:MisterSynergy" title="User:MisterSynergy">User:MisterSynergy</a></bdi></div></div></div> <div id="contentSub2"></div> <div id="jump-to-nav"></div> <a class="mw-jump-link" href="#mw-head">Jump to navigation</a> <a class="mw-jump-link" href="#searchInput">Jump to search</a> <div id="mw-content-text" class="mw-body-content"><div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr"><style data-mw-deduplicate="TemplateStyles:r1664105387">.mw-parser-output .MisterSynergy-headerBox{padding:5px;background-color:#AEA;position:relative}.mw-parser-output .MisterSynergy-headerEdit{position:absolute;right:0;top:0;padding:3px}.mw-parser-output .MisterSynergy-headerHeadline{font-size:2.0em;font-family:serif;text-align:center}.mw-parser-output .MisterSynergy-headerList{list-style:none;column-width:16em}.mw-parser-output .MisterSynergy-hr{margin:10px 0}.mw-parser-output .MisterSynergy-activity .inactive{background-color:#FDD}.mw-parser-output .MisterSynergy-activity .slipping{background-color:#BBB}.mw-parser-output .MisterSynergy-activity .freshly_promoted{background-color:#DFD}</style> <div class="MisterSynergy-headerBox"> <div class="MisterSynergy-headerEdit"><a class="external text" href="https://www.wikidata.org/w/index.php?title=User:MisterSynergy/header&action=edit">+/−</a></div> <div class="MisterSynergy-headerHeadline">MisterSynergy’s work lists</div> <ul class="MisterSynergy-headerList"> <li><a class="mw-selflink selflink">rowing/queries</a></li> <li><a href="/wiki/User:MisterSynergy/rowing/P214_for_rowers" title="User:MisterSynergy/rowing/P214 for rowers">rowing/P214 for rowers</a></li> <li><a href="/wiki/User:MisterSynergy/rowing/P3171_for_rowers" title="User:MisterSynergy/rowing/P3171 for rowers">rowing/P3171 for rowers</a></li> <li><a href="/wiki/User:MisterSynergy/rowing/event_participation" title="User:MisterSynergy/rowing/event participation">rowing/event participation</a></li> <li><a href="/wiki/User:MisterSynergy/rowing/unconnected_pages" title="User:MisterSynergy/rowing/unconnected pages">rowing/unconnected pages</a></li> <li><a href="/wiki/User:MisterSynergy/badminton/queries" title="User:MisterSynergy/badminton/queries">badminton/queries</a></li> <li><a href="/wiki/User:MisterSynergy/tennis/queries" title="User:MisterSynergy/tennis/queries">tennis/queries</a></li> <li><a href="/wiki/User:MisterSynergy/sports/queries" title="User:MisterSynergy/sports/queries">sports/queries</a></li> <li><a href="/wiki/User:MisterSynergy/sports/P641_worklists" title="User:MisterSynergy/sports/P641 worklists">sports/P641 worklists</a></li> <li><a href="/wiki/User:MisterSynergy/sports/P1447_worklists" title="User:MisterSynergy/sports/P1447 worklists">sports/P1447 worklists</a></li> <li><a href="/wiki/User:MisterSynergy/sports/Olympics" title="User:MisterSynergy/sports/Olympics">sports/Olympics</a></li> <li><a href="/wiki/User:MisterSynergy/cultural_heritage/Germany" title="User:MisterSynergy/cultural heritage/Germany">cultural heritage/Germany</a></li> <li><a href="/wiki/User:MisterSynergy/misc/linked_deleted_items" title="User:MisterSynergy/misc/linked deleted items">misc/linked deleted items</a></li> <li><a href="/wiki/User:MisterSynergy/misc/quantity_data_type" title="User:MisterSynergy/misc/quantity data type">misc/quantity data type</a></li> <li><a href="/wiki/User:MisterSynergy/misc/references" title="User:MisterSynergy/misc/references">misc/references</a></li> <li><a href="/wiki/User:MisterSynergy/misc/sitelink_badges" title="User:MisterSynergy/misc/sitelink badges">misc/sitelink badges</a></li> <li><a href="/wiki/User:MisterSynergy/misc/unsorted_worklists" title="User:MisterSynergy/misc/unsorted worklists">misc/unsorted worklists</a></li> </ul> <hr class="MisterSynergy-hr" /> <a href="/wiki/Special:PrefixIndex/User:MisterSynergy/" title="Special:PrefixIndex/User:MisterSynergy/">Special:PrefixIndex/User:MisterSynergy/</a> • <a href="/wiki/User:MisterSynergy/sysop/header" title="User:MisterSynergy/sysop/header">User:MisterSynergy/sysop/header</a> • <a href="/wiki/User:MisterSynergy/itemstats" title="User:MisterSynergy/itemstats">item statistics</a> • <a href="/wiki/User:MisterSynergy/patrol" title="User:MisterSynergy/patrol">patrol</a> • <a href="/wiki/User:MisterSynergy/pages_with_code" title="User:MisterSynergy/pages with code">pages with code</a> • <a href="/wiki/User:MisterSynergy/activity" title="User:MisterSynergy/activity">activity</a> • <a href="/w/index.php?title=User:MisterSynergy/jobs&action=edit&redlink=1" class="new" title="User:MisterSynergy/jobs (page does not exist)">jobs</a> </div> <div id="toc" class="toc" role="navigation" aria-labelledby="mw-toc-heading"><input type="checkbox" role="button" id="toctogglecheckbox" class="toctogglecheckbox" style="display:none" /><div class="toctitle" lang="en" dir="ltr"><h2 id="mw-toc-heading">Contents</h2><label class="toctogglelabel" for="toctogglecheckbox"></label></div> <ul> <li class="toclevel-1 tocsection-1"><a href="#Unsorted">1 Unsorted</a> <ul> <li class="toclevel-2 tocsection-2"><a href="#Missing_P31/P279_of_rowing_items">1.1 Missing P31/P279 of rowing items</a></li> <li class="toclevel-2 tocsection-3"><a href="#Rowing_persons_with_notability_issues">1.2 Rowing persons with notability issues</a></li> <li class="toclevel-2 tocsection-4"><a href="#Incorrect_use_of_bounds">1.3 Incorrect use of bounds</a></li> <li class="toclevel-2 tocsection-5"><a href="#Languages_and_writing_scripts_by_country_of_citizenship">1.4 Languages and writing scripts by country of citizenship</a></li> <li class="toclevel-2 tocsection-6"><a href="#Ratio_of_sourced_claims_(by_source_and_property)">1.5 Ratio of sourced claims (by source and property)</a></li> <li class="toclevel-2 tocsection-7"><a href="#Number_of_P143_sources_(by_property)">1.6 Number of P143 sources (by property)</a></li> </ul> </li> <li class="toclevel-1 tocsection-8"><a href="#Related_to_general_person_data">2 Related to general person data</a> <ul> <li class="toclevel-2 tocsection-9"><a href="#Missing_place_of_death">2.1 Missing place of death</a></li> <li class="toclevel-2 tocsection-10"><a href="#Places_of_birth_via_plwiki">2.2 Places of birth via plwiki</a></li> <li class="toclevel-2 tocsection-11"><a href="#Check_citizenship">2.3 Check citizenship</a></li> <li class="toclevel-2 tocsection-12"><a href="#Check_citizenship_(contemporaneity)">2.4 Check citizenship (contemporaneity)</a></li> <li class="toclevel-2 tocsection-13"><a href="#(Potential)_rowing_twins">2.5 (Potential) rowing twins</a></li> </ul> </li> <li class="toclevel-1 tocsection-14"><a href="#Related_to_names">3 Related to names</a> <ul> <li class="toclevel-2 tocsection-15"><a href="#P1559_missing_(works_also_with_P735,_P569,_P570,_P19,_P20,_P21,_P27,_P31)">3.1 P1559 missing (works also with P735, P569, P570, P19, P20, P21, P27, P31)</a></li> <li class="toclevel-2 tocsection-16"><a href="#Series_ordinals_for_multiple_given_names">3.2 Series ordinals for multiple given names</a></li> <li class="toclevel-2 tocsection-17"><a href="#Use_of_compound_given_name_items">3.3 Use of compound given name items</a></li> <li class="toclevel-2 tocsection-18"><a href="#Hungarian_names">3.4 Hungarian names</a></li> </ul> </li> <li class="toclevel-1 tocsection-19"><a href="#Related_to_event_participation">4 Related to event participation</a> <ul> <li class="toclevel-2 tocsection-20"><a href="#Event_participation_P710/P1344_symmetry">4.1 Event participation P710/P1344 symmetry</a></li> <li class="toclevel-2 tocsection-21"><a href="#Olympic_rowing_events">4.2 Olympic rowing events</a></li> </ul> </li> <li class="toclevel-1 tocsection-22"><a href="#Related_to_identifiers">5 Related to identifiers</a> <ul> <li class="toclevel-2 tocsection-23"><a href="#P1447_might_be_missing">5.1 P1447 might be missing</a></li> <li class="toclevel-2 tocsection-24"><a href="#Check_unknown_values_against_external_databases">5.2 Check unknown values against external databases</a></li> <li class="toclevel-2 tocsection-25"><a href="#External_identifiers_of_rowing_persons">5.3 External identifiers of rowing persons</a></li> <li class="toclevel-2 tocsection-26"><a href="#Non-unique_identifiers">5.4 Non-unique identifiers</a></li> <li class="toclevel-2 tocsection-27"><a href="#Non-single_identifiers">5.5 Non-single identifiers</a></li> </ul> </li> <li class="toclevel-1 tocsection-28"><a href="#Related_to_terms_(labels,_descriptions,_and_aliases)">6 Related to terms (labels, descriptions, and aliases)</a> <ul> <li class="toclevel-2 tocsection-29"><a href="#Missing_French_labels/descriptions_of_rowers_(works_also_with_German/English/…)">6.1 Missing French labels/descriptions of rowers (works also with German/English/…)</a></li> <li class="toclevel-2 tocsection-30"><a href="#Search_for_descriptions_in_foreign_languages">6.2 Search for descriptions in foreign languages</a></li> <li class="toclevel-2 tocsection-31"><a href="#Particular_literals_in_terms">6.3 Particular literals in terms</a></li> <li class="toclevel-2 tocsection-32"><a href="#Use_of_aliases">6.4 Use of aliases</a></li> <li class="toclevel-2 tocsection-33"><a href="#Descriptions_of_rowing_persons">6.5 Descriptions of rowing persons</a></li> <li class="toclevel-2 tocsection-34"><a href="#Descriptions_of_rowing_persons_with_non-rowing_occupations">6.6 Descriptions of rowing persons with non-rowing occupations</a></li> <li class="toclevel-2 tocsection-35"><a href="#Missing_descriptions_of_rowing_persons_by_language">6.7 Missing descriptions of rowing persons by language</a></li> <li class="toclevel-2 tocsection-36"><a href="#English_description_and_English_Wikipedia_short_description">6.8 English description and English Wikipedia short description</a></li> </ul> </li> <li class="toclevel-1 tocsection-37"><a href="#Watchlist_management">7 Watchlist management</a> <ul> <li class="toclevel-2 tocsection-38"><a href="#All_rowing_persons_(for_watchlist_import)">7.1 All rowing persons (for watchlist import)</a></li> <li class="toclevel-2 tocsection-39"><a href="#Search_for_non-rowing_stuff_on_watchlist">7.2 Search for non-rowing stuff on watchlist</a></li> </ul> </li> </ul> </div> <div class="mw-heading mw-heading2"><h2 id="Unsorted">Unsorted</h2>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=1" title="Edit section: Unsorted">edit</a>]</div> <div class="mw-heading mw-heading3"><h3 id="Missing_P31/P279_of_rowing_items">Missing P31/P279 of rowing items</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=2" title="Edit section: Missing P31/P279 of rowing items">edit</a>]</div> <a rel="nofollow" class="external text" href="https://petscan.wmflabs.org/?psid=1504972">petscan:1504972</a> <div class="mw-heading mw-heading3"><h3 id="Rowing_persons_with_notability_issues">Rowing persons with notability issues</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=3" title="Edit section: Rowing persons with notability issues">edit</a>]</div> <style data-mw-deduplicate="TemplateStyles:r1502159272">.mw-parser-output .wdt-sparql-container-collapsible{border:1px solid #BBBBBB}.mw-parser-output .wdt-sparql-container-collapsible pre{margin-top:2px}</style><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?itemLabel ?itemDescription ?statements WITH { SELECT DISTINCT ?item WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . } } AS %s WHERE { INCLUDE %s . ?item wikibase:sitelinks 0; wikibase:identifiers 0; wikibase:statements ?statements . MINUS { [] ?backlink ?item } OPTIONAL { ?item ?p [ prov:wasDerivedFrom [ ?pr [] ] ] . FILTER(?pr NOT IN (pr:P143, pr:P3452)) } FILTER(!BOUND(?p)) . MINUS { ?item wdt:P973|wdt:P1343 [] } SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Fstatements%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%7D%0A%7D%20AS%20%25s%20WHERE%20%7B%0A%20%20INCLUDE%20%25s%20.%0A%20%20%3Fitem%20wikibase%3Asitelinks%200%3B%20wikibase%3Aidentifiers%200%3B%20wikibase%3Astatements%20%3Fstatements%20.%0A%20%20MINUS%20%7B%20%5B%5D%20%3Fbacklink%20%3Fitem%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fitem%20%3Fp%20%5B%20prov%3AwasDerivedFrom%20%5B%20%3Fpr%20%5B%5D%20%5D%20%5D%20.%20FILTER%28%3Fpr%20NOT%20IN%20%28pr%3AP143%2C%20pr%3AP3452%29%29%20%7D%0A%20%20FILTER%28%21BOUND%28%3Fp%29%29%20.%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP973%7Cwdt%3AP1343%20%5B%5D%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Incorrect_use_of_bounds">Incorrect use of bounds</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=4" title="Edit section: Incorrect use of bounds">edit</a>]</div> Can be done with all quantity properties, not just <a href="/wiki/Property:P2067" title="Property:P2067">mass (P2067)</a>. <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?itemLabel ?length ?upperBound ?lowerBound { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?item p:P2067 [ psv:P2067 ?value ] . # items that use P2067 (mass) ?value wikibase:quantityAmount ?length . OPTIONAL { ?value wikibase:quantityUpperBound ?upperBound; wikibase:quantityLowerBound ?lowerBound . } SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Flength%20%3FupperBound%20%3FlowerBound%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%3Fitem%20p%3AP2067%20%5B%20psv%3AP2067%20%3Fvalue%20%5D%20.%20%23%20items%20that%20use%20P2067%20%28mass%29%0A%20%20%3Fvalue%20wikibase%3AquantityAmount%20%3Flength%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fvalue%20wikibase%3AquantityUpperBound%20%3FupperBound%3B%20wikibase%3AquantityLowerBound%20%3FlowerBound%20.%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D">Try it!</a> </div> More general: <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?claimprop ?value ?lowerBound ?upperBound { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?prop wikibase:propertyType wikibase:Quantity; wikibase:claim ?claimprop; wikibase:statementValue ?stmtval . ?item ?claimprop [ ?stmtval [ wikibase:quantityAmount ?value; wikibase:quantityLowerBound ?lowerBound; wikibase:quantityUpperBound ?upperBound ] ] . } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3Fclaimprop%20%3Fvalue%20%3FlowerBound%20%3FupperBound%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%3Fprop%20wikibase%3ApropertyType%20wikibase%3AQuantity%3B%20wikibase%3Aclaim%20%3Fclaimprop%3B%20wikibase%3AstatementValue%20%3Fstmtval%20.%0A%20%20%3Fitem%20%3Fclaimprop%20%5B%20%3Fstmtval%20%5B%20wikibase%3AquantityAmount%20%3Fvalue%3B%20wikibase%3AquantityLowerBound%20%3FlowerBound%3B%20wikibase%3AquantityUpperBound%20%3FupperBound%20%5D%20%5D%20.%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Languages_and_writing_scripts_by_country_of_citizenship">Languages and writing scripts by country of citizenship</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=5" title="Edit section: Languages and writing scripts by country of citizenship">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?country ?countryLabel (GROUP_CONCAT(DISTINCT ?lang; separator=', ') AS ?langs) (GROUP_CONCAT(DISTINCT ?scriptL; separator=', ') AS ?scripts) (COUNT(DISTINCT ?item) AS ?cnt) WITH { SELECT DISTINCT ?item WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 } } AS %s WHERE { INCLUDE %s . ?item wdt:P27 ?country . OPTIONAL { ?country wdt:P37 ?language . ?language rdfs:label ?lang . FILTER(LANG(?lang) = 'en') . OPTIONAL { ?language wdt:P282 ?script . ?script rdfs:label ?scriptL . FILTER(LANG(?scriptL) = 'en') . } } SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } GROUP BY ?country ?countryLabel ORDER BY DESC(?cnt) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fcountry%20%3FcountryLabel%20%28GROUP_CONCAT%28DISTINCT%20%3Flang%3B%20separator%3D%27%2C%20%27%29%20AS%20%3Flangs%29%20%28GROUP_CONCAT%28DISTINCT%20%3FscriptL%3B%20separator%3D%27%2C%20%27%29%20AS%20%3Fscripts%29%20%28COUNT%28DISTINCT%20%3Fitem%29%20AS%20%3Fcnt%29%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%0A%20%20%7D%0A%7D%20AS%20%25s%20WHERE%20%7B%0A%20%20INCLUDE%20%25s%20.%0A%20%20%3Fitem%20wdt%3AP27%20%3Fcountry%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fcountry%20wdt%3AP37%20%3Flanguage%20.%0A%20%20%20%20%3Flanguage%20rdfs%3Alabel%20%3Flang%20.%0A%20%20%20%20FILTER%28LANG%28%3Flang%29%20%3D%20%27en%27%29%20.%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Flanguage%20wdt%3AP282%20%3Fscript%20.%0A%20%20%20%20%20%20%3Fscript%20rdfs%3Alabel%20%3FscriptL%20.%0A%20%20%20%20%20%20FILTER%28LANG%28%3FscriptL%29%20%3D%20%27en%27%29%20.%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D%20GROUP%20BY%20%3Fcountry%20%3FcountryLabel%20ORDER%20BY%20DESC%28%3Fcnt%29">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Ratio_of_sourced_claims_(by_source_and_property)">Ratio of sourced claims (by source and property)</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=6" title="Edit section: Ratio of sourced claims (by source and property)">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?refProp ?refPropLabel ?claimProp ?claimPropLabel ?cnt_all ?cnt_sourced ?sourced_ratio WITH { SELECT ?refProp ?claimProp ?wdt_ref ?pr_ref ?p_claim WHERE { VALUES (?refProp ?claimProp) { (wd:P2091 wd:P21) (wd:P2091 wd:P27) (wd:P2091 wd:P1532) (wd:P2091 wd:P2048) (wd:P2091 wd:P2067) (wd:P2091 wd:P569) (wd:P2091 wd:P106) (wd:P2091 wd:P641) (wd:P2091 wd:P551) (wd:P2091 wd:P1416) (wd:P2091 wd:P54) (wd:P2091 wd:P463) (wd:P2091 wd:P1344) (wd:P2091 wd:P1559) (wd:P2091 wd:P1477) (wd:P2091 wd:P735) (wd:P2091 wd:P734) #(wd:P1447 wd:P21) (wd:P1447 wd:P27) (wd:P1447 wd:P1532) (wd:P1447 wd:P2048) (wd:P1447 wd:P2067) (wd:P1447 wd:P569) (wd:P1447 wd:P19) (wd:P1447 wd:P570) (wd:P1447 wd:P20) (wd:P1447 wd:P106) (wd:P1447 wd:P641) (wd:P1447 wd:P1416) (wd:P1447 wd:P54) (wd:P1447 wd:P463) (wd:P1447 wd:P1344) (wd:P1447 wd:P1559) (wd:P1447 wd:P1477) (wd:P1447 wd:P735) (wd:P1447 wd:P734) (wd:P1447 wd:P25) (wd:P1447 wd:P22) (wd:P1447 wd:P3373) (wd:P1447 wd:P40) (wd:P1447 wd:P26) (wd:P1447 wd:P1038) (wd:P1447 wd:P451) } ?refProp wikibase:directClaim ?wdt_ref; wikibase:reference ?pr_ref . ?claimProp wikibase:claim ?p_claim } } AS %subquery1 WITH { SELECT DISTINCT ?item ?s ?wdt_ref ?p_claim WHERE { INCLUDE %subquery1 . ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; ?wdt_ref []; ?p_claim ?s } } AS %subquery2 WITH { SELECT ?refProp ?claimProp ?wdt_ref ?pr_ref ?p_claim (COUNT(DISTINCT ?s) AS ?cnt_all) WHERE { INCLUDE %subquery2 } GROUP BY ?refProp ?claimProp ?wdt_ref ?pr_ref ?p_claim } AS %subquery3 WITH { SELECT ?refProp ?claimProp ?wdt_ref ?pr_ref ?p_claim (COUNT(DISTINCT ?s) AS ?cnt_sourced) WHERE { INCLUDE %subquery1 . INCLUDE %subquery2 . ?s prov:wasDerivedFrom [ ?pr_ref [] ] } GROUP BY ?refProp ?claimProp ?wdt_ref ?pr_ref ?p_claim } AS %subquery4 WHERE { INCLUDE %subquery1 . INCLUDE %subquery3 . INCLUDE %subquery4 . BIND(CONCAT(STR(ROUND(?cnt_sourced / ?cnt_all * 1000)/10), '%') AS ?sourced_ratio) . SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } ORDER BY ASC(xsd:integer(STRAFTER(STR(?claimProp), 'entity/P'))) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3FrefProp%20%3FrefPropLabel%20%3FclaimProp%20%3FclaimPropLabel%20%3Fcnt_all%20%3Fcnt_sourced%20%3Fsourced_ratio%20WITH%20%7B%0A%20%20SELECT%20%3FrefProp%20%3FclaimProp%20%3Fwdt_ref%20%3Fpr_ref%20%3Fp_claim%20WHERE%20%7B%20VALUES%20%28%3FrefProp%20%3FclaimProp%29%20%7B%0A%20%20%20%20%28wd%3AP2091%20wd%3AP21%29%20%28wd%3AP2091%20wd%3AP27%29%20%28wd%3AP2091%20wd%3AP1532%29%20%28wd%3AP2091%20wd%3AP2048%29%20%28wd%3AP2091%20wd%3AP2067%29%20%28wd%3AP2091%20wd%3AP569%29%20%28wd%3AP2091%20wd%3AP106%29%20%28wd%3AP2091%20wd%3AP641%29%20%28wd%3AP2091%20wd%3AP551%29%20%28wd%3AP2091%20wd%3AP1416%29%20%28wd%3AP2091%20wd%3AP54%29%20%28wd%3AP2091%20wd%3AP463%29%20%28wd%3AP2091%20wd%3AP1344%29%20%28wd%3AP2091%20wd%3AP1559%29%20%28wd%3AP2091%20wd%3AP1477%29%20%28wd%3AP2091%20wd%3AP735%29%20%28wd%3AP2091%20wd%3AP734%29%0A%20%20%20%20%23%28wd%3AP1447%20wd%3AP21%29%20%28wd%3AP1447%20wd%3AP27%29%20%28wd%3AP1447%20wd%3AP1532%29%20%28wd%3AP1447%20wd%3AP2048%29%20%28wd%3AP1447%20wd%3AP2067%29%20%28wd%3AP1447%20wd%3AP569%29%20%28wd%3AP1447%20wd%3AP19%29%20%28wd%3AP1447%20wd%3AP570%29%20%28wd%3AP1447%20wd%3AP20%29%20%28wd%3AP1447%20wd%3AP106%29%20%28wd%3AP1447%20wd%3AP641%29%20%28wd%3AP1447%20wd%3AP1416%29%20%28wd%3AP1447%20wd%3AP54%29%20%28wd%3AP1447%20wd%3AP463%29%20%28wd%3AP1447%20wd%3AP1344%29%20%28wd%3AP1447%20wd%3AP1559%29%20%28wd%3AP1447%20wd%3AP1477%29%20%28wd%3AP1447%20wd%3AP735%29%20%28wd%3AP1447%20wd%3AP734%29%20%28wd%3AP1447%20wd%3AP25%29%20%28wd%3AP1447%20wd%3AP22%29%20%28wd%3AP1447%20wd%3AP3373%29%20%28wd%3AP1447%20wd%3AP40%29%20%28wd%3AP1447%20wd%3AP26%29%20%28wd%3AP1447%20wd%3AP1038%29%20%28wd%3AP1447%20wd%3AP451%29%0A%20%20%7D%20%3FrefProp%20wikibase%3AdirectClaim%20%3Fwdt_ref%3B%20wikibase%3Areference%20%3Fpr_ref%20.%20%3FclaimProp%20wikibase%3Aclaim%20%3Fp_claim%20%7D%0A%7D%20AS%20%25subquery1%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fitem%20%3Fs%20%3Fwdt_ref%20%3Fp_claim%20WHERE%20%7B%20INCLUDE%20%25subquery1%20.%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20%3Fwdt_ref%20%5B%5D%3B%20%3Fp_claim%20%3Fs%20%7D%0A%7D%20AS%20%25subquery2%20WITH%20%7B%0A%20%20SELECT%20%3FrefProp%20%3FclaimProp%20%3Fwdt_ref%20%3Fpr_ref%20%3Fp_claim%20%28COUNT%28DISTINCT%20%3Fs%29%20AS%20%3Fcnt_all%29%20WHERE%20%7B%20INCLUDE%20%25subquery2%20%7D%20GROUP%20BY%20%3FrefProp%20%3FclaimProp%20%3Fwdt_ref%20%3Fpr_ref%20%3Fp_claim%0A%7D%20AS%20%25subquery3%20WITH%20%7B%0A%20%20SELECT%20%3FrefProp%20%3FclaimProp%20%3Fwdt_ref%20%3Fpr_ref%20%3Fp_claim%20%28COUNT%28DISTINCT%20%3Fs%29%20AS%20%3Fcnt_sourced%29%20WHERE%20%7B%20INCLUDE%20%25subquery1%20.%20INCLUDE%20%25subquery2%20.%20%3Fs%20prov%3AwasDerivedFrom%20%5B%20%3Fpr_ref%20%5B%5D%20%5D%20%7D%20GROUP%20BY%20%3FrefProp%20%3FclaimProp%20%3Fwdt_ref%20%3Fpr_ref%20%3Fp_claim%0A%7D%20AS%20%25subquery4%20WHERE%20%7B%0A%20%20INCLUDE%20%25subquery1%20.%20INCLUDE%20%25subquery3%20.%20INCLUDE%20%25subquery4%20.%20BIND%28CONCAT%28STR%28ROUND%28%3Fcnt_sourced%20%2F%20%3Fcnt_all%20%2A%201000%29%2F10%29%2C%20%27%25%27%29%20AS%20%3Fsourced_ratio%29%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D%20ORDER%20BY%20ASC%28xsd%3Ainteger%28STRAFTER%28STR%28%3FclaimProp%29%2C%20%27entity%2FP%27%29%29%29">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Number_of_P143_sources_(by_property)">Number of P143 sources (by property)</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=7" title="Edit section: Number of P143 sources (by property)">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?property ?propertyLabel ?cnt_s ?cnt_refs ?ratio WITH { SELECT DISTINCT ?property ?s WHERE { [] p:P106/ps:P106/wdt:P279* wd:Q26270618; ?p ?s . ?property wikibase:claim ?p; wikibase:propertyType ?type . FILTER(?type != wikibase:ExternalId) . } } AS %subquery1 WITH { SELECT ?property (COUNT(DISTINCT ?s) AS ?cnt_s) (COUNT(DISTINCT ?dummy) as ?cnt_refs) WHERE { INCLUDE %subquery1 . OPTIONAL { ?s prov:wasDerivedFrom ?refHandle . ?refHandle pr:P143 ?val . # P143, P887, P4656, P3452, P5852 } BIND(CONCAT(STR(?s), STR(?refHandle)) AS ?dummy) . } GROUP BY ?property HAVING(?cnt_refs > 0) } AS %subquery2 WHERE { INCLUDE %subquery2 . BIND(CONCAT(STR(ROUND((?cnt_refs / ?cnt_s)*1000)/10), '%') AS ?ratio) . SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } ORDER BY DESC(?cnt_refs) DESC(xsd:integer(STRBEFORE(?ratio, '%'))) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fproperty%20%3FpropertyLabel%20%3Fcnt_s%20%3Fcnt_refs%20%3Fratio%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fproperty%20%3Fs%20WHERE%20%7B%0A%20%20%20%20%5B%5D%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20%3Fp%20%3Fs%20.%0A%20%20%20%20%3Fproperty%20wikibase%3Aclaim%20%3Fp%3B%20wikibase%3ApropertyType%20%3Ftype%20.%0A%20%20%20%20FILTER%28%3Ftype%20%21%3D%20wikibase%3AExternalId%29%20.%0A%20%20%7D%0A%7D%20AS%20%25subquery1%20WITH%20%7B%0A%20%20SELECT%20%3Fproperty%20%28COUNT%28DISTINCT%20%3Fs%29%20AS%20%3Fcnt_s%29%20%28COUNT%28DISTINCT%20%3Fdummy%29%20as%20%3Fcnt_refs%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25subquery1%20.%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fs%20prov%3AwasDerivedFrom%20%3FrefHandle%20.%0A%20%20%20%20%20%20%3FrefHandle%20pr%3AP143%20%3Fval%20.%20%23%20P143%2C%20P887%2C%20P4656%2C%20P3452%2C%20P5852%0A%20%20%20%20%7D%0A%20%20%20%20BIND%28CONCAT%28STR%28%3Fs%29%2C%20STR%28%3FrefHandle%29%29%20AS%20%3Fdummy%29%20.%0A%20%20%7D%20GROUP%20BY%20%3Fproperty%20HAVING%28%3Fcnt_refs%20%3E%200%29%0A%7D%20AS%20%25subquery2%20WHERE%20%7B%0A%20%20INCLUDE%20%25subquery2%20.%0A%20%20BIND%28CONCAT%28STR%28ROUND%28%28%3Fcnt_refs%20%2F%20%3Fcnt_s%29%2A1000%29%2F10%29%2C%20%27%25%27%29%20AS%20%3Fratio%29%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D%20ORDER%20BY%20DESC%28%3Fcnt_refs%29%20DESC%28xsd%3Ainteger%28STRBEFORE%28%3Fratio%2C%20%27%25%27%29%29%29">Try it!</a> </div> <div class="mw-heading mw-heading2"><h2 id="Related_to_general_person_data">Related to general person data</h2>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=8" title="Edit section: Related to general person data">edit</a>]</div> <div class="mw-heading mw-heading3"><h3 id="Missing_place_of_death">Missing place of death</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=9" title="Edit section: Missing place of death">edit</a>]</div> Deceased, but no place of death given; already in good form, check regularly. <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?itemLabel ?itemDescription ?dod { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?item wdt:P570 ?dod . MINUS { ?item wdt:P20 ?pod . } SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Fdod%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%3Fitem%20wdt%3AP570%20%3Fdod%20.%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP20%20%3Fpod%20.%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Places_of_birth_via_plwiki">Places of birth via plwiki</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=10" title="Edit section: Places of birth via plwiki">edit</a>]</div> <a href="/wiki/Q1551807" title="Q1551807">Polish Wikipedia (Q1551807)</a> has a significant amount of articles about rowers which do not appear in any other Wikipedia edition. They confuse the <a href="/wiki/Property:P551" title="Property:P551">residence (P551)</a> field in the <a href="/wiki/Q21008628" title="Q21008628">World Rowing athlete database (Q21008628)</a> with the <a href="/wiki/Property:P19" title="Property:P19">place of birth (P19)</a> of that person. Thus there is likely some incorrect data in Wikidata via that path. The <a href="/wiki/Property:P19" title="Property:P19">place of birth (P19)</a> claims of affected items will be marked with a <a href="/wiki/Property:P143" title="Property:P143">imported from Wikimedia project (P143)</a> <a href="/wiki/Q1551807" title="Q1551807">Polish Wikipedia (Q1551807)</a> reference. <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?placeOfBirth ?sitelink { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?item p:P19 [ ps:P19 ?placeOfBirth ] . FILTER(ISBLANK(?placeOfBirth) = false) . ?sitelink schema:about ?item; schema:isPartOf <https://pl.wikipedia.org/> . ?item wikibase:sitelinks 1 . } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FplaceOfBirth%20%3Fsitelink%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%3Fitem%20p%3AP19%20%5B%20ps%3AP19%20%3FplaceOfBirth%20%5D%20.%0A%20%20FILTER%28ISBLANK%28%3FplaceOfBirth%29%20%3D%20false%29%20.%0A%20%20%3Fsitelink%20schema%3Aabout%20%3Fitem%3B%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fpl.wikipedia.org%2F%3E%20.%0A%20%20%3Fitem%20wikibase%3Asitelinks%201%20.%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Check_citizenship">Check citizenship</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=11" title="Edit section: Check citizenship">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item (COUNT(?item) AS ?cocs) { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?item wdt:P27 ?coc . FILTER NOT EXISTS { ?item wdt:P570 ?dod . } ?coc wdt:P31/wdt:P279* wd:Q15893266 . } GROUP BY ?item ORDER BY DESC(?cocs) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%28COUNT%28%3Fitem%29%20AS%20%3Fcocs%29%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%3Fitem%20wdt%3AP27%20%3Fcoc%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP570%20%3Fdod%20.%0A%20%20%7D%0A%20%20%3Fcoc%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ15893266%20.%0A%7D%20GROUP%20BY%20%3Fitem%20ORDER%20BY%20DESC%28%3Fcocs%29">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Check_citizenship_(contemporaneity)">Check citizenship (contemporaneity)</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=12" title="Edit section: Check citizenship (contemporaneity)">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?rower ?rowerLabel ?dob ?dod ?state ?stateLabel ?inception ?dissolved WHERE { ?rower p:P106/ps:P106/wdt:P279* wd:Q26270618; wdt:P27 ?state . ?state wdt:P571 ?inception . OPTIONAL { ?state wdt:P576 ?dissolved } ?rower p:P569/psv:P569 [ wikibase:timeValue ?dob; wikibase:timePrecision ?dobPrecision ] . FILTER(?dobPrecision >= 9) . OPTIONAL { ?rower p:P570/psv:P570 [ wikibase:timeValue ?dod; wikibase:timePrecision ?dodPrecision ] . FILTER(?dodPrecision >= 9) } FILTER(?dissolved < ?dob|| ?inception > ?dod) . # completely out of bounds # FILTER(?dissolved < ?dod || ?inception > ?dob) . # partially out of bounds; yields a lot of results, and does not indicate what to do SERVICE wikibase:label { bd:serviceParam wikibase:language '[AUTO_LANGUAGE],en' } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Frower%20%3FrowerLabel%20%3Fdob%20%3Fdod%20%3Fstate%20%3FstateLabel%20%3Finception%20%3Fdissolved%20WHERE%20%7B%0A%20%20%3Frower%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20wdt%3AP27%20%3Fstate%20.%0A%20%20%3Fstate%20wdt%3AP571%20%3Finception%20.%0A%20%20OPTIONAL%20%7B%20%3Fstate%20wdt%3AP576%20%3Fdissolved%20%7D%0A%20%20%3Frower%20p%3AP569%2Fpsv%3AP569%20%5B%20wikibase%3AtimeValue%20%3Fdob%3B%20wikibase%3AtimePrecision%20%3FdobPrecision%20%5D%20.%20FILTER%28%3FdobPrecision%20%3E%3D%209%29%20.%0A%20%20OPTIONAL%20%7B%20%3Frower%20p%3AP570%2Fpsv%3AP570%20%5B%20wikibase%3AtimeValue%20%3Fdod%3B%20wikibase%3AtimePrecision%20%3FdodPrecision%20%5D%20.%20FILTER%28%3FdodPrecision%20%3E%3D%209%29%20%7D%0A%20%20FILTER%28%3Fdissolved%20%3C%20%3Fdob%7C%7C%20%3Finception%20%3E%20%3Fdod%29%20.%20%23%20completely%20out%20of%20bounds%0A%23%20%20FILTER%28%3Fdissolved%20%3C%20%3Fdod%20%7C%7C%20%3Finception%20%3E%20%3Fdob%29%20.%20%23%20partially%20out%20of%20bounds%3B%20yields%20a%20lot%20of%20results%2C%20and%20does%20not%20indicate%20what%20to%20do%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27%5BAUTO_LANGUAGE%5D%2Cen%27%20%7D%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="(Potential)_rowing_twins">(Potential) rowing twins</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=13" title="Edit section: (Potential) rowing twins">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT DISTINCT ?item1 ?item1Label ?item2 ?item2Label ?dob ?coc ?gender ?sibling1 ?sibling2 WITH { SELECT DISTINCT ?item1 ?dob ?coc ?gender WHERE { ?item1 p:P106/ps:P106/wdt:P279* wd:Q26270618; p:P569 [ psv:P569 [ wikibase:timeValue ?dob; wikibase:timePrecision 11 ] ]; wdt:P27 ?coc; wdt:P21 ?gender . } } AS %subquery WHERE { INCLUDE %subquery . ?item2 p:P106/ps:P106/wdt:P279* wd:Q26270618; p:P569 [ psv:P569 [ wikibase:timeValue ?dob; wikibase:timePrecision 11 ] ]; wdt:P27 ?coc; wdt:P21 ?gender . FILTER(xsd:integer(STRAFTER(STR(?item1), 'Q')) < xsd:integer(STRAFTER(STR(?item2), 'Q'))) . OPTIONAL { ?item1 p:P3373 ?sibling2s . ?sibling2s ps:P3373 ?sibling2 . FILTER(?sibling2 = ?item2) . } OPTIONAL { ?item2 p:P3373 ?sibling1s . ?sibling1s ps:P3373 ?sibling1 . FILTER(?sibling1 = ?item1) . } SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem1%20%3Fitem1Label%20%3Fitem2%20%3Fitem2Label%20%3Fdob%20%3Fcoc%20%3Fgender%20%3Fsibling1%20%3Fsibling2%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fitem1%20%3Fdob%20%3Fcoc%20%3Fgender%20WHERE%20%7B%0A%20%20%20%20%3Fitem1%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20p%3AP569%20%5B%20psv%3AP569%20%5B%20wikibase%3AtimeValue%20%3Fdob%3B%20wikibase%3AtimePrecision%2011%20%5D%20%5D%3B%20wdt%3AP27%20%3Fcoc%3B%20wdt%3AP21%20%3Fgender%20.%0A%20%20%7D%0A%7D%20AS%20%25subquery%20WHERE%20%7B%0A%20%20INCLUDE%20%25subquery%20.%0A%20%20%3Fitem2%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20p%3AP569%20%5B%20psv%3AP569%20%5B%20wikibase%3AtimeValue%20%3Fdob%3B%20wikibase%3AtimePrecision%2011%20%5D%20%5D%3B%20wdt%3AP27%20%3Fcoc%3B%20wdt%3AP21%20%3Fgender%20.%0A%20%20FILTER%28xsd%3Ainteger%28STRAFTER%28STR%28%3Fitem1%29%2C%20%27Q%27%29%29%20%3C%20xsd%3Ainteger%28STRAFTER%28STR%28%3Fitem2%29%2C%20%27Q%27%29%29%29%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem1%20p%3AP3373%20%3Fsibling2s%20.%0A%20%20%20%20%3Fsibling2s%20ps%3AP3373%20%3Fsibling2%20.%0A%20%20%20%20FILTER%28%3Fsibling2%20%3D%20%3Fitem2%29%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem2%20p%3AP3373%20%3Fsibling1s%20.%0A%20%20%20%20%3Fsibling1s%20ps%3AP3373%20%3Fsibling1%20.%0A%20%20%20%20FILTER%28%3Fsibling1%20%3D%20%3Fitem1%29%20.%0A%20%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading2"><h2 id="Related_to_names">Related to names</h2>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=14" title="Edit section: Related to names">edit</a>]</div> <div class="mw-heading mw-heading3"><h3 id="P1559_missing_(works_also_with_P735,_P569,_P570,_P19,_P20,_P21,_P27,_P31)">P1559 missing (works also with P735, P569, P570, P19, P20, P21, P27, P31)</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=15" title="Edit section: P1559 missing (works also with P735, P569, P570, P19, P20, P21, P27, P31)">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 MINUS { ?item wdt:P1559 ?dummy } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%0A%20%20%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP1559%20%3Fdummy%20%7D%0A%7D">Try it!</a> </div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?itemLabel { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . FILTER NOT EXISTS { ?item wdt:P1559 ?name . } ?item wdt:P27 wd:Q183 . ?sitelink schema:about ?item; schema:isPartOf <https://de.wikipedia.org/> . SERVICE wikibase:label { bd:serviceParam wikibase:language 'de,en' } . } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP1559%20%3Fname%20.%0A%20%20%7D%0A%20%20%3Fitem%20wdt%3AP27%20wd%3AQ183%20.%0A%20%20%3Fsitelink%20schema%3Aabout%20%3Fitem%3B%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fde.wikipedia.org%2F%3E%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27de%2Cen%27%20%7D%20.%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Series_ordinals_for_multiple_given_names">Series ordinals for multiple given names</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=16" title="Edit section: Series ordinals for multiple given names">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT DISTINCT ?item ?qid WHERE { { SELECT ?item (COUNT(?givenname) AS ?cnt) WHERE { ?item wdt:P106 wd:Q13382576 . ?item wdt:P735 ?givenname . } GROUP BY ?item } FILTER(?cnt > 1) . MINUS { ?item p:P735/pq:P1545 [] } BIND(xsd:integer(SUBSTR(STR(?item), 33)) AS ?qid) . } ORDER BY DESC(?qid) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem%20%3Fqid%20WHERE%20%7B%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fitem%20%28COUNT%28%3Fgivenname%29%20AS%20%3Fcnt%29%20WHERE%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP106%20wd%3AQ13382576%20.%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP735%20%3Fgivenname%20.%0A%20%20%20%20%7D%20GROUP%20BY%20%3Fitem%0A%20%20%7D%0A%20%20FILTER%28%3Fcnt%20%3E%201%29%20.%0A%20%20MINUS%20%7B%20%3Fitem%20p%3AP735%2Fpq%3AP1545%20%5B%5D%20%7D%0A%20%20BIND%28xsd%3Ainteger%28SUBSTR%28STR%28%3Fitem%29%2C%2033%29%29%20AS%20%3Fqid%29%20.%0A%7D%20ORDER%20BY%20DESC%28%3Fqid%29">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Use_of_compound_given_name_items">Use of compound given name items</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=17" title="Edit section: Use of compound given name items">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT DISTINCT ?item ?label ?givennameLabel WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; wdt:P735 ?givenname . ?givenname wdt:P31 wd:Q1243157; rdfs:label ?givennameLabel . FILTER(LANG(?givennameLabel) = 'en') . ?item rdfs:label ?label . FILTER(LANG(?label) = 'en') . FILTER(CONTAINS(STR(?label), '-') = false) . FILTER(CONTAINS(STR(?givennameLabel), '-') = false) . } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem%20%3Flabel%20%3FgivennameLabel%20WHERE%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20wdt%3AP735%20%3Fgivenname%20.%0A%20%20%3Fgivenname%20wdt%3AP31%20wd%3AQ1243157%3B%20rdfs%3Alabel%20%3FgivennameLabel%20.%0A%20%20FILTER%28LANG%28%3FgivennameLabel%29%20%3D%20%27en%27%29%20.%0A%20%20%3Fitem%20rdfs%3Alabel%20%3Flabel%20.%0A%20%20FILTER%28LANG%28%3Flabel%29%20%3D%20%27en%27%29%20.%0A%20%20FILTER%28CONTAINS%28STR%28%3Flabel%29%2C%20%27-%27%29%20%3D%20false%29%20.%0A%20%20FILTER%28CONTAINS%28STR%28%3FgivennameLabel%29%2C%20%27-%27%29%20%3D%20false%29%20.%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Hungarian_names">Hungarian names</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=18" title="Edit section: Hungarian names">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT DISTINCT ?item ?enLabel ?huLabel ?nativeLabel ?nativeLabelLang WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; wdt:P27 wd:Q28 . ?item rdfs:label ?enLabel . FILTER(LANG(?enLabel) = 'en') . ?item rdfs:label ?huLabel . FILTER(LANG(?huLabel) = 'hu') . OPTIONAL { ?item wdt:P1559 ?nativeLabel . BIND(LANG(?nativeLabel) AS ?nativeLabelLang) . } FILTER(STR(?enLabel) = STR(?huLabel)) . } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem%20%3FenLabel%20%3FhuLabel%20%3FnativeLabel%20%3FnativeLabelLang%20WHERE%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20wdt%3AP27%20wd%3AQ28%20.%0A%20%20%3Fitem%20rdfs%3Alabel%20%3FenLabel%20.%0A%20%20FILTER%28LANG%28%3FenLabel%29%20%3D%20%27en%27%29%20.%0A%20%20%3Fitem%20rdfs%3Alabel%20%3FhuLabel%20.%0A%20%20FILTER%28LANG%28%3FhuLabel%29%20%3D%20%27hu%27%29%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP1559%20%3FnativeLabel%20.%0A%20%20%20%20BIND%28LANG%28%3FnativeLabel%29%20AS%20%3FnativeLabelLang%29%20.%0A%20%20%7D%0A%20%20FILTER%28STR%28%3FenLabel%29%20%3D%20STR%28%3FhuLabel%29%29%20.%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading2"><h2 id="Related_to_event_participation">Related to event participation</h2>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=19" title="Edit section: Related to event participation">edit</a>]</div> <ul><li>See also: <a href="/wiki/User:MisterSynergy/rowing/event_participation" title="User:MisterSynergy/rowing/event participation">User:MisterSynergy/rowing/event participation</a>.</li></ul> <div class="mw-heading mw-heading3"><h3 id="Event_participation_P710/P1344_symmetry">Event participation P710/P1344 symmetry</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=20" title="Edit section: Event participation P710/P1344 symmetry">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?itemLabel ?event ?eventLabel WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?item wdt:P1344 ?event . ?event wdt:P710 ?item . SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fevent%20%3FeventLabel%20WHERE%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%3Fitem%20wdt%3AP1344%20%3Fevent%20.%0A%20%20%3Fevent%20wdt%3AP710%20%3Fitem%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%20%7D%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Olympic_rowing_events">Olympic rowing events</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=21" title="Edit section: Olympic rowing events">edit</a>]</div> General overview: <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?regatta ?year ?item ?itemLabel ?class ?participants ?distance { ?item wdt:P31 wd:Q18536594; wdt:P3157 ?distance; wdt:P361 ?regatta; wdt:P1132 ?participants . ?regatta wdt:P31 wd:Q720609; wdt:P580 ?time . BIND(YEAR(?time) AS ?year) . OPTIONAL { ?item wdt:P2094 ?class . } ?item rdfs:label ?itemLabel . FILTER(LANG(?itemLabel) = 'de') . } ORDER BY ASC(?year) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fregatta%20%3Fyear%20%3Fitem%20%3FitemLabel%20%3Fclass%20%3Fparticipants%20%3Fdistance%20%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ18536594%3B%20wdt%3AP3157%20%3Fdistance%3B%20wdt%3AP361%20%3Fregatta%3B%20wdt%3AP1132%20%3Fparticipants%20.%0A%20%20%3Fregatta%20wdt%3AP31%20wd%3AQ720609%3B%20wdt%3AP580%20%3Ftime%20.%0A%20%20BIND%28YEAR%28%3Ftime%29%20AS%20%3Fyear%29%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP2094%20%3Fclass%20.%0A%20%20%7D%0A%20%20%3Fitem%20rdfs%3Alabel%20%3FitemLabel%20.%0A%20%20FILTER%28LANG%28%3FitemLabel%29%20%3D%20%27de%27%29%20.%0A%7D%20ORDER%20BY%20ASC%28%3Fyear%29">Try it!</a> </div> Number of participants (needs work): <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?regatta ?year ?number ?sum ?diff { { SELECT ?regatta (SUM(?number) AS ?sum) { ?item wdt:P31 wd:Q18536594; wdt:P361 ?regatta; wdt:P1132 ?number . ?regatta wdt:P31 wd:Q720609 . } GROUP BY ?regatta } ?regatta wdt:P1132 ?number; wdt:P580 ?date . BIND(YEAR(?date) AS ?year) . BIND(?number - ?sum AS ?diff) . } ORDER BY ASC(?year) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fregatta%20%3Fyear%20%3Fnumber%20%3Fsum%20%3Fdiff%20%7B%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fregatta%20%28SUM%28%3Fnumber%29%20AS%20%3Fsum%29%20%7B%0A%20%20%20%20%20%20%3Fitem%20wdt%3AP31%20wd%3AQ18536594%3B%20wdt%3AP361%20%3Fregatta%3B%20wdt%3AP1132%20%3Fnumber%20.%0A%20%20%20%20%20%20%3Fregatta%20wdt%3AP31%20wd%3AQ720609%20.%0A%20%20%20%20%7D%20GROUP%20BY%20%3Fregatta%0A%20%20%7D%0A%20%20%3Fregatta%20wdt%3AP1132%20%3Fnumber%3B%20wdt%3AP580%20%3Fdate%20.%0A%20%20BIND%28YEAR%28%3Fdate%29%20AS%20%3Fyear%29%20.%0A%20%20BIND%28%3Fnumber%20-%20%3Fsum%20AS%20%3Fdiff%29%20.%0A%7D%20ORDER%20BY%20ASC%28%3Fyear%29">Try it!</a> </div> <div class="mw-heading mw-heading2"><h2 id="Related_to_identifiers">Related to identifiers</h2>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=22" title="Edit section: Related to identifiers">edit</a>]</div> <div class="mw-heading mw-heading3"><h3 id="P1447_might_be_missing">P1447 might be missing</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=23" title="Edit section: P1447 might be missing">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?oorg ?sr { ?item wdt:P3171 ?oorg . FILTER NOT EXISTS { ?item wdt:P1447 ?sr . } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3Foorg%20%3Fsr%20%7B%0A%20%20%3Fitem%20wdt%3AP3171%20%3Foorg%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP1447%20%3Fsr%20.%0A%20%20%7D%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Check_unknown_values_against_external_databases">Check unknown values against external databases</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=24" title="Edit section: Check unknown values against external databases">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?identifier ?id { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; wdt:P19 ?var . FILTER ISBLANK(?var) . ?identifier wikibase:propertyType wikibase:ExternalId; wikibase:directClaim ?directClaim . ?item ?directClaim ?id . } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3Fidentifier%20%3Fid%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20wdt%3AP19%20%3Fvar%20.%0A%20%20FILTER%20ISBLANK%28%3Fvar%29%20.%0A%20%20%3Fidentifier%20wikibase%3ApropertyType%20wikibase%3AExternalId%3B%20wikibase%3AdirectClaim%20%3FdirectClaim%20.%0A%20%20%3Fitem%20%3FdirectClaim%20%3Fid%20.%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="External_identifiers_of_rowing_persons">External identifiers of rowing persons</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=25" title="Edit section: External identifiers of rowing persons">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?identifier ?identifierLabel (COUNT(*) AS ?cnt) WITH { SELECT DISTINCT ?item WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . } } AS %subquery WHERE { INCLUDE %subquery . ?identifier wikibase:propertyType wikibase:ExternalId; wikibase:directClaim ?directClaim . ?item ?directClaim ?identifierValue . FILTER(?identifier != wd:P2091) . # FISA rower ID FILTER(?identifier NOT IN (wd:P1447, wd:P3171, wd:P3520, wd:P5815, wd:P4391)) . # Sports-Reference.com ID, IOC ID, DatabaseOlympics.com, Olympic Channel, TheSports FILTER(?identifier NOT IN (wd:P2002, wd:P2003, wd:P2013, wd:P2397, wd:P3185, wd:P4015)) . # Twitter, instagram, Facebook, youtube channel, vKontakte, vimeo FILTER(?identifier NOT IN (wd:P3682, wd:P4060, wd:P4054, wd:P4053, wd:P2593, wd:P4056, wd:P2323, wd:P4062, wd:P4068, wd:P4069, wd:P4490, wd:P4067, wd:P4050, wd:P6071, wd:P4061, wd:P4547)) . # national olympic committees FILTER(?identifier != wd:P646) . # Freebase SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } GROUP BY ?identifier ?identifierLabel ORDER BY DESC (?cnt) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fidentifier%20%3FidentifierLabel%20%28COUNT%28%2A%29%20AS%20%3Fcnt%29%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%7D%0A%7D%20AS%20%25subquery%20WHERE%20%7B%0A%20%20INCLUDE%20%25subquery%20.%0A%20%20%3Fidentifier%20wikibase%3ApropertyType%20wikibase%3AExternalId%3B%20wikibase%3AdirectClaim%20%3FdirectClaim%20.%0A%20%20%3Fitem%20%3FdirectClaim%20%3FidentifierValue%20.%0A%20%20FILTER%28%3Fidentifier%20%21%3D%20wd%3AP2091%29%20.%20%23%20FISA%20rower%20ID%0A%20%20FILTER%28%3Fidentifier%20NOT%20IN%20%28wd%3AP1447%2C%20wd%3AP3171%2C%20wd%3AP3520%2C%20wd%3AP5815%2C%20wd%3AP4391%29%29%20.%20%23%20Sports-Reference.com%20ID%2C%20IOC%20ID%2C%20DatabaseOlympics.com%2C%20Olympic%20Channel%2C%20TheSports%0A%20%20FILTER%28%3Fidentifier%20NOT%20IN%20%28wd%3AP2002%2C%20wd%3AP2003%2C%20wd%3AP2013%2C%20wd%3AP2397%2C%20wd%3AP3185%2C%20wd%3AP4015%29%29%20.%20%23%20Twitter%2C%20instagram%2C%20Facebook%2C%20youtube%20channel%2C%20vKontakte%2C%20vimeo%0A%20%20FILTER%28%3Fidentifier%20NOT%20IN%20%28wd%3AP3682%2C%20wd%3AP4060%2C%20wd%3AP4054%2C%20wd%3AP4053%2C%20wd%3AP2593%2C%20wd%3AP4056%2C%20wd%3AP2323%2C%20wd%3AP4062%2C%20wd%3AP4068%2C%20wd%3AP4069%2C%20wd%3AP4490%2C%20wd%3AP4067%2C%20wd%3AP4050%2C%20wd%3AP6071%2C%20wd%3AP4061%2C%20wd%3AP4547%29%29%20.%20%23%20national%20olympic%20committees%0A%20%20FILTER%28%3Fidentifier%20%21%3D%20wd%3AP646%29%20.%20%23%20Freebase%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D%20GROUP%20BY%20%3Fidentifier%20%3FidentifierLabel%20ORDER%20BY%20DESC%20%28%3Fcnt%29">Try it!</a> </div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?itemLabel ?identifier ?identifierValue WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?identifier wikibase:propertyType wikibase:ExternalId; wikibase:directClaim ?directClaim . ?item ?directClaim ?identifierValue . FILTER(?identifier != wd:P2091) . # FISA rower ID FILTER(?identifier != wd:P1447 && ?identifier != wd:P3171 && ?identifier != wd:P3520) . # Sports-Reference.com ID, IOC ID, DatabaseOlympics.com FILTER(?identifier != wd:P2002 && ?identifier != wd:P2003 && ?identifier != wd:P2013) . # Twitter, instagram, Facebook FILTER(?identifier != wd:P3682 && ?identifier != wd:P4060 && ?identifier != wd:P4054 && ?identifier != wd:P4053 && ?identifier != wd:P2593 && ?identifier != wd:P4056 && ?identifier != wd:P2323) . # national olympic committees FILTER(?identifier != wd:P646) . # Freebase SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3Fidentifier%20%3FidentifierValue%20WHERE%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%3Fidentifier%20wikibase%3ApropertyType%20wikibase%3AExternalId%3B%20wikibase%3AdirectClaim%20%3FdirectClaim%20.%0A%20%20%3Fitem%20%3FdirectClaim%20%3FidentifierValue%20.%0A%20%20FILTER%28%3Fidentifier%20%21%3D%20wd%3AP2091%29%20.%20%23%20FISA%20rower%20ID%0A%20%20FILTER%28%3Fidentifier%20%21%3D%20wd%3AP1447%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP3171%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP3520%29%20.%20%23%20Sports-Reference.com%20ID%2C%20IOC%20ID%2C%20DatabaseOlympics.com%0A%20%20FILTER%28%3Fidentifier%20%21%3D%20wd%3AP2002%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP2003%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP2013%29%20.%20%23%20Twitter%2C%20instagram%2C%20Facebook%0A%20%20FILTER%28%3Fidentifier%20%21%3D%20wd%3AP3682%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP4060%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP4054%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP4053%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP2593%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP4056%20%26%26%20%3Fidentifier%20%21%3D%20wd%3AP2323%29%20.%20%23%20national%20olympic%20committees%0A%20%20FILTER%28%3Fidentifier%20%21%3D%20wd%3AP646%29%20.%20%23%20Freebase%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D">Try it!</a> </div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?identifier ?identifierLabel (COUNT(DISTINCT ?s) AS ?statements) (COUNT(DISTINCT ?item) AS ?items) WITH { SELECT DISTINCT ?item WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . } } AS %subquery WHERE { INCLUDE %subquery . ?item ?p ?s . ?identifier wikibase:claim ?p; wikibase:propertyType wikibase:ExternalId . SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } GROUP BY ?identifier ?identifierLabel ORDER BY DESC(?statements) DESC(?items) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fidentifier%20%3FidentifierLabel%20%28COUNT%28DISTINCT%20%3Fs%29%20AS%20%3Fstatements%29%20%28COUNT%28DISTINCT%20%3Fitem%29%20AS%20%3Fitems%29%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%7D%0A%7D%20AS%20%25subquery%20WHERE%20%7B%0A%20%20INCLUDE%20%25subquery%20.%0A%20%20%3Fitem%20%3Fp%20%3Fs%20.%0A%20%20%3Fidentifier%20wikibase%3Aclaim%20%3Fp%3B%20wikibase%3ApropertyType%20wikibase%3AExternalId%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D%20GROUP%20BY%20%3Fidentifier%20%3FidentifierLabel%20ORDER%20BY%20DESC%28%3Fstatements%29%20DESC%28%3Fitems%29">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Non-unique_identifiers">Non-unique identifiers</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=26" title="Edit section: Non-unique identifiers">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?identifier ?value ?item2 WITH { SELECT DISTINCT ?item WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . } } AS %subquery WHERE { INCLUDE %subquery ?identifier wikibase:propertyType wikibase:ExternalId; wikibase:claim ?identifierClaim; wikibase:statementProperty ?identifierStatementProperty; wikibase:reference ?ref . ?item ?identifierClaim [ ?identifierStatementProperty ?value ] . ?item2 ?identifierClaim [ ?identifierStatementProperty ?value ] . FILTER(?item != ?item2) . } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3Fidentifier%20%3Fvalue%20%3Fitem2%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%7D%0A%7D%20AS%20%25subquery%20WHERE%20%7B%0A%20%20INCLUDE%20%25subquery%20%0A%20%20%3Fidentifier%20wikibase%3ApropertyType%20wikibase%3AExternalId%3B%20wikibase%3Aclaim%20%3FidentifierClaim%3B%20wikibase%3AstatementProperty%20%3FidentifierStatementProperty%3B%20wikibase%3Areference%20%3Fref%20.%0A%20%20%3Fitem%20%3FidentifierClaim%20%5B%20%3FidentifierStatementProperty%20%3Fvalue%20%5D%20.%0A%20%20%3Fitem2%20%3FidentifierClaim%20%5B%20%3FidentifierStatementProperty%20%3Fvalue%20%5D%20.%0A%20%20FILTER%28%3Fitem%20%21%3D%20%3Fitem2%29%20.%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Non-single_identifiers">Non-single identifiers</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=27" title="Edit section: Non-single identifiers">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?identifier (COUNT(?value) AS ?cnt) (GROUP_CONCAT(?value; separator=', ') AS ?values) WITH { SELECT DISTINCT ?item WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . } } AS %subquery WHERE { INCLUDE %subquery ?identifier wikibase:propertyType wikibase:ExternalId; wikibase:claim ?identifierClaim; wikibase:statementProperty ?identifierStatementProperty; wikibase:reference ?ref . ?item ?identifierClaim [ ?identifierStatementProperty ?value ] . } GROUP BY ?item ?identifier HAVING(?cnt > 1) ORDER BY DESC(?cnt) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3Fidentifier%20%28COUNT%28%3Fvalue%29%20AS%20%3Fcnt%29%20%28GROUP_CONCAT%28%3Fvalue%3B%20separator%3D%27%2C%20%27%29%20AS%20%3Fvalues%29%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%7D%0A%7D%20AS%20%25subquery%20WHERE%20%7B%0A%20%20INCLUDE%20%25subquery%20%0A%20%20%3Fidentifier%20wikibase%3ApropertyType%20wikibase%3AExternalId%3B%20wikibase%3Aclaim%20%3FidentifierClaim%3B%20wikibase%3AstatementProperty%20%3FidentifierStatementProperty%3B%20wikibase%3Areference%20%3Fref%20.%0A%20%20%3Fitem%20%3FidentifierClaim%20%5B%20%3FidentifierStatementProperty%20%3Fvalue%20%5D%20.%0A%7D%20GROUP%20BY%20%3Fitem%20%3Fidentifier%20HAVING%28%3Fcnt%20%3E%201%29%20ORDER%20BY%20DESC%28%3Fcnt%29">Try it!</a> </div> <div class="mw-heading mw-heading2"><h2 id="Related_to_terms_(labels,_descriptions,_and_aliases)">Related to terms (labels, descriptions, and aliases)</h2>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=28" title="Edit section: Related to terms (labels, descriptions, and aliases)">edit</a>]</div> <div class="mw-heading mw-heading3"><h3 id="Missing_French_labels/descriptions_of_rowers_(works_also_with_German/English/…)">Missing French labels/descriptions of rowers (works also with German/English/…)</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=29" title="Edit section: Missing French labels/descriptions of rowers (works also with German/English/…)">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?itemLabel ?itemDescription ?citizenship WHERE { { SELECT ?item ?citizenship WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?item wdt:P27 ?citizenship . } } OPTIONAL { ?item rdfs:label ?labels . FILTER( LANG(?labels) = "fr" ) . } FILTER(!BOUND(?labels)) SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Fcitizenship%20WHERE%20%7B%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fitem%20%3Fcitizenship%20WHERE%20%7B%0A%09%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%09%20%20%3Fitem%20wdt%3AP27%20%3Fcitizenship%20.%0A%20%20%20%20%7D%09%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem%20rdfs%3Alabel%20%3Flabels%20.%0A%20%20%09FILTER%28%20LANG%28%3Flabels%29%20%3D%20%22fr%22%20%29%20.%20%0A%20%20%7D%0A%20%20FILTER%28%21BOUND%28%3Flabels%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22fr%22%20%7D%0A%7D">Try it!</a> </div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?itemLabel ?itemDescription ?citizenship ?citizenshipLabel WHERE { { SELECT ?item ?citizenship WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?item wdt:P27 ?citizenship . } } OPTIONAL { ?item schema:description ?descriptions . FILTER( LANG(?descriptions) = "fr" ) . } FILTER(!BOUND(?descriptions)) SERVICE wikibase:label { bd:serviceParam wikibase:language "fr" } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Fcitizenship%20%3FcitizenshipLabel%20WHERE%20%7B%0A%20%20%7B%0A%20%20%20%20SELECT%20%3Fitem%20%3Fcitizenship%20WHERE%20%7B%0A%09%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%09%20%20%3Fitem%20wdt%3AP27%20%3Fcitizenship%20.%0A%20%20%20%20%7D%09%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem%20schema%3Adescription%20%3Fdescriptions%20.%0A%20%20%09FILTER%28%20LANG%28%3Fdescriptions%29%20%3D%20%22fr%22%20%29%20.%20%0A%20%20%7D%0A%20%20FILTER%28%21BOUND%28%3Fdescriptions%29%29%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22fr%22%20%7D%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Search_for_descriptions_in_foreign_languages">Search for descriptions in foreign languages</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=30" title="Edit section: Search for descriptions in foreign languages">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT * WITH { SELECT ?country ?gender ?descriptionLanguage WHERE { BIND(wd:Q38 AS ?country) . BIND(wd:Q6581072 AS ?gender) . BIND('it' AS ?descriptionLanguage) . } } AS %input WITH { SELECT (COUNT(DISTINCT ?item) AS ?items) WHERE { INCLUDE %input . ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; wdt:P27 ?country; wdt:P21 ?gender . } } AS %items WITH { SELECT (COUNT(DISTINCT ?item) AS ?itemsWithAnyDescription) WHERE { INCLUDE %input . ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; wdt:P27 ?country; wdt:P21 ?gender; schema:description ?description . FILTER(LANG(?description) = ?descriptionLanguage) . } } AS %itemsWithAnyDescription WITH { SELECT ?description (COUNT(DISTINCT ?item) AS ?itemsWithThisDescription) WHERE { INCLUDE %input . ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; wdt:P27 ?country; wdt:P21 ?gender; schema:description ?description . FILTER(LANG(?description) = ?descriptionLanguage) . } GROUP BY ?description ORDER BY DESC(?cnt) } AS %itemsWithThisDescription WHERE { INCLUDE %itemsWithThisDescription . INCLUDE %itemsWithAnyDescription . INCLUDE %items . INCLUDE %input . } ORDER BY DESC(?itemsWithThisDescription) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%2A%20WITH%20%7B%0A%20%20SELECT%20%3Fcountry%20%3Fgender%20%3FdescriptionLanguage%20WHERE%20%7B%0A%20%20%20%20BIND%28wd%3AQ38%20AS%20%3Fcountry%29%20.%0A%20%20%20%20BIND%28wd%3AQ6581072%20AS%20%3Fgender%29%20.%0A%20%20%20%20BIND%28%27it%27%20AS%20%3FdescriptionLanguage%29%20.%0A%20%20%7D%0A%7D%20AS%20%25input%20WITH%20%7B%0A%20%20SELECT%20%28COUNT%28DISTINCT%20%3Fitem%29%20AS%20%3Fitems%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25input%20.%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20wdt%3AP27%20%3Fcountry%3B%20wdt%3AP21%20%3Fgender%20.%0A%20%20%7D%0A%7D%20AS%20%25items%20WITH%20%7B%0A%20%20SELECT%20%28COUNT%28DISTINCT%20%3Fitem%29%20AS%20%3FitemsWithAnyDescription%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25input%20.%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20wdt%3AP27%20%3Fcountry%3B%20wdt%3AP21%20%3Fgender%3B%20schema%3Adescription%20%3Fdescription%20.%0A%20%20%20%20FILTER%28LANG%28%3Fdescription%29%20%3D%20%3FdescriptionLanguage%29%20.%0A%20%20%7D%0A%7D%20AS%20%25itemsWithAnyDescription%20WITH%20%7B%0A%20%20SELECT%20%3Fdescription%20%28COUNT%28DISTINCT%20%3Fitem%29%20AS%20%3FitemsWithThisDescription%29%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25input%20.%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20wdt%3AP27%20%3Fcountry%3B%20wdt%3AP21%20%3Fgender%3B%20schema%3Adescription%20%3Fdescription%20.%0A%20%20%20%20FILTER%28LANG%28%3Fdescription%29%20%3D%20%3FdescriptionLanguage%29%20.%0A%20%20%7D%20GROUP%20BY%20%3Fdescription%20ORDER%20BY%20DESC%28%3Fcnt%29%0A%7D%20AS%20%25itemsWithThisDescription%20WHERE%20%7B%0A%20%20INCLUDE%20%25itemsWithThisDescription%20.%0A%20%20INCLUDE%20%25itemsWithAnyDescription%20.%0A%20%20INCLUDE%20%25items%20.%0A%20%20INCLUDE%20%25input%20.%0A%7D%20ORDER%20BY%20DESC%28%3FitemsWithThisDescription%29">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Particular_literals_in_terms">Particular literals in terms</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=31" title="Edit section: Particular literals in terms">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT DISTINCT ?item ?term ?literal ?lang WHERE { VALUES ?term { rdfs:label schema:description skos:altLabel } ?item p:P106/ps:P106/wdt:P279* wd:Q26270618; ?term ?literal . FILTER(CONTAINS(?literal, ' ')) . BIND(LANG(?literal) AS ?lang) . } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem%20%3Fterm%20%3Fliteral%20%3Flang%20WHERE%20%7B%0A%20%20VALUES%20%3Fterm%20%7B%20rdfs%3Alabel%20schema%3Adescription%20skos%3AaltLabel%20%7D%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%3B%20%3Fterm%20%3Fliteral%20.%0A%20%20FILTER%28CONTAINS%28%3Fliteral%2C%20%27%20%20%27%29%29%20.%0A%20%20BIND%28LANG%28%3Fliteral%29%20AS%20%3Flang%29%20.%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Use_of_aliases">Use of aliases</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=32" title="Edit section: Use of aliases">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?term WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 OPTIONAL { ?item skos:altLabel ?term FILTER(lang(?term) = "de") } FILTER(BOUND(?term)) } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3Fterm%20%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%0A%20%20%20%20OPTIONAL%20%7B%0A%20%20%20%20%20%20%3Fitem%20skos%3AaltLabel%20%3Fterm%0A%20%20%20%20%20%20FILTER%28lang%28%3Fterm%29%20%3D%20%22de%22%29%0A%20%20%20%20%7D%0A%20%20%20%20FILTER%28BOUND%28%3Fterm%29%29%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Descriptions_of_rowing_persons">Descriptions of rowing persons</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=33" title="Edit section: Descriptions of rowing persons">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?desc ?genderLbl ?cocLbl (COUNT(?desc) AS ?cnt) { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . OPTIONAL { ?item wdt:P21 ?gender . ?gender rdfs:label ?genderLbl . FILTER(LANG(?genderLbl) = 'de') . } OPTIONAL { ?item wdt:P27 ?coc . ?coc rdfs:label ?cocLbl . FILTER(LANG(?cocLbl) = 'de') . } ?item schema:description ?desc . FILTER(LANG(?desc) = 'de') . } GROUP BY ?desc ?genderLbl ?cocLbl ORDER BY DESC(?cnt) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fdesc%20%3FgenderLbl%20%3FcocLbl%20%28COUNT%28%3Fdesc%29%20AS%20%3Fcnt%29%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP21%20%3Fgender%20.%0A%20%20%20%20%3Fgender%20rdfs%3Alabel%20%3FgenderLbl%20.%0A%20%20%20%20FILTER%28LANG%28%3FgenderLbl%29%20%3D%20%27de%27%29%20.%0A%20%20%7D%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fitem%20wdt%3AP27%20%3Fcoc%20.%0A%20%20%20%20%3Fcoc%20rdfs%3Alabel%20%3FcocLbl%20.%0A%20%20%20%20FILTER%28LANG%28%3FcocLbl%29%20%3D%20%27de%27%29%20.%0A%20%20%7D%0A%20%20%3Fitem%20schema%3Adescription%20%3Fdesc%20.%0A%20%20FILTER%28LANG%28%3Fdesc%29%20%3D%20%27de%27%29%20.%0A%7D%20GROUP%20BY%20%3Fdesc%20%3FgenderLbl%20%3FcocLbl%20ORDER%20BY%20DESC%28%3Fcnt%29">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Descriptions_of_rowing_persons_with_non-rowing_occupations">Descriptions of rowing persons with non-rowing occupations</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=34" title="Edit section: Descriptions of rowing persons with non-rowing occupations">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?item ?itemLabel ?itemDescription ?occupation ?occupationLabel WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?item wdt:P106 ?occupation . MINUS { ?occupation wdt:P279* wd:Q26270618 } SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3Foccupation%20%3FoccupationLabel%20WHERE%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%3Fitem%20wdt%3AP106%20%3Foccupation%20.%0A%20%20MINUS%20%7B%20%3Foccupation%20wdt%3AP279%2A%20wd%3AQ26270618%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Missing_descriptions_of_rowing_persons_by_language">Missing descriptions of rowing persons by language</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=35" title="Edit section: Missing descriptions of rowing persons by language">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT ?str (COUNT(*) AS ?cnt) WITH { SELECT DISTINCT ?item WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . ?item wdt:P21 wd:Q6581072; wdt:P27 wd:Q183 . } } AS %subquery WHERE { INCLUDE %subquery . ?item schema:description ?str . FILTER(LANG(?str) = 'es') . } GROUP BY ?str ORDER BY DESC(?cnt) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20%3Fstr%20%28COUNT%28%2A%29%20AS%20%3Fcnt%29%20WITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20%20%20%3Fitem%20wdt%3AP21%20wd%3AQ6581072%3B%20wdt%3AP27%20wd%3AQ183%20.%0A%20%20%7D%0A%7D%20AS%20%25subquery%20WHERE%20%7B%0A%20%20INCLUDE%20%25subquery%20.%0A%20%20%3Fitem%20schema%3Adescription%20%3Fstr%20.%20FILTER%28LANG%28%3Fstr%29%20%3D%20%27es%27%29%20.%0A%7D%20GROUP%20BY%20%3Fstr%20ORDER%20BY%20DESC%28%3Fcnt%29">Try it!</a> </div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT DISTINCT ?item WITH { SELECT ?item (COUNT(*) AS ?cnt) WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q13382576; wdt:P106 ?occ . ?item wdt:P21 wd:Q6581097; wdt:P27 wd:Q183 . } GROUP BY ?item HAVING ( ?cnt = 1 ) } AS %subquery WHERE { INCLUDE %subquery . OPTIONAL { ?item schema:description ?str . FILTER(LANG(?str) = 'es') } FILTER(!BOUND(?str)) . } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem%20WITH%20%7B%0A%20%20SELECT%20%3Fitem%20%28COUNT%28%2A%29%20AS%20%3Fcnt%29%20WHERE%20%7B%0A%20%20%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ13382576%3B%20wdt%3AP106%20%3Focc%20.%0A%20%20%20%20%3Fitem%20wdt%3AP21%20wd%3AQ6581097%3B%20wdt%3AP27%20wd%3AQ183%20.%20%20%20%20%0A%20%20%7D%20GROUP%20BY%20%3Fitem%20HAVING%20%28%20%3Fcnt%20%3D%201%20%29%0A%7D%20AS%20%25subquery%20WHERE%20%7B%0A%20%20INCLUDE%20%25subquery%20.%0A%20%20OPTIONAL%20%7B%20%3Fitem%20schema%3Adescription%20%3Fstr%20.%20FILTER%28LANG%28%3Fstr%29%20%3D%20%27es%27%29%20%7D%0A%20%20FILTER%28%21BOUND%28%3Fstr%29%29%20.%0A%7D">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="English_description_and_English_Wikipedia_short_description">English description and English Wikipedia short description</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=36" title="Edit section: English description and English Wikipedia short description">edit</a>]</div> <ul><li><a rel="nofollow" class="external text" href="https://petscan.wmflabs.org/?psid=17020429">petscan:17020429</a> (different descriptions)</li> <li><a rel="nofollow" class="external text" href="https://petscan.wmflabs.org/?psid=17023647">petscan:17023647</a> (case-insensitively identical descriptions)</li> <li><a rel="nofollow" class="external text" href="https://petscan.wmflabs.org/?psid=17023652">petscen:17023652</a> (description missing in Wikidata)</li></ul> <div class="mw-heading mw-heading2"><h2 id="Watchlist_management">Watchlist management</h2>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=37" title="Edit section: Watchlist management">edit</a>]</div> <div class="mw-heading mw-heading3"><h3 id="All_rowing_persons_(for_watchlist_import)">All rowing persons (for watchlist import)</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=38" title="Edit section: All rowing persons (for watchlist import)">edit</a>]</div> <ul><li><a href="/wiki/Special:EditWatchlist/raw" title="Special:EditWatchlist/raw">Special:EditWatchlist/raw</a></li></ul> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT DISTINCT ?stritem WHERE { ?item p:P106/ps:P106/wdt:P279* wd:Q26270618 . BIND(STRAFTER(STR(?item), 'entity/') AS ?stritem) . } ORDER BY ASC(xsd:integer(STRAFTER(?stritem, 'Q'))) </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fstritem%20WHERE%20%7B%0A%20%20%3Fitem%20p%3AP106%2Fps%3AP106%2Fwdt%3AP279%2A%20wd%3AQ26270618%20.%0A%20%20BIND%28STRAFTER%28STR%28%3Fitem%29%2C%20%27entity%2F%27%29%20AS%20%3Fstritem%29%20.%0A%7D%20ORDER%20BY%20ASC%28xsd%3Ainteger%28STRAFTER%28%3Fstritem%2C%20%27Q%27%29%29%29">Try it!</a> </div> <div class="mw-heading mw-heading3"><h3 id="Search_for_non-rowing_stuff_on_watchlist">Search for non-rowing stuff on watchlist</h3>[<a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit&section=39" title="Edit section: Search for non-rowing stuff on watchlist">edit</a>]</div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r1502159272"><div class="wdt-sparql-container"><div><div class="mw-highlight mw-highlight-lang-sparql mw-content-ltr" dir="ltr"><pre>SELECT DISTINCT ?item ?itemLabel WHERE { VALUES ?item { # put items here } MINUS { ?item wdt:P106?/wdt:P279* wd:Q26270618 } # rowing people MINUS { ?item wdt:P31?/wdt:P279* wd:Q21246076 } # events MINUS { ?item wdt:P31?/wdt:P279* wd:Q21224061 } # regattas MINUS { ?item wdt:P3450/wdt:P279* wd:Q21224061 } # seasons MINUS { ?item wdt:P31?/wdt:P279* wd:Q43445087 } # organizations MINUS { ?item wdt:P31|wdt:P366 wd:Q2137251 } # venues MINUS { ?item wdt:P31 wd:Q22936940; wdt:P641/wdt:P279* wd:Q159354 } # competition classes MINUS { ?item wdt:P31 wd:Q26211803 } # boat classes MINUS { ?item wdt:P279*|wdt:P361 wd:Q606305 } # equipment MINUS { ?item wdt:P641?/wdt:P279* wd:Q159354 } # just sport MINUS { ?item wdt:P31/wdt:P279* wd:Q4167836 } # categories MINUS { ?item wdt:P31/wdt:P279* wd:Q11266439 } # templates MINUS { ?item wdt:P31 wd:Q13406463 } # lists MINUS { ?item wdt:P31 wd:Q4167410 } # dab SERVICE wikibase:label { bd:serviceParam wikibase:language 'en' } } </pre></div></div><a class="external text" href="https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20VALUES%20%3Fitem%20%7B%0A%20%20%20%20%23%20put%20items%20here%0A%20%20%7D%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP106%3F%2Fwdt%3AP279%2A%20wd%3AQ26270618%20%7D%20%23%20rowing%20people%0A%20%20%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%3F%2Fwdt%3AP279%2A%20wd%3AQ21246076%20%7D%20%23%20events%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%3F%2Fwdt%3AP279%2A%20wd%3AQ21224061%20%7D%20%23%20regattas%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP3450%2Fwdt%3AP279%2A%20wd%3AQ21224061%20%7D%20%23%20seasons%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%3F%2Fwdt%3AP279%2A%20wd%3AQ43445087%20%7D%20%23%20organizations%0A%20%20%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%7Cwdt%3AP366%20wd%3AQ2137251%20%7D%20%23%20venues%0A%20%20%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ22936940%3B%20wdt%3AP641%2Fwdt%3AP279%2A%20wd%3AQ159354%20%7D%20%23%20competition%20classes%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ26211803%20%7D%20%23%20boat%20classes%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP279%2A%7Cwdt%3AP361%20wd%3AQ606305%20%7D%20%23%20equipment%0A%20%20%20%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP641%3F%2Fwdt%3AP279%2A%20wd%3AQ159354%20%7D%20%23%20just%20sport%0A%20%20%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ4167836%20%7D%20%23%20categories%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%2Fwdt%3AP279%2A%20wd%3AQ11266439%20%7D%20%23%20templates%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ13406463%20%7D%20%23%20lists%0A%20%20MINUS%20%7B%20%3Fitem%20wdt%3AP31%20wd%3AQ4167410%20%7D%20%23%20dab%0A%20%20%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%27en%27%20%7D%0A%7D">Try it!</a> </div>    </div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?type=1x1" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Retrieved from "<a dir="ltr" href="https://www.wikidata.org/w/index.php?title=User:MisterSynergy/rowing/queries&oldid=1250025433">https://www.wikidata.org/w/index.php?title=User:MisterSynergy/rowing/queries&oldid=1250025433</a>"</div></div> <div id="catlinks" class="catlinks catlinks-allhidden" data-mw="interface"></div> </div> </div> <div id="mw-navigation"> <h2>Navigation menu</h2> <div id="mw-head"> <nav id="p-personal" class="mw-portlet mw-portlet-personal vector-user-menu-legacy vector-menu" aria-labelledby="p-personal-label" > <h3 id="p-personal-label" class="vector-menu-heading " > Personal tools </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-uls" class="mw-list-item active"><a class="uls-trigger" href="#">English</a></li><li id="pt-anonuserpage" class="mw-list-item">Not logged in</li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Special:MyTalk" title="Discussion about edits from this IP address [n]" accesskey="n">Talk</a></li><li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Special:MyContributions" title="A list of edits made from this IP address [y]" accesskey="y">Contributions</a></li><li id="pt-createaccount" class="mw-list-item"><a href="/w/index.php?title=Special:CreateAccount&returnto=User%3AMisterSynergy%2Frowing%2Fqueries" title="You are encouraged to create an account and log in; however, it is not mandatory">Create account</a></li><li id="pt-login" class="mw-list-item"><a href="/w/index.php?title=Special:UserLogin&returnto=User%3AMisterSynergy%2Frowing%2Fqueries" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o">Log in</a></li> </ul> </div> </nav> <div id="left-navigation"> <nav id="p-namespaces" class="mw-portlet mw-portlet-namespaces vector-menu-tabs vector-menu-tabs-legacy vector-menu" aria-labelledby="p-namespaces-label" > <h3 id="p-namespaces-label" class="vector-menu-heading " > Namespaces </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-user" class="selected mw-list-item"><a href="/wiki/User:MisterSynergy/rowing/queries" title="View the user page [c]" accesskey="c">User page</a></li><li id="ca-talk" class="new mw-list-item"><a href="/w/index.php?title=User_talk:MisterSynergy/rowing/queries&action=edit&redlink=1" rel="discussion" class="new" title="Discussion about the content page (page does not exist) [t]" accesskey="t">Discussion</a></li> </ul> </div> </nav> <nav id="p-variants" class="mw-portlet mw-portlet-variants emptyPortlet vector-menu-dropdown vector-menu" aria-labelledby="p-variants-label" > <input type="checkbox" id="p-variants-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-variants" class="vector-menu-checkbox" aria-labelledby="p-variants-label" > <label id="p-variants-label" class="vector-menu-heading " > English </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> </div> <div id="right-navigation"> <nav id="p-views" class="mw-portlet mw-portlet-views vector-menu-tabs vector-menu-tabs-legacy vector-menu" aria-labelledby="p-views-label" > <h3 id="p-views-label" class="vector-menu-heading " > Views </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected mw-list-item"><a href="/wiki/User:MisterSynergy/rowing/queries">Read</a></li><li id="ca-edit" class="mw-list-item"><a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=edit" title="Edit this page [e]" accesskey="e">Edit</a></li><li id="ca-history" class="mw-list-item"><a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=history" title="Past revisions of this page [h]" accesskey="h">View history</a></li> </ul> </div> </nav> <nav id="p-cactions" class="mw-portlet mw-portlet-cactions emptyPortlet vector-menu-dropdown vector-menu" aria-labelledby="p-cactions-label" title="More options" > <input type="checkbox" id="p-cactions-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-p-cactions" class="vector-menu-checkbox" aria-labelledby="p-cactions-label" > <label id="p-cactions-label" class="vector-menu-heading " > More </label> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box"> <h3 >Search</h3> <form action="/w/index.php" id="searchform" class="vector-search-box-form"> <div id="simpleSearch" class="vector-search-box-inner" data-search-loc="header-navigation"> <input class="vector-search-box-input" type="search" name="search" placeholder="Search Wikidata" aria-label="Search Wikidata" autocapitalize="sentences" title="Search Wikidata [f]" accesskey="f" id="searchInput" > <input type="hidden" name="title" value="Special:Search"> <input id="mw-searchButton" class="searchButton mw-fallbackSearchButton" type="submit" name="fulltext" title="Search the pages for this text" value="Search"> <input id="searchButton" class="searchButton" type="submit" name="go" title="Go to a page with this exact name if it exists" value="Go"> </div> </form> </div> </div> </div> <div id="mw-panel" class="vector-legacy-sidebar"> <div id="p-logo" role="banner"> <a class="mw-wiki-logo" href="/wiki/Wikidata:Main_Page" title="Visit the main page"></a> </div> <nav id="p-navigation" class="mw-portlet mw-portlet-navigation vector-menu-portal portal vector-menu" aria-labelledby="p-navigation-label" > <h3 id="p-navigation-label" class="vector-menu-heading " > Navigation </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage-description" class="mw-list-item"><a href="/wiki/Wikidata:Main_Page" title="Visit the main page [z]" accesskey="z">Main page</a></li><li id="n-portal" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Project:Community_portal" title="About the project, what you can do, where to find things">Community portal</a></li><li id="n-villagepump" class="mw-list-item"><a href="/wiki/Wikidata:Project_chat">Project chat</a></li><li id="n-special-newitem" class="mw-list-item"><a href="/wiki/Special:NewItem">Create a new Item</a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Special:RecentChanges" title="A list of recent changes in the wiki [r]" accesskey="r">Recent changes</a></li><li id="n-wikibase-randomitem" class="mw-list-item"><a href="/wiki/Special:Random/Main" title="[x]" accesskey="x">Random Item</a></li><li id="n-wikibase-queryservice" class="mw-list-item"><a href="//query.wikidata.org/">Query Service</a></li><li id="n-nearby-pages-title" class="mw-list-item"><a href="/wiki/Special:Nearby">Nearby</a></li><li id="n-help" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Help:Contents" title="The place to find out">Help</a></li><li id="n-sitesupport" class="mw-list-item"><a href="//donate.wikimedia.org/wiki/Special:FundraiserRedirector?utm_source=donate&utm_medium=sidebar&utm_campaign=C13_wikidata.org&uselang=en" title="Support us">Donate</a></li> </ul> </div> </nav> <nav id="p-wikibase-lexeme-lexicographical-data" class="mw-portlet mw-portlet-wikibase-lexeme-lexicographical-data vector-menu-portal portal vector-menu" aria-labelledby="p-wikibase-lexeme-lexicographical-data-label" > <h3 id="p-wikibase-lexeme-lexicographical-data-label" class="vector-menu-heading " > Lexicographical data </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-special-newlexeme" class="mw-list-item"><a href="/wiki/Special:NewLexeme">Create a new Lexeme</a></li><li id="n-recentchanges-lexemes" class="mw-list-item"><a href="https://www.wikidata.org/wiki/Special:RecentChanges?namespace=146%3B147">Recent changes</a></li><li id="n-wikibase-lexeme-randomlexeme" class="mw-list-item"><a href="/wiki/Special:Random/Lexeme">Random Lexeme</a></li> </ul> </div> </nav> <nav id="p-tb" class="mw-portlet mw-portlet-tb vector-menu-portal portal vector-menu" aria-labelledby="p-tb-label" > <h3 id="p-tb-label" class="vector-menu-heading " > Tools </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Special:WhatLinksHere/User:MisterSynergy/rowing/queries" title="A list of all wiki pages that link here [j]" accesskey="j">What links here</a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Special:RecentChangesLinked/User:MisterSynergy/rowing/queries" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k">Related changes</a></li><li id="t-contributions" class="mw-list-item"><a href="/wiki/Special:Contributions/MisterSynergy" title="A list of contributions by this user">User contributions</a></li><li id="t-log" class="mw-list-item"><a href="/wiki/Special:Log/MisterSynergy">Logs</a></li><li id="t-userrights" class="mw-list-item"><a href="/wiki/Special:UserRights/MisterSynergy">View user groups</a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Special:SpecialPages" title="A list of all special pages [q]" accesskey="q">Special pages</a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=User:MisterSynergy/rowing/queries&oldid=1250025433" title="Permanent link to this revision of this page">Permanent link</a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=User:MisterSynergy/rowing/queries&action=info" title="More information about this page">Page information</a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Special:UrlShortener&url=https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FUser%3AMisterSynergy%2Frowing%2Fqueries">Get shortened URL</a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Special:QrCode&url=https%3A%2F%2Fwww.wikidata.org%2Fwiki%2FUser%3AMisterSynergy%2Frowing%2Fqueries">Download QR code</a></li> </ul> </div> </nav> <nav id="p-coll-print_export" class="mw-portlet mw-portlet-coll-print_export vector-menu-portal portal vector-menu" aria-labelledby="p-coll-print_export-label" > <h3 id="p-coll-print_export-label" class="vector-menu-heading " > Print/export </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-create_a_book" class="mw-list-item"><a href="/w/index.php?title=Special:Book&bookcmd=book_creator&referer=User%3AMisterSynergy%2Frowing%2Fqueries">Create a book</a></li><li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Special:DownloadAsPdf&page=User%3AMisterSynergy%2Frowing%2Fqueries&action=show-download-screen">Download as PDF</a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=User:MisterSynergy/rowing/queries&printable=yes" title="Printable version of this page [p]" accesskey="p">Printable version</a></li> </ul> </div> </nav> <nav id="p-wikibase-otherprojects" class="mw-portlet mw-portlet-wikibase-otherprojects emptyPortlet vector-menu-portal portal vector-menu" aria-labelledby="p-wikibase-otherprojects-label" > <h3 id="p-wikibase-otherprojects-label" class="vector-menu-heading " > In other projects </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> </div> </div> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> This page was last edited on 7 August 2020, at 18:10.</li> <li id="footer-info-copyright">All structured data from the main, Property, Lexeme, and EntitySchema namespaces is available under the <a rel="nofollow" class="external text" href="//creativecommons.org/publicdomain/zero/1.0/">Creative Commons CC0 License</a>; text in the other namespaces is available under the <a rel="nofollow" class="external text" href="//creativecommons.org/licenses/by-sa/4.0/">Creative Commons Attribution-ShareAlike License</a>; additional terms may apply. By using this site, you agree to the <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use">Terms of Use</a> and <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy Policy</a>.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy policy</a></li> <li id="footer-places-about"><a href="/wiki/Special:MyLanguage/Project:Introduction">About Wikidata</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Special:MyLanguage/Project:General_disclaimer">Disclaimers</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Universal_Code_of_Conduct">Code of Conduct</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Developers</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/www.wikidata.org">Statistics</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookie statement</a></li> <li id="footer-places-mobileview"><a href="//m.wikidata.org/w/index.php?title=User:MisterSynergy/rowing/queries&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobile view</a></li> <li id="footer-places-data-access"><a href="/wiki/Special:MyLanguage/Wikidata:Data_access">Data access</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> <script>(RLQ=window.RLQ||[]).push(function(){mw.log.warn("This page is using the deprecated ResourceLoader module \"codex-search-styles\".\n[1.43] Use a CodexModule with codexComponents to set your specific components used: https://www.mediawiki.org/wiki/Codex#Using_a_limited_subset_of_components");mw.config.set({"wgHostname":"mw-web.codfw.main-f69cdc8f6-zdfpm","wgBackendResponseTime":4120,"wgPageParseReport":{"limitreport":{"cputime":"0.390","walltime":"3.980","ppvisitednodes":{"value":8518,"limit":1000000},"postexpandincludesize":{"value":155774,"limit":2097152},"templateargumentsize":{"value":55884,"limit":2097152},"expansiondepth":{"value":7,"limit":100},"expensivefunctioncount":{"value":37,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":128246,"limit":5000000},"entityaccesscount":{"value":0,"limit":500},"timingprofile":["100.00% 3857.242 1 -total"," 82.53% 3183.306 31 Template:SPARQL"," 16.43% 633.755 6 Template:Sparql"," 1.77% 68.226 74 Template:SPARQLText"," 1.39% 53.717 37 Template:Int_try_it"," 1.22% 46.961 37 Template:TranslateThis"," 0.43% 16.599 1 User:MisterSynergy/header"," 0.37% 14.426 8 Template:Label"," 0.37% 14.397 5 Template:Property"," 0.15% 5.807 3 Template:Q"]},"scribunto":{"limitreport-timeusage":{"value":"0.081","limit":"10.000"},"limitreport-memusage":{"value":1651857,"limit":52428800}},"cachereport":{"origin":"mw-web.codfw.main-f69cdc8f6-zdfpm","timestamp":"20241124225903","ttl":2592000,"transientcontent":false}}});});</script> </body> </html>