MYSQL

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

word	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 word,template,SUBSTRING(definition FROM 1 FOR 32) FROM senses_vtemplates LEFT JOIN vtemplates USING (templateid) INNER JOIN words USING (wordid) INNER JOIN synsets USING (synsetid) WHERE word = 'rain'

word	template	SUBSTRING(definition FROM 1 FOR 32)
rain	It was %sing all day long	precipitate as rain

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

word	frame	SUBSTRING(definition FROM 1 FOR 32)
clean	Somebody ----s somebody	clean one's body or parts thereo
clean	Somebody ----s something	clean one's body or parts thereo
clean	Somebody ----s	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 PP	remove all contents or possessio
clean	Somebody ----s somebody of something	remove all contents or possessio
clean	Somebody ----s something	remove all contents or possessio
clean	Something ----s something	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 word,template,SUBSTRING(definition FROM 1 FOR 32) FROM senses_vtemplates LEFT JOIN vtemplates USING (templateid) RIGHT JOIN words USING (wordid) RIGHT JOIN synsets USING (synsetid) WHERE word = 'clean' ORDER BY synsetid

word	template	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 word,frame,SUBSTRING(definition FROM 1 FOR 32) FROM senses_vframes INNER JOIN vframes USING (frameid) RIGHT JOIN words USING (wordid) RIGHT JOIN synsets USING (synsetid) WHERE word = 'write' ORDER BY synsetid

word	frame	SUBSTRING(definition FROM 1 FOR 32)
write	Somebody ----s	communicate or express by writin
write	Somebody ----s that CLAUSE	communicate or express by writin
write	Somebody ----s somebody	communicate or express by writin
write	Somebody ----s something	communicate or express by writin
write	Somebody ----s something to somebody	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 to somebody	communicate (with) in writing
write	Somebody ----s somebody	communicate (with) in writing
write	Somebody ----s	mark or trace words or symbols o
write	Somebody ----s something	mark or trace words or symbols o
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

SELECT word,template,SUBSTRING(definition FROM 1 FOR 32) FROM senses_vtemplates LEFT JOIN vtemplates USING (templateid) RIGHT JOIN words USING (wordid) RIGHT JOIN synsets USING (synsetid) WHERE word = 'write' ORDER BY synsetid

word	template	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

SELECT word,SUBSTRING(definition FROM 1 FOR 32),SUBSTRING(GROUP_CONCAT(frame) FROM 1 FOR 70),SUBSTRING(GROUP_CONCAT(template) FROM 1 FOR 32) FROM senses_vframes INNER JOIN vframes USING (frameid) LEFT JOIN senses_vtemplates USING (synsetid,wordid) LEFT JOIN vtemplates USING (templateid) RIGHT JOIN words USING (wordid) RIGHT JOIN synsets USING (synsetid) WHERE word = 'write' GROUP BY synsetid ORDER BY synsetid

word	SUBSTRING(definition FROM 1 FOR 32)	SUBSTRING(GROUP_CONCAT(frame) FROM 1 FOR 70)	SUBSTRING(GROUP_CONCAT(template) FROM 1 FOR 32)
write	communicate or express by writin	Somebody ----s somebody something,Somebody ----s something to somebody	They %s the information to them,
write	record data on a computer	Somebody ----s something,Something ----s something
write	communicate (with) in writing	Somebody ----s to somebody,Somebody ----s somebody
write	mark or trace words or symbols o	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

SELECT frameid,frame,COUNT(*) AS N FROM senses INNER JOIN senses_vframes USING (wordid,synsetid) INNER JOIN vframes USING (frameid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid) GROUP BY frameid ORDER BY N DESC

frameid	frame	N
8	Somebody ----s something	13233
2	Somebody ----s	5152
9	Somebody ----s somebody	5079
11	Something ----s something	4897
1	Something ----s	3608
22	Somebody ----s PP	2219
10	Something ----s somebody	2127
4	Something is ----ing PP	1058
21	Somebody ----s something PP	1023
26	Somebody ----s that CLAUSE	676
20	Somebody ----s somebody PP	475
15	Somebody ----s something to somebody	386
14	Somebody ----s somebody something	202
24	Somebody ----s somebody to INFINITIVE	198
28	Somebody ----s to INFINITIVE	190
16	Somebody ----s something from somebody	152
17	Somebody ----s somebody with something	124
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
37	Somebody ----s for something	1
38	Somebody ----s on somebody	1
36	Somebody ----s at something	1
39	Somebody ----s out of somebody	1

SELECT sensekey,definition,COUNT(*) AS N FROM senses INNER JOIN senses_vframes USING (wordid,synsetid) INNER JOIN vframes USING (frameid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid) GROUP BY sensekey,definition,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
take_hold%2:35:00::	have or hold in one's hands or grip	7
beat_back%2:35:00::	cause to move back by force or influence	7
set%2:30:09::	make ready or suitable or equip in advance for a particular purpose or for some use, event, etc	7
ready%2:30:00::	make ready or suitable or equip in advance for a particular purpose or for some use, event, etc	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
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
push_back%2:35:00::	cause to move back by force or influence	7
attract%2:35:00::	direct toward itself or oneself by means of some psychological power or physical attributes	7
repel%2:35:00::	cause to move back by force or influence	7
fix%2:30:03::	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
drive%2:35:11::	cause to move back by force or influence	7
teach%2:32:00::	impart skills or knowledge to	7
pull_in%2:35:00::	direct toward itself or oneself by means of some psychological power or physical attributes	7
draw%2:35:06::	direct toward itself or oneself by means of some psychological power or physical attributes	7
ensnarl%2:35:00::	entangle or catch in (or as if in) a mesh	6

SELECT word,synsetid,frame,SUBSTRING(definition FROM 1 FOR 32) FROM senses INNER JOIN senses_vframes USING (wordid,synsetid) INNER JOIN vframes USING (frameid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid) WHERE word = 'prepare'

word	synsetid	frame	SUBSTRING(definition FROM 1 FOR 32)
prepare	9036	Somebody ----s	make ready or suitable or equip
prepare	9036	Somebody ----s to INFINITIVE	make ready or suitable or equip
prepare	9036	Somebody ----s somebody	make ready or suitable or equip
prepare	9036	Somebody ----s somebody PP	make ready or suitable or equip
prepare	9036	Somebody ----s something	make ready or suitable or equip
prepare	9036	Somebody ----s something PP	make ready or suitable or equip
prepare	9036	Something ----s somebody	make ready or suitable or equip
prepare	9036	Something ----s something	make ready or suitable or equip
prepare	13001	Somebody ----s to somebody	undergo training or instruction
prepare	13008	Somebody ----s somebody	create by training and teaching
prepare	29334	Somebody ----s something	arrange by systematic planning a
prepare	29525	Somebody ----s something	prepare for eating by applying h
prepare	30984	Somebody ----s something	to prepare verbally, either for
prepare	37862	Somebody ----s something	lead up to and soften by soundin
prepare	41346	Somebody ----s somebody	educate for a future role or fun