User:Daniel/Queries: Difference between revisions

Latest revision as of 09:29, 30 May 2024

About

This page assists with the creation, curation and maintenance of queries related to mathematical content here on the MaRDI portal or in other knowledge bases, especially in Wikidata.

Demo queries

These are queries that highlight some particular aspect of the data or the associated technical contexts.

Map of institutions involved in NFDI consortia

Formulas involving mass

https://w.wiki/6CmU

Meaning of a given symbol in various formulas

Items matching a certain identifier

DLMF ID

https://w.wiki/7Qmt

Formulas containing certain LaTeX strings

https://w.wiki/7Qmx

Mathematicians who have had non-mathematical things named after them

e.g. lunar craters OR asteroids OR species
- variant with OR mathematical functions
- variant with AND for all of the above

Housekeeping queries

List of MaRDI Wikibase properties

sorted alphabetically based on English label

sorted by PID

Author identifiers

mathematicians with both a zbMATH author ID and an ORCID known to Wikidata

Editing queries

These queries generate commands that can be used to make additional edits in the same Wikibase or another.

Maintenance queries

These queries help maintain or improve data quality, e.g. by checking for consistency or gaps.

zbMATH-related queries

On Wikidata

Author name strings common on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)
The results here are dominated by astronomy, which rarely uses full names, so author disambiguation is harder. Let's filter this a bit for strings that are easier to disambiguate.
- Author name strings containing a dash that are common on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)
- Common author name strings (without single-letter initials) on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)
  This looks like a good dataset to work with, paving the way for disambiguating strings with initials later with more confidence.
- Common author name strings on documents that have a zbMATH document ID
Find zbMATH author IDs to be added to Wikidata author items: Wikidata items of authors for which Wikidata does not know the zbMATH author ID but the zbMATH author ID of at least two co-authors on a paper with zbMATH document ID, from which the missing zbMATH author ID may be inferred.
- variant without zbMATH document ID
- variant for one co-author
Find zbMATH document IDs to be added to Wikidata paper items: Wikidata items of documents for which Wikidata does not know the zbMATH document ID but the zbMATH author ID of at least one author, from which the missing zbMATH document ID may be inferred.
- variant
- more refined variant
People with both a zbMATH author ID and a Wikimedia user name

