MYSQL

SELECT lemma,synsetid,definition,parse FROM words LEFT JOIN senses USING (wordid) INNER JOIN synsets USING (synsetid) INNER JOIN xwnparselfts USING (synsetid) WHERE pos='v' and lemma='want'

lemma	synsetid	definition	parse
want	200709205	wish or demand the presence of	(TOP (S (S (VP (TO to) (VP (VB want) ) ) ) (VP (VBZ is) (S (VP (TO to) (VP (VB wish) (CC or) (VB demand) (NP (NP (DT the) (NN presence) ) (PP (IN of) ) ) ) ) ) ) (. .) ) )
want	201188725	have need of	(TOP (S (S (VP (TO to) (VP (VB want) ) ) ) (VP (VBZ is) (S (VP (TO to) (VP (VB have) (NP (NP (NN need) ) (PP (IN of) ) ) ) ) ) ) (. .) ) )
want	201317064	hunt or look for; want for a particular reason	(TOP (S (S (VP (TO to) (VP (VB want) ) ) ) (VP (VBZ is) (S (VP (TO to) (VP (VB want) (PP (IN for) (NP (DT a) (JJ particular) (NN reason) ) ) ) ) ) ) (. .) ) )
want	201317064	hunt or look for; want for a particular reason	(TOP (S (S (VP (TO to) (VP (VB want) ) ) ) (VP (VBZ is) (S (VP (TO to) (VP (VP (VB hunt) ) (CC or) (VP (VB look) (ADVP (RP for) ) ) ) ) ) ) (. .) ) )
want	201825237	feel or have a desire for; want strongly	(TOP (S (S (VP (TO to) (VP (VB desire) ) ) ) (VP (VBZ is) (S (VP (TO to) (VP (VB want) (ADVP (RB strongly) ) ) ) ) ) (. .) ) )
want	201825237	feel or have a desire for; want strongly	(TOP (S (S (VP (TO to) (VP (VB desire) ) ) ) (VP (VBZ is) (S (VP (TO to) (VP (VB feel) (CC or) (VB have) (NP (NP (DT a) (NN desire) ) (PP (IN for) ) ) ) ) ) ) (. .) ) )
want	202632567	be without, lack; be deficient in	(TOP (S (S (VP (TO to) (VP (VB want) ) ) ) (VP (VBZ is) (S (VP (TO to) (VP (VB be) (ADJP (JJ deficient) (PP (IN in) ) ) ) ) ) ) (. .) ) )
want	202632567	be without, lack; be deficient in	(TOP (S (S (VP (TO to) (VP (VB want) ) ) ) (VP (VBZ is) (S (VP (TO to) (VP (VP (VB be) (PP (IN without) ) ) (, ,) (VP (VB lack) ) ) ) ) ) (. .) ) )

SELECT lemma,synsetid,definition,lft FROM words LEFT JOIN senses USING (wordid) INNER JOIN synsets USING (synsetid) INNER JOIN xwnparselfts USING (synsetid) WHERE pos='v' and lemma='want'

lemma	synsetid	definition	lft
want	200709205	wish or demand the presence of	want:VB(e1, x1, x2) -> wish:VB(e2, x1, x3) or:CC(e1, e2, e3) demand:VB(e3, x1, x3) presence:NN(x3) of:IN(x3, x2)
want	201188725	have need of	want:VB(e1, x1, x2) -> have:VB(e1, x1, x3) need:NN(x3) of:IN(e1, x2)
want	201317064	hunt or look for; want for a particular reason	want:VB(e1, x1, x2) -> hunt:VB(e2, x1, x3) or:CC(e1, e2, e3) look_for:VB(e3, x1, x4)
want	201317064	hunt or look for; want for a particular reason	want:VB(e1, x1, x2) -> want:VB(e1, x1, x4) for:IN(e1, x3) particular:JJ(x3) reason:NN(x3)
want	201825237	feel or have a desire for; want strongly	desire:VB(e1, x1, x2) -> feel:VB(e2, x1, x3) or:CC(e1, e2, e3) have:VB(e3, x1, x3) desire:NN(x3) for:IN(e1, x2)
want	201825237	feel or have a desire for; want strongly	desire:VB(e1, x1, x2) -> want:VB(e1, x1, x3) strongly:RB(e1)
want	202632567	be without, lack; be deficient in	want:VB(e1, x1, x2) -> be:VB(e1, x1, x3) deficient:JJ(x3) in:IN(e1, x2)
want	202632567	be without, lack; be deficient in	want:VB(e1, x1, x2) -> be:VB(e2, x1, x3) without:IN(e1, x2) or:CC(e1, e2, e3) lack:VB(e3, x1, x2)

