Page for requesting database queries
Archives
|
|
|
This page has archives. Sections older than 14 days may be automatically archived by
Lowercase sigmabot III 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.
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 article titles that meet certain criteria, consider using
PetScan (
user manual) or the default
search. Petscan can generate list 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.
Quarry does not have access to page content, so queries which require checking wikitext cannot be answered with Quarry. However, someone may be able to assist by using Quarry in another way (e.g. checking the table of category links rather than the "Category:" text) or suggest an alternative tool.
I'm hoping to get a list of articles that are tagged as being in
Wikipedia:WikiProject Climate change and that do not exist in the Japanese Wikipedia. Any help from the lovely volunteers here would be very much appreciated. Cheers,
Clayoquot (
talk |
contribs)
15:03, 16 July 2024 (UTC)
reply
- This can't be done with a sql query - interwiki links aren't in the main database, and jawiki is on a different database server than enwiki. Someone more familiar with
WP:PetScan than I might be able to get a result with it. Also worth asking at
d:WD:RAQ; they do have access to the interwikis over there, and I seem to recall there's a way to get at wikiproject ratings as well. —
Cryptic
17:13, 16 July 2024 (UTC)
reply
interwiki links aren't in the main database
- aren't they in
langlinks
?
* Pppery *
it has begun...
17:20, 16 July 2024 (UTC)
reply
- Erm. Wow. That's egg on my face. I'm sure I've looked for them before, and had thought that table went away when language links were migrated to Wikidata. Hang on. —
Cryptic
17:25, 16 July 2024 (UTC)
reply
-
quarry:query/84886. —
Cryptic
17:34, 16 July 2024 (UTC)
reply
- Amazing! Thank you so much Cryptic and Pppery!
Clayoquot (
talk |
contribs)
19:43, 16 July 2024 (UTC)
reply
Is it possible to find a list of changes to a category's members, that are older than RecentChanges? Asking for
Wikipedia:Categories for discussion/Log/2024 July 5#Category:Athletes by location in Greece. —
Qwerfjkl
talk
15:42, 17 July 2024 (UTC)
reply
- I'm pretty sure not, unless it was depopulated by a bot, or was old enough that you can find the cat page with the Wayback Machine. —
Cryptic
19:27, 17 July 2024 (UTC)
reply
Hello, I'd like a query for every file that use any of
these templates twice (the same template twice, not one usage of one template and one usage of another). For example
File:Madonna Frozen Sickick.png should be one of the results. Thanks!
Jonteemil (
talk)
13:47, 27 July 2024 (UTC)
reply
- Not possible with a query: the table showing transclusions doesn't have duplicates (it's the same one used to generate
Special:Whatlinkshere), and the replicas don't have the page text. Best I can think of is using search one template at a time,
like so. —
Cryptic
18:58, 27 July 2024 (UTC)
reply
Hi all, if possible, I'd like to request a list of any subcategories in
Category:Compositions by composer (which have more than 2 entries) in which there is no corresponding navigational box created for said composer's works.
So essentially, I'd be looking for categories like
Category:Compositions by Example Person which have more than 2 pages, but there is no corresponding
Template:Example Person that exists. I'd then go through the list and create the missing templates myself.
Thanks –
Aza24
(talk)
22:35, 28 July 2024 (UTC)
reply
-
quarry:query/85143. —
Cryptic
23:24, 28 July 2024 (UTC)
reply
- At least one false negative that I noticed by accident:
Category:Compositions by Dmitry Bortniansky isn't on the list despite
Template:Dmitry Bortniansky not existing, since it only has one member,
Category:Operas by Dmitry Bortniansky, even though that category has two members. Trivial to rerun the query without the minimum-number-of-members constraint, while still showing a count of members (and a list of the members' namespaces) if you want. —
Cryptic
23:31, 28 July 2024 (UTC)
reply
- Thank you so much @
Cryptic, that should work well. Question: will this link stick around or should I copy the results somewhere for my own use?
Aza24
(talk)
00:24, 29 July 2024 (UTC)
reply
- It'll stay in place (and the results won't change even when the underlying data here does). It would probably be convenient to copy it into a sandbox page, though, so you can click on the links directly. The cyan "Download data" dropdown has an option for wikitable format. —
Cryptic
00:29, 29 July 2024 (UTC)
reply
- Yes, good point! Thanks again.
Aza24
(talk)
04:28, 29 July 2024 (UTC)
reply