@@ Line 4: / Line 4: @@
-== Content queries ==
+== Demo queries ==
+''These are queries that highlight some particular aspect of the data or the associated technical contexts.''
+=== Map of institutions involved in NFDI consortia ===
+* [https://query.wikidata.org/#%23defaultView%3AMap%0A%0APREFIX%20target%3A%20%3Chttp%3A%2F%2Fwww.wikidata.org%2Fentity%2FQ99534506%3E%0A%0ASELECT%20%3Fpartner%20%3FpartnerLabel%20%3Flocation%20%3Fproject%20%3FprojectLabel%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fpartner%20%3Flocation%20%3Fproject%20WHERE%20%7B%0A%20%20%20%20%3Fproject%20wdt%3AP31%20wd%3AQ98270496%20.%0A%20%20%20%20%3Fproject%20%28%5Ewdt%3AP1344%20%7C%20wdt%3AP710%29%2a%20%2F%20%28wdt%3AP527%20%7C%20wdt%3AP710%20%7C%20wdt%3AP1416%29%20%3Fpartner%20.%0A%20%20%20%20%3Fpartner%20wdt%3AP159%2a%20%2F%20wdt%3AP625%20%3Flocation%20.%0A%20%20%7D%0A%7D%20AS%20%25result%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D overall]
+* [https://w.wiki/6Hd9 (Cord Wiljes)]
+** [https://query.wikidata.org/#%23defaultView%3AGraph%0ASELECT%20DISTINCT%20%20%3Fwsingular%20%3FwsingularLabel%20%3Fp%20%3FpLabel%20%28%22EC0000%22%20AS%20%3Frgb%29%0AWHERE%20%0A%7B%0A%20%20wd%3AQ108327788%20wdt%3AP1416%20%3Fwsingular%20.%0A%20%20%3Fp%20wdt%3AP31%20wd%3AQ98270496%20.%0A%20%20%3Fp%20p%3AP1416%20%3Fstatement%20.%0A%20%20%3Fstatement%20ps%3AP1416%20%3Fwsingular%20.%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20pq%3AP3831%20%3FaffiliationType%20.%7D%20%20%0A%20%20OPTIONAL%20%7B%20%3Fwsingular%20wdt%3AP154%20%3Fwsingularpicture%20%7D%0A%20%20OPTIONAL%20%7B%20%3Fp%20wdt%3AP154%20%3Fppicture%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cde%2Cen%22%20.%20%7D%0A%7D%20ORDER%20BY%20ASC%28%3FwsingularLabel%29%20ASC%28%3FpLabel%29 variant]
+* [https://w.wiki/6H2s (Steffen Neumann)]
+=== Formulas involving mass ===
+* https://w.wiki/6CmU
+=== Meaning of a given symbol in various formulas ===
+==== Meaning of the symbol 'η' in various formulas ====
+* https://w.wiki/6Cg8
+==== Meaning of the symbol 'μ' in various formulas ====
+* https://w.wiki/6CmL
+=== Most frequent topics of publications with a zbMATH document ID ===
+* https://w.wiki/6CJC
+=== Most frequent topics of publications by an author with a zbMATH author ID ===
+* https://w.wiki/6CJD
+=== Items matching a certain identifier ===
+==== DLMF ID ====
+* https://w.wiki/7Qmt
+=== Formulas containing certain LaTeX strings ===
+* https://w.wiki/7Qmx
+=== Mathematicians who have had non-mathematical things named after them ===
+* [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fmathematician%20%3FmathematicianLabel%20WHERE%20%7B%0A%20%20%3Fmathematician%20wdt%3AP106%2Fwdt%3AP279%2a%20wd%3AQ170790%20.%0A%20%20%7B%20%3Fobject%20wdt%3AP2824%20%3Fid1%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP719%20%3Fid2%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP225%20%3Fid3%20.%20%7D%0A%20%20%0A%20%20%3Fobject%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D e.g. lunar craters OR asteroids OR species]
+** [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fmathematician%20%3FmathematicianLabel%20WHERE%20%7B%0A%20%20%3Fmathematician%20wdt%3AP106%2Fwdt%3AP279%2a%20wd%3AQ170790%20.%0A%20%20%7B%20%3Fobject%20wdt%3AP2824%20%3Fid1%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP719%20%3Fid2%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP225%20%3Fid3%20.%20%7D%0A%20%20UNION%0A%20%20%7B%20%3Fobject%20wdt%3AP11497%20%3Fid4%20.%20%7D%0A%20%20%0A%20%20%3Fobject%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D variant with OR mathematical functions]
+** [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fmathematician%20%3FmathematicianLabel%20WHERE%20%7B%0A%20%20%3Fmathematician%20wdt%3AP106%2Fwdt%3AP279%2a%20wd%3AQ170790%20.%0A%20%20%3Ffunction%20wdt%3AP11497%20%3Fdlmf%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20%3Fcrater%20wdt%3AP2824%20%3Fobject_name1%20%3B%0A%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20%3Fasteroid%20wdt%3AP716%20%3Fobject_name2%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20%3Ftaxon%20wdt%3AP225%20%3Ftaxonname%20%3B%0A%20%20%20%20%20%20%20%20%20wdt%3AP138%20%3Fmathematician%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20ASC%28%3Fdob%29 variant with AND for all of the above]
+== Housekeeping queries ==
+=== List of MaRDI Wikibase properties ===
+* [https://query.portal.mardi4nfdi.de/#%23title%3A%20List%20of%20properties%0ASELECT%20DISTINCT%20%3FpropertyLabel%20%3Fproperty%20WHERE%20%7B%0A%20%20%3Fproperty%20a%20wikibase%3AProperty%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0AORDER%20BY%20ASC%28%3FpropertyLabel%29 sorted alphabetically based on English label]
+* [https://query.portal.mardi4nfdi.de/index.html#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fentity%2F%3E%0ASELECT%20DISTINCT%20%3Fproperty%20%3FpropertyLabel%20%0AWHERE%20%7B%0A%20%20%3Fproperty%20a%20wikibase%3AProperty%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20%20wikibase%3Aclaim%20%3Fp.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22en%22.%20%7D%0A%0A%7D%0AGROUP%20BY%20%3Fproperty%20%3FpropertyLabel%20%0AORDER%20BY%20ASC%28xsd%3Ainteger%28REPLACE%28STR%28%3Fproperty%29%2C%20%22.%2aP%22%2C%20%22%22%29%29%29%0A sorted by PID]
-''These are queries aimed at gathering content from one or more knowledge bases.''
+=== Author identifiers ===
-== Demo queries ==
+* [https://query.wikidata.org/#SELECT%20%2a%20WHERE%20%7B%0A%3Fitem%20wdt%3AP1556%20%3Fzbmath_au%20%3B%0A%20%20%20%20%20%20wdt%3AP496%20%3Forcid%20%3B%0A%20%20%20%20%20%20wdt%3AP106%20wd%3AQ170790%20.%0A%7D mathematicians with both a zbMATH author ID and an ORCID known to Wikidata]
-''These are queries that highlight some particular aspect of the data or the associated technical contexts.''
 == Editing queries ==
-''These queries generate commands that can be used to make additional edits.''
+''These queries generate commands that can be used to make additional edits in the same Wikibase or another.''
 == Maintenance queries ==
@@ Line 20: / Line 74: @@
 ==== On Wikidata ====
-''See also recent changes to
+''See also recent changes to [https://www.wikidata.org/w/index.php?hidecategorization=1&target=Property%3AP894&limit=500&days=7&enhanced=1&title=Special:RecentChangesLinked&urlversion=2 items '''linked from''' zbMATH work ID (P894)], [https://www.wikidata.org/w/index.php?hidecategorization=1&target=Property%3AP894&showlinkedto=1&limit=500&days=7&enhanced=1&title=Special:RecentChangesLinked&urlversion=2 items '''linking to''' zbMATH work ID (P894)], [https://www.wikidata.org/w/index.php?hidecategorization=1&target=Property%3AP1556&limit=500&days=7&enhanced=1&title=Special:RecentChangesLinked&urlversion=2 items '''linked from''' zbMATH author ID (P1556)] and [https://www.wikidata.org/w/index.php?hidecategorization=1&target=Property%3AP1556&showlinkedto=1&limit=500&days=7&enhanced=1&title=Special:RecentChangesLinked&urlversion=2 items '''linking to''' author ID (P1556)] as well as [https://bambots.brucemyers.com/NavelGazer.php?property=P894 frequent curators of zbMATH work ID (P894) statements] and  [https://bambots.brucemyers.com/NavelGazer.php?property=P1556 frequent curators of zbMATH author ID (P1556) statements].''
-: [https://www.wikidata.org/w/index.php?hidecategorization=1&target=Property%3AP894&limit=500&days=7&enhanced=1&title=Special:RecentChangesLinked&urlversion=2 items linked from zbMATH work ID (P894)]
-: [https://www.wikidata.org/w/index.php?hidecategorization=1&target=Property%3AP894&showlinkedto=1&limit=500&days=7&enhanced=1&title=Special:RecentChangesLinked&urlversion=2 items linking to zbMATH work ID (P894)]
-: [https://www.wikidata.org/w/index.php?hidecategorization=1&target=Property%3AP1556&limit=500&days=7&enhanced=1&title=Special:RecentChangesLinked&urlversion=2 items linked from zbMATH author ID (P1556)]
-: [https://www.wikidata.org/w/index.php?hidecategorization=1&target=Property%3AP1556&showlinkedto=1&limit=500&days=7&enhanced=1&title=Special:RecentChangesLinked&urlversion=2 items linking to author ID (P1556)]
-''
-* [https://query.wikidata.org/#%23title%3A%20Author%20name%20strings%20common%20on%20works%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0ASELECT%0A%23%20Number%20of%20works%20with%20the%20author%20name%20string%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0A%3Fcount%0A%0A%23%20Total%20number%20of%20works%20with%20the%20author%20name%20string%0A%3Fcount1%0A%0A%23%20Author%20as%20a%20string%0A%3Fauthorstring%0A%0A%23%20Build%20URL%20to%20the%20Author%20disambiguator%20tool%0A%28CONCAT%28%0A%20%20%27https%3A%2F%2Ftools.wmflabs.org%2Fauthor-disambiguator%2Fnames_oauth.php%3Fname%3D%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fauthorstring%29%29%20AS%20%3Fresolver_url%29%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fwork%20%3Fauthorstring%20WHERE%20%7B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fwork%20wdt%3AP894%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fauthor%20wdt%3AP1556%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fauthor%20%5Ewdt%3AP50%20%3Fwork%20.%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20%20%20LIMIT%2050000%0A%7D%20AS%20%25works%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%28COUNT%28DISTINCT%20%3Fwork%29%20AS%20%3Fcount%29%0A%20%20%28COUNT%28DISTINCT%20%3Fwork1%29%20AS%20%3Fcount1%29%0A%20%20%3Fauthorstring%0A%20%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25works%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fwork1%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthorstring%0A%7D%20AS%20%25result%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%20DESC%28%3Fcount1%29 Author name strings common on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)]
+* [https://query.wikidata.org/#%23title%3A%20Author%20name%20strings%20common%20on%20works%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0ASELECT%0A%23%20Number%20of%20works%20with%20the%20author%20name%20string%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0A%3Fcount%0A%0A%23%20Total%20number%20of%20works%20with%20the%20author%20name%20string%0A%3Fcount1%0A%0A%23%20Author%20as%20a%20string%0A%3Fauthorstring%0A%0A%23%20Length%20of%20author%20string%0A%3Flength%20%0A%0A%23%20String%20score%0A%3Fscore%20%0A%0A%23%20Build%20URL%20to%20the%20Author%20disambiguator%20tool%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Ftools.wmflabs.org%2Fauthor-disambiguator%2Fnames_oauth.php%3Flimit%3D9000%26name%3D%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fauthorstring%29%29%29%20AS%20%3Fresolver_url%29%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fwork%20%3Fauthorstring%20WHERE%20%7B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fwork%20wdt%3AP894%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fauthor%20wdt%3AP1556%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fauthor%20%5Ewdt%3AP50%20%3Fwork%20.%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20%20%20LIMIT%2010000%0A%7D%20AS%20%25works%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%28COUNT%28DISTINCT%20%3Fwork%29%20AS%20%3Fcount%29%0A%20%20%28COUNT%28DISTINCT%20%3Fwork1%29%20AS%20%3Fcount1%29%0A%20%20%3Fauthorstring%0A%20%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25works%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fwork1%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthorstring%0A%7D%20AS%20%25result%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%20%20%20%20%20%20%20%20%20%20BIND%28STRLEN%28%3Fauthorstring%29%20AS%20%3Flength%29%0A%20%20%20%20%20%20%20%20%20%20BIND%28%3Fcount%20%2a%20%3Fcount1%20%2a%20%3Flength%20%2a%20%3Flength%20AS%20%3Fscore%29%20%0A%7D%0AORDER%20BY%20DESC%28%3Fscore%29%20DESC%28%3Fcount1%29%20DESC%28%3Fcount%29 Author name strings common on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)]
+*:The results here are dominated by astronomy, which rarely uses full names, so author disambiguation is harder. Let's filter this a bit for strings that are easier to disambiguate.
+** [https://query.wikidata.org/#%23title%3A%20Author%20name%20strings%20containing%20a%20dash%20that%20are%20common%20on%20works%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0ASELECT%0A%23%20Number%20of%20works%20with%20the%20author%20name%20string%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0A%3Fcount%0A%0A%23%20Total%20number%20of%20works%20with%20the%20author%20name%20string%0A%3Fcount1%0A%0A%23%20Author%20as%20a%20string%0A%3Fauthorstring%0A%0A%23%20Length%20of%20author%20string%0A%3Flength%20%0A%0A%23%20String%20score%0A%3Fscore%20%0A%0A%23%20Build%20URL%20to%20the%20Author%20disambiguator%20tool%0A%28CONCAT%28%0A%20%20%27https%3A%2F%2Ftools.wmflabs.org%2Fauthor-disambiguator%2Fnames_oauth.php%3Flimit%3D9000%26name%3D%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fauthorstring%29%29%20AS%20%3Fresolver_url%29%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fwork%20%3Fauthorstring%20WHERE%20%7B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fwork%20wdt%3AP894%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fauthor%20wdt%3AP1556%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fauthor%20%5Ewdt%3AP50%20%3Fwork%20.%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%20%20%20%20FILTER%20%28REGEX%28%3Fauthorstring%2C%20%22%28-%7C%E2%80%90%7C%E2%80%91%7C%E2%80%92%7C%E2%80%93%7C%E2%80%94%7C%E2%80%95%7C%E2%88%92%29%22%29%29%0A%20%20%7D%0A%20%20%20%20LIMIT%2010000%0A%7D%20AS%20%25works%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%28COUNT%28DISTINCT%20%3Fwork%29%20AS%20%3Fcount%29%0A%20%20%28COUNT%28DISTINCT%20%3Fwork1%29%20AS%20%3Fcount1%29%0A%20%20%3Fauthorstring%0A%20%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25works%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fwork1%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthorstring%0A%7D%20AS%20%25result%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%20%20%20%20%20%20%20%20%20%20BIND%28STRLEN%28%3Fauthorstring%29%20AS%20%3Flength%29%0A%20%20%20%20%20%20%20%20%20%20BIND%28%3Fcount%20%2a%20%3Fcount1%20%2a%20%3Flength%20%2a%20%3Flength%20AS%20%3Fscore%29%20%0A%7D%0AORDER%20BY%20DESC%28%3Fscore%29%20DESC%28%3Fcount1%29%20DESC%28%3Fcount%29 Author name strings containing a dash that are common on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)]
+** [https://query.wikidata.org/#%23title%3A%20Common%20author%20name%20strings%20%28without%20single-letter%20initials%29%20on%20works%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0ASELECT%0A%23%20Number%20of%20works%20with%20the%20author%20name%20string%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0A%3Fcount%0A%0A%23%20Total%20number%20of%20works%20with%20the%20author%20name%20string%0A%3Fcount1%0A%0A%23%20Author%20as%20a%20string%0A%3Fauthorstring%0A%0A%23%20Length%20of%20author%20string%0A%3Flength%20%0A%0A%23%20String%20score%0A%3Fscore%20%0A%0A%23%20Build%20URL%20to%20the%20Author%20disambiguator%20tool%0A%28CONCAT%28%0A%20%20%27https%3A%2F%2Ftools.wmflabs.org%2Fauthor-disambiguator%2Fnames_oauth.php%3Flimit%3D9000%26name%3D%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fauthorstring%29%29%20AS%20%3Fresolver_url%29%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fwork%20%3Fauthorstring%20WHERE%20%7B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fwork%20wdt%3AP894%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fauthor%20wdt%3AP1556%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fauthor%20%5Ewdt%3AP50%20%3Fwork%20.%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%20%20%23%20remove%20single-letter%20initials%0A%20%20%20%20FILTER%28%21regex%20%28LCASE%28%3Fauthorstring%29%2C%20%22%5E.%2a%3F%28%28%5C%5Cb%5C%5Cw%7B1%7D%5C%5Cb%29%7C%5B.%5D%29.%2a%24%22%29%29.%0A%20%20%7D%0A%20%20%20%20LIMIT%2010000%0A%7D%20AS%20%25works%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%28COUNT%28DISTINCT%20%3Fwork%29%20AS%20%3Fcount%29%0A%20%20%28COUNT%28DISTINCT%20%3Fwork1%29%20AS%20%3Fcount1%29%0A%20%20%3Fauthorstring%0A%20%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25works%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fwork1%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthorstring%0A%7D%20AS%20%25result%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%23%20%20%20FILTER%20%28%3Fcount1%20%3E%2049%29%0A%20%20%20%20%20%20%20%20%20%20BIND%28STRLEN%28%3Fauthorstring%29%20AS%20%3Flength%29%0A%20%20%20%20%20%20%20%20%20%20BIND%28%3Fcount%20%2a%20%3Fcount1%20%2a%20%3Flength%20%2a%20%3Flength%20AS%20%3Fscore%29%20%0A%7D%0AORDER%20BY%20DESC%28%3Fscore%29%20DESC%28%3Fcount1%29%20DESC%28%3Fcount%29 Common author name strings (without single-letter initials) on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)]
+**:This looks like a good dataset to work with, paving the way for disambiguating strings with initials later with more confidence.
+** [https://query.wikidata.org/#SELECT%0A%20%20%23%20Number%20of%20works%20with%20the%20author%0A%20%20%3Fcount%0A%0A%20%20%23%20Author%20score%20-%203%20points%20for%20authoring%20a%20work%2C%201%20for%20being%20cited%0A%20%20%3Fscore%0A%0A%20%20%23%20Author%20as%20a%20string%0A%20%20%3Fauthor%0A%0A%20%20%23%20Build%20URL%20to%20the%20Author%20disambiguator%20tool%0A%20%20%28URI%28CONCAT%28%0A%20%20%20%20%20%20%27https%3A%2F%2Fauthor-disambiguator.toolforge.org%2Fnames_oauth.php%3Fdoit%3DLook%2Bfor%2Bauthor%26name%3D%27%2C%0A%20%20%20%20%20%20ENCODE_FOR_URI%28%3Fauthor%29%29%29%20AS%20%3Fresolver_url%29%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fwork%20WHERE%20%7B%0A%20%20%20%20%3Fwork%20wdt%3AP894%20%3Fzbm_doc.%0A%20%20%7D%0A%20%20LIMIT%2010000%0A%7D%20AS%20%25works%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%20%20%28COUNT%28%3Fwork%29%20AS%20%3Fcount%29%0A%20%20%20%20%3Fauthor%0A%20%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25works%0A%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthor%20.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthor%0A%7D%20AS%20%25result%0A%0A%23%20Generate%20a%20score%20for%20each%20author%0AWITH%20%7B%0A%20%20SELECT%20%28SUM%28%3Fscore_%29%20AS%20%3Fscore%29%20%3Fauthor%0A%20%20WHERE%20%7B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%23%20Assign%20them%203%20points%20if%20they%20are%20an%20author%20of%20a%20work%20on%20the%20subject%0A%20%20%20%20%20%20SELECT%20%283%20AS%20%3Fscore_%29%20%3Fauthor%20%3Fwork%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthor%20.%0A%20%20%20%20%20%20%20%20%3Fwork%20wdt%3AP894%20%3Fzbm_doc.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20%23%20Assign%20them%201%20point%20if%20they%20are%20the%20author%20of%20a%20work%20that%20is%20cited%20by%20a%20work%20on%20the%20subject%0A%20%20%20%20%20%20SELECT%20%281%20AS%20%3Fscore_%29%20%3Fauthor%20%3Fwork%20WHERE%20%7B%0A%20%20%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthor%20.%0A%20%20%20%20%20%20%20%20%3Fciting_work%20wdt%3AP2860%20%3Fwork%20.%0A%20%20%20%20%20%20%20%20%3Fciting_work%20wdt%3AP894%20%3Fzbm_doc.%0A%20%20%20%20%20%20%7D%0A%20%20%20%20%7D%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthor%0A%7D%20AS%20%25scores%0A%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%20%20INCLUDE%20%25scores%0A%0A%20%20%23%20Label%20the%20result%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22%20.%20%7D%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%20DESC%28%3Fscore%29%0ALIMIT%20200%0A Common author name strings on documents that have a zbMATH document ID]
+* Find zbMATH author IDs to be added to Wikidata author items: [https://query.wikidata.org/#%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%23%20Wikidata%20items%20of%20authors%20for%20which%20Wikidata%20does%20not%20know%20the%20zbMATH%20author%20ID%20but%20%23%20%20%0A%23%20the%20zbMATH%20author%20ID%20of%20at%20least%20two%20co-authors%20on%20a%20paper%20with%20zbMATH%20document%20ID%2C%20%23%0A%23%20from%20which%20the%20missing%20zbMATH%20author%20ID%20may%20be%20inferred.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%0ASELECT%20DISTINCT%20%20%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2F%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fzbm_doc%29%29%29%20AS%20%3Fresolver_url%29%0A%3Fauthor3%0A%3Fauthor3Label%0A%3Fitem%20%3FitemLabel%20%3Fstatements3%20%20%20%20%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fauthor3%20%3Fzbm_doc%20%3Fitem%20WHERE%20%7B%0A%20%20%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fitem%20wdt%3AP894%20%3Fzbm_doc%20.%20bd%3AserviceParam%20bd%3Asample.limit%2030000%20%7D%0A%20%20%3Fitem%20wdt%3AP50%20%3Fauthor1%20%2C%20%3Fauthor2%2C%20%3Fauthor3%20.%0A%20%20%3Fauthor1%20wdt%3AP1556%20%3Fzbm_au1%20.%0A%20%20%3Fauthor2%20wdt%3AP1556%20%3Fzbm_au2%20.%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor2%29%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor3%29%0A%20%20FILTER%20%28%3Fauthor2%20%21%3D%20%3Fauthor3%29%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fauthor3%20wdt%3AP1556%20%3Fzbm_au%20%7D%0A%20%20%20%20%7D%0A%7D%20AS%20%25prep%0AWHERE%20%7B%0A%20%20INCLUDE%20%25prep%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fauthor3%20wikibase%3Astatements%20%3Fstatements3%20.%0A%7D%0AORDER%20BY%20DESC%28%3Fstatements3%29%0A%23%20LIMIT%201000 Wikidata items of authors for which Wikidata does not know the zbMATH author ID but the zbMATH author ID of at least two co-authors on a paper with zbMATH document ID, from which the missing zbMATH author ID may be inferred.]
+** [https://w.wiki/8Ygk variant without zbMATH document ID]
+** [https://query.wikidata.org/#%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%23%20Wikidata%20items%20of%20authors%20for%20which%20Wikidata%20does%20not%20know%20the%20zbMATH%20author%20ID%20but%20%23%20%20%0A%23%20the%20zbMATH%20author%20ID%20of%20at%20least%20one%20co-author%20on%20a%20paper%20with%20zbMATH%20document%20ID%2C%20%20%23%0A%23%20from%20which%20the%20missing%20zbMATH%20author%20ID%20may%20be%20inferred.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%0ASELECT%20DISTINCT%20%3Fauthor2%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2F%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fzbm_doc%29%29%29%20AS%20%3Fresolver_url%29%0A%3Fauthor2Label%0A%3Fitem%20%3FitemLabel%20%3Fstatements2%20%20%20%20%0AWHERE%20%7B%0A%20%20%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fitem%20wdt%3AP894%20%3Fzbm_doc%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20%3Fitem%20wdt%3AP50%20%3Fauthor1%20%2C%20%3Fauthor2%20.%0A%20%20%3Fauthor1%20wdt%3AP1556%20%3Fzbm_au1%20.%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor2%29%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fauthor2%20wdt%3AP1556%20%5B%5D%20%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fauthor2%20wikibase%3Astatements%20%3Fstatements2%20.%0A%7D%0AORDER%20BY%20DESC%28%3Fstatements2%29%0A%23%20LIMIT%20101112345 variant for one co-author]
+* Find zbMATH document IDs to be added to Wikidata paper items: [https://query.wikidata.org/#%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%23%20Wikidata%20items%20of%20documents%20for%20which%20Wikidata%20does%20not%20know%20the%20zbMATH%20document%20ID%20%23%20%0A%23%20but%20the%20zbMATH%20author%20ID%20of%20at%20least%20one%20author%2C%20from%20which%20the%20missing%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%20zbMATH%20document%20ID%20may%20be%20inferred.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%0ASELECT%20DISTINCT%20%0A%3Fitem2%20%3Fitem2Label%20%0A%3Fzbm_doc1%0A%3Fstatements1%20%20%20%20%0A%3Fauthor1%20%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2Fauthors%2F%27%2C%0A%20%20ENCODE_FOR_URI%28STR%28%3Fzbm_au1%29%29%29%29%20AS%20%3Fresolver1_url%29%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2F%3Fq%3D%5C%22%27%2C%0A%20%20ENCODE_FOR_URI%28STR%28%3Fitem2Label%29%29%2C%20%22%5C%22%22%29%29%20AS%20%3Fresolver2_url%29%0A%3Fauthor1Label%0AWHERE%20%7B%0A%20%20%3Fauthor1%20wdt%3AP1556%20%3Fzbm_au1%20.%0A%20%20%3Fauthor1%20%5Ewdt%3AP50%20%3Fitem1%20.%0A%20%20%3Fitem1%20wdt%3AP894%20%3Fzbm_doc1%20.%0A%20%20%3Fauthor1%20%5Ewdt%3AP50%20%3Fitem2%20.%0A%20%20%3Fitem2%20wdt%3AP31%20wd%3AQ13442814%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem2%20wdt%3AP894%20%3Fzbm_doc2%20.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fauthor1%20wikibase%3Astatements%20%3Fstatements1%20.%0A%20%20FILTER%20%28%3Fstatements1%20%3E%2020%29%0A%7D%0ALIMIT%20100 Wikidata items of documents for which Wikidata does not know the zbMATH document ID but the zbMATH author ID of at least one author, from which the missing zbMATH document ID may be inferred.]
+** [https://query.wikidata.org/#%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%23%20Wikidata%20items%20of%20documents%20for%20which%20Wikidata%20does%20not%20know%20the%20zbMATH%20document%20ID%20%23%20%0A%23%20but%20the%20zbMATH%20author%20ID%20of%20at%20least%20one%20author%2C%20from%20which%20the%20missing%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%20zbMATH%20document%20ID%20may%20be%20inferred.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%0ASELECT%20DISTINCT%20%0A%3Fitem2%20%3Fitem2Label%20%0A%3Fzbm_doc1%0A%3Fstatements1%20%20%20%20%0A%3Fauthor1%20%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2Fauthors%2F%27%2C%0A%20%20ENCODE_FOR_URI%28STR%28%3Fzbm_au1%29%29%29%29%20AS%20%3Fresolver1_url%29%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2F%3Fq%3D%5C%22%27%2C%0A%20%20ENCODE_FOR_URI%28STR%28%3Fitem2Label%29%29%2C%20%22%5C%22%22%29%29%20AS%20%3Fresolver2_url%29%0A%3Fauthor1Label%0AWHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fauthor1%20wdt%3AP1556%20%3Fzbm_au1%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20%3Fauthor1%20%5Ewdt%3AP50%20%3Fitem1%20.%0A%20%20%3Fitem1%20wdt%3AP894%20%3Fzbm_doc1%20.%0A%20%20%3Fauthor1%20%5Ewdt%3AP50%20%3Fitem2%20.%0A%20%20%3Fitem2%20wdt%3AP31%20wd%3AQ13442814%20.%0A%20%20%3Fitem2%20wdt%3AP50%20%3Fauthor2%20.%0A%20%20%3Fauthor2%20wdt%3AP1556%20%3Fzbm_au2%20.%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor2%29%0A%20%20%3Fitem2%20wdt%3AP2093%20%3Fauthornamestring%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem2%20wdt%3AP894%20%3Fzbm_doc2%20.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fauthor1%20wikibase%3Astatements%20%3Fstatements1%20.%0A%20%20FILTER%20%28%3Fstatements1%20%3E%2020%29%0A%7D%0A%23%20LIMIT%20100 variant]
+** [https://query.wikidata.org/#%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%23%20Wikidata%20items%20of%20documents%20for%20which%20Wikidata%20does%20not%20know%20the%20zbMATH%20document%20ID%20%23%20%0A%23%20but%20that%20have%20%281%29%20been%20published%20in%20a%20math%20journal%20and%20%282%29%20at%20least%20two%20authors%20%20%20%20%20%23%0A%23%20with%20a%20zbMATH%20author%20ID.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%20This%20yields%20candidates%20that%20are%20likely%20to%20have%20a%20zbMATH%20entry.%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%20%23%0A%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%23%0A%0ASELECT%20DISTINCT%20%0A%3Fitem2%20%3Fitem2Label%20%0A%3Fzbm_doc1%0A%3Fstatements1%20%20%20%20%0A%3Fauthor1%20%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2Fauthors%2F%27%2C%0A%20%20ENCODE_FOR_URI%28STR%28%3Fzbm_au1%29%29%29%29%20AS%20%3Fresolver1_url%29%0A%28URI%28CONCAT%28%0A%20%20%27https%3A%2F%2Fzbmath.org%2F%3Fq%3D%5C%22%27%2C%0A%20%20ENCODE_FOR_URI%28STR%28%3Fitem2Label%29%29%2C%20%22%5C%22%22%29%29%20AS%20%3Fresolver2_url%29%0A%3Fauthor1Label%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fvenue%20%28COUNT%28%3Fitem0%29%20AS%20%3Fcount%29%20WHERE%20%7B%0A%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fitem0%20wdt%3AP894%20%3Fzbm_doc0%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20%20%20%3Fitem0%20wdt%3AP1433%20%3Fvenue%20.%0A%20%20%20%20%3Fvenue%20wdt%3AP1476%20%3Fvenue_title%20.%0A%20%20%20%20FILTER%20REGEX%28LCASE%28%3Fvenue_title%29%2C%20%22mathemat%22%29%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fvenue%0A%20%20ORDER%20BY%20DESC%28%3Fcount%29%0A%20%20LIMIT%20100%0A%7D%20AS%20%25venues%0AWHERE%20%7B%0A%20%20INCLUDE%20%25venues%0A%20%20%3Fvenue%20%5Ewdt%3AP1433%20%3Fitem1%2C%20%3Fitem2%20.%0A%20%20%3Fitem1%20wdt%3AP894%20%3Fzbm_doc1%20.%0A%20%20%3Fitem1%20wdt%3AP50%20%3Fauthor1%20.%0A%20%20%3Fauthor1%20wdt%3AP1556%20%3Fzbm_au1%20.%0A%20%20%3Fauthor1%20%5Ewdt%3AP50%20%3Fitem2%20.%0A%20%20%3Fitem2%20wdt%3AP31%20wd%3AQ13442814%20.%0A%20%20%3Fitem2%20wdt%3AP50%20%3Fauthor2%20.%0A%20%20%3Fauthor2%20wdt%3AP1556%20%3Fzbm_au2%20.%0A%20%20FILTER%20%28%3Fauthor1%20%21%3D%20%3Fauthor2%29%0A%20%20%3Fitem2%20wdt%3AP2093%20%3Fauthornamestring%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fitem2%20wdt%3AP894%20%3Fzbm_doc2%20.%7D%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%20%20%3Fauthor1%20wikibase%3Astatements%20%3Fstatements1%20.%0A%23%20%20%20FILTER%20%28%3Fstatements1%20%3E%2020%29%0A%7D%0ALIMIT%20100%20 more refined variant]
+* [https://w.wiki/95vz People with both a zbMATH author ID and a Wikimedia user name]
-:The results here are dominated by astronomy, which rarely uses full names, so author disambiguation is harder. Let's filter this to exclude strings with initials.
+==== On Wikipedia ====
-* [https://query.wikidata.org/#%23title%3A%20Common%20author%20name%20strings%20%28without%20single-letter%20initials%29%20on%20works%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0ASELECT%0A%23%20Number%20of%20works%20with%20the%20author%20name%20string%20that%20have%20either%20a%20zbMATH%20work%20ID%20%28P894%29%20or%20an%20author%20with%20a%20zbMATH%20author%20ID%20%28P1556%29%0A%3Fcount%0A%0A%23%20Total%20number%20of%20works%20with%20the%20author%20name%20string%0A%3Fcount1%0A%0A%23%20Author%20as%20a%20string%0A%3Fauthorstring%0A%0A%23%20Build%20URL%20to%20the%20Author%20disambiguator%20tool%0A%28CONCAT%28%0A%20%20%27https%3A%2F%2Ftools.wmflabs.org%2Fauthor-disambiguator%2Fnames_oauth.php%3Fname%3D%27%2C%0A%20%20ENCODE_FOR_URI%28%3Fauthorstring%29%29%20AS%20%3Fresolver_url%29%0AWITH%20%7B%0A%20%20SELECT%20DISTINCT%20%3Fwork%20%3Fauthorstring%20WHERE%20%7B%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fwork%20wdt%3AP894%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%20%20UNION%0A%20%20%20%20%7B%0A%20%20%20%20%20%20SERVICE%20bd%3Asample%20%7B%20%3Fauthor%20wdt%3AP1556%20%5B%5D%20.%20bd%3AserviceParam%20bd%3Asample.limit%20100000%20%7D%20%20%20%0A%20%20%20%20%20%20%3Fauthor%20%5Ewdt%3AP50%20%3Fwork%20.%0A%20%20%20%20%20%20%3Fwork%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%20%20%7D%0A%20%20%20%20%23%20remove%20single-letter%20initials%0A%20%20%20%20FILTER%28%21regex%20%28LCASE%28%3Fauthorstring%29%2C%20%22%5E.%2a%3F%28%28%5C%5Cb%5C%5Cw%7B1%7D%5C%5Cb%29%7C%5B.%5D%29.%2a%24%22%29%29.%0A%20%20%7D%0A%20%20%20%20LIMIT%2010000%0A%7D%20AS%20%25works%0AWITH%20%7B%0A%20%20SELECT%0A%20%20%28COUNT%28DISTINCT%20%3Fwork%29%20AS%20%3Fcount%29%0A%20%20%28COUNT%28DISTINCT%20%3Fwork1%29%20AS%20%3Fcount1%29%0A%20%20%3Fauthorstring%0A%20%20WHERE%20%7B%0A%20%20%20%20INCLUDE%20%25works%0A%20%20%20%20%20%20%20%20%20%20%20%20%3Fwork1%20wdt%3AP2093%20%3Fauthorstring%20.%0A%20%20%7D%0A%20%20GROUP%20BY%20%3Fauthorstring%0A%7D%20AS%20%25result%0AWHERE%20%7B%0A%20%20INCLUDE%20%25result%0A%7D%0AORDER%20BY%20DESC%28%3Fcount%29%20DESC%28%3Fcount1%29%0ALIMIT%20200 Common author name strings (without single-letter initials) on works that have either a zbMATH work ID (P894) or an author with a zbMATH author ID (P1556)]
-== Q & A tools ==
+* [https://query.wikidata.org/#SELECT%20DISTINCT%20%3Fpaper%20%3FpaperLabel%20WHERE%0A%7B%0A%20%20%3Fpaper%20wdt%3AP894%20%3Fzbm_doc%20.%0A%0A%20%20%3Fpaper%20%5Eschema%3Aabout%20%3Farticle%20.%0A%20%20%3Farticle%20schema%3AisPartOf%20%3Chttps%3A%2F%2Fen.wikipedia.org%2F%3E%20.%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22.%20%7D%0A%7D%0ALIMIT%2010 articles on the English Wikipedia about publications with a zbMATH document ID]
+==== On MaRDI ====
+* swMATH: [https://query.portal.mardi4nfdi.de/#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fentity%2F%3E%0APREFIX%20p%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2F%3E%0APREFIX%20ps%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fstatement%2F%3E%0A%0ASELECT%20DISTINCT%0A%3FitemLabel%20%3Fswmath%0A%7B%0A%20%20%3Fitem%20p%3AP13%20%3Fstatement%20.%0A%20%20%3Fstatement%20wikibase%3Arank%20%3Frank%20.%0A%20%20OPTIONAL%20%7B%20%3Fstatement%20ps%3AP13%20%3Fdbvalue%20%7D%0A%0A%20%20BIND%28COALESCE%28IF%28wikibase%3AisSomeValue%28%3Fdbvalue%29%2C%20%22unknown%22%2C%20%22concrete%22%29%2C%20%22novalue%22%29%20AS%20%3Fsnacktype%29%0A%20%20BIND%28IF%28wikibase%3AisSomeValue%28%3Fdbvalue%29%2C%20%22%22%2C%20%3Fdbvalue%29%20AS%20%3Fswmath%29%0A%0A%20%20SERVICE%20wikibase%3Alabel%20%7B%20bd%3AserviceParam%20wikibase%3Alanguage%20%22%5BAUTO_LANGUAGE%5D%2Cen%22%20%7D%0A%20%20%0A%7D package name and swMATH ID]
+* [https://query.portal.mardi4nfdi.de/#SELECT%20DISTINCT%20%3Fmardi_item%20%3Fdoi%20WHERE%20%7B%0A%20%20SERVICE%20bd%3Asample%20%7B%20%3Fmardi_item%20wdt%3AP27%20%3Fdoi%20.%20bd%3AserviceParam%20bd%3Asample.limit%2010000%20%7D%0A%20%20%3Fmardi_item%20wdt%3AP16%20%3Fauthor%20.%0A%20%20FILTER%20NOT%20EXISTS%20%7B%20%3Fmardi_item%20wdt%3AP12%20%3Fwikidata%20%7D%0A%7D MaRDI items with DOI but no Wikidata QID]
+== Tools ==
+== Q & A ==
 * [https://templet.dcc.uchile.cl/ templet]
 * [http://qawiki.org/ QAwiki]
 * [http://wikiask.org/ WikiAsk]
+=== Annotation ===
+* [https://www.wikidata.org/wiki/Wikidata:Tools/Wikidata_for_Web Wikidata for Web]
+== See also ==
+* A generic [https://www.ics.forth.gr/isl/assistive-query-building-semantic-data-qub Query GUI]
+* To experiment with the MaRDI Query Service time-out limit, see [https://query.portal.mardi4nfdi.de/#PREFIX%20wdt%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fprop%2Fdirect%2F%3E%0APREFIX%20wd%3A%20%3Chttps%3A%2F%2Fportal.mardi4nfdi.de%2Fentity%2F%3E%0A%0ASELECT%20%3Fitem%20%3Fproperty_a_value%0AWHERE%20%7B%0A%3Fitem%20wdt%3AP31%20wd%3AQ56887.%0A%3Fitem%20wdt%3AP1451%20%3Fproperty_a_value.%0A%7D%0ALIMIT%201000 this query] and try it with other limits