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.

You may also be interested in the following:

• If you are interested in writing SQL queries or helping out here, visit our tips page.
• If you need to obtain a list of pages that meet certain criteria, consider using PetScan (user manual) or the default search. PetScan can generate lists of articles in subcategories, articles which transclude some template, etc.
• 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.

The database replicas do not have access to page content, so requests which require checking wikitext cannot be answered with database queries. In particular, there is no way to query for template parameters or anything related to references. However, someone may be able to assist by querying in another way (for example, checking for external links rather than references) or suggest an alternative tool.

Pages eligible for U6 and transclude Template:Infobox ship begin

Hi! Would it be possible to get a list of pages unambiguously eligible for WP:U6 and also transclude TM:Infobox ship begin? (That is, the user has made no edits outside userspace, the user subpage is more than six months old, it is not a .js/.css subpage, it is not in Category:User namespace book pages, and transcludes TM:Infobox ship begin.)

Boring details of why this is helpful: because these are slated for deletion, there is no point in doing the conversion to {{infobox ship}} per a TFD outcome; better to skip the line and U6 them now. Best, HouseBlaster (talk • he/they) 22:45, 13 January 2026 (UTC)

Only sixteen. quarry:query/101029. —Cryptic 00:07, 14 January 2026 (UTC)

Thanks, Cryptic :) HouseBlaster (talk • he/they) 00:20, 14 January 2026 (UTC)

Statistics of pages which have been speedily deleted and declined as drafts

Hello everyone, recently I have proposed the idea to have a disclaimer on the sign up page when creating an account, you can read the idea and discussion at Wikipedia:Village pump (proposals)#The Wikipedia sign up page disclaimer idea. I am here to ask about statistics of the last month (although I think a couple months would be more favourable) of the amount of pages which have been deleted or denied as applications due to being contrary to Wikipedia, or people trying to write about themselves, family member etc. Specifically deleted under criteria G1, G11, G15, A1, A3, A7 (especially), A9, and A11. These criteria are the ones I think are most important to the overall proposal, and any statistics (like monthly amounts, either showing a rise, steady pace or fall) would help greatly. Thank you all. Mwen Sé Kéyòl Translator-a (talk) 10:11, 17 January 2026 (UTC)

Speedy stats going back to the start of 2023 at quarry:query/101108. AFC declines aren't logged AFAIK and aren't visible once the page is deleted, so there's no direct way to get historical data; you could try looking at Wayback Machine archives of categories like Category:Rejected AfC submissions. —Cryptic 10:54, 17 January 2026 (UTC)

Thanks, I’ll look at those stats you’ve given me. I’ll then compile them and compare. Mwen Sé Kéyòl Translator-a (talk) 11:10, 17 January 2026 (UTC)

About cleaning mass message lists of inactive users

Hey there, I would love it if someone could help me with a query that lists all of the users in a mass message list who have no edits or logged actions in 12 months. Ideally, it might also display the date of the last edit so the list can be sorted by that value. Thanks in advance, and let me know if you have any questions! —TechnoSquirrel69 (sigh) 04:19, 19 January 2026 (UTC)

I can do it for lists that are in Category:MassMessage delivery lists, I suppose. MassMessage can use any page or category as its list of recipients, though, and plenty of the ones I see scrolling past on my watchlist aren't in that category (and don't have their content model set to Mass Message Delivery List either; I think that automatically puts them in the cat?). quarry:query/101151. And you're going to want to get wider consensus than "I personally think this might be a good idea" before you start removing names, too. —Cryptic 05:30, 19 January 2026 (UTC)

Thanks, this is very helpful! I was only planning to clean out one list, not go on a spree with every list in existence. —TechnoSquirrel69 (sigh) 05:54, 19 January 2026 (UTC)

Which? —Cryptic 06:12, 19 January 2026 (UTC)

This one, which is related to an event I just organized (and future events I'm planning). —TechnoSquirrel69 (sigh) 15:47, 19 January 2026 (UTC)

quarry:query/101175 specifically for that page. —Cryptic 16:05, 19 January 2026 (UTC)

How about doing things in reverse, and asking for any mass message list that has not been used in 18 months, and then targeting them for deletion. (I'm baffled to see MM lists specific do 2013-14 still on the books.) I'm aware of several people from other projects who subscribe to certain enwiki-only mass messages because they want to be aware of what's happening here; many actions here have an impact on other projects down the road. Risker (talk) 07:56, 19 January 2026 (UTC)

quarry:query/101159 has all 544 by their last logged use. About 460 have gone unused for more than a year and a half. —Cryptic 09:20, 19 January 2026 (UTC)

@TechnoSquirrel69, the Wikipedia:Feedback request service has a bot that removes inactive users. It could probably be adapted to do the same for other lists. WhatamIdoing (talk) 21:08, 4 February 2026 (UTC)

I appreciate you for letting me know! Taking a closer look, it appears to be user-configurable by list, which is super nice. I know the current operators, so I'll talk to them about it and put it on the lists I'm using if appropriate. —TechnoSquirrel69 (sigh) 04:28, 5 February 2026 (UTC)

You're welcome. I hope it proves useful to you. WhatamIdoing (talk) 04:34, 5 February 2026 (UTC)

Recreated Pages

Hey, would it be possible for somebody to help me with a query that lists all drafts that have been recreated from G5 deletions in the past 45 days or so? I don't know if this is possible but I'd greatly appreciate the help if it is. Thanks! --Seawolf35 ^T--C 02:34, 30 January 2026 (UTC)

Recreated in the last 45 days, or deleted G5 in the last 45 days? —Cryptic 02:44, 30 January 2026 (UTC)

And do you want pages that are currently redlinks, or just currently-existing ones? —Cryptic 02:45, 30 January 2026 (UTC)

@Cryptic Just currently existing ones that have been recreated from G5 deletions. This is for sock hunting as it is painful to go through each and every deletion log manually from the page feed. --Seawolf35 ^T--C 02:48, 30 January 2026 (UTC)

Hrm. Do you want pages that are currently in the draft namespace including pages created elsewhere and then moved to draft (for which I'd go by their earliest currently-not-deleted revision); or pages that were created in the draft namespace and might have been moved elsewhere since then? Only going to be looking at G5 deletions on draft titles either way. —Cryptic 03:00, 30 January 2026 (UTC)

Cryptic: Could you do both? If not then pages created in the draft mainspace. --Seawolf35 ^T--C 03:03, 30 January 2026 (UTC)

I think I misunderstood. Pages currently in the draft namespace. --Seawolf35 ^T--C 03:05, 30 January 2026 (UTC)

quarry:query/101579. —Cryptic 03:12, 30 January 2026 (UTC)

Cryptic Thank you very much! I don't know how people understand all this SQL stuff but I'm glad some people share their knowledge. --Seawolf35 ^T--C 03:15, 30 January 2026 (UTC)

quarry:query/101580 for the other method, looking at the creation log. It finds less since it doesn't see that, for example, Draft:Caleb Alloway started at User:Intermezzo118/sandbox. —Cryptic 03:17, 30 January 2026 (UTC)