MYSQL

SELECT lemma,frame,SUBSTRING(definition FROM 1 FOR 32) FROM vframemaps INNER JOIN vframes USING (frameid) INNER JOIN words USING (wordid) INNER JOIN synsets USING (synsetid) WHERE lemma = 'snow'

lemma	frame	SUBSTRING(definition FROM 1 FOR 32)
snow	Somebody ----s somebody	conceal one's true motives from
snow	It is ----ing	fall as snow

SELECT lemma,sentence,SUBSTRING(definition FROM 1 FOR 32) FROM vframesentencemaps LEFT JOIN vframesentences USING (sentenceid) INNER JOIN words USING (wordid) INNER JOIN synsets USING (synsetid) WHERE lemma = 'snow'

lemma	sentence	SUBSTRING(definition FROM 1 FOR 32)
snow	It was %sing all day long	fall as snow

SELECT lemma,frame,SUBSTRING(definition FROM 1 FOR 32) FROM vframemaps INNER JOIN vframes USING (frameid) RIGHT JOIN words USING (wordid) RIGHT JOIN synsets USING (synsetid) WHERE lemma = 'clean' ORDER BY synsetid

lemma	frame	SUBSTRING(definition FROM 1 FOR 32)
clean	Somebody ----s	clean one's body or parts thereo
clean	Somebody ----s something	clean one's body or parts thereo
clean	Somebody ----s somebody	clean one's body or parts thereo
clean	Somebody ----s something	remove unwanted substances from,
clean	Somebody ----s something	remove shells or husks from
clean	Somebody ----s something	remove unwanted substances from
clean	Something ----s something	remove unwanted substances from
clean	Somebody ----s something PP	remove while making clean
clean	Somebody ----s something	make clean by removing dirt, fil
clean	Something ----s something	make clean by removing dirt, fil
clean	Somebody ----s	clean and tidy up the house
clean	Somebody ----s something	remove all contents or possessio
clean	Something ----s something	remove all contents or possessio
clean	Somebody ----s somebody of something	remove all contents or possessio
clean	Somebody ----s PP	remove all contents or possessio
clean	Somebody ----s somebody	deprive wholly of money in a gam
clean	Something ----s	be cleanable
clean	Something is ----ing PP	be cleanable

SELECT lemma,sentence,SUBSTRING(definition FROM 1 FOR 32) FROM vframesentencemaps LEFT JOIN vframesentences USING (sentenceid) RIGHT JOIN words USING (wordid) RIGHT JOIN synsets USING (synsetid) WHERE lemma = 'clean' ORDER BY synsetid

lemma	sentence	SUBSTRING(definition FROM 1 FOR 32)
clean	They %s themselves	clean one's body or parts thereo
clean	The chefs %s the vegetables	remove shells or husks from
clean	They %s the snow from the path	remove while making clean
clean	They %s the cape	make clean by removing dirt, fil

SELECT lemma,frame,SUBSTRING(definition FROM 1 FOR 32) FROM vframemaps INNER JOIN vframes USING (frameid) RIGHT JOIN words USING (wordid) RIGHT JOIN synsets USING (synsetid) WHERE lemma = 'write' ORDER BY synsetid

