Wikipedia:Request a query

Archives

Archive 1	Archive 2	Archive 3
Archive 4

This page has archives. Sections older than 14 days may be automatically archived by when more than 4 sections are present.

This is a page for requesting one-off database queries for certain criteria. Users who are interested and able to perform SQL queries on the projects can provide results from the Quarry website.

In simple cases you may use PetScan (manual), which can generate list of articles in subcategories, articles, which transclude some template, etc., or the default search may also be useful.

If you need to make changes to a number of articles based on a particular query, you can post to the bot requests page, depending on how many changes are needed.

For long-term review and checking, database reports are available.

BSicons

Done by JJMC89 on Commons. Jc86035 (talk) Use {{re|Jc86035}}
to reply to me 10:24, 25 January 2017 (UTC)[reply]

The following discussion is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.

Are there ways to (a) make a list of Commons files with page name beginning with File:BSicon_ which were uploaded, reuploaded, edited or created as redirects in the past $x$ (or 7) days, ~~(b) make a list of Commons redirects with page name beginning with File:BSicon_ or (c) make a list of Commons files with page name matching the regex ^File:BSicon .+(l|r)(f|g).*\.svg$~~? (See also this bot request. It would help very much if these were automated, but I have no experience with making bots or using Tool Labs.) Thanks, Jc86035 (talk) Use {{re|Jc86035}}
to reply to me 05:15, 15 January 2017 (UTC)[reply]

(b) and (c) can probably be done with PetScan and a text editor, actually. Jc86035 (talk) Use {{re|Jc86035}}
to reply to me 14:08, 15 January 2017 (UTC)[reply]

Pinging AlgaeGraphix. Jc86035 (talk) Use {{re|Jc86035}}
to reply to me 14:09, 15 January 2017 (UTC)[reply]

The discussion above is closed. Please do not modify it. Subsequent comments should be made on the appropriate discussion page. No further edits should be made to this discussion.

Any talk pages of monthly maintenance categories?

Can anyone compile a list of all talk pages of categoiries in Category:Monthly clean up category counter, if any exist? 103.6.159.67 (talk) 14:47, 24 January 2017 (UTC)[reply]

I have posted this report at User:Topbanana/Monthly_cleanup_talk_pages for you. 143 of the 8879 relevant category pages have talk pages. - TB (talk) 10:01, 21 February 2017 (UTC)[reply]

Stats Table required

I'm looking for ways to get the huge and still increasing backlog at Special:NewPagesFeed reduced. In November I poineered the rollout of the New Page Reviewer right. After three months I now need to know how it is performing and what the next steps will be. To do this I need the following data in sortable Wikitable form of New Page Reviewers showing:

user name
date of 'promotion'
number of Curations
date of last curation
date of last edit.
Admin yes/no

There are currently around 300 or so non-admin Reviewers in this user group, all the rest are admins (who besides myself, are unlikely to be patrolling new pages with the Curation tool. Is this something someone could quarry for me fairly quickly? I'm sorry I have to ask, but I don't have a clue about regex, SQL, or data mining - but once it's been done once and I know how, I could repeat the operation when I need it again. Thanks, Kudpung กุดผึ้ง (talk) 12:23, 3 February 2017 (UTC)[reply]

@Kudpung: found it... I'll see what I can do -- Samtar ^{talk · contribs} 20:57, 9 February 2017 (UTC)[reply]

Sam is unable to do this. Is anyone actually watching this page? Kudpung กุดผึ้ง (talk) 18:54, 16 February 2017 (UTC)[reply]

I'm watching it. I'll see what I can do, I'll get started when I get home (circa 2 hours from now). Iazyges Consermonor Opus meum 19:17, 16 February 2017 (UTC)[reply]

useful information for interested editors (for request "Stats Table required")

Tables needed

enwiki_p.logging - to find the rights change (log_type = 'rights')
enwiki_p.user - general user information
enwiki_p.user_groups - to find users who currently have the 'patroller' right

hi, any help is appreciated (or suggestion)

I'm a member of wikiproject Medicine, basically this happened to us [1] and so we have a source code but we need someone's help to do 2016 version (of 2015[2]), I can assist in whatever is needed. ...thank you--Ozzie10aaaa (talk) 17:56, 17 February 2017 (UTC)[reply]

@Ozzie10aaaa: To track down this kind of expert, try posting at Wikipedia:Request a query. -- John of Reading (talk) 19:49, 17 February 2017 (UTC)[reply]

will do, and thanks--Ozzie10aaaa (talk) 20:59, 17 February 2017 (UTC)[reply]

as indicated above I'm posting here and would appreciate any help, thank you--Ozzie10aaaa (talk) 21:02, 17 February 2017 (UTC)[reply]