MYSQL

SELECT ssensenum,sw.lemma,link,dw.lemma AS linkedlemma,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXsemlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid LEFT JOIN linktypes USING (linkid) WHERE sw.lemma = 'horse' ORDER BY linkid,ssensenum

ssensenum	lemma	link	linkedlemma	SUBSTRING(sdefinition FROM 1 FOR 60)
1	horse	hypernym	cater	provide with a horse or horses
1	horse	hypernym	ply	provide with a horse or horses
1	horse	hypernym	equid	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hypernym	provide	provide with a horse or horses
1	horse	hypernym	equine	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hypernym	supply	provide with a horse or horses
2	horse	hypernym	gymnastic apparatus	a padded gymnastic apparatus on legs
2	horse	hypernym	exerciser	a padded gymnastic apparatus on legs
3	horse	hypernym	soldiery	troops trained to fight on horseback
3	horse	hypernym	troops	troops trained to fight on horseback
3	horse	hypernym	military personnel	troops trained to fight on horseback
4	horse	hypernym	framework	a framework for holding wood that is being sawed
5	horse	hypernym	chess piece	a chessman shaped to resemble the head of a horse; can move
5	horse	hypernym	chessman	a chessman shaped to resemble the head of a horse; can move
1	horse	hyponym	poster	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	hack	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	gee-gee	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	chestnut	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	plug	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	protohippus	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	palomino	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	racehorse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	remount	provide with a horse or horses
1	horse	hyponym	mare	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	workhorse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	pony	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	roan	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	pacer	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	hack	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	dawn horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	liver chestnut	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	pony	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	pinto	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	steeplechaser	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	mount	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	post-horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	polo pony	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	stable companion	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	high stepper	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	jade	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	eohippus	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	bay	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	bangtail	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	male horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	stalking-horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	riding horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	post horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	wild horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	stablemate	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	stepper	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	nag	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	mesohippus	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	sorrel	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	race horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	female horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	harness horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hyponym	saddle horse	solid-hoofed herbivorous quadruped domesticated since prehis
2	horse	hyponym	buck	a padded gymnastic apparatus on legs
2	horse	hyponym	long horse	a padded gymnastic apparatus on legs
2	horse	hyponym	pommel horse	a padded gymnastic apparatus on legs
2	horse	hyponym	vaulting horse	a padded gymnastic apparatus on legs
2	horse	hyponym	side horse	a padded gymnastic apparatus on legs
4	horse	hyponym	trestle	a framework for holding wood that is being sawed
1	horse	part holonym	poll	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	part holonym	encolure	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	part holonym	horseflesh	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	part holonym	withers	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	part holonym	horseback	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	part holonym	horsemeat	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	part holonym	gaskin	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	part holonym	horse's foot	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	member holonym	foal	solid-hoofed herbivorous quadruped domesticated since prehis
3	horse	member holonym	trooper	troops trained to fight on horseback
3	horse	member holonym	cavalryman	troops trained to fight on horseback
1	horse	member meronym	genus equus	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	member meronym	equus	solid-hoofed herbivorous quadruped domesticated since prehis
3	horse	domain category	military	troops trained to fight on horseback
3	horse	domain category	military machine	troops trained to fight on horseback
3	horse	domain category	armed forces	troops trained to fight on horseback
3	horse	domain category	war machine	troops trained to fight on horseback
3	horse	domain category	armed services	troops trained to fight on horseback
5	horse	domain category	chess	a chessman shaped to resemble the head of a horse; can move
5	horse	domain category	chess game	a chessman shaped to resemble the head of a horse; can move

SELECT ssensenum,sw.lemma,dw.lemma AS hypernym,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXsemlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid WHERE sw.lemma = 'horse' AND linkid=1 AND spos='n' ORDER BY ssensenum

ssensenum	lemma	hypernym	SUBSTRING(sdefinition FROM 1 FOR 60)
1	horse	equid	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	equine	solid-hoofed herbivorous quadruped domesticated since prehis
2	horse	exerciser	a padded gymnastic apparatus on legs
2	horse	gymnastic apparatus	a padded gymnastic apparatus on legs
3	horse	military personnel	troops trained to fight on horseback
3	horse	soldiery	troops trained to fight on horseback
3	horse	troops	troops trained to fight on horseback
4	horse	framework	a framework for holding wood that is being sawed
5	horse	chess piece	a chessman shaped to resemble the head of a horse; can move
5	horse	chessman	a chessman shaped to resemble the head of a horse; can move

SELECT ssensenum,sw.lemma,dw.lemma AS hyponym,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXsemlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid WHERE sw.lemma = 'horse' AND linkid=2 AND spos='n' ORDER BY ssensenum

