MYSQL

SELECT * FROM relations ORDER BY relationid

relationid	relation	recurses
1	hypernym	1
2	hyponym	1
3	instance hypernym	1
4	instance hyponym	1
11	part holonym	1
12	part meronym	1
13	member holonym	1
14	member meronym	1
15	substance holonym	1
16	substance meronym	1
21	entails	1
22	is entailed by	1
23	causes	1
24	is caused by	1
30	antonym	0
40	similar	0
50	also	0
60	attribute	0
70	verb group	0
71	participle	0
80	pertainym	0
81	derivation	0
91	domain topic	0
92	domain member topic	0
93	domain region	0
94	domain member region	0
95	exemplifies	0
96	is exemplified by	0
97	domain	0
98	member	0
99	other	0

SELECT relation, COUNT(*) FROM semrelations LEFT JOIN relations USING(relationid) GROUP BY relationid ORDER BY relationid

relation	COUNT(*)
hypernym	91550
hyponym	91550
instance hypernym	8590
instance hyponym	8590
part holonym	9199
part meronym	9199
member holonym	12296
member meronym	12296
substance holonym	830
substance meronym	830
entails	408
is entailed by	408
causes	221
is caused by	221
similar	23184
also	2730
attribute	1278
domain topic	6716
domain member topic	6716
domain region	1355
domain member region	1355
exemplifies	995
is exemplified by	995

SELECT synset1id, COUNT(*) AS c, definition FROM semrelations LEFT JOIN synsets AS s ON (s.synsetid = synset1id) GROUP BY synset1id ORDER BY c DESC LIMIT 5