lemma	frame	SUBSTRING(definition FROM 1 FOR 32)
write	Somebody ----s something	communicate or express by writin
write	Somebody ----s somebody	communicate or express by writin
write	Somebody ----s something to somebody	communicate or express by writin
write	Somebody ----s that CLAUSE	communicate or express by writin
write	Somebody ----s	communicate or express by writin
write	Somebody ----s somebody something	communicate or express by writin
write	Somebody ----s something	record data on a computer
write	Something ----s something	record data on a computer
write	Somebody ----s somebody	communicate (with) in writing
write	Somebody ----s to somebody	communicate (with) in writing
write	Somebody ----s that CLAUSE	communicate by letter
write	Somebody ----s	mark or trace on a surface
write	Somebody ----s something	mark or trace on a surface
write	Somebody ----s something	create code, write a computer pr
write	Somebody ----s something	produce a literary work
write	Somebody ----s something	write or name the letters that c
write	Somebody ----s	write music
write	Somebody ----s something	write music
write	Somebody ----s	have (one's written work) issued
write	Somebody ----s something	have (one's written work) issued

SELECT lemma,sentence,SUBSTRING(definition FROM 1 FOR 32) FROM vframesentencemaps LEFT JOIN vframesentences USING (sentenceid) RIGHT JOIN words USING (wordid) RIGHT JOIN synsets USING (synsetid) WHERE lemma = 'write' ORDER BY synsetid

lemma	sentence	SUBSTRING(definition FROM 1 FOR 32)
write	They %s them the information	communicate or express by writin
write	They %s the information to them	communicate or express by writin
write	Sam and Sue %s the movie	produce a literary work
write	Did he %s his major works over a short period of time?	write music
write	Did he %s his major works over a short period of time?	have (one's written work) issued

SELECT lemma,SUBSTRING(definition FROM 1 FOR 32),SUBSTRING(GROUP_CONCAT(frame) FROM 1 FOR 70),SUBSTRING(GROUP_CONCAT(sentence) FROM 1 FOR 32) FROM vframemaps INNER JOIN vframes USING (frameid) LEFT JOIN vframesentencemaps USING (synsetid,wordid) LEFT JOIN vframesentences USING (sentenceid) RIGHT JOIN words USING (wordid) RIGHT JOIN synsets USING (synsetid) WHERE lemma = 'write' GROUP BY synsetid ORDER BY synsetid

lemma	SUBSTRING(definition FROM 1 FOR 32)	SUBSTRING(GROUP_CONCAT(frame) FROM 1 FOR 70)	SUBSTRING(GROUP_CONCAT(sentence) FROM 1 FOR 32)
write	communicate or express by writin	Somebody ----s something,Somebody ----s something,Somebody ----s someb	They %s them the information,The
write	record data on a computer	Somebody ----s something,Something ----s something
write	communicate (with) in writing	Somebody ----s somebody,Somebody ----s to somebody
write	communicate by letter	Somebody ----s that CLAUSE
write	mark or trace on a surface	Somebody ----s,Somebody ----s something
write	create code, write a computer pr	Somebody ----s something
write	produce a literary work	Somebody ----s something	Sam and Sue %s the movie
write	write or name the letters that c	Somebody ----s something
write	write music	Somebody ----s,Somebody ----s something	Did he %s his major works over a
write	have (one's written work) issued	Somebody ----s,Somebody ----s something	Did he %s his major works over a

SELECT frameid,frame,COUNT(*) AS N FROM verbswithframes GROUP BY frameid ORDER BY N DESC

frameid	frame	N
8	Somebody ----s something	13205
2	Somebody ----s	5110
9	Somebody ----s somebody	5071
11	Something ----s something	4906
1	Something ----s	3604
22	Somebody ----s PP	2222
10	Something ----s somebody	2134
4	Something is ----ing PP	1063
21	Somebody ----s something PP	1019
26	Somebody ----s that CLAUSE	679
20	Somebody ----s somebody PP	478
15	Somebody ----s something to somebody	386
14	Somebody ----s somebody something	200
24	Somebody ----s somebody to INFINITIVE	198
28	Somebody ----s to INFINITIVE	192
16	Somebody ----s something from somebody	150
17	Somebody ----s somebody with something	125
33	Somebody ----s VERB-ing	111
31	Somebody ----s something with something	104
6	Something ----s Adjective/Noun	69
7	Somebody ----s Adjective	67
27	Somebody ----s to somebody	64
13	Somebody ----s on something	57
18	Somebody ----s somebody of something	57
5	Something ----s something Adjective/Noun	54
29	Somebody ----s whether INFINITIVE	51
3	It is ----ing	43
34	It ----s that CLAUSE	42
30	Somebody ----s somebody into V-ing something	37
23	Somebody's (body part) ----s	35
19	Somebody ----s something on somebody	34
12	Something ----s to somebody	25
25	Somebody ----s somebody INFINITIVE	19
32	Somebody ----s INFINITIVE	9
35	Something ----s INFINITIVE	5

SELECT sensekey,definition,COUNT(*) AS N FROM verbswithframes GROUP BY senseid ORDER BY N DESC LIMIT 20

sensekey	definition	N
gear_up%2:30:00::	make ready or suitable or equip in advance for a particular purpose or for some use, event, etc	8
prepare%2:30:00::	make ready or suitable or equip in advance for a particular purpose or for some use, event, etc	8
teach%2:32:00::	impart skills or knowledge to	7
take_hold%2:35:00::	have or hold in one's hands or grip	7
ready%2:30:00::	make ready or suitable or equip in advance for a particular purpose or for some use, event, etc	7
set%2:30:09::	make ready or suitable or equip in advance for a particular purpose or for some use, event, etc	7
set_up%2:30:02::	make ready or suitable or equip in advance for a particular purpose or for some use, event, etc	7
fix%2:30:03::	make ready or suitable or equip in advance for a particular purpose or for some use, event, etc	7
draw%2:35:06::	direct toward itself or oneself by means of some psychological power or physical attributes	7
draw_in%2:35:00::	direct toward itself or oneself by means of some psychological power or physical attributes	7
pull%2:35:02::	direct toward itself or oneself by means of some psychological power or physical attributes	7
pull_in%2:35:00::	direct toward itself or oneself by means of some psychological power or physical attributes	7
attract%2:35:00::	direct toward itself or oneself by means of some psychological power or physical attributes	7
push_back%2:35:00::	cause to move back by force or influence	7
drive%2:35:11::	cause to move back by force or influence	7
repulse%2:35:00::	cause to move back by force or influence	7
force_back%2:35:00::	cause to move back by force or influence	7
beat_back%2:35:00::	cause to move back by force or influence	7
repel%2:35:00::	cause to move back by force or influence	7
touch%2:35:00::	make physical contact with, come in contact with	6

SELECT lemma,synsetid,frame,SUBSTRING(definition FROM 1 FOR 32) FROM verbswithframes WHERE lemma = 'prepare' AND synsetid = 200406243

lemma	synsetid	frame	SUBSTRING(definition FROM 1 FOR 32)
prepare	200406243	Somebody ----s	make ready or suitable or equip
prepare	200406243	Somebody ----s something	make ready or suitable or equip
prepare	200406243	Somebody ----s somebody	make ready or suitable or equip
prepare	200406243	Something ----s somebody	make ready or suitable or equip
prepare	200406243	Something ----s something	make ready or suitable or equip
prepare	200406243	Somebody ----s somebody PP	make ready or suitable or equip
prepare	200406243	Somebody ----s something PP	make ready or suitable or equip
prepare	200406243	Somebody ----s to INFINITIVE	make ready or suitable or equip