MYSQL

SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy20 where ssynsetid=100124550

SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy20 where dsynsetid=100130045

SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 where dsynsetid=100130045

SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 where dsynsetid=102690270

lemma	quality	ssynsetid	dsynsetid	ssensekey	dsensekey	SUBSTRING(definition FROM 1 FOR 32)
air hose	100	102665619	102690270	air_hose%1:06:00::	air_hose%1:06:00::	a hose that carries air under pr
airline	100	102665619	102690270	airline%1:06:01::	airline%1:06:01::	a hose that carries air under pr

SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE lemma='abase' ORDER BY ssensekey

lemma	quality	ssynsetid	dsynsetid	ssensekey	dsensekey	SUBSTRING(definition FROM 1 FOR 32)
abase	100	201782644	201799794	abase%2:37:00::	abase%2:37:00::	cause to feel shame; hurt the pr

SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE lemma='afford' ORDER BY ssensekey

lemma	quality	ssynsetid	dsynsetid	ssensekey	dsensekey	SUBSTRING(definition FROM 1 FOR 32)
afford	100	201181406	201192628	afford%2:34:00::	afford%2:34:00::	be able to spare or give up
afford	100	202316932	202339171	afford%2:40:00::	afford%2:40:00::	be the cause or source of
afford	70	202335639	202358034	afford%2:40:01::	afford%2:40:01::	afford access to
afford	70	202335639	202744451	afford%2:40:01::	afford%2:42:00::	have the financial means to do s
afford	100	202719910	202744451	afford%2:42:00::	afford%2:42:00::	have the financial means to do s

SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy20 WHERE ssensekey LIKE 'want\%%'

SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE dsynsetid=100002137 ORDER BY ssensekey

lemma	quality	ssynsetid	dsynsetid	ssensekey	dsensekey	SUBSTRING(definition FROM 1 FOR 32)
abstraction	80	100002236	100002137	abstraction%1:03:00::	abstraction%1:03:00::	a general concept formed by extr
abstract entity	100	100002119	100002137	abstract_entity%1:03:00::	abstract_entity%1:03:00::	a general concept formed by extr

SELECT quality,synsetid2,synsetid,SUBSTRING(definition FROM 1 FOR 32) FROM synsetmaps2130 INNER JOIN synsets USING (synsetid) WHERE synsetid=100002137

quality	synsetid2	synsetid	SUBSTRING(definition FROM 1 FOR 32)
37	100002119	100002137	a general concept formed by extr
100	100002119	100002137	a general concept formed by extr
62	100002236	100002137	a general concept formed by extr
100	100002236	100002137	a general concept formed by extr

SELECT lemma,quality,ssynsetid,dsynsetid,ssensekey,dsensekey,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE ssynsetid=100019102 ORDER BY ssensekey

lemma	quality	ssynsetid	dsynsetid	ssensekey	dsensekey	SUBSTRING(definition FROM 1 FOR 32)
matter	90	100019102	100020827	matter%1:03:00::	matter%1:03:00::	that which has mass and occupies
substance	80	100019102	100019613	substance%1:03:00::	substance%1:03:00::	the real physical matter of whic

SELECT quality,synsetid2,synsetid,SUBSTRING(definition FROM 1 FOR 32) FROM synsetmaps2130 INNER JOIN synsets USING (synsetid) WHERE synsetid2=100019102

quality	synsetid2	synsetid	SUBSTRING(definition FROM 1 FOR 32)
100	100019102	100020827	that which has mass and occupies
100	100019102	100019613	the real physical matter of whic
100	100019102	100020090	a particular kind or species of
100	100019102	114580597	material of a particular kind or

SELECT quality,ssynsetid,dsynsetid,SUBSTRING(definition FROM 1 FOR 32) FROM legacy21 WHERE dsynsetid=202358034

quality	ssynsetid	dsynsetid	SUBSTRING(definition FROM 1 FOR 32)
100	202335639	202358034	afford access to
100	202335639	202358034	afford access to
70	202335639	202358034	afford access to

SELECT sensekey,SUBSTRING(definition FROM 1 FOR 64) FROM senses INNER JOIN synsets USING (synsetid) WHERE sensekey LIKE 'james\%%'

sensekey	SUBSTRING(definition FROM 1 FOR 64)
james%1:10:00::	a New Testament book attributed to Saint James the Apostle
james%1:17:00::	a river that rises in North Dakota and flows southward across So
james%1:17:01::	a river in Virginia that flows east into Chesapeake Bay at Hampt
james%1:18:00::	(New Testament) disciple of Jesus; brother of John; author of th
james%1:18:01::	writer who was born in the United States but lived in England (1
james%1:18:02::	United States pragmatic philosopher and psychologist (1842-1910)
james%1:18:03::	United States outlaw who fought as a Confederate soldier and lat
james%1:18:04::	the first Stuart to be king of England and Ireland from 1603 to
james%1:18:05::	the last Stuart to be king of England and Ireland and Scotland;
james%1:18:06::	a Stuart king of Scotland who married a daughter of Henry VII; w