ssensenum	lemma	hyponym	SUBSTRING(sdefinition FROM 1 FOR 60)
1	horse	roan	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	stable companion	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	stablemate	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	gee-gee	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	dawn horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	eohippus	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	mesohippus	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	protohippus	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	male horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	female horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	mare	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	mount	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	riding horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	saddle horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	pony	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	polo pony	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	wild horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hack	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	hack	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	jade	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	nag	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	plug	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	pony	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	bangtail	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	race horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	racehorse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	steeplechaser	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	stalking-horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	harness horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	workhorse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	post-horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	post horse	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	poster	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	pacer	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	high stepper	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	stepper	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	chestnut	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	liver chestnut	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	bay	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	sorrel	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	palomino	solid-hoofed herbivorous quadruped domesticated since prehis
1	horse	pinto	solid-hoofed herbivorous quadruped domesticated since prehis
2	horse	pommel horse	a padded gymnastic apparatus on legs
2	horse	side horse	a padded gymnastic apparatus on legs
2	horse	buck	a padded gymnastic apparatus on legs
2	horse	long horse	a padded gymnastic apparatus on legs
2	horse	vaulting horse	a padded gymnastic apparatus on legs
4	horse	trestle	a framework for holding wood that is being sawed

SELECT ssensenum,sw.lemma,link,dw.lemma AS linked,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXlexlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid LEFT JOIN linktypes USING (linkid) WHERE sw.lemma = 'black' ORDER BY linkid,ssensenum

ssensenum	lemma	link	linked	SUBSTRING(sdefinition FROM 1 FOR 60)
1	black	antonym	white	being of the achromatic color of maximum darkness; having li
1	black	antonym	white	the quality or state of the achromatic color of least lightn
2	black	antonym	white	of or belonging to a racial group having dark skin especiall
6	black	antonym	white	(board games) the darker pieces
1	black	derivation	black	the quality or state of the achromatic color of least lightn
1	black	derivation	blackness	being of the achromatic color of maximum darkness; having li
1	black	derivation	black	make or become black
8	black	derivation	blackness	extremely dark
13	black	derivation	blackness	(of coffee) without cream or sugar
14	black	derivation	blackness	soiled with dirt or soot

SELECT ssensenum,sw.lemma,dw.lemma AS antonym,SUBSTRING(sdefinition FROM 1 FOR 60) FROM sensesXlexlinksXsenses AS l LEFT JOIN words AS sw ON l.swordid = sw.wordid LEFT JOIN words AS dw ON l.dwordid = dw.wordid WHERE sw.lemma = 'black' AND linkid=30 AND spos='a' ORDER BY ssensenum

ssensenum	lemma	antonym	SUBSTRING(sdefinition FROM 1 FOR 60)
1	black	white	being of the achromatic color of maximum darkness; having li
2	black	white	of or belonging to a racial group having dark skin especiall

SELECT lemma,sensenum,synsetid FROM wordsXsenses WHERE lemma='option' ORDER BY sensenum

lemma	sensenum	synsetid
option	1	113241600
option	2	105790944
option	3	100161243

SELECT lemma,sensenum,synsetid,pos,SUBSTRING(definition FROM 1 FOR 60) FROM wordsXsensesXsynsets WHERE lemma='option' ORDER BY sensenum

lemma	sensenum	synsetid	pos	SUBSTRING(definition FROM 1 FOR 60)
option	1	113241600	n	the right to buy or sell property at an agreed price; the ri
option	2	105790944	n	one of a number of things from which only one can be chosen
option	3	100161243	n	the act of choosing or selecting

SELECT synsetid,lemma FROM wordsXsensesXsynsets WHERE synsetid = 100161243

synsetid	lemma
100161243	choice
100161243	option
100161243	pick
100161243	selection

SELECT synsetid,GROUP_CONCAT(lemma) FROM wordsXsensesXsynsets WHERE synsetid = 100161243 GROUP BY synsetid

synsetid	GROUP_CONCAT(lemma)
100161243	choice,option,pick,selection

SELECT synsetid,lemma FROM wordsXsensesXsynsets WHERE lemma = 'option'

synsetid	lemma
100161243	option
105790944	option
113241600	option

SELECT synsetid,dest.lemma,SUBSTRING(src.definition FROM 1 FOR 60) FROM wordsXsensesXsynsets AS src INNER JOIN wordsXsensesXsynsets AS dest USING(synsetid) WHERE src.lemma = 'option' AND dest.lemma <> 'option'

synsetid	lemma	SUBSTRING(src.definition FROM 1 FOR 60)
100161243	choice	the act of choosing or selecting
100161243	pick	the act of choosing or selecting
100161243	selection	the act of choosing or selecting
105790944	alternative	one of a number of things from which only one can be chosen
105790944	choice	one of a number of things from which only one can be chosen

SELECT synsetid,lemma,SUBSTRING(definition FROM 1 FOR 60) FROM wordsXsensesXsynsets WHERE synsetid IN ( SELECT synsetid FROM wordsXsensesXsynsets WHERE lemma = 'option') AND lemma <> 'option' ORDER BY synsetid

synsetid	lemma	SUBSTRING(definition FROM 1 FOR 60)
100161243	choice	the act of choosing or selecting
100161243	selection	the act of choosing or selecting
100161243	pick	the act of choosing or selecting
105790944	alternative	one of a number of things from which only one can be chosen
105790944	choice	one of a number of things from which only one can be chosen