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 generate an on-wiki list or table from a SQL query (with or without periodic updates), consider using {{database report}}.
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.
Four queries
Cryptic, (or someone else) I am requesting the following queries. Hope this isn't too much work. If possible copy some of these to subpages of Wikipedia:Database reports:
A query that would list all articles created by users where their username is the same as the article title, like if User:Example were to create the article Example.
A version of that query only featuring articles also within the "Single-article users" query
A version of the Templateless articles query only featuring articles also within the "Single-article users" query
(Would those last two take too long?) RanDom 404 (talk) 15:00, 15 September 2026 (UTC)
A query here addresses the first one. I've taken "articles" to mean "mainspace pages which are not currently redirects". As for the second one, my effort purports to show that there aren't any, but that may well be a bug. (Do you have any examples?) I've not attempted the third or fourth queries. Someone may like to combine the single-user query above with this query once the definitions are clear. Certes (talk) 16:00, 15 September 2026 (UTC)
That's going to be missing just about all article titles with spaces in them. actor_name is usually like user_name in that it doesn't replace spaces with underscores the way page_title does. Most (all?) exceptions are from imported edits, which is whyEnter_the_Dragon is the only one in your results that shows up. —Cryptic 16:09, 15 September 2026 (UTC)
D'oh, I should have spotted that they were all single words! Thank you. There is also the issue of what is an "article": many pages have switched between article, redirect and dab over the years and it might be pragmatic just to declare that anything with rev_len > 100 was created as an article. And I expect many of them have had a page move which means the current title doesn't match that at creation. A bit of a minefield calling for many heuristics. Certes (talk) 16:26, 15 September 2026 (UTC)
User renames is also a stumbling block, and harder to detect. —Cryptic 16:50, 15 September 2026 (UTC)
Are there any updates on this, Cryptic? RanDom 404 (talk) 17:06, 3 October 2026 (UTC)
quarry:query/109922 is a fork of Certes' query with a column for edits to other pages, and also fixes the checked-for category to Category:All articles lacking sources (there are still only 18). quarry:query/109923 has mainspace pages with zero transclusions whose creator edited no other page. I don't think that criterion is a good indicator for what you're looking for; someone who creates a page as their first edit A) is already viewed with suspicion by their new page patroller, and B) can't have done that in mainspace to begin with, not for many years, so either someone moved it into mainspace for them or they're going to have another live edit at the redirect they left in Draft: or User: or wherever it was they moved it from. Besides, people who deliberately create hard-to-detect hoaxes usually build up a buffer of "good" edits to avoid those two issues: both lessening suspicion for A and getting able to create directly in mainspace without help for B. —Cryptic 02:50, 4 October 2026 (UTC)
This may be true with more elaborate hoaxes like Alan MacMasters, but in the majority of cases seen on the WP:HOAXLIST you'll find that the majority of Wikipedia's longest lasting hoaxes were created by users with few to no other edits. RanDom 404 (talk) 15:16, 4 October 2026 (UTC)
A version of the "Single-article users" query featuring only articles created on April 1
First one should be easier. RanDom 404 (talk) 19:42, 3 October 2026 (UTC)
To what purpose? What of use will, say, the first one tell you that Category:Articles lacking sources from April 2026 doesn't? I mean, I'm happy to datamine for things that will help Wikipedia, but if this is just to satisfy curiosity, I (or anyone else) am only likely to go along if it satisfies my/their curiosity too. —Cryptic 21:59, 3 October 2026 (UTC)
Those categories are for articles tagged in April, not articles created in April. The reason I'm requesting the queries is because I'm trying to detect hoax articles. RanDom 404 (talk) 23:38, 3 October 2026 (UTC)
A nice round quarry:query/110000.Tracking down what precisely Special:ActiveUsers does was an adventure. "With any edits (or even any edits or logs) in the last n days" would have been much more straightforward.Six of the usernames listed there aren't registered: Adam Black GB, ArchieMartin, DarkGlow, Explodicle, GeorgeLouis, Shruti14. Given the page's age, it's also quite likely some of those users have gotten renames and the listed username is just there to prevent impersonation; I didn't check for that.Also, it's impossible to distinguish which section a link is in, so you're getting the six from the first section too. —Cryptic 02:10, 6 October 2026 (UTC)
Hi Cryptic. If I give you a list of members of a WikiProject, can you make a separate list of the ones that have not edited Wikipedia for 24 months, and if so, what format do you need the list to be in? Kudpung กุดผึ้ง (talk) 03:27, 15 October 2026 (UTC)
(edit conflict) Not Cryptic, but that depends on how many members there are. Probably just a comma separated list, names in quotes. For example "BilledMammal", "Kudpung", "Cryptic". If there are several hundred, then a page with links to all their user pages would be better. BilledMammal (talk) 04:25, 15 October 2026 (UTC)
If there's more than a dozen or so, the easiest way to do it is to link them all from the same page, with no other userpage links. User talk links, or a mix of user and user talk, are ok too, like at Wikipedia:WikiProject Notability/Member List from the section above. —Cryptic 04:33, 15 October 2026 (UTC)
