MYSQL

SELECT COUNT(*) FROM fn_corpuses

COUNT(*)
13

SELECT COUNT(*) FROM fn_documents

COUNT(*)
3429

SELECT corpus,COUNT(*) FROM fn_corpuses LEFT JOIN fn_documents USING (corpusid) GROUP BY corpusid ORDER BY corpus

corpus	COUNT(*)
ANC	21
ANC_r	392
AP	1484
BNC2	1312
BNC2_cxn	1
KBEval	9
LUCorpus-v0.3	22
MASC	114
Miscellaneous	11
NTI	20
NYTIMES	19
PropBank	6
WikiTexts	18

SELECT d.corpusid,s.corpusid,documentdesc,COUNT(*) AS c FROM fn_documents AS d LEFT JOIN fn_sentences AS s USING (documentid) GROUP BY documentid,documentdesc,d.corpusid,s.corpusid,documentdesc ORDER BY c DESC LIMIT 20

corpusid	documentdesc	c
100	apwsE980303.0902	34147
100	apwsE980413.0662	337
100	apwsE980415.0089	1
175	Examples4-5	1
100	apwsE980303.0199	1
100	apwsE980414.0470	1
100	apwsE980422.0443	1
100	apwsE980406.0512	1
100	apwsE980418.0347	1
100	apwsE980407.0152	1
100	apwsE980417.0615	1
100	apwsE980305.0005	1
100	apwsE980305.0025	1
175	This is a 5-sentence news story about alleged White House gunman Robert Pickett.	1
100	apwsE980408.0184	1
100	apwsE980314.0155	1
100	apwsE980330.0395	1
100	apwsE980402.0285	1
100	apwsE980403.0662	1
100	apwsE980312.0584	1

SELECT corpus,SUM(c) AS nsentences,COUNT(documentdesc) AS ndocuments,SUBSTRING(GROUP_CONCAT(documentdesc ORDER BY documentdesc),1,80) FROM ( SELECT d.corpusid,documentdesc,COUNT(*) AS c FROM fn_documents AS d LEFT JOIN fn_sentences AS s USING (documentid) GROUP BY documentid ) AS s LEFT JOIN fn_corpuses USING (corpusid) GROUP BY s.corpusid ORDER BY nsentences DESC

corpus	nsentences	ndocuments	SUBSTRING(GROUP_CONCAT(documentdesc ORDER BY documentdesc),1,80)
NYTIMES	34501	19	apwsE980302.0253,apwsE980303.0199,apwsE980303.0902,apwsE980305.0005,apwsE980305.
AP	1484	1484	apwsE941111.0319,apwsE941111.0431,apwsE941112.0096,apwsE941113.0042,apwsE941113.
BNC2	1312	1312	bncp,bncp=10,bncp=1000,bncp=1002,bncp=1003,bncp=1004,bncp=1015,bncp=1017,bncp=10
ANC_r	392	392	anc,written_1%fiction%eggan%TheStory,written_1%fiction%hargrave%dmecomplete%DME0
MASC	114	114	Examples of the lemma able from the MASC project for FN annotation,Examples of t
LUCorpus-v0.3	22	22	20000410_nyt-NEW,20000415_apw_eng-NEW,20000416_xin_eng-NEW,20000419_apw_eng-NEW,
ANC	21	21	Berlitz History of Greece,Berlitz History of Jerusalem,Berlitz History of Las Ve
NTI	20	20	B W Tutorial chapter1,China Overview,Iran Biological,Iran Chemical,Iran Introduc
WikiTexts	18	18	acquisition.n,boutique.n,extent.n,Fires_1,Fires_10,Fires_2,Fires_3,Fires_4,Fires
Miscellaneous	11	11	C-4 Text,Chapter 14 of The Hound of the Baskervilles,Examples4-5,Hijack,Iran-rel
KBEval	9	9	atm,Brandeis,cycorp,LCC-M,lcch,MIT,parc,Stanford,utd-icsi
PropBank	6	6	Aetna Life and Casualty,Bell Ringing,Election Victory,Loma Prieta,Polemic Progre
BNC2_cxn	1	1	rate.speed_080313