SELECT lemma,synsetid,definition,wsd FROM words LEFT JOIN senses USING (wordid) INNER JOIN synsets USING (synsetid) INNER JOIN xwnwsds USING (synsetid) WHERE pos='v' and lemma='want'

lemma	synsetid	definition	wsd
want	200709205	wish or demand the presence of	<wf pos="VB" lemma="wish" quality="normal" wnsn="4">wish</wf><wf pos="CC">or</wf><wf pos="VB" lemma="demand" quality="silver" wnsn="1">demand</wf><wf pos="DT">the</wf><wf pos="NN" lemma="presence" quality="normal" wnsn="1">presence</wf><wf pos="IN">of</wf>
want	201188725	have need of	<wf pos="VB" lemma="have" quality="normal" wnsn="1">have</wf><wf pos="NN" lemma="need" quality="normal" wnsn="1">need</wf><wf pos="IN">of</wf>
want	201188725	have need of	<wf pos="VB" lemma="have" quality="normal" wnsn="1">have</wf><wf pos="NN" lemma="need" quality="normal" wnsn="1">need</wf><wf pos="IN">of</wf>
want	201188725	have need of	<wf pos="VB" lemma="have" quality="normal" wnsn="1">have</wf><wf pos="NN" lemma="need" quality="normal" wnsn="1">need</wf><wf pos="IN">of</wf>
want	201317064	hunt or look for; want for a particular reason	<wf pos="VB" lemma="hunt" quality="gold" wnsn="6">hunt</wf><wf pos="CC">or</wf><wf pos="VB" lemma="look_for" quality="gold" wnsn="1">look_for</wf><punc>;</punc><wf pos="VBP" lemma="want" quality="gold" wnsn="3">want</wf><wf pos="IN">for</wf><wf pos="DT">a</wf><wf pos="JJ" lemma="particular" quality="gold" wnsn="2">particular</wf><wf pos="NN" lemma="reason" quality="gold" wnsn="1">reason</wf>
want	201825237	feel or have a desire for; want strongly	<wf pos="VB" lemma="feel" quality="normal" wnsn="3">feel</wf><wf pos="CC">or</wf><wf pos="VB" lemma="have" quality="normal" wnsn="3">have</wf><wf pos="DT">a</wf><wf pos="NN" lemma="desire" quality="normal" wnsn="1">desire</wf><wf pos="IN">for</wf><punc>;</punc><wf pos="VBP" lemma="want" quality="silver" wnsn="1">want</wf><wf pos="RB" lemma="strongly" quality="normal" wnsn="1">strongly</wf>
want	201825237	feel or have a desire for; want strongly	<wf pos="VB" lemma="feel" quality="normal" wnsn="3">feel</wf><wf pos="CC">or</wf><wf pos="VB" lemma="have" quality="normal" wnsn="3">have</wf><wf pos="DT">a</wf><wf pos="NN" lemma="desire" quality="normal" wnsn="1">desire</wf><wf pos="IN">for</wf><punc>;</punc><wf pos="VBP" lemma="want" quality="silver" wnsn="1">want</wf><wf pos="RB" lemma="strongly" quality="normal" wnsn="1">strongly</wf>
want	202632567	be without, lack; be deficient in	<wf pos="VB" lemma="be" quality="normal" wnsn="1">be</wf><wf pos="IN">without</wf><punc>,</punc><wf pos="NN" lemma="lack" quality="silver" wnsn="1">lack</wf><punc>;</punc><wf pos="VB" lemma="be" quality="normal" wnsn="1">be</wf><wf pos="JJ" lemma="deficient" quality="normal" wnsn="1">deficient</wf><wf pos="IN">in</wf>