Wikipedia:Request a query

Shortcuts

• WP:RAQWP:RAQ
• WP:QUARRYWP:QUARRY
• WP:SQLREQWP:SQLREQ
• WP:QUERYWP: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 in a category, but not linked on a corresponding page

Specifically, I'm looking for pages that are in Category:Game Boy Advance games but aren't linked on the List of Game Boy Advance games.

I gave it a try, but my SQL skills are lacking and I got stuck on the inside of the NOT EXISTS part: quarry:query/100504. --Retro (talk | contribs) 19:09, 31 December 2025 (UTC)[reply]

You were pretty close. quarry:query/100518. —Cryptic 23:38, 31 December 2025 (UTC)[reply]

Appreciate the help! Retro (talk | contribs) 00:33, 1 January 2026 (UTC)[reply]

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)[reply]

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

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

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)[reply]

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)[reply]

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)[reply]

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)[reply]

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)[reply]

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)[reply]

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

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)[reply]

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

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)[reply]

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)[reply]