Jump to: navigation, search

About this board

Edit description

Discussion area for discussion about Quarry itself and help about individual queries.

By clicking "Add topic", you agree to our Terms of Use and agree to irrevocably release your text under the CC BY-SA 3.0 License and GFDL
Mr. Fulano (talkcontribs)

Hi, what is the parameter to discovery while users create more pages in a wiki?

Halfak (WMF) (talkcontribs)

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:

rc_user_text COUNT(*)
DBD 2207
Wilhelmina Will 2046
Sesamehoneytart 1873
Lugnuts 1030
Ss112 939
AnomieBOT 904
Lithopsian 819
Matthiaspaul 793
Chubbles 763
SchreiberBike 703
Mr. Fulano (talkcontribs)

Thank you, I did this!

Reply to "New pages"
Summary by Halfak (WMF)

has query

FShbib (talkcontribs)

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.

Crang115 (talkcontribs)

I think this is what you wanted:

FShbib (talkcontribs)

Yes. Thank you, I appreciate your help. :)

Quality Category of the Articles

Summary by Halfak (WMF)

has query

Anmoldalmia (talkcontribs)

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?

Halfak (WMF) (talkcontribs)

Here you go:

find a roman letter and greek letter next to it?

Naraht (talkcontribs)

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.

Edgars2007 (talkcontribs)

No, you can't search wikitext via Quarry.

Naraht (talkcontribs)

Thank you. Still looking for a way to do this without having another editor pull it from a database dump.

Reply to "find a roman letter and greek letter next to it?"
Priyasadhale (talkcontribs)

which tables wikipedia uses

Edgars2007 (talkcontribs)

Hello! Could you be more specific about what you want to know? here is the database schema

Reply to "which tables wikipedia uses"

How would i get a list of all hip hop artists?

2607:FEA8:2CDF:F468:612A:3346:1588:DDA0 (talkcontribs)

What title says. Not sure where they are located in the db

XXN (talkcontribs)

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.

Reply to "How would i get a list of all hip hop artists?"
The Polish (talkcontribs)

Given all pages containing the template orphaned on, I would to find what pages are not orphaned (one or more linkings).

Can somebody tell me what is wrong in this query. In the resultset there are all the linkings to the template orphaned.

Thanks in advance.

XXN (talkcontribs)

Negation is not needed, remove that "NOT".

The Polish (talkcontribs)

That is not the only problem because is not still working (now 0 results). For ex. there is the article Aleksiej Rybakow (polityk) that has 1 linking and in the talk page there is the template orphaned. I don't know why Quarry doesn't show it.

Edgars2007 (talkcontribs)

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

XXN (talkcontribs)

@The Polish: Removed also "pl_from = page_id" in that subquery (as it's un-needed here), seems to work as expected.

The Polish (talkcontribs)


Ineuw (talkcontribs)

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.

YuviPanda (talkcontribs)

Quarry is read only, so you can't actually do any updates / insertions via it.

Ineuw (talkcontribs)

YuviPanda, thanks for the reply.

Finding better image versions (SVG)

Abschreibbar (talkcontribs)

My question was solved with

Anthere (talkcontribs)


I am looking for a query that would do that for me


Halfak (WMF) (talkcontribs)

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?

Halfak (WMF) (talkcontribs)

Here's a query that gets all editors of all talk pages tagged with that category in English Wikipedia:

Anthere (talkcontribs)

That's a good start ! Thanks. I go try to add the other elements.

Halfak (WMF) (talkcontribs)

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....

Anthere (talkcontribs)

I always have troubles with Flow :( Sorry...

Halfak (WMF) (talkcontribs)

No worries. The difference between talk pages and flow is pretty big.  :)

Reply to "Can someone help me with a query ?"