Wikipedia:Request a query

  (Redirected from Wikipedia:SQL query requests)

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.

Medical external links surveyEdit

  Moved from WP:BOTREQ
  Moved to WP:BOTREQ

Typos in linksEdit

Coming from here, I'd like a query for mainspace pages that link to pages that transclude {{R from misspelling}}. Any ideas on how to do that? {{u|Sdkb}}talk 07:00, 22 September 2020 (UTC)

quarry:query/48390SD0001 (talk) 10:45, 22 September 2020 (UTC)
I see now Wikipedia:Database reports/Linked misspellings exists. – SD0001 (talk) 19:42, 23 September 2020 (UTC)
SD0001, thanks for putting together the quarry! There appear to be surprisingly few instances, which leads me to think that someone somewhere has been handling this. {{u|Sdkb}}talk 20:15, 23 September 2020 (UTC)

Most-viewed non-vital pagesEdit

I'm interested in identifying potential candidates for WikiProject Vital Articles. Would it be possible to run a query that identifies the pages with the most views over the past year that do not have their talk pages categorized in Category:Wikipedia vital articles or any of its subcategories? {{u|Sdkb}}talk 23:47, 24 September 2020 (UTC)

@Sdkb:   Done https://public.paws.wmcloud.org/User:AntiCompositeBot/NonVitalViews.ipynb Out of the top 500 most-viewed articles in 2019, 236 are not vital articles at any level. --AntiCompositeNumber (talk) 00:39, 25 September 2020 (UTC)
Thanks! Whew, that's a lot of pop culture pages haha. {{u|Sdkb}}talk 02:07, 25 September 2020 (UTC)

Articles by number of <ref></ref> tagsEdit

Hello, and this may not be the best place for this question, but I'm looking for a way to get a list of all pages with 9 or fewer ref tags. Dawnseeker2000 15:13, 5 October 2020 (UTC)