Wikipedia:Request a query

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.

Redlinked categories with a history of deletion

I'd love a report on currently populated, redlinked categories with a history of deletion - similar to Wikipedia:Database reports/Deleted red-linked categories. This allows for easier spotting of stuff that was never migrated after a merge/rename and also many that were deleted per C1 that are now eligible for restoration, among other things. Unfortunately that report had an error and is only showing very few entries, and it doesn't appear as if it's going to be fixed anytime soon after I brought up the issue, so maybe someone here can re-run the report (I'm not sure where reports like this usually end up, but I would suggest simply replacing that page with the final report so others will be able to find it easily instead of a userspace page or whatnot). Thanks, VegaDark (talk) 19:03, 14 January 2017 (UTC)

Hah, I think this page was specifically set up to distinguish itself from Wikipedia:Database reports or one of its many, many talk pages. I can't remember what went wrong with Deleted red-linked categories (configuration). The page history says it was last updated in November 2016? --MZMcBride (talk) 20:06, 14 January 2017 (UTC)

Yeah, the November report only shows 50-something categories. It's blatantly wrong. Not sure what happened to the report but it's only showing a fraction of the categories the report is intended to show. If you want to fix that, I'm all for it :D VegaDark (talk) 04:09, 15 January 2017 (UTC)

I think the issue we were/are hitting is phabricator:T131266. I tweaked the report to work around this issue, but the consequence is that we're now hitting MediaWiki's api.php instead. Doing this many times, without batching the requests, makes the script take a lot longer. We'll see what happens in a few hours. --MZMcBride (talk) 07:19, 16 January 2017 (UTC)

Hmm, or not. The report finished in about 49 minutes with about 1,100 results. I guess the api.php queries were faster than I thought. I was assuming one per second, but I think we went faster than that. There about 31,000 red-linked categories, if you include categories that have not been previously deleted. --MZMcBride (talk) 07:29, 16 January 2017 (UTC)

Thanks! I think the red-linked categories report is also useful, but with 31k it's not particularly manageable - no end in sight for that cleanup task. VegaDark (talk) 03:23, 18 January 2017 (UTC)

BSicons

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)

(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)

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

OhioLINK Finding Aid Repository

Is it possible to generate a list (with wikilinks) of the subjects of all the biographies (like this one) at this website? Note that they are all noindexed. The list could be useful for the Missing articles project to work on. See talk thread (which hasn't got any replies yet, through). 103.6.159.75 (talk) 13:25, 17 January 2017 (UTC)

I would suggest contacting the website owners to see if they can provide you with a list. There are other things that you could try like writing a spider bot or downloading the entire website, but these can hog the website's bandwidth and might get your IP blocked etc., so it would be much better to get in touch first. The site's owners can probably run a simple SQL query on their database to find the information, which would be a lot less work. Once we have a list of entries it can easily be formatted to make wikilinks or compared against the Wikipedia database. — Mr. Stradivarius ^{♪ talk ♪} 04:29, 18 January 2017 (UTC)

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)