Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Drcenjary
.
Toggle Highlighting
SQL
This is a list of tools demonstrated or discussed at the conference. ==Tool directories== * '''[https://tools.wmflabs.org/hay/directory/#/ Hay's Tools Directory]''' **[https://tools.wmflabs.org/magnustools/hay2.html alternative view of same directory] * [http://tools.wmflabs.org/ Tool Labs full tool list] (includes tools not yet on Hay's Tools Directory) * [http://seealso.org/ SeeAlso - Wiki visualizations directory] * [http://tools.wmflabs.org/hay/wdd/ Wikimedia Documentation Directory] == Statistics and tracking == *'''[https://outreachdashboard.wmflabs.org Programs and Events Dashboard]''' (AKA Outreach Dashboard) - track contributions from groups of users over time (e.g. workshop attendees; competition participants) *'''[http://tools.wmflabs.org/pageviews/ Pageviews]'''/Massviews/Topviews/Userviews - query and comparison interface *[http://tools.wmflabs.org/hay/exturl/ External URL patterns] statistics *[http://tools.wmflabs.org/glamtools/treeviews/ '''TreeViews'''] - monthly view stats for articles in whole category trees *[https://chrome.google.com/webstore/detail/wikipedia-tools/aiilcelhmpllcgkhhpifagfehbddkdfp?utm_source=permalink '''Wikipedia Tools for Chrome'''] - a Chrome add-on useful in compiling Wikipedia statistics *Media **[http://tools.wmflabs.org/hay/reccat/ Recent acquisitions] - show '''newest members in category''' **[http://tools.wmflabs.org/glamtools/glamorous/ GLAMorous] - track '''image usage across projects''', by Commons category **[http://tools.wmflabs.org/glamtools/baglama2/ BaGLAMa] - track '''page views of articles containing images''' from a Commons category out of a fixed list (you can request your category to be added!) ***See also [[toolforge:glamtools/glamorgan.html|'''GLAMorgan''']] ==Querying== * '''[https://petscan.wmflabs.org/ PetScan]''' -- the Swiss-army chainsaw of querying Wikimedia projects! A (very) powerful query interface over pages, categories, and Wikidata * [[quarry:|'''Quarry''']] -- run arbitrary SQL queries against the replicated Wikimedia databases. [[quarry:query/12234|Example]]. ** pro tip: <s>steal</s>adapt other people's queries and change them to suit your needs! ==Editing== *What to work on? **'''[http://recommend.wmflabs.org/#Recommend GapFinder]''' (suggests ''popular'' articles to translate, by topic) **[http://tools.wmflabs.org/most-wanted/index.php?hints=0&project=tawiki&number=50 most wanted] **[http://tools.wmflabs.org/wiki-todo/ Wiki Todo] **[http://tools.wmflabs.org/wikidata-todo/ Wikidata Todo] **[http://tools.wmflabs.org/not-in-the-other-language/ Not in the other language] **[http://tools.wmflabs.org/missingtopics/ Missing Topics] in category or tree *Editing convenience **[[User:Asaf (WMF)/common.js|'''Eran's autocompleter gadget''']] - one of the best-kept secrets in the Wikimedia movement! **HotCat gadget **... ==Media== *'''[[c:Commons:Pattypan|PattyPan]] batch uploader''' *[http://tools.wmflabs.org/flickr2commons/ Flickr2Commons], [http://tools.wmflabs.org/magnustools/flickrfree.php Flickr Free and New] (uses Flickr2Commons) *[[toolforge:croptool/|Crop Tool]] for Commons *'''[http://tools.wmflabs.org/fist/fist.php Free Image Search Tool], [http://tools.wmflabs.org/fist/wdfist/index.html Wikidata FIST]''' *[[toolforge:videoconvert/index.php|'''VideoConvert''']] - converts MP4, AVI, WMV to WebM for uploading to Commons *[[toolforge:video2commons/|Video2Commons]] - video uploader *[https://github.com/abartov/pronuncify Pronuncify] (Linux), [https://github.com/abartov/pronuncify.net Pronuncify.NET] (Windows) - record audio pronunciation files for Commons in batches *[[m:User:Ijon/GLAMify|GLAMify]] - suggest images for articles based on usage in interwiki links ([[metawiki:User:Ijon/GLAMify/2015/3/Featured_pictures_on_Wikimedia_Commons_en_ta|e.g.]]) *[http://tools.wmflabs.org/ptools/findfiles.php Commons file finder] - by user and category *[[c:Commons:Upload tools|List of upload tools on Commons]] ==Wikidata== *'''[http://query.wikidata.org Wikidata Query]''' **e.g. [https://query.wikidata.org/#SELECT%20%3Fitem%20%3FitemLabel%20%28COUNT%28distinct%20%3Fsitelink%29%20as%20%3Fcount%29%0AWHERE%0A%7B%0A%20%20%3Fitem%20wdt%3AP31%20wd%3AQ5%20.%0A%20%20%3Fitem%20wdt%3AP106%20wd%3AQ49757%20.%0A%20%20%3Fsitelink%20schema%3Aabout%20%3Fitem%20.%0A%09FILTER%20EXISTS%20%7B%20%3Fwen%20schema%3Aabout%20%3Fitem%20.%20%3Fwen%20schema%3AinLanguage%20%22en%22%20%7D%0A%09FILTER%20NOT%20EXISTS%20%7B%20%3Fwhe%20schema%3Aabout%20%3Fitem%20.%20%3Fwhe%20schema%3AinLanguage%20%22ar%22%20%7D%0A%09SERVICE%20wikibase%3Alabel%20%7B%0A%09%09bd%3AserviceParam%20wikibase%3Alanguage%20%22en%2Cfr%22%20.%0A%09%7D%0A%7D%0AGROUP%20BY%20%3Fitem%20%3FitemLabel%20%0AORDER%20BY%20DESC%28%3Fcount%29%0A missing articles about poets on '''ar'''wiki with the most interwiki links] (change 'ar' to your language wiki) *[http://tools.wmflabs.org/reasonator Resonator] - a prettier display of what Wikidata knows about an item *[http://tools.wmflabs.org/hay/propbrowse/ Wikidata property browser] *[http://tools.wmflabs.org/pltools/harvesttemplates/ Harvest data from templates into Wikidata] *[http://tools.wmflabs.org/wikidata-timeline Wikidata-based timelines] *'''[http://tools.wmflabs.org/wikidata-game The Wikidata Game]''' and '''[http://tools.wmflabs.org/wikidata-game/distributed/ The Distributed Wikidata Game]''' *[https://en.wikipedia.org/wiki/Wikipedia:Wikidata#Inserting_Wikidata_values_into_Wikipedia_articles Using arbitrary Wikidata in other wikis] (e.g. Infoboxes) **See also: [https://tools.wmflabs.org/listeria/ Listeria] *[https://tools.wmflabs.org/wikidata-todo/tabernacle.html Tabernacle], for tabulating ''and editing'' data on Wikidata
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...