CINXE.COM
Wikidata:WikiProject Mineralogy/Queries - Wikidata
<!DOCTYPE html> <html class="client-nojs" lang="en" dir="ltr"> <head> <meta charset="UTF-8"> <title>Wikidata:WikiProject Mineralogy/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":"cf1f31fc-326f-45d5-a2be-be847a157ecc","wgCanonicalNamespace":"Project","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":4,"wgPageName":"Wikidata:WikiProject_Mineralogy/Queries","wgTitle":"WikiProject Mineralogy/Queries","wgCurRevisionId":1789684922,"wgRevisionId":1789684922,"wgArticleId":25902661,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view", "wgUserName":null,"wgUserGroups":["*"],"wgCategories":[],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Wikidata:WikiProject_Mineralogy/Queries","wgRelevantArticleId":25902661,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"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":10000,"wgCentralAuthMobileDomain":false,"wgEditSubmitButtonLabelPublish":true,"wgDiscussionToolsFeaturesEnabled":{"replytool":true,"newtopictool":true,"sourcemodetoolbar":true,"topicsubscription":false,"autotopicsub":false,"visualenhancements":false, "visualenhancements_reply":false,"visualenhancements_pageframe":false},"wgDiscussionToolsFallbackEditMode":"source","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","ext.discussionTools.init.styles":"ready","oojs-ui-core.styles":"ready","oojs-ui.styles.indicators":"ready","mediawiki.widgets.styles":"ready","oojs-ui-core.icons":"ready","skins.vector.styles.legacy":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","codex-search-styles":"ready","ext.uls.pt":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["ext.pygments.view","site", "mediawiki.page.ready","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.discussionTools.init","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.discussionTools.init.styles%7Cext.pygments%2CwikimediaBadges%7Cext.uls.pt%7Cext.visualEditor.desktopArticleTarget.noscript%7Cmediawiki.widgets.styles%7Coojs-ui-core.icons%2Cstyles%7Coojs-ui.styles.indicators%7Cskins.vector.styles.legacy%7Cwikibase.client.init&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="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/Wikidata:WikiProject_Mineralogy/Queries"> <link rel="alternate" type="application/x-wiki" title="Edit" href="/w/index.php?title=Wikidata:WikiProject_Mineralogy/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/Wikidata:WikiProject_Mineralogy/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="ext-discussiontools-replytool-enabled ext-discussiontools-newtopictool-enabled ext-discussiontools-sourcemodetoolbar-enabled skin-vector-legacy mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-4 ns-subject mw-editable page-Wikidata_WikiProject_Mineralogy_Queries rootpage-Wikidata_WikiProject_Mineralogy 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"><!-- CentralNotice --></div> <div class="mw-indicators"> </div> <h1 id="firstHeading" class="firstHeading mw-first-heading"><span class="mw-page-title-namespace">Wikidata</span><span class="mw-page-title-separator">:</span><span class="mw-page-title-main">WikiProject Mineralogy/Queries</span></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/Wikidata:WikiProject_Mineralogy" title="Wikidata:WikiProject Mineralogy">Wikidata:WikiProject Mineralogy</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"><p>This is page that gathers useful and interesting queries. </p> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Maintenance" data-mw-thread-id="h-Maintenance"><span data-mw-comment-start="" id="h-Maintenance"></span>Maintenance<span data-mw-comment-end="h-Maintenance"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikidata:WikiProject_Mineralogy/Queries&action=edit&section=1" title="Edit section: Maintenance"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span><!--__DTELLIPSISBUTTON__{"threadItem":{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Maintenance","replies":[]}}--></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><span></span><span class="c"># List all items that are a subclass of mineral and are missing a picture statement</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P279</span><span class="o">*</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q7946</span> <span class="p">.</span> <span class="k">filter</span> <span class="nf">not exists</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P18</span> <span class="nv">?x</span> <span class="p">}</span> <span class="p">.</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span> <span class="p">.</span> <span class="p">}</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20are%20a%20subclass%20of%20mineral%20and%20are%20missing%20a%20picture%20statement%0ASELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%09%3Fitem%20wdt%3AP279%2A%20wd%3AQ7946%20.%0A%09filter%20not%20exists%20%7B%20%3Fitem%20wdt%3AP18%20%3Fx%20%7D%20.%0A%20%20%09SERVICE%20wikibase%3Alabel%20%7B%0A%09%09bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%09%7D%0A%7D"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># List all items that are in the subclass-tree of mineral</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P279</span><span class="o">*</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q7946</span> <span class="p">.</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span> <span class="p">.</span> <span class="p">}</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20are%20in%20the%20subclass-tree%20of%20mineral%0ASELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%09%3Fitem%20wdt%3AP279%2A%20wd%3AQ7946%20.%0A%20%20%09SERVICE%20wikibase%3Alabel%20%7B%0A%09%09bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%09%7D%0A%7D"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># List all items that have 'mineral series' in property 'named after'</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P138</span><span class="o">*</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q3965281</span> <span class="p">.</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span> <span class="p">.</span> <span class="p">}</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20have%20%27mineral%20series%27%20in%20property%20%27named%20after%27%0ASELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%09%3Fitem%20wdt%3AP138%2A%20wd%3AQ3965281%20.%0A%20%20%09SERVICE%20wikibase%3Alabel%20%7B%0A%09%09bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%09%7D%0A%7D"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c">#Author name strings </span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P2093</span> <span class="s">"Jane Doe"</span> <span class="p">.</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span><span class="p">.</span> <span class="p">}</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23Author%20name%20strings%20%0ASELECT%20%3Fitem%20%3FitemLabel%0A%7B%0A%20%20%3Fitem%20wdt%3AP2093%20%22Jane%20Doe%22%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D"><span dir="ltr" lang="en">Try it!</span></a> </div> <p>Example, gadolinite-(Ce): cerium dominant analogue of gadolinite-(Y); translates to 'named after', cerium, gadolinite-REE, 'mineral series'. </p> <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><span></span><span class="c"># List all items that have a named after (P138) mineral series (Q24241569)</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="p">(</span><span class="nf">GROUP_CONCAT</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">;</span> <span class="nf">separator</span><span class="o">=</span><span class="s">', '</span><span class="p">)</span> <span class="k">AS</span> <span class="nv">?namedAfter</span><span class="p">)</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P138</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q24241569</span><span class="p">;</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P138</span> <span class="nv">?namedAfterItem</span> <span class="p">.</span> <span class="k">OPTIONAL</span> <span class="p">{</span> <span class="nv">?namedAfterItem</span> <span class="nn">rdfs</span><span class="p">:</span><span class="nt">label</span> <span class="nv">?namedAfterItemLabel</span> <span class="p">.</span> <span class="k">FILTER</span><span class="p">(</span><span class="nf">LANG</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">)</span> <span class="o">=</span> <span class="s">'en'</span><span class="p">)</span> <span class="p">.</span> <span class="p">}</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">'en'</span> <span class="p">}</span> <span class="p">}</span> <span class="k">GROUP BY</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20have%20a%20named%20after%20%28P138%29%20mineral%20series%20%28Q24241569%29%0ASELECT%20%3Fitem%20%3FitemLabel%20%28GROUP_CONCAT%28%3FnamedAfterItemLabel%3B%20separator%3D%27%2C%20%27%29%20AS%20%3FnamedAfter%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP138%20wd%3AQ24241569%3B%20wdt%3AP138%20%3FnamedAfterItem%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FnamedAfterItem%20rdfs%3Alabel%20%3FnamedAfterItemLabel%20.%0A%20%20%20%20FILTER%28LANG%28%3FnamedAfterItemLabel%29%20%3D%20%27en%27%29%20.%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%3Fitem%20%3FitemLabel"><span dir="ltr" lang="en">Try it!</span></a> </div> <p>Notes: Mineralogical Society of America (MSA), Handbook of Mineralogy (HOM) and mindat.org are avoided as reference. It is assumed that the description of the type specimen cites the naming rationale, if this is untrue then it is the 'type locality' (the only name cited in the description in this case). One exception is suhailite: Andalusia has old names of arabic origin and Suhail is the old arabic name for <a href="/wiki/Q492735" title="Q492735">Fuengirola</a>. Another exception is the Chinese literature before <a href="/wiki/Q16977" title="Q16977">Deng Xiaoping</a>: 'type localities' and so 'naming localities' were considered state secrets. Reference, before 1896: <a href="/wiki/Q53857737" title="Q53857737">A Dictionary of the Names of Minerals</a>. Consider that some items have more than one name. Alsace was once part of the German Empire; Trieste and Tyrol was once part of the Austro-Hungary Empire. Sadamisaki Peninsula is called Misaki Peninsula (misakiite). Valais (French) is Wallis (German), wallisite. Vulcano is Hiera (ancient Greek), hietatite; or Therasia (θηρασια, warm earth), therasiaite. Sardinia is Ichnusa (Ιχνουσσα, Ancient Greek), ichnusaite. </p> <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><span></span><span class="c"># List all items that have a named after (P138) naming locality (Q22815296)</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="p">(</span><span class="nf">GROUP_CONCAT</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">;</span> <span class="nf">separator</span><span class="o">=</span><span class="s">', '</span><span class="p">)</span> <span class="k">AS</span> <span class="nv">?namedAfter</span><span class="p">)</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P138</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q22815296</span><span class="p">;</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P138</span> <span class="nv">?namedAfterItem</span> <span class="p">.</span> <span class="k">OPTIONAL</span> <span class="p">{</span> <span class="nv">?namedAfterItem</span> <span class="nn">rdfs</span><span class="p">:</span><span class="nt">label</span> <span class="nv">?namedAfterItemLabel</span> <span class="p">.</span> <span class="k">FILTER</span><span class="p">(</span><span class="nf">LANG</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">)</span> <span class="o">=</span> <span class="s">'en'</span><span class="p">)</span> <span class="p">.</span> <span class="p">}</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">'en'</span> <span class="p">}</span> <span class="p">}</span> <span class="k">GROUP BY</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20have%20a%20named%20after%20%28P138%29%20naming%20locality%20%28Q22815296%29%0ASELECT%20%3Fitem%20%3FitemLabel%20%28GROUP_CONCAT%28%3FnamedAfterItemLabel%3B%20separator%3D%27%2C%20%27%29%20AS%20%3FnamedAfter%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP138%20wd%3AQ22815296%3B%20wdt%3AP138%20%3FnamedAfterItem%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FnamedAfterItem%20rdfs%3Alabel%20%3FnamedAfterItemLabel%20.%0A%20%20%20%20FILTER%28LANG%28%3FnamedAfterItemLabel%29%20%3D%20%27en%27%29%20.%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%3Fitem%20%3FitemLabel"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># List all items that have a main subject (P921) type description (earth sciences) (Q56241591)</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="p">(</span><span class="nf">GROUP_CONCAT</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">;</span> <span class="nf">separator</span><span class="o">=</span><span class="s">', '</span><span class="p">)</span> <span class="k">AS</span> <span class="nv">?namedAfter</span><span class="p">)</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P921</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q83353</span><span class="p">;</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P50</span> <span class="nv">?namedAfterItem</span> <span class="p">.</span> <span class="k">OPTIONAL</span> <span class="p">{</span> <span class="nv">?namedAfterItem</span> <span class="nn">rdfs</span><span class="p">:</span><span class="nt">label</span> <span class="nv">?namedAfterItemLabel</span> <span class="p">.</span> <span class="k">FILTER</span><span class="p">(</span><span class="nf">LANG</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">)</span> <span class="o">=</span> <span class="s">'en'</span><span class="p">)</span> <span class="p">.</span> <span class="p">}</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">'en'</span> <span class="p">}</span> <span class="p">}</span> <span class="k">GROUP BY</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20have%20a%20main%20subject%20%28P921%29%20type%20description%20%28earth%20sciences%29%20%28Q56241591%29%0ASELECT%20%3Fitem%20%3FitemLabel%20%28GROUP_CONCAT%28%3FnamedAfterItemLabel%3B%20separator%3D%27%2C%20%27%29%20AS%20%3FnamedAfter%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP921%20wd%3AQ83353%3B%20wdt%3AP50%20%3FnamedAfterItem%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FnamedAfterItem%20rdfs%3Alabel%20%3FnamedAfterItemLabel%20.%0A%20%20%20%20FILTER%28LANG%28%3FnamedAfterItemLabel%29%20%3D%20%27en%27%29%20.%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%3Fitem%20%3FitemLabel"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># List all items that have a named after (P138) naming region (Q28837448)</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="p">(</span><span class="nf">GROUP_CONCAT</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">;</span> <span class="nf">separator</span><span class="o">=</span><span class="s">', '</span><span class="p">)</span> <span class="k">AS</span> <span class="nv">?namedAfter</span><span class="p">)</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P138</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q28837448</span><span class="p">;</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P138</span> <span class="nv">?namedAfterItem</span> <span class="p">.</span> <span class="k">OPTIONAL</span> <span class="p">{</span> <span class="nv">?namedAfterItem</span> <span class="nn">rdfs</span><span class="p">:</span><span class="nt">label</span> <span class="nv">?namedAfterItemLabel</span> <span class="p">.</span> <span class="k">FILTER</span><span class="p">(</span><span class="nf">LANG</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">)</span> <span class="o">=</span> <span class="s">'en'</span><span class="p">)</span> <span class="p">.</span> <span class="p">}</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">'en'</span> <span class="p">}</span> <span class="p">}</span> <span class="k">GROUP BY</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20have%20a%20named%20after%20%28P138%29%20naming%20region%20%28Q28837448%29%0ASELECT%20%3Fitem%20%3FitemLabel%20%28GROUP_CONCAT%28%3FnamedAfterItemLabel%3B%20separator%3D%27%2C%20%27%29%20AS%20%3FnamedAfter%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP138%20wd%3AQ28837448%3B%20wdt%3AP138%20%3FnamedAfterItem%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FnamedAfterItem%20rdfs%3Alabel%20%3FnamedAfterItemLabel%20.%0A%20%20%20%20FILTER%28LANG%28%3FnamedAfterItemLabel%29%20%3D%20%27en%27%29%20.%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%3Fitem%20%3FitemLabel"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># List all items that have a named after (P138) chemical composition (Q1263816)</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="p">(</span><span class="nf">GROUP_CONCAT</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">;</span> <span class="nf">separator</span><span class="o">=</span><span class="s">', '</span><span class="p">)</span> <span class="k">AS</span> <span class="nv">?namedAfter</span><span class="p">)</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P138</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q1263816</span><span class="p">;</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P138</span> <span class="nv">?namedAfterItem</span> <span class="p">.</span> <span class="k">OPTIONAL</span> <span class="p">{</span> <span class="nv">?namedAfterItem</span> <span class="nn">rdfs</span><span class="p">:</span><span class="nt">label</span> <span class="nv">?namedAfterItemLabel</span> <span class="p">.</span> <span class="k">FILTER</span><span class="p">(</span><span class="nf">LANG</span><span class="p">(</span><span class="nv">?namedAfterItemLabel</span><span class="p">)</span> <span class="o">=</span> <span class="s">'en'</span><span class="p">)</span> <span class="p">.</span> <span class="p">}</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">'en'</span> <span class="p">}</span> <span class="p">}</span> <span class="k">GROUP BY</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20have%20a%20named%20after%20%28P138%29%20chemical%20composition%20%28Q1263816%29%0ASELECT%20%3Fitem%20%3FitemLabel%20%28GROUP_CONCAT%28%3FnamedAfterItemLabel%3B%20separator%3D%27%2C%20%27%29%20AS%20%3FnamedAfter%29%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP138%20wd%3AQ1263816%3B%20wdt%3AP138%20%3FnamedAfterItem%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3FnamedAfterItem%20rdfs%3Alabel%20%3FnamedAfterItemLabel%20.%0A%20%20%20%20FILTER%28LANG%28%3FnamedAfterItemLabel%29%20%3D%20%27en%27%29%20.%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%3Fitem%20%3FitemLabel"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># List all subject of: mineralogy AND species nova</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P921</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q83353</span> <span class="p">.</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P921</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q27652812</span> <span class="p">.</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20subject%20of%3A%20mineralogy%20AND%20species%20nova%0ASELECT%20%3Fitem%20%20WHERE%20%7B%0A%20%20%20%3Fitem%20wdt%3AP921%20wd%3AQ83353%20.%0A%20%20%20%3Fitem%20wdt%3AP921%20wd%3AQ27652812%20.%0A%7D"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># List all items without IMA Mineral Symbol</span> <span class="k">SELECT</span> <span class="k">DISTINCT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"[AUTO_LANGUAGE]"</span><span class="p">.</span> <span class="p">}</span> <span class="p">{</span> <span class="k">SELECT</span> <span class="k">DISTINCT</span> <span class="nv">?item</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">p</span><span class="p">:</span><span class="nt">P31</span> <span class="nv">?statement0</span><span class="p">.</span> <span class="nv">?statement0</span> <span class="p">(</span><span class="nn">ps</span><span class="p">:</span><span class="nt">P31</span><span class="o">/</span><span class="p">(</span><span class="nn">wdt</span><span class="p">:</span><span class="nt">P279</span><span class="o">*</span><span class="p">))</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q12089225</span><span class="p">.</span> <span class="k">MINUS</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">p</span><span class="p">:</span><span class="nt">P10113</span> <span class="nv">?statement1</span><span class="p">.</span> <span class="nv">?statement1</span> <span class="p">(</span><span class="nn">ps</span><span class="p">:</span><span class="nt">P10113</span><span class="p">)</span> <span class="nl">_:anyValueP10113</span><span class="p">.</span> <span class="p">}</span> <span class="p">}</span> <span class="p">}</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20without%20IMA%20Mineral%20Symbol%0ASELECT%20DISTINCT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%22.%20%7D%0A%20%20%7B%0A%20%20%20%20SELECT%20DISTINCT%20%3Fitem%20WHERE%20%7B%0A%20%20%20%20%20%20%3Fitem%20p%3AP31%20%3Fstatement0.%0A%20%20%20%20%20%20%3Fstatement0%20%28ps%3AP31%2F%28wdt%3AP279%2A%29%29%20wd%3AQ12089225.%0A%20%20%20%20%20%20MINUS%20%7B%0A%20%20%20%20%20%20%20%20%3Fitem%20p%3AP10113%20%3Fstatement1.%0A%20%20%20%20%20%20%20%20%3Fstatement1%20%28ps%3AP10113%29%20_%3AanyValueP10113.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%7D%0A%7D"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c">#List all valid minerals</span> <span class="k">SELECT</span> <span class="nv">?min</span> <span class="nv">?minLabel</span> <span class="nv">?imaLabel</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span><span class="p">.</span> <span class="p">}</span> <span class="k">VALUES</span> <span class="nv">?ima</span> <span class="p">{</span><span class="nn">wd</span><span class="p">:</span><span class="nt">Q13406835</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q13406846</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q13406860</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q13406872</span><span class="p">}</span> <span class="c"># A, G, Rn, Rd</span> <span class="nv">?min</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P31</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q12089225</span><span class="p">.</span> <span class="nv">?min</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P579</span> <span class="nv">?ima</span><span class="p">.</span> <span class="c"># OPTIONAL { ?cawiki schema:about ?min; schema:inLanguage "ca"; schema:isPartOf <https://ca.wikipedia.org/> }</span> <span class="c"># FILTER (!BOUND(?cawiki))</span> <span class="p">}</span> <span class="k">ORDER BY</span> <span class="nv">?minLabel</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23List%20all%20valid%20minerals%0ASELECT%20%3Fmin%20%3FminLabel%20%3FimaLabel%20WHERE%20%7B%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%20%20VALUES%20%3Fima%20%7Bwd%3AQ13406835%20wd%3AQ13406846%20wd%3AQ13406860%20wd%3AQ13406872%7D%20%23%20A%2C%20G%2C%20Rn%2C%20Rd%0A%20%20%3Fmin%20wdt%3AP31%20wd%3AQ12089225.%0A%20%20%3Fmin%20wdt%3AP579%20%3Fima.%0A%20%20%23%20OPTIONAL%20%7B%20%3Fcawiki%20schema%3Aabout%20%3Fmin%3B%20schema%3AinLanguage%20%22ca%22%3B%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fca.wikipedia.org%2F%3E%20%7D%0A%20%20%23%20FILTER%20%28%21BOUND%28%3Fcawiki%29%29%0A%7D%20ORDER%20BY%20%3FminLabel"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># List all subject of: mineralogy AND type description</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P921</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q83353</span> <span class="p">.</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P921</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q56241591</span> <span class="p">.</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20subject%20of%3A%20mineralogy%20AND%20type%20description%0ASELECT%20%3Fitem%20%20WHERE%20%7B%0A%20%20%20%3Fitem%20wdt%3AP921%20wd%3AQ83353%20.%0A%20%20%20%3Fitem%20wdt%3AP921%20wd%3AQ56241591%20.%0A%7D"><span dir="ltr" lang="en">Try it!</span></a> </div> <dl><dd><ul><li>Instance of 'mineral': <a href="/wiki/Special:Search/haswbstatement:P31%3DQ7946" title="Special:Search/haswbstatement:P31=Q7946">Special:Search/haswbstatement:P31=Q7946</a></li> <li>Instance of 'mineral species': <a href="/wiki/Special:Search/haswbstatement:P31%3DQ55076514" title="Special:Search/haswbstatement:P31=Q55076514">Special:Search/haswbstatement:P31=Q55076514</a></li></ul></dd></dl> <p><br/> </p> <dl><dt>German description</dt></dl> <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><span></span><span class="c"># List all items that are a subclass of mineral and are missing a label in German</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P279</span><span class="o">*</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q7946</span> <span class="p">.</span> <span class="k">filter</span> <span class="nf">not exists</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">rdfs</span><span class="p">:</span><span class="nt">label</span> <span class="nv">?missinglabel</span> <span class="k">filter</span> <span class="p">(</span><span class="nf">lang</span><span class="p">(</span><span class="nv">?missinglabel</span><span class="p">)</span> <span class="o">=</span> <span class="s">"de"</span><span class="p">)</span> <span class="p">}</span> <span class="p">.</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span> <span class="p">.</span> <span class="p">}</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20are%20a%20subclass%20of%20mineral%20and%20are%20missing%20a%20label%20in%20German%0ASELECT%20%3Fitem%20%3FitemLabel%20WHERE%20%7B%0A%09%3Fitem%20wdt%3AP279%2A%20wd%3AQ7946%20.%0A%09filter%20not%20exists%20%7B%20%3Fitem%20rdfs%3Alabel%20%3Fmissinglabel%20filter%20%28lang%28%3Fmissinglabel%29%20%3D%20%22de%22%29%20%7D%20.%0A%20%20%09SERVICE%20wikibase%3Alabel%20%7B%0A%09%09bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%09%7D%0A%7D"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># List all items with mineral in the German label</span> <span class="k">SELECT</span> <span class="nv">?item</span> <span class="nv">?itemDescription</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P279</span><span class="o">*</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q7946</span><span class="p">;</span> <span class="nn">schema</span><span class="p">:</span><span class="nt">description</span> <span class="nv">?itemDescription</span><span class="p">.</span> <span class="k">FILTER</span><span class="p">(</span><span class="nf">CONTAINS</span><span class="p">(</span><span class="nv">?itemDescription</span><span class="p">,</span> <span class="s">" Mineral"</span><span class="p">))</span> <span class="k">FILTER</span><span class="p">(</span><span class="nf">LANG</span><span class="p">(</span><span class="nv">?itemDescription</span><span class="p">)</span><span class="o">=</span><span class="s">"de"</span><span class="p">)</span> <span class="p">}</span> <span class="k">LIMIT</span> <span class="mi">5000</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20with%20mineral%20in%20the%20German%20label%0ASELECT%20%3Fitem%20%3FitemDescription%20WHERE%20%7B%0A%20%20%3Fitem%20wdt%3AP279%2A%20wd%3AQ7946%3B%0A%20%20%20%20%20%20%20%20schema%3Adescription%20%3FitemDescription.%0A%20%20FILTER%28CONTAINS%28%3FitemDescription%2C%20%22%20Mineral%22%29%29%0A%20%20FILTER%28LANG%28%3FitemDescription%29%3D%22de%22%29%0A%7D%0ALIMIT%205000"><span dir="ltr" lang="en">Try it!</span></a> </div> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Type_localities" data-mw-thread-id="h-Type_localities"><span data-mw-comment-start="" id="h-Type_localities"></span>Type localities<span data-mw-comment-end="h-Type_localities"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikidata:WikiProject_Mineralogy/Queries&action=edit&section=2" title="Edit section: Type localities"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span><!--__DTELLIPSISBUTTON__{"threadItem":{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Type_localities","replies":[]}}--></div> <dl><dd><small>Notes (<a href="/wiki/Q15708377" title="Q15708377">list of show mines</a>): most type localities are historical, past status. Meteorites were collected; <a href="/wiki/Q26453772" title="Q26453772">Ivigtut cryolite deposit</a> is empty (even the jetty and the dumps were sorted a second time); Mount Vesuvius is quiet, but volcanoes are waking up worldwide (2019-2029); Karnasurt underground mine (the <a href="/wiki/Q23828935" title="Q23828935">Palitra pegmatite</a> (7 by 1.5 m) was possibly removed); <a href="/wiki/Q29052222" title="Q29052222">Michael Mine, Weiler</a>/ Southern part (adit is inaccessible and the dump has been landscaped), Silbereckle mine/ Northern part (adit is visible); <a href="/wiki/Q26617618" title="Q26617618">New Cliffe Hill granite quarry</a> (the 'copper lode' and associated secondary mineralisation was removed in the late 1990's); the <a href="/wiki/Q26878777" title="Q26878777">Crestmore quarries</a> were used by the Riverside Portland Cement Company; <a href="/wiki/Q23828064" title="Q23828064">Jacupiranga open pit</a> mines apatite for agricultural use, it delivers calcareous rock for the cement production as well (it uses flotation as an enrichment step); <a href="/wiki/Q29912983" title="Q29912983">Kintore opencut</a>, Broken Hill South mine swallowed the old Kintore shaft, the Block 10 mine, almost the Central mine (Block 9) and a portion of the [Broken] Proprietary mine workings (Blocks 9-11); <a href="/wiki/Q29913057" title="Q29913057">Block 14 opencut</a>, Broken Hill swallowed much of the British mine (Blocks 15 & 16), and the Proprietary mine; <a href="/wiki/Q15107508" title="Q15107508">Falun copper mine</a>, <a href="/wiki/Q18752017" title="Q18752017">Cap Garonne</a> and <a href="/wiki/Q24449579" title="Q24449579">Gonzen</a> are museum mines; <a href="/wiki/Q23723997" title="Q23723997">Tsumeb</a> is only extracting specimens for mineral collectors; etc. On the other side, new mineral species can be found in San Juan Co., UT; wayneburnhamite was found in the Crestmore quarries and hitachiite was found in the <a href="/wiki/Q11510089" title="Q11510089">Hitachi mine</a>. Economical viable ore and the source of new minerals (contact zones) are actually on different locations. The workload gets smaller by using a low resolution (sometimes up to county level; instead of up to mine level), the use of the MinDat database as reference was avoided since the 1st half of 2017. Caution: <a href="/wiki/Q30316566" title="Q30316566">Glocker E F (1847)</a> redefined the names rocksalt and halite (ancient Greek for rocksalt/ "Steinsalz"); <a href="/wiki/Q30316656" title="Q30316656">Vauquelin L N (1798)</a> redefined emerald and beryl; <a href="/wiki/Q30316521" title="Q30316521">Scheele C W (1779)</a> redefined galena (Bleiglanz), molybdenite and graphite; Albertus Magnus redefined spinel, spinel; almandine, granat; rubi, corundum, etc.; these papers are not a full description of a type specimen from a type locality.</small></dd></dl> <p><br/> </p> <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><span></span><span class="c"># List all items that have a type locality</span> <span class="k">select</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="nv">?imaLabel</span> <span class="nv">?locLabel</span> <span class="k">where</span> <span class="p">{</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P579</span> <span class="nv">?ima</span> <span class="p">.</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P2695</span> <span class="nv">?loc</span> <span class="p">.</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span> <span class="p">}</span> <span class="p">}</span> <span class="k">ORDER BY</span> <span class="nv">?item</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20List%20all%20items%20that%20have%20a%20type%20locality%0Aselect%20%3Fitem%20%3FitemLabel%20%3FimaLabel%20%3FlocLabel%20where%0A%7B%0A%20%20%3Fitem%20wdt%3AP579%20%3Fima%20.%0A%20%20%3Fitem%20wdt%3AP2695%20%3Floc%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20%7D%0A%7D%20ORDER%20BY%20%3Fitem"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># Find all mineral type localities and sort them by most minerals defined</span> <span class="k">SELECT</span> <span class="nv">?locality</span> <span class="nv">?name</span> <span class="p">(</span><span class="nf">COUNT</span><span class="p">(</span><span class="k">DISTINCT</span> <span class="nv">?mineral</span><span class="p">)</span> <span class="k">AS</span> <span class="nv">?count</span><span class="p">)</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?mineral</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P579</span> <span class="nv">?status</span> <span class="p">.</span> <span class="nv">?mineral</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P2695</span> <span class="nv">?locality</span> <span class="p">.</span> <span class="c"># Where a locality statement exists</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span> <span class="p">.</span> <span class="nv">?locality</span> <span class="nn">rdfs</span><span class="p">:</span><span class="nt">label</span> <span class="nv">?name</span> <span class="p">}</span> <span class="p">}</span> <span class="k">GROUP BY</span> <span class="nv">?locality</span> <span class="nv">?name</span> <span class="k">ORDER BY</span> <span class="k">DESC</span><span class="p">(</span><span class="nv">?count</span><span class="p">)</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20Find%20all%20mineral%20type%20localities%20and%20sort%20them%20by%20most%20minerals%20defined%0ASELECT%20%3Flocality%20%3Fname%20%28COUNT%28DISTINCT%20%3Fmineral%29%20AS%20%3Fcount%29%0AWHERE%0A%7B%0A%20%20%20%20%3Fmineral%20wdt%3AP579%20%3Fstatus%20.%0A%20%20%20%20%3Fmineral%20wdt%3AP2695%20%3Flocality%20.%20%20%20%20%20%20%20%20%20%20%23%20Where%20a%20locality%20statement%20exists%0A%20%20%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%20%20%20%20%20%20%20%20%3Flocality%20rdfs%3Alabel%20%3Fname%0A%20%20%20%20%7D%0A%7D%0AGROUP%20BY%20%3Flocality%20%3Fname%0AORDER%20BY%20DESC%28%3Fcount%29"><span dir="ltr" lang="en">Try it!</span></a> </div> <p><br/> </p> <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><span></span><span class="c"># Find all mineral type localities and which you can render as a map</span> <span class="k">SELECT</span> <span class="nv">?locality</span> <span class="nv">?name</span> <span class="nv">?location</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?mineral</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P579</span> <span class="nv">?status</span> <span class="p">.</span> <span class="nv">?mineral</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P2695</span> <span class="nv">?locality</span> <span class="p">.</span> <span class="c"># Where a locality statement exists</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span> <span class="p">.</span> <span class="nv">?locality</span> <span class="nn">rdfs</span><span class="p">:</span><span class="nt">label</span> <span class="nv">?name</span> <span class="p">}</span> <span class="nv">?locality</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P625</span> <span class="nv">?location</span> <span class="p">}</span> <span class="k">GROUP BY</span> <span class="nv">?locality</span> <span class="nv">?name</span> <span class="nv">?location</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20Find%20all%20mineral%20type%20localities%20and%20which%20you%20can%20render%20as%20a%20map%0ASELECT%20%3Flocality%20%3Fname%20%3Flocation%0AWHERE%0A%7B%0A%20%20%20%20%3Fmineral%20wdt%3AP579%20%3Fstatus%20.%0A%20%20%20%20%3Fmineral%20wdt%3AP2695%20%3Flocality%20.%20%20%20%20%20%20%20%20%20%20%23%20Where%20a%20locality%20statement%20exists%0A%20%20%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%20%20%20%20%20%20%20%20%3Flocality%20rdfs%3Alabel%20%3Fname%0A%20%20%20%20%7D%0A%20%20%20%20%20%3Flocality%20wdt%3AP625%20%3Flocation%20%0A%7D%0AGROUP%20BY%20%3Flocality%20%3Fname%20%3Flocation"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># Find all mineral type localities that are meteorites and sort them by defined minerals</span> <span class="k">SELECT</span> <span class="nv">?locality</span> <span class="nv">?name</span> <span class="p">(</span><span class="nf">COUNT</span><span class="p">(</span><span class="k">DISTINCT</span> <span class="nv">?mineral</span><span class="p">)</span> <span class="k">AS</span> <span class="nv">?count</span><span class="p">)</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?mineral</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P579</span> <span class="nv">?status</span> <span class="p">.</span> <span class="nv">?mineral</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P2695</span> <span class="nv">?locality</span> <span class="p">.</span> <span class="c"># Where a locality statement exists</span> <span class="nv">?locality</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P31</span> <span class="nv">?thing</span> <span class="p">.</span> <span class="c"># Where the locality is the instance of a thing (helper)</span> <span class="nv">?thing</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">279</span><span class="o">*</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q60186</span> <span class="p">.</span> <span class="c"># And the thing is in the subclass tree of meteorite (Should also work if p31 = iron meteorite for example)</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span> <span class="p">.</span> <span class="nv">?locality</span> <span class="nn">rdfs</span><span class="p">:</span><span class="nt">label</span> <span class="nv">?name</span> <span class="p">}</span> <span class="p">}</span> <span class="k">GROUP BY</span> <span class="nv">?locality</span> <span class="nv">?name</span> <span class="k">ORDER BY</span> <span class="k">DESC</span><span class="p">(</span><span class="nv">?count</span><span class="p">)</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20Find%20all%20mineral%20type%20localities%20that%20are%20meteorites%20and%20sort%20them%20by%20defined%20minerals%0ASELECT%20%3Flocality%20%3Fname%20%28COUNT%28DISTINCT%20%3Fmineral%29%20AS%20%3Fcount%29%0AWHERE%0A%7B%0A%20%20%20%20%3Fmineral%20wdt%3AP579%20%3Fstatus%20.%0A%20%20%20%20%3Fmineral%20wdt%3AP2695%20%3Flocality%20.%20%20%20%20%23%20Where%20a%20locality%20statement%20exists%0A%20%20%20%20%3Flocality%20wdt%3AP31%20%3Fthing%20.%20%20%20%20%20%20%20%20%23%20Where%20the%20locality%20is%20the%20instance%20of%20a%20thing%20%28helper%29%0A%20%20%20%20%3Fthing%20wdt%3A279%2A%20wd%3AQ60186%20.%20%20%20%20%20%20%20%23%20And%20the%20thing%20is%20in%20the%20subclass%20tree%20of%20meteorite%20%28Should%20also%20work%20if%20p31%20%3D%20iron%20meteorite%20for%20example%29%0A%20%20%0A%20%20%20%20SERVICE%20wikibase%3Alabel%20%7B%0A%20%20%20%20%20%20%20%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22%20.%0A%20%20%20%20%20%20%20%20%3Flocality%20rdfs%3Alabel%20%3Fname%0A%20%20%20%20%7D%0A%7D%0AGROUP%20BY%20%3Flocality%20%3Fname%0AORDER%20BY%20DESC%28%3Fcount%29"><span dir="ltr" lang="en">Try it!</span></a> </div> <div class="mw-heading mw-heading2 ext-discussiontools-init-section"><h2 id="Showcase" data-mw-thread-id="h-Showcase"><span data-mw-comment-start="" id="h-Showcase"></span>Showcase<span data-mw-comment-end="h-Showcase"></span></h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Wikidata:WikiProject_Mineralogy/Queries&action=edit&section=3" title="Edit section: Showcase"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span><!--__DTELLIPSISBUTTON__{"threadItem":{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Showcase","replies":[]}}--></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><span></span><span class="c">#Minerals and their commons colors</span> <span class="c">#defaultView:Graph</span> <span class="k">SELECT</span> <span class="k">DISTINCT</span> <span class="nv">?mineral</span> <span class="nv">?mineralLabel</span> <span class="nv">?rgb</span> <span class="nv">?color</span> <span class="nv">?colorLabel</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="nv">?mineral</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P279</span><span class="o">*</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q7946</span> <span class="p">;</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P462</span> <span class="nv">?color</span> <span class="p">.</span> <span class="nv">?color</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P465</span> <span class="nv">?rgb</span> <span class="p">.</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span> <span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"en"</span><span class="p">.</span> <span class="p">}</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23Minerals%20and%20their%20commons%20colors%0A%23defaultView%3AGraph%0ASELECT%20DISTINCT%20%3Fmineral%20%3FmineralLabel%20%3Frgb%20%3Fcolor%20%3FcolorLabel%0AWHERE%0A%7B%0A%20%20%3Fmineral%20wdt%3AP279%2A%20wd%3AQ7946%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20wdt%3AP462%20%3Fcolor%20.%0A%20%20%3Fcolor%20wdt%3AP465%20%3Frgb%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%7D"><span dir="ltr" lang="en">Try it!</span></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><span></span><span class="c"># examle with selected minerals </span> <span class="k">SELECT</span> <span class="nv">?sg</span> <span class="nv">?sgLabel</span> <span class="nv">?sgImage</span> <span class="nv">?group</span> <span class="nv">?groupLabel</span> <span class="nv">?groupDescription</span> <span class="nv">?item</span> <span class="nv">?itemLabel</span> <span class="nv">?itemDescription</span> <span class="nv">?itemImage</span> <span class="k">WHERE</span> <span class="p">{</span> <span class="k">VALUES</span> <span class="nv">?item</span> <span class="p">{</span><span class="nn">wd</span><span class="p">:</span><span class="nt">Q108147097</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q1117109</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q114584875</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q13292920</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q13322207</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q1614643</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q1656448</span> <span class="nn">wd</span><span class="p">:</span><span class="nt">Q19810681</span><span class="p">}</span> <span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P279</span> <span class="nv">?group</span><span class="p">.</span> <span class="nv">?group</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P279</span> <span class="nv">?sg</span><span class="p">.</span> <span class="k">OPTIONAL</span> <span class="p">{</span><span class="nv">?item</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P18</span> <span class="nv">?itemImage</span><span class="p">.}</span> <span class="k">OPTIONAL</span> <span class="p">{</span><span class="nv">?group</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P18</span> <span class="nv">?groupImage</span><span class="p">.}</span> <span class="k">OPTIONAL</span> <span class="p">{</span><span class="nv">?sg</span> <span class="nn">wdt</span><span class="p">:</span><span class="nt">P18</span> <span class="nv">?sgImage</span><span class="p">.}</span> <span class="k">SERVICE</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">label</span><span class="p">{</span> <span class="nn">bd</span><span class="p">:</span><span class="nt">serviceParam</span> <span class="nn">wikibase</span><span class="p">:</span><span class="nt">language</span> <span class="s">"sr"</span><span class="p">.</span> <span class="p">}</span> <span class="p">}</span> </pre></div></div><a class="external text" href="https://query.wikidata.org/#%23%20examle%20with%20selected%20minerals%20%0ASELECT%20%20%3Fsg%20%3FsgLabel%20%3FsgImage%20%20%20%20%3Fgroup%20%3FgroupLabel%20%20%3FgroupDescription%20%3Fitem%20%3FitemLabel%20%3FitemDescription%20%3FitemImage%0AWHERE%20%20%7B%0A%20%20VALUES%20%3Fitem%20%7Bwd%3AQ108147097%20wd%3AQ1117109%20wd%3AQ114584875%20wd%3AQ13292920%20wd%3AQ13322207%20wd%3AQ1614643%20wd%3AQ1656448%20wd%3AQ19810681%7D%20%20%20%0A%20%20%3Fitem%20%20%20%20wdt%3AP279%20%20%20%3Fgroup.%0A%20%20%3Fgroup%20%20%20wdt%3AP279%20%3Fsg.%0A%20%20OPTIONAL%20%7B%3Fitem%20wdt%3AP18%20%3FitemImage.%7D%0A%20%20OPTIONAL%20%7B%3Fgroup%20wdt%3AP18%20%3FgroupImage.%7D%0A%20%20OPTIONAL%20%7B%3Fsg%20wdt%3AP18%20%3FsgImage.%7D%0A%20%20SERVICE%20wikibase%3Alabel%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22sr%22.%20%7D%0A%7D"><span dir="ltr" lang="en">Try it!</span></a> </div> <!-- NewPP limit report Parsed by mw‐web.eqiad.main‐587f7d4878‐zfnfz Cached time: 20241120133551 Cache expiry: 2592000 Reduced expiry: false Complications: [] DiscussionTools time usage: 0.034 seconds CPU time usage: 0.238 seconds Real time usage: 2.199 seconds Preprocessor visited node count: 4542/1000000 Post‐expand include size: 60982/2097152 bytes Template argument size: 21882/2097152 bytes Highest expansion depth: 7/100 Expensive parser function count: 21/500 Unstrip recursion depth: 0/20 Unstrip post‐expand size: 41376/5000000 bytes Lua time usage: 0.046/10.000 seconds Lua memory usage: 1447368/52428800 bytes Number of Wikibase entities loaded: 0/500 --> <!-- Transclusion expansion time report (%,ms,calls,template) 100.00% 2113.418 1 -total 58.41% 1234.462 13 Template:SPARQL 41.53% 877.626 8 Template:Sparql 2.26% 47.691 42 Template:SPARQLText 2.16% 45.557 21 Template:Int_try_it 1.71% 36.045 21 Template:TranslateThis --> <!-- Saved in parser cache with key wikidatawiki:pcache:idhash:25902661-0!canonical and timestamp 20241120133551 and revision id 1789684922. Rendering was triggered because: page-view --> </div><!--esi <esi:include src="/esitest-fa8a495983347898/content" /> --><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=Wikidata:WikiProject_Mineralogy/Queries&oldid=1789684922">https://www.wikidata.org/w/index.php?title=Wikidata:WikiProject_Mineralogy/Queries&oldid=1789684922</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 " > <span class="vector-menu-heading-label">Personal tools</span> </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="#"><span>English</span></a></li><li id="pt-anonuserpage" class="mw-list-item"><span title="The user page for the IP address you are editing as">Not logged in</span></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"><span>Talk</span></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"><span>Contributions</span></a></li><li id="pt-createaccount" class="mw-list-item"><a href="/w/index.php?title=Special:CreateAccount&returnto=Wikidata%3AWikiProject+Mineralogy%2FQueries" title="You are encouraged to create an account and log in; however, it is not mandatory"><span>Create account</span></a></li><li id="pt-login" class="mw-list-item"><a href="/w/index.php?title=Special:UserLogin&returnto=Wikidata%3AWikiProject+Mineralogy%2FQueries" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o"><span>Log in</span></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 " > <span class="vector-menu-heading-label">Namespaces</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-project" class="selected mw-list-item"><a href="/wiki/Wikidata:WikiProject_Mineralogy/Queries" title="View the project page [c]" accesskey="c"><span>Project page</span></a></li><li id="ca-talk" class="mw-list-item"><a href="/wiki/Wikidata_talk:WikiProject_Mineralogy/Queries" rel="discussion" class="mw-redirect" title="Discussion about the content page [t]" accesskey="t"><span>Discussion</span></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 " > <span class="vector-menu-heading-label">English</span> </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 " > <span class="vector-menu-heading-label">Views</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected mw-list-item"><a href="/wiki/Wikidata:WikiProject_Mineralogy/Queries"><span>Read</span></a></li><li id="ca-edit" class="mw-list-item"><a href="/w/index.php?title=Wikidata:WikiProject_Mineralogy/Queries&action=edit" title="Edit this page [e]" accesskey="e"><span>Edit</span></a></li><li id="ca-history" class="mw-list-item"><a href="/w/index.php?title=Wikidata:WikiProject_Mineralogy/Queries&action=history" title="Past revisions of this page [h]" accesskey="h"><span>View history</span></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 " > <span class="vector-menu-heading-label">More</span> </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 " > <span class="vector-menu-heading-label">Navigation</span> </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"><span>Main page</span></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"><span>Community portal</span></a></li><li id="n-villagepump" class="mw-list-item"><a href="/wiki/Wikidata:Project_chat"><span>Project chat</span></a></li><li id="n-special-newitem" class="mw-list-item"><a href="/wiki/Special:NewItem"><span>Create a new Item</span></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"><span>Recent changes</span></a></li><li id="n-wikibase-randomitem" class="mw-list-item"><a href="/wiki/Special:Random/Main" title="[x]" accesskey="x"><span>Random Item</span></a></li><li id="n-wikibase-queryservice" class="mw-list-item"><a href="//query.wikidata.org/"><span>Query Service</span></a></li><li id="n-nearby-pages-title" class="mw-list-item"><a href="/wiki/Special:Nearby"><span>Nearby</span></a></li><li id="n-help" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Help:Contents" title="The place to find out"><span>Help</span></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"><span>Donate</span></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 " > <span class="vector-menu-heading-label">Lexicographical data</span> </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"><span>Create a new Lexeme</span></a></li><li id="n-recentchanges-lexemes" class="mw-list-item"><a href="https://www.wikidata.org/wiki/Special:RecentChanges?namespace=146%3B147"><span>Recent changes</span></a></li><li id="n-wikibase-lexeme-randomlexeme" class="mw-list-item"><a href="/wiki/Special:Random/Lexeme"><span>Random Lexeme</span></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 " > <span class="vector-menu-heading-label">Tools</span> </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/Wikidata:WikiProject_Mineralogy/Queries" title="A list of all wiki pages that link here [j]" accesskey="j"><span>What links here</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Special:RecentChangesLinked/Wikidata:WikiProject_Mineralogy/Queries" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></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"><span>Special pages</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Wikidata:WikiProject_Mineralogy/Queries&oldid=1789684922" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Wikidata:WikiProject_Mineralogy/Queries&action=info" title="More information about this page"><span>Page information</span></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%2FWikidata%3AWikiProject_Mineralogy%2FQueries"><span>Get shortened URL</span></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%2FWikidata%3AWikiProject_Mineralogy%2FQueries"><span>Download QR code</span></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 " > <span class="vector-menu-heading-label">Print/export</span> </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=Wikidata%3AWikiProject+Mineralogy%2FQueries"><span>Create a book</span></a></li><li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Special:DownloadAsPdf&page=Wikidata%3AWikiProject_Mineralogy%2FQueries&action=show-download-screen"><span>Download as PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=Wikidata:WikiProject_Mineralogy/Queries&printable=yes" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></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 " > <span class="vector-menu-heading-label">In other projects</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </nav> <nav id="p-lang" class="mw-portlet mw-portlet-lang vector-menu-portal portal vector-menu" aria-labelledby="p-lang-label" > <h3 id="p-lang-label" class="vector-menu-heading " > <span class="vector-menu-heading-label">In Wikipedia</span> </h3> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-add wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:NewItem?site=wikidatawiki&page=Wikidata%3AWikiProject+Mineralogy%2FQueries" title="Add interlanguage links" class="wbc-editpage">Add links</a></span></div> </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 14 December 2022, at 09:31.</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=Wikidata:WikiProject_Mineralogy/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-4fxvw","wgBackendResponseTime":114,"wgDiscussionToolsPageThreads":[{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Maintenance","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Type_localities","replies":[]},{"headingLevel":2,"name":"h-","type":"heading","level":0,"id":"h-Showcase","replies":[]}],"wgPageParseReport":{"discussiontools":{"limitreport-timeusage":"0.034"},"limitreport":{"cputime":"0.238","walltime":"2.199","ppvisitednodes":{"value":4542,"limit":1000000},"postexpandincludesize":{"value":60982,"limit":2097152},"templateargumentsize":{"value":21882,"limit":2097152},"expansiondepth":{"value":7,"limit":100},"expensivefunctioncount":{"value":21,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":41376,"limit":5000000},"entityaccesscount":{"value":0,"limit":500},"timingprofile":["100.00% 2113.418 1 -total"," 58.41% 1234.462 13 Template:SPARQL"," 41.53% 877.626 8 Template:Sparql"," 2.26% 47.691 42 Template:SPARQLText"," 2.16% 45.557 21 Template:Int_try_it"," 1.71% 36.045 21 Template:TranslateThis"]},"scribunto":{"limitreport-timeusage":{"value":"0.046","limit":"10.000"},"limitreport-memusage":{"value":1447368,"limit":52428800}},"cachereport":{"origin":"mw-web.eqiad.main-587f7d4878-zfnfz","timestamp":"20241120133551","ttl":2592000,"transientcontent":false}}});});</script> </body> </html>