Query Library

Rank English Wikipedia articles by the length of their discussions

Viewing the first 20 of total 326 rows

Download Full Results
discussion_word_counttitleurl
28604Origin of the Romanianshttps://en.wikipedia.org/wiki/Talk:Origin_of_the_Romanians
19128Magdalene asylumhttps://en.wikipedia.org/wiki/Talk:Magdalene_asylum
15560Comparison of Pascal and Chttps://en.wikipedia.org/wiki/Talk:Comparison_of_Pascal_and_C
14816Spin–statistics theoremhttps://en.wikipedia.org/wiki/Talk:Spin%E2%80%93statistics_theorem
12903Empress Elisabeth of Austriahttps://en.wikipedia.org/wiki/Talk:Empress_Elisabeth_of_Austria
12546History of filmhttps://en.wikipedia.org/wiki/Talk:History_of_film
10182Financehttps://en.wikipedia.org/wiki/Talk:Finance
9892Net neutralityhttps://en.wikipedia.org/wiki/Talk:Net_neutrality
9319New Utopiahttps://en.wikipedia.org/wiki/Talk:New_Utopia
9286Aviation in World War Ihttps://en.wikipedia.org/wiki/Talk:Aviation_in_World_War_I
9197Louis de Brogliehttps://en.wikipedia.org/wiki/Talk:Louis_de_Broglie
8544Battle Cry Campaignhttps://en.wikipedia.org/wiki/Talk:Battle_Cry_Campaign
8366Dungeons & Dragons Onlinehttps://en.wikipedia.org/wiki/Talk:Dungeons_&_Dragons_Online
8099lonelygirl15https://en.wikipedia.org/wiki/Talk:Lonelygirl15
7480Scoliosishttps://en.wikipedia.org/wiki/Talk:Scoliosis
7415William Slim, 1st Viscount Slimhttps://en.wikipedia.org/wiki/Talk:William_Slim,_1st_Viscount_Slim
7261General aviationhttps://en.wikipedia.org/wiki/Talk:General_aviation
6947Internet Relay Chathttps://en.wikipedia.org/wiki/Talk:Internet_Relay_Chat
6594University of South Floridahttps://en.wikipedia.org/wiki/Talk:University_of_South_Florida
6555Lion's sharehttps://en.wikipedia.org/wiki/Talk:Lion's_share

Viewing the first 20 of total 326 rows

Download Full Results
Query
select
    cardinality(words(css_text_first(content, '#content'))) as discussion_word_count,
    remove_left(css_text_first(content, 'h1#firstHeading'), 'Talk:') as title,
    url
from 
    pages
where 
	url_domain = 'wikipedia.org' 
		and
	url like 'https://en.wikipedia.org/wiki/Talk:%' 
		and 
	url not like 'https://en.wikipedia.org/wiki/Talk:%/%'
order by discussion_word_count desc
Load in editor
Data scanned21.75 GB
Results28.14 KB (326 rows)

Turn the web into a database!

Mixnode is a fast, flexible and massively scalable platform to extract and analyze data from the web.

or contact us at hi@mixnode.com