synset1id	c	definition
81901	671	a large and densely populated urban area; may include several independent administrative districts
81534	613	the collection of rules imposed by authority
83427	528	a monarchy in northwestern Europe occupying most of the British Isles; divided into England and Scotland and Wales and Northern Ireland; `Great Britain' is often used loosely to refer to the United Kingdom
121	421	a human being; person, singular, assertive existential pronoun; pronoun, person, singular; quantifier: assertive existential
2580	402	cause to change; make different; cause a transformation

SELECT sy1.synsetid,sy1.definition,relation,COUNT(relation) FROM semrelations LEFT JOIN synsets AS sy1 ON (sy1.synsetid = synset1id) LEFT JOIN relations USING (relationid) WHERE sy1.synsetid = 6 GROUP BY relationid

synsetid	definition	relation	COUNT(relation)
6	an entity that has physical existence	hypernym	1
6	an entity that has physical existence	hyponym	6

SELECT w1.word,sy1.definition,relation,GROUP_CONCAT(w2.word),sy2.definition FROM semrelations LEFT JOIN synsets AS sy1 ON (sy1.synsetid = synset1id) LEFT JOIN senses AS s1 ON (sy1.synsetid = s1.synsetid) LEFT JOIN words AS w1 ON (s1.wordid = w1.wordid) LEFT JOIN synsets AS sy2 ON (sy2.synsetid = synset2id) LEFT JOIN senses AS s2 ON (sy2.synsetid = s2.synsetid) LEFT JOIN words AS w2 ON (s2.wordid = w2.wordid) LEFT JOIN relations USING(relationid) WHERE w1.word = 'pull' GROUP BY sy1.synsetid,w1.word,sy1.definition,relationid,relation,sy2.synsetid,sy2.synsetid,sy2.definition ORDER BY sy1.synsetid,relationid

word	definition	relation	GROUP_CONCAT(w2.word)	definition
pull	strain abnormally	hypernym	injure,wound	cause injuries or bodily harm to
pull	the act of pulling; applying force to move something toward or with you	hypernym	actuation,propulsion	the act of propelling
pull	the act of pulling; applying force to move something toward or with you	hyponym	draw,haul,haulage	the act of drawing or hauling something
pull	the act of pulling; applying force to move something toward or with you	hyponym	drag	the act of dragging (pulling with force)
pull	the act of pulling; applying force to move something toward or with you	hyponym	traction	(orthopedics) the act of pulling on a bone or limb (as in a fracture) to relieve pressure or align parts in a special way during healing
pull	the act of pulling; applying force to move something toward or with you	hyponym	pluck	the act of pulling and releasing a taut cord
pull	the act of pulling; applying force to move something toward or with you	hyponym	deracination,excision,extirpation	the act of pulling up or out; uprooting; cutting off from existence
pull	the act of pulling; applying force to move something toward or with you	hyponym	draft,draught,drawing	the act of moving a load by drawing or pulling
pull	the act of pulling; applying force to move something toward or with you	hyponym	jerk,tug	a sudden abrupt pull
pull	take away	hypernym	remove,take,take away,withdraw	remove something concrete, as by lifting, pushing, or taking off, or remove something abstract
pull	take away	similar	draw,get out,pull,pull out,take out	bring, take, or pull out of a container or from under a cover
pull	a sustained effort	hypernym	effort,elbow grease,exertion,sweat,travail	use of physical or mental energy; hard work
pull	a slow inhalation (as of tobacco smoke)	hypernym	aspiration,breathing in,inhalation,inspiration,intake	the act of inhaling; the drawing in of air (or other gases) as in breathing
pull	a slow inhalation (as of tobacco smoke)	hyponym	toke	a puff of a marijuana or hashish cigarette
pull	a slow inhalation (as of tobacco smoke)	part holonym	smoke,smoking	the act of smoking tobacco or other substances
pull	take sides with; align oneself with; show strong sympathy for	hypernym	side	take sides for or against
pull	remove, usually with some force or effort; also used in an abstract sense	hypernym	remove,take,take away,withdraw	remove something concrete, as by lifting, pushing, or taking off, or remove something abstract
pull	remove, usually with some force or effort; also used in an abstract sense	hyponym	squeeze out,wring out	extract (liquid) by squeezing or pressing
pull	remove, usually with some force or effort; also used in an abstract sense	hyponym	demodulate	extract information from a modulated carrier wave
pull	remove, usually with some force or effort; also used in an abstract sense	hyponym	thread	remove facial hair by tying a fine string around it and pulling at the string
pull	remove, usually with some force or effort; also used in an abstract sense	similar	take out,pull out,draw,get out,pull	bring, take, or pull out of a container or from under a cover
pull	strip of feathers	hypernym	strip	remove the surface from
pull	hit in the direction that the player is facing when carrying through the swing	hypernym	hit	cause to move by striking
pull	hit in the direction that the player is facing when carrying through the swing	domain topic	ball,baseball,baseball game	a ball game played with a bat and ball between two teams of nine players; teams take turns at bat trying to score runs
pull	cause to move by pulling	hypernym	displace,move	cause to move or shift into a new position or place, both in a concrete and in an abstract sense
pull	cause to move by pulling	hyponym	tug	pull or strain hard at
pull	cause to move by pulling	hyponym	pick off,pluck,pull off,tweak	pull or pull out sharply
pull	cause to move by pulling	hyponym	winch	pull or lift up with or as if with a winch
pull	cause to move by pulling	hyponym	jerk,yank	pull, or move with a sudden movement
pull	cause to move by pulling	hyponym	attract,draw,draw in,pull,pull in	direct toward itself or oneself by means of some psychological power or physical attributes
pull	cause to move by pulling	hyponym	cart,drag,hale,haul	draw slowly or heavily
pull	cause to move by pulling	hyponym	drag	pull, as against a resistance
pull	cause to move by pulling	hyponym	pick,pluck,plunk	pull lightly but sharply with a plucking motion
pull	cause to move by pulling	hyponym	stretch	pull in opposite directions
pull	cause to move by pulling	hyponym	abduct	pull away from the body
pull	cause to move by pulling	hyponym	adduct	draw a limb towards the body
pull	cause to move by pulling	hyponym	pull back	move to a rearward position; pull towards the back
pull	cause to move by pulling	hyponym	twitch	move or pull with a sudden motion
pull	cause to move by pulling	similar	pull	apply force so as to cause motion towards the source of the motion
pull	cause to move by pulling	similar	draw,pull	cause to move in a certain direction by exerting a force upon, either physically or in an abstract sense
pull	direct toward itself or oneself by means of some psychological power or physical attributes	hypernym	draw,pull	cause to move by pulling
pull	direct toward itself or oneself by means of some psychological power or physical attributes	hyponym	arrest,catch,get	attract and fix
pull	direct toward itself or oneself by means of some psychological power or physical attributes	hyponym	draw in,retract	pull inward or towards a center
pull	direct toward itself or oneself by means of some psychological power or physical attributes	hyponym	bring	attract the attention of
pull	direct toward itself or oneself by means of some psychological power or physical attributes	hyponym	tug	pull hard
pull	direct toward itself or oneself by means of some psychological power or physical attributes	similar	draw in,retract	pull inward or towards a center
pull	direct toward itself or oneself by means of some psychological power or physical attributes	similar	curl,curl up,draw in	shape one's body into a curl
pull	tear or be torn violently	hypernym	bust,rupture,snap,tear	separate or cause to separate abruptly
pull	apply force so as to cause motion towards the source of the motion	hypernym	force	do forcibly; exert force
pull	apply force so as to cause motion towards the source of the motion	hyponym	hike up,hitch up	pull up
pull	apply force so as to cause motion towards the source of the motion	hyponym	draw close	pull towards oneself
pull	apply force so as to cause motion towards the source of the motion	hyponym	pull back,draw back,retract	use a surgical instrument to hold open (the edges of a wound or an organ)
pull	apply force so as to cause motion towards the source of the motion	hyponym	pick at,pluck at,pull at	pluck or pull at with the fingers
pull	apply force so as to cause motion towards the source of the motion	hyponym	attract	exert a force on (a body) causing it to approach or prevent it from moving away
pull	apply force so as to cause motion towards the source of the motion	hyponym	gather	draw and bring closer
pull	apply force so as to cause motion towards the source of the motion	hyponym	twist,wrench	twist or pull violently or suddenly, especially so as to remove (something) from that to which it is attached or from where it originates
pull	apply force so as to cause motion towards the source of the motion	similar	draw,pull	cause to move by pulling
pull	rein in to keep from winning a race	hypernym	rein in,rein	stop or check by or as if by a pull at the reins
pull	operate when rowing a boat	hypernym	row	propel with oars
pull	bring, take, or pull out of a container or from under a cover	hypernym	withdraw,take away,take,remove	remove something concrete, as by lifting, pushing, or taking off, or remove something abstract
pull	bring, take, or pull out of a container or from under a cover	hyponym	unsheathe	draw from a sheath or scabbard
pull	bring, take, or pull out of a container or from under a cover	similar	pull	take away
pull	bring, take, or pull out of a container or from under a cover	similar	draw,take out	take liquid out of a container or well
pull	bring, take, or pull out of a container or from under a cover	similar	pull out,tear out,take out,rip out,pull up,pull,extract,draw out	remove, usually with some force or effort; also used in an abstract sense
pull	steer into a certain direction	hypernym	drive	cause someone or something to move by driving
pull	steer into a certain direction	similar	pull	move into a certain direction
pull	move into a certain direction	hypernym	drive	move by being propelled by a force
pull	move into a certain direction	hyponym	cut in	drive in front of another vehicle leaving too little space for that vehicle to maneuver comfortably
pull	move into a certain direction	similar	pull	steer into a certain direction
pull	cause to move in a certain direction by exerting a force upon, either physically or in an abstract sense	hypernym	displace,move	cause to move or shift into a new position or place, both in a concrete and in an abstract sense
pull	cause to move in a certain direction by exerting a force upon, either physically or in an abstract sense	similar	draw,pull	cause to move by pulling
pull	perform an act, usually with a negative connotation	hypernym	act,move	perform an action, or work out or perform (an action)
pull	perform an act, usually with a negative connotation	hyponym	make	carry out or commit
pull	perform an act, usually with a negative connotation	hyponym	recommit	commit once again, as of a crime
pull	a device used for pulling something	hypernym	device	an instrumentality invented for a particular purpose
pull	a device used for pulling something	hyponym	bellpull	a handle or cord that is pulled to ring a doorbell or a servant's bell etc.
pull	a device used for pulling something	hyponym	pull chain	a chain (usually with a handle at the end) that is pulled in order to operate some mechanism (e.g. to flush a toilet)
pull	special advantage or influence	hypernym	advantage,vantage	the quality of having a superior or more favorable position
pull	the force used in pulling	hypernym	force	(physics) the influence that produces a change in a physical quantity
pull	a sharp strain on muscles or ligaments	hypernym	harm,hurt,injury,trauma	any physical damage to the body caused by violence or accident or fracture etc.; the condition of an injury
pull	a sharp strain on muscles or ligaments	hyponym	sprain	a painful injury to a joint caused by a sudden wrenching of its ligaments

SELECT w1.word,sy1.synsetid,sy1.definition,GROUP_CONCAT(DISTINCT relation) FROM semrelations LEFT JOIN synsets AS sy1 ON (sy1.synsetid = synset1id) LEFT JOIN senses AS s1 ON (sy1.synsetid = s1.synsetid) LEFT JOIN words AS w1 ON (s1.wordid = w1.wordid) LEFT JOIN relations USING (relationid) WHERE w1.word = 'pull' GROUP BY sy1.synsetid ORDER BY sy1.synsetid

word	synsetid	definition	GROUP_CONCAT(DISTINCT relation)
pull	1372	strain abnormally	hypernym
pull	2333	the act of pulling; applying force to move something toward or with you	hypernym,hyponym
pull	12486	take away	hypernym,similar
pull	13360	a sustained effort	hypernym
pull	16534	a slow inhalation (as of tobacco smoke)	hypernym,hyponym,part holonym
pull	21377	take sides with; align oneself with; show strong sympathy for	hypernym
pull	24531	remove, usually with some force or effort; also used in an abstract sense	hypernym,hyponym,similar
pull	25067	strip of feathers	hypernym
pull	25452	hit in the direction that the player is facing when carrying through the swing	domain topic,hypernym
pull	26082	cause to move by pulling	hypernym,hyponym,similar
pull	27010	direct toward itself or oneself by means of some psychological power or physical attributes	hypernym,hyponym,similar
pull	28060	tear or be torn violently	hypernym
pull	28659	apply force so as to cause motion towards the source of the motion	hypernym,hyponym,similar
pull	32616	rein in to keep from winning a race	hypernym
pull	33977	operate when rowing a boat	hypernym
pull	34782	bring, take, or pull out of a container or from under a cover	hypernym,hyponym,similar
pull	35818	steer into a certain direction	hypernym,similar
pull	35820	move into a certain direction	hypernym,hyponym,similar
pull	36577	cause to move in a certain direction by exerting a force upon, either physically or in an abstract sense	hypernym,similar
pull	44504	perform an act, usually with a negative connotation	hypernym,hyponym
pull	57779	a device used for pulling something	hypernym,hyponym
pull	64106	special advantage or influence	hypernym
pull	98059	the force used in pulling	hypernym
pull	112147	a sharp strain on muscles or ligaments	hypernym,hyponym

SELECT relation, COUNT(*) FROM lexrelations LEFT JOIN relations USING(relationid) GROUP BY relationid ORDER BY relationid

relation	COUNT(*)
antonym	8000
similar	2
also	1148
participle	73
pertainym	8072
derivation	74688
domain topic	14
domain member topic	14
domain region	158
domain member region	158
exemplifies	413
is exemplified by	413

SELECT synset1id, word1id, COUNT(*) AS c,word,GROUP_CONCAT(DISTINCT relation),definition FROM lexrelations LEFT JOIN synsets AS s ON (s.synsetid = synset1id) LEFT JOIN words AS w ON (w.wordid = word1id) LEFT JOIN relations USING(relationid) GROUP BY word1id,synset1id ORDER BY c DESC LIMIT 5

synset1id	word1id	c	word	GROUP_CONCAT(DISTINCT relation)	definition
72541	138537	298	trade name	is exemplified by	a name given to a product or service
83427	18033	93	britain	derivation,domain member region	a monarchy in northwestern Europe occupying most of the British Isles; divided into England and Scotland and Wales and Northern Ireland; `Great Britain' is often used loosely to refer to the United Kingdom
72543	138555	82	trademark	domain member topic,is exemplified by	a formally registered symbol identifying the manufacturer or distributor of a product
83246	20565	64	canada	derivation,domain member region	a nation in northern North America; the French were the first Europeans to settle in mainland Canada
7020	22035	15	carry	derivation	the act of carrying something

