Dalībnieks:Edgars2007/SQL
- wikitech:Nova_Resource:Tools/Shared_Resources/MySQL_queries
- wikitech:Help:MySQL queries
- Special
- tables.sql
- tsreports
pl_from || pl_namespace || pl_title || pl_from_namespace 94069 0 Limbažu_viļņotais_līdzenums 10
- Izveidotie raksti pēc mēneša
- Īsākie nozīmīgie raksti
- Most used modules
- Raksti ar visvairāk saitēm no nozīmju atdalīšanas lapām
- Lielākās attēlu aprakstu lapas
- Īsākie raksti par Latvijas ievērojamākajām personām
- Miršanas gadu kateg. bez mirgads veidnes
- None
- None
- Pages containing an unusually high number of non-free files (lvwiki)
- lvwiki esošie attēli, kas Commons ir ar citu nosaukumu
- Edgars2007's testing area 2
- Edgars2007's testing area
- Small lvwiki articles not marked as stubs
- Most used modules in main namespace
- Category redirects without template
- lvwiki invalid navbar links
- Orphaned non-free files (Latvian Wikipedia)
- FRK iesniegti CEE raksti
- Visvairāk izmantotie aizsargātie attēli (lvwiki)
- None
- Commons files with local description page on lvwiki
- Files hiding Commons files (lvwiki)
- Non-free files used outside articles (lvwiki)
- Visvairāk labotie raksti Vikipēdijā latviešu valodā
- LVwiki aizsargātie Commons esošie faili
- Lvwiki articles with the longest title
- Usage statistics of editProtectedHelper
- Lietotāji ar visvairāk labojumiem, kas nav automātiskie pārbaudītāji
- Latvian Wikipedia users with most edits
- Most common thanker/thanked unordered pairs
- Most thanked Latvian Wikipedia editors
- Templates transcluded on the most pages (lvwiki)
- Visvairāk novēršanas
- Untitled query #3497
- Users with the most edits in last month
- Lietotāji ar visvairāk labojumiem
- Visvairāk saišu uz nozīmju atdalīšanas lapām
- Pāradresācijas uz ārējiem resursiem
- Untitled query #3038
- Raksti ar "izolēts raksts" veidni, kam ir vismaz viena saite
- Raksti ar visvairāk saitēm uz tiem?
- Untitled query #3003
- Rakstu/lietotāju lapas vienā kategorijā
- Orphaned talk pages (lvwiki)
- Ir ar iekavu, bet nav ar abām iekavām (Ir atverošās, bet nav aizverošo iekavu)
- Self-categorized categories (lvwiki)
- Redirects obscuring page content (lvwiki)
- New active users in Latvian Wikipedia
- Saites rakstos uz Vikipēdiju citās valodās
- Most frequent domains (Latvian Wikipedia)
- Testing
- Vecās smilšu kastes
- Latvian Wikiped Most common deletion summaries
- Lvwiki unexisting templates
- Latvian cross namespace redirects
- Most thankful Latvian Wikipedia editors
- Īsākās diskusiju lapas
- Largest lvwiki talk pages
- Self categorized categories
- Duplicate Wikipedia files (Latvian Wikipedia)
Citi potenciāli noderīgi[labot šo sadaļu | labot pirmkodu]
- Wrong Extension
- Double file extensions
- Zombie images
- Double file extensions|Give thanks
- Active editors fi >100
- Not used templates redirects on plwiki
- Sandboxes of anonymous users on plwiki
- Templates linking to disambiguation pages in Fa WP
- Templates linking to disambiguation pages in Fa WP (part 2)
- User pages with Infobox person template not edited by user
- Commons file pages linking to non-existing users
- (iswiki) Redirects to deleted pages
- Categorized article redirects in German Wikipedia
- Categories on English Wikipedia that are soft redirects
- Toolserver.org links on huwiki
- quarry:query/3846 vikidati/korejieši
- quarry:query/3654 Most linked disambiguation pages on Fa WP
- quarry:query/3268 Orphaned fair use images (en)
- quarry:query/2424 Hewiki redirections to red links
- quarry:query/2157 Hewiki unexisting templates
- quarry:query/3630 Commons file pages linking to non-existing users
- quarry:query/1203 Non-free files used outside articles
- quarry:query/3649 Empty categories in enwiki
- quarry:query/2888 Very big non-free files
- quarry:query/3644 Hewiki pictures many
- quarry:query/1943 Pages created by list of users and list of links
- quarry:query/2151 Pages with most deletions in cswiki
- quarry:query/2499 Hewiki wikipedia namespace suspicious pages
- quarry:query/3611 + quarry:query/3610 Modules on commons with wikitext page content
- quarry:query/3588 enwiki top articles with most revisions
- quarry:query/3585 Pages edited by a user from a specific time
- quarry:query/3568 Pages and first rev ts, number of rev for a set of wikipedians
- quarry:query/2679 Some non-free files used in articles about people
- quarry:query/2669 Non-free files with short file information pages
- quarry:query/3558 Top 1000 -Article Pages with most revisions(tewiki)
- quarry:query/3556 Featured article title,size,revisions of tewiki
- quarry:query/3550 Top contributors for main name space pages of a book
- quarry:query/3383 Possible stubs in cswiki
- quarry:query/3512 Edit quality (20k random sample, 2015) [enwiki]
- quarry:query/3529 Wikitrends-1 top edited pages
- Get page creation info for all pages in a category
- quarry:query/231 Pages ending in :
- quarry:query/237 Popular templates on English Wikipedia
--- varbūt atdalīt, cik linku ir uz lapām
- quarry:query/238 Top-500 most-interlinked pages
- quarry:query/252 Find pages ending in special characters, cont.
- quarry:query/310 Highly active new editors
- quarry:query/311 100 shortest articles on Swedish Wikipedia
- quarry:query/531 Most linked stubs on hu.wikipedia
- quarry:query/619 Users with highest number of unpatrolled edits (Commons)
- quarry:query/838 Commons files with no machine-readable authors that are used more than 20 times
- quarry:query/860 redirects with the most revisions
- quarry:query/1279 Why did you delete these items? (Get deleted items with incoming links.)
- quarry:query/1272 Files without a file information page
- quarry:query/2130 Hewiki articles without category
- quarry:query/2149 rowiki files with possible problems (short page content)
- quarry:query/2241 Users with >5 edits in December 2014 on Swedish Wikipedia
- quarry:query/2262 Hewiki unexisting categories
- quarry:query/2302 PNGs linked over 10,000 times on fr wikipedia
- quarry:query/2335 Most deleted articles on itwiki by title
- quarry:query/1694 Non-free files used on disambiguation pages
- quarry:query/2495 Extracting edit summaries of first revisions
- quarry:query/2443 query to find user pages which end in things like .com, .nl
- quarry:query/2560 Wiki Commons Uncategorized Images which are used in fawikipedia
- quarry:query/2771 Weird titles in enwiki mainspace
- quarry:query/2384 SVG maps from 2015-02 onwards used 4-10 times in the Spanish Wikipedia
- quarry:query/2639 List of articles about living people containing at least one fair use image
- quarry:query/2907 List of articles with excessive fair use images
- quarry:query/3117 List of fair use images used on several articles
- quarry:query/3374 File talk pages with no files
Vaicājumi, ko nedrīkst atļauties pazaudēt[labot šo sadaļu | labot pirmkodu]
USE lvwiki_p;
SELECT p.page_title, COUNT(t.tl_title) FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = '1800_births'
LEFT JOIN templatelinks t ON p.page_id = t.tl_from AND t.tl_namespace = 10 AND t.tl_title IN ('Reflist', 'Denmark-writer-stub')
GROUP BY p.page_title
ORDER BY COUNT(t.tl_title) DESC
LIMIT 5
Disambigi[labot šo sadaļu | labot pirmkodu]
USE lvwiki_p;
SELECT p.page_namespace, p.page_title, COUNT(pl.pl_from) FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = 'Nozīmju_atdalīšana'
# INNER skips pages whose link count is zero. Change INNER to LEFT on the line below if you also want to include those:
INNER JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
# This counts all links, including links from talk pages to disambiguation pages. If you only want to count
# links from the article namespace, then remove the # from the line below:
# AND pl.pl_from_namespace = 0
GROUP BY p.page_title
ORDER BY COUNT(pl.pl_from) DESC
USE lvwiki_p;
SELECT p.page_title, COUNT(pl.pl_from) FROM page p
INNER JOIN categorylinks c ON p.page_id = c.cl_from AND c.cl_to = 'Nozīmju_atdalīšana'
INNER JOIN pagelinks pl ON p.page_title = pl.pl_title AND p.page_namespace = pl.pl_namespace
AND pl.pl_from_namespace = 0 and p.page_namespace=0
GROUP BY p.page_title
ORDER BY COUNT(pl.pl_from) DESC
Saites uz pāradresācijām[labot šo sadaļu | labot pirmkodu]
SELECT pl.pl_namespace, pl.pl_title, count(pl.pl_from), pl.pl_from_namespace
from pagelinks pl
where pl.pl_namespace=0
and pl.pl_from_namespace=0
and /*pl.pl_from_namespace=0 and - svarīgi arī veidnēs izvākt*/ pl.pl_title in (SELECT p2.page_title
from pagelinks pl2
join page p2 on pl2.pl_from=p2.page_id
where p2.page_is_redirect=1 and pl2.pl_namespace=0
and pl2.pl_from_namespace=0
and /*pl2.pl_from_namespace=0 and - svarīgi arī veidnēs izvākt*/pl2.pl_title in (...)
)
group by pl.pl_title
order by count(pl.pl_from)