Archives | |
---|---|
| |
Threads older than 14 days may be archived. |
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.
Table schemas are available here.
Contents
Redirects to fr:
I am seeking an alphabetical list of all pages in the mainspace that redirect to a target at fr: if possible. Cryptic helped me with a similar request; I tried to adjust that code and run it myself to no avail. — Godsy (TALKCONT) 04:13, 13 August 2018 (UTC)
- Adding fr: to the SELECT clause at the top just changes what gets displayed in the output; you're still asking for redirect targets in the Special: namespace (WHERE rd_namespace = -1). You'd want something like
WHERE rd_title 'fr:%'
instead, if they got stored normally, but they apparently don't - there's a rd_interwiki column, from many many years ago before following hard redirects to other wikis was disabled. Querying forWHERE rd_interwiki != ''
finds only one such page, User:Thryduulf/R to other wiki.Soft redirects, as before, can't be easily queried for. The same sort of workaround I tried before is at quarry:query/28941. —Cryptic 05:14, 13 August 2018 (UTC)
Articles without WikiProject on talk page
Per a request at Wikipedia:Help desk#articles without talk pages I created a quarry query. The results can be pasted into a sandbox page and previewed to have wikilinks to the articles. --Bamyers99 (talk) 22:02, 6 December 2018 (UTC)
All articles in two categories (including subcategories)
Hi! I'd much appreciate any help running a query that finds all articles that are in both Category:European novels (including subcategories) and Category:Young adult novels (including subcategories). Thank you. /212.112.188.253 (talk) 16:42, 8 February 2019 (UTC)
- This sounds like a job for Petscan. —Cryptic 05:40, 9 February 2019 (UTC)
- I agree. You may have to increase the "depth" so that you get all "real" subcategories without false positives such as The Boy Sherlock Holmes. Certes (talk) 11:02, 9 February 2019 (UTC)
Populated places in Austria
I'd like to request a list of the complete contents of the Category:Populated places in Austria tree (inclusive of subcategories) as of February 20. It can be saved to my sandbox, or wherever else such dump reports get saved if there's a standard process for that.
There's a discussion at Wikipedia:Village_pump_(technical)#Populated_places_in_Austria if you need the background context on what happened, but since that discussion exists I don't think it's necessary to repeat the whole story.
Thanks. Bearcat (talk) 16:57, 5 May 2019 (UTC)
- That sounds like an easy job for PetScan, but it gets harder if you want to exclude subcategories which are not about settlements, such as Category:Buildings and structures in Eisenstadt and Category:People from Güssing. Certes (talk) 00:00, 6 May 2019 (UTC)
- Generating a full category tree is problematic in all but the simplest cases. Would a list of the pages that (directly) transcluded {{Infobox Town AT}} and the categories those were in be sufficient? —Cryptic 02:41, 6 May 2019 (UTC)
- Another alternative is Wikidata, which you can query with SPARQL (tutorial). This WDQS query may be what you need. (Click the white triangle on blue, bottom left, to run it). Of course, this tells you what Wikidata thinks is an Austrian settlement with a Wikipedia article, not which articles Wikipedia has categorised as Austrian settlements. Certes (talk) 11:42, 6 May 2019 (UTC)