SELECT w1.word,relation,w2.word,s1.definition,s2.definition FROM lexrelations LEFT JOIN synsets AS s1 ON (s1.synsetid = synset1id) LEFT JOIN synsets AS s2 ON (s2.synsetid = synset2id) LEFT JOIN words AS w1 ON (w1.wordid = word1id) LEFT JOIN words AS w2 ON (w2.wordid = word2id) LEFT JOIN relations USING(relationid) WHERE w1.word = 'pull' ORDER BY relationid

word	relation	word	definition	definition
pull	antonym	push	cause to move by pulling	move with force
pull	also	pull along	cause to move by pulling	pull along heavily, like a heavy load against a resistance
pull	also	pull back	cause to move by pulling	move to a rearward position; pull towards the back
pull	also	pull down	cause to move by pulling	tear down so as to make flat with the ground
pull	also	pull in	cause to move by pulling	direct toward itself or oneself by means of some psychological power or physical attributes
pull	also	pull off	cause to move by pulling	pull or pull out sharply
pull	also	pull out	cause to move by pulling	remove, usually with some force or effort; also used in an abstract sense
pull	also	pull up	cause to move by pulling	remove, usually with some force or effort; also used in an abstract sense
pull	derivation	pull	apply force so as to cause motion towards the source of the motion	the act of pulling; applying force to move something toward or with you
pull	derivation	pulling	cause to move by pulling	the act of pulling; applying force to move something toward or with you
pull	derivation	pull	apply force so as to cause motion towards the source of the motion	the force used in pulling
pull	derivation	puller	apply force so as to cause motion towards the source of the motion	someone who applies force so as to cause motion toward herself or himself
pull	derivation	pulling	apply force so as to cause motion towards the source of the motion	the act of pulling; applying force to move something toward or with you
pull	derivation	pull	perform an act, usually with a negative connotation	a sustained effort
pull	derivation	pull	a device used for pulling something	direct toward itself or oneself by means of some psychological power or physical attributes
pull	derivation	pull	the force used in pulling	direct toward itself or oneself by means of some psychological power or physical attributes
pull	derivation	pull	the force used in pulling	apply force so as to cause motion towards the source of the motion
pull	derivation	pull	a sharp strain on muscles or ligaments	strain abnormally
pull	derivation	pull	direct toward itself or oneself by means of some psychological power or physical attributes	the force used in pulling
pull	derivation	pull	direct toward itself or oneself by means of some psychological power or physical attributes	a device used for pulling something
pull	derivation	pull	direct toward itself or oneself by means of some psychological power or physical attributes	the act of pulling; applying force to move something toward or with you
pull	derivation	pull	strain abnormally	a sharp strain on muscles or ligaments
pull	derivation	puller	cause to move by pulling	someone who pulls or tugs or drags in an effort to move something
pull	derivation	pull	cause to move by pulling	the act of pulling; applying force to move something toward or with you
pull	derivation	pull	a sustained effort	perform an act, usually with a negative connotation
pull	derivation	pull	the act of pulling; applying force to move something toward or with you	apply force so as to cause motion towards the source of the motion
pull	derivation	pull	the act of pulling; applying force to move something toward or with you	direct toward itself or oneself by means of some psychological power or physical attributes
pull	derivation	pull	the act of pulling; applying force to move something toward or with you	cause to move by pulling