MYSQL

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

wordid	pos	freq	range	disp	lemma
12320	v	42277	100	0.98	be
62318	v	13655	100	0.97	have
38006	v	5594	100	0.92	do
115291	v	3344	100	0.92	say
57446	v	2210	100	0.87	get
80925	v	2165	100	0.98	make
58418	v	2078	100	0.91	go
116926	v	1920	100	0.95	see
74296	v	1882	100	0.9	know
133078	n	1833	100	0.98	time
129777	v	1797	100	0.98	take
146521	n	1639	100	0.96	year
132195	v	1520	100	0.9	think
27533	v	1512	100	0.94	come
57893	v	1284	100	0.98	give
58843	a	1276	100	0.97	good
98216	n	1256	100	0.95	people
89722	a	1154	100	0.95	new
79040	v	1151	100	0.92	look
143325	n	1108	100	0.97	way

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

wordid	pos	freq	range	disp	lemma
58843	a	1276	100	0.97	good
89722	a	1154	100	0.95	new
92630	a	648	100	0.95	old
59656	a	635	100	0.97	great
63886	a	574	100	0.96	high
121401	a	518	100	0.97	small
75484	a	471	100	0.95	large
78882	a	392	100	0.97	long
146831	a	379	100	0.96	young
111701	a	354	100	0.89	right
40159	a	353	100	0.95	early
13752	a	338	100	0.94	big
75681	a	302	100	0.97	late
51872	a	289	100	0.98	full
47080	a	288	100	0.96	far
79432	a	286	100	0.95	low
10777	a	264	100	0.95	bad
128393	a	241	100	0.92	sure
25825	a	239	100	0.96	clear
77610	a	228	100	0.95	likely

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

wordid	pos	freq	range	disp	lemma
133078	n	1833	100	0.98	time
146521	n	1639	100	0.96	year
98216	n	1256	100	0.95	people
143325	n	1108	100	0.97	way
81318	n	1003	100	0.95	man
33852	n	940	100	0.97	day
132185	n	776	100	0.92	thing
24010	n	710	100	0.94	child
87206	n	673	100	0.84	mr
59100	n	670	100	0.88	government
145783	n	653	100	0.96	work
77376	n	645	100	0.96	life
145482	n	631	100	0.95	woman
129414	n	619	100	0.89	system
21507	n	613	100	0.92	case
96883	n	612	100	0.97	part
60327	n	607	100	0.94	group
91583	n	606	100	0.95	number
145880	n	600	100	0.96	world
65540	n	598	100	0.95	house

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

wordid	pos	freq1	range1	disp1	freq2	range2	disp2	ll	lemma
132185	n	2240	10	0.96	607	90	0.94	-22464.9	thing
133078	n	2103	10	0.95	1802	90	0.98	-439.7	time
98216	n	2071	10	0.87	1162	90	0.96	-5231.4	people
146521	n	1507	10	0.9	1655	90	0.95	126.9	year
143325	n	1358	10	0.95	1079	90	0.97	-614.7	way
33852	n	1064	10	0.94	926	90	0.97	-181.8	day
65957	n	1053	10	0.81	136	90	0.89	-20229.9	hundred
103393	n	899	10	0.85	101	90	0.75	-18746.4	pound
143538	n	829	10	0.93	435	90	0.94	-2548.1	week
122793	n	800	10	0.89	163	90	0.95	-10829.2	sort
102024	n	747	10	0.79	454	90	0.96	-1441.9	point
91583	n	638	10	0.87	602	90	0.95	-20.1	number
86098	n	637	10	0.96	345	90	0.95	-1799.1	money
81318	n	629	10	0.89	1047	90	0.94	1843.7	man
145783	n	601	10	0.92	659	90	0.95	48.8	work
87206	n	570	10	0.66	685	90	0.83	190.2	mr
104721	n	568	10	0.83	564	90	0.95	-0.2	problem
65540	n	557	10	0.92	602	90	0.95	33.1	house
132464	n	553	10	0.83	113	90	0.9	-7468	thousand
115711	n	549	10	0.87	527	90	0.93	-8.7	school

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

wordid	pos	freq1	range1	disp1	freq2	range2	disp2	ll	lemma
133078	n	2103	10	0.95	1802	90	0.98	-439.7	time
146521	n	1507	10	0.9	1655	90	0.95	126.9	year
98216	n	2071	10	0.87	1162	90	0.96	-5231.4	people
143325	n	1358	10	0.95	1079	90	0.97	-614.7	way
81318	n	629	10	0.89	1047	90	0.94	1843.7	man
33852	n	1064	10	0.94	926	90	0.97	-181.8	day
24010	n	497	10	0.82	734	90	0.94	814.5	child
59100	n	312	10	0.7	711	90	0.87	2707.2	government
87206	n	570	10	0.66	685	90	0.83	190.2	mr
77376	n	333	10	0.87	681	90	0.97	2081	life
129414	n	232	10	0.76	664	90	0.89	3582.9	system
145482	n	371	10	0.81	661	90	0.94	1434.8	woman
145783	n	601	10	0.92	659	90	0.95	48.8	work
21507	n	314	10	0.8	648	90	0.92	2028.3	case
145880	n	250	10	0.81	640	90	0.96	2954.6	world
60327	n	334	10	0.79	639	90	0.94	1670.1	group
96883	n	418	10	0.85	635	90	0.97	791.6	part
28106	n	232	10	0.78	620	90	0.91	3051.4	company
132185	n	2240	10	0.96	607	90	0.94	-22464.9	thing
91583	n	638	10	0.87	602	90	0.95	-20.1	number