MYSQL

SELECT * FROM bnc_bncs INNER JOIN words USING (wordid) ORDER BY freq DESC LIMIT 20

wordid	word	posid	freq	range	disp	word
12762	be	v	42277	100	0.98	be
64121	have	v	13655	100	0.97	have
39165	do	v	5594	100	0.92	do
118880	say	v	3344	100	0.92	say
59084	get	v	2210	100	0.87	get
83428	make	v	2165	100	0.98	make
60084	go	v	2078	100	0.91	go
120546	see	v	1920	100	0.95	see
76573	know	v	1882	100	0.9	know
137177	time	n	1833	100	0.98	time
133793	take	v	1797	100	0.98	take
150979	year	n	1639	100	0.96	year
136270	think	v	1520	100	0.9	think
28413	come	v	1512	100	0.94	come
59551	give	v	1284	100	0.98	give
60519	good	a	1276	100	0.97	good
101311	people	n	1256	100	0.95	people
92576	new	a	1154	100	0.95	new
81469	look	v	1151	100	0.92	look
147683	way	n	1108	100	0.97	way

SELECT * FROM bnc_bncs INNER JOIN words USING (wordid) WHERE posid = 'a' ORDER BY freq DESC LIMIT 20

wordid	word	posid	freq	range	disp	word
60519	good	a	1276	100	0.97	good
92576	new	a	1154	100	0.95	new
95561	old	a	648	100	0.95	old
61357	great	a	635	100	0.97	great
65751	high	a	574	100	0.96	high
125172	small	a	518	100	0.97	small
77820	large	a	471	100	0.95	large
81302	long	a	392	100	0.97	long
151302	young	a	379	100	0.96	young
115183	right	a	354	100	0.89	right
41390	early	a	353	100	0.95	early
14229	big	a	338	100	0.94	big
78019	late	a	302	100	0.97	late
53446	full	a	289	100	0.98	full
48508	far	a	288	100	0.96	far
81880	low	a	286	100	0.95	low
11130	bad	a	264	100	0.95	bad
132359	sure	a	241	100	0.92	sure
26669	clear	a	239	100	0.96	clear
79993	likely	a	228	100	0.95	likely

SELECT * FROM bnc_bncs INNER JOIN words USING (wordid) WHERE posid = 'n' ORDER BY freq DESC LIMIT 20

wordid	word	posid	freq	range	disp	word
137177	time	n	1833	100	0.98	time
150979	year	n	1639	100	0.96	year
101311	people	n	1256	100	0.95	people
147683	way	n	1108	100	0.97	way
83836	man	n	1003	100	0.95	man
34920	day	n	940	100	0.97	day
136260	thing	n	776	100	0.92	thing
24800	child	n	710	100	0.94	child
60784	government	n	670	100	0.88	government
150219	work	n	653	100	0.96	work
79745	life	n	645	100	0.96	life
149913	woman	n	631	100	0.95	woman
133413	system	n	619	100	0.89	system
22198	case	n	613	100	0.92	case
99934	part	n	612	100	0.97	part
62047	group	n	607	100	0.94	group
94488	number	n	606	100	0.95	number
150318	world	n	600	100	0.96	world
67453	house	n	598	100	0.95	house
7856	area	n	585	100	0.93	area

SELECT * FROM bnc_spwrs INNER JOIN words USING (wordid) WHERE posid = 'n' ORDER BY freq1 DESC LIMIT 20

wordid	word	posid	freq1	range1	disp1	freq2	range2	disp2	ll	word
136260	thing	n	2240	10	0.96	607	90	0.94	-22464.9	thing
137177	time	n	2103	10	0.95	1802	90	0.98	-439.7	time
101311	people	n	2071	10	0.87	1162	90	0.96	-5231.4	people
150979	year	n	1507	10	0.9	1655	90	0.95	126.9	year
147683	way	n	1358	10	0.95	1079	90	0.97	-614.7	way
34920	day	n	1064	10	0.94	926	90	0.97	-181.8	day
67878	hundred	n	1053	10	0.81	136	90	0.89	-20229.9	hundred
81666	lot	n	992	10	0.91	160	90	0.95	-16310.8	lot
106677	pound	n	899	10	0.85	101	90	0.75	-18746.4	pound
147904	week	n	829	10	0.93	435	90	0.94	-2548.1	week
126612	sort	n	800	10	0.89	163	90	0.95	-10829.2	sort
14864	bit	n	747	10	0.91	104	90	0.92	-13606.8	bit
105215	point	n	747	10	0.79	454	90	0.96	-1441.9	point
94488	number	n	638	10	0.87	602	90	0.95	-20.1	number
88809	money	n	637	10	0.96	345	90	0.95	-1799.1	money
83836	man	n	629	10	0.89	1047	90	0.94	1843.7	man
150219	work	n	601	10	0.92	659	90	0.95	48.8	work
108037	problem	n	568	10	0.83	564	90	0.95	-0.2	problem
67453	house	n	557	10	0.92	602	90	0.95	33.1	house
136548	thousand	n	553	10	0.83	113	90	0.9	-7468	thousand

SELECT * FROM bnc_spwrs INNER JOIN words USING (wordid) WHERE posid = 'n' ORDER BY freq2 DESC LIMIT 20

wordid	word	posid	freq1	range1	disp1	freq2	range2	disp2	ll	word
137177	time	n	2103	10	0.95	1802	90	0.98	-439.7	time
150979	year	n	1507	10	0.9	1655	90	0.95	126.9	year
101311	people	n	2071	10	0.87	1162	90	0.96	-5231.4	people
147683	way	n	1358	10	0.95	1079	90	0.97	-614.7	way
83836	man	n	629	10	0.89	1047	90	0.94	1843.7	man
34920	day	n	1064	10	0.94	926	90	0.97	-181.8	day
24800	child	n	497	10	0.82	734	90	0.94	814.5	child
60784	government	n	312	10	0.7	711	90	0.87	2707.2	government
79745	life	n	333	10	0.87	681	90	0.97	2081	life
133413	system	n	232	10	0.76	664	90	0.89	3582.9	system
149913	woman	n	371	10	0.81	661	90	0.94	1434.8	woman
150219	work	n	601	10	0.92	659	90	0.95	48.8	work
22198	case	n	314	10	0.8	648	90	0.92	2028.3	case
150318	world	n	250	10	0.81	640	90	0.96	2954.6	world
62047	group	n	334	10	0.79	639	90	0.94	1670.1	group
99934	part	n	418	10	0.85	635	90	0.97	791.6	part
28995	company	n	232	10	0.78	620	90	0.91	3051.4	company
136260	thing	n	2240	10	0.96	607	90	0.94	-22464.9	thing
67453	house	n	557	10	0.92	602	90	0.95	33.1	house
94488	number	n	638	10	0.87	602	90	0.95	-20.1	number