Hi, what is the parameter to discovery while users create more pages in a wiki?
About this board
Discussion area for discussion about Quarry itself and help about individual queries.
Hmm... It'll be hard to do over-all (for performance reasons), but it's pretty easy to check how many page creations were done in the last 30 days. The recentchanges table has that information.
- rc_type = 1 limits the query to new page creations
- rc_namespace = 0 limits he query to article namespace
Here's the top 10 article-page creators in the last 30 days:
Hi. Is there a way to add a column to rank the results of the query? Like example: The first user in the list (query below) would have number 1, the second is 2... I mean giving me the ranks automatically without "#", which doesn't work with tables in Wikipedia.
I saw a query before with results like this and I couldn't find it.
Yes. Thank you, I appreciate your help. :)
Quality Category of the Articles
Hello all. Is there a query I can make to find out the quality tag for each article? For example, querying the IDs of those articles which belong to the quality class of Featured Articles (FA), etc?
find a roman letter and greek letter next to it?
Is there a way to search through Quarry for [A-Z][Α-Ω], it doesn't appear that a search on the english language wikipedia for insource:/[A-Z][Α-Ω]/ doesn't return any page at all.
No, you can't search wikitext via Quarry.
Thank you. Still looking for a way to do this without having another editor pull it from a database dump.
which tables wikipedia uses
which tables wikipedia uses
How would i get a list of all hip hop artists?
What title says. Not sure where they are located in the db
An easy way to get such a list is via Petscan. Here is a list of results but it might also include few other articles.
Orphaned articles with linkings
Negation is not needed, remove that "NOT".
This is lvwiki version (ignore all those comments and stuff). We have a little bit different situation (we use template in articles) and the query may need some clean-up, but this one should be a good start
Old pages' deletions
Uploaded and then deleted and replaced an Index: namespace file on Wikisource. Then, I realized that the deletion does not cascade to the related pages of the Page: namespace. My question is, am I permitted to delete these pages using SQL? I am an admin on Wikisource and this question is for future reference.
Quarry is read only, so you can't actually do any updates / insertions via it.
YuviPanda, thanks for the reply.
Finding better image versions (SVG)
Can someone help me with a query ?
I am looking for a query that would do that for me
- list of all editors (by username)
- who edited articles where talk pages are from that category (https://en.wikipedia.org/wiki/Category:WikiProject_Wiki_Loves_Women_translation)
- in a list of languages (the full list is here : https://meta.wikimedia.org/wiki/16_African_Women_Translate-a-thon/languages but any query with 2 languages will do. I can then adapt it myself to add the other languages)
- between date 1 and date 2 (practically speaking between 20th of Feb and the 08 of March 2017)
- information to display : username, article name, language of the article edited
- Can anyone help me ?
Is "Category:WikiProject_Wiki_Loves_Women_translation" used across all of the languages under consideration? Or is it maybe localized/translated on the individual wikis?
Here's a query that gets all editors of all talk pages tagged with that category in English Wikipedia: https://quarry.wmflabs.org/query/17110
That's a good start ! Thanks. I go try to add the other elements.
Anthere accidentally edited one of my comments to reply. I've undone that change. Here's the message she posted:
It is only used on the English language at the moment. I could try to ask people to come up with translations equivalent, or I could try to stick the English version....
I always have troubles with Flow :( Sorry...
No worries. The difference between talk pages and flow is pretty big. :)