Topic on Talk:Quarry

Hi, I'm looking for help to build 2 queries that can generate tables that can meet the criteria of the following two tables https://en.wikipedia.org/wiki/Wikipedia:WikiProject_Stub_sorting/To_do#Oversized_stub_categories

1. The first table lists all stub cats with 6 or more listings pages (with # of pages)
2. The second table lists all stub cats with 5 listings pages (with # of pages)

I hope this could be a useful tool for directing stub diffusion work. Eventually, I'd like to take the generated queries and try to build a script that can regularly run the query (monthly or weekly).

I think this is what you want: https://quarry.wmflabs.org/query/28347 For the second query just comment line 5 and uncomment line 4.

Thanks, I really appreciate this work! I think I worded my request a little confusingly - the query column called "cat_pages" definitely fulfills the original table's " Articles" column. However, I was trying to say something slightly different with "number of pages," but I don't have a better word, sorry. Hopefully I can do a better job communicating this, and furthermore it is something doable.

By number of pages, I'm referring to how a category with 400 articles might have 2 pages (only word I know to describe this, sorry!) in the category, but a category with 500 might have 3 pages (~200 articles/entries per page). I don't know if this information is easily retrievable, but I'm hoping it is.

So the final query would ideally have 3 columns

1. Category (cat_title, but output w/o underscores if this is easy)
2. Pages (# of pages in the sense described in paragraph 2, and a net new column)
3. Articles (currently titled cat_pages)|

Thanks again for any help.

Hi,

If I understood you correctly, replacing the first line with "select cat_title Category, ceil(cat_pages/200) Pages, cat_pages Article" should do the job.

Thanks to both of you, I was able to put together something that I think meets my needs https://quarry.wmflabs.org/query/28451