MYSQL

SELECT word,COUNT(DISTINCT positionid) AS N,GROUP_CONCAT(positionid),GROUP_CONCAT(senseid) FROM senses INNER JOIN senses_adjpositions USING (wordid,synsetid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid) GROUP BY wordid HAVING N >1 ORDER BY N DESC

word	N	GROUP_CONCAT(positionid)	GROUP_CONCAT(senseid)
left	2	a,p	108302,108303
up	2	a,p,p,p,p	200704,200705,200706,200707,200708
true	2	a,a,a,a,p	195350,195352,195353,195354,195355
throwaway	2	p,a	190781,190782
supposed	2	p,a	184454,184457
square	2	a,p	178467,178468
several	2	p,a,a	168473,168474,168475
proper	2	a,ip	148544,148545
previous	2	p,a,a	147163,147164,147165
out	2	p,p,a,p,p,a,p,a	133464,133468,133469,133470,133471,133473,133474,133476
low-density	2	a,p	112685,112686
at rest	2	a,p	12209,12210
leading	2	a,p	107903,107905
in	2	a,p	96189,96190
heavy	2	p,a	89069,89075
gone	2	a,p	83344,83347
downward	2	a,ip	56017,56018
down	2	p,a,a,p,p	55930,55931,55932,55934,55936
dead	2	a,p,a,p	48498,48505,48508,48509
certain	2	p,p,a	31773,31774,31778
big	2	a,p	18778,18782

SELECT word,positionid,position,definition FROM senses INNER JOIN senses_adjpositions USING (wordid,synsetid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid) INNER JOIN adjpositions USING (positionid) WHERE word = 'out'

word	positionid	position	definition
out	p	predicate	not allowed to continue to bat or run
out	p	predicate	being out or having grown cold
out	a	attributive	outside or external
out	p	predicate	excluded from use or mention
out	p	predicate	not worth considering as a possibility
out	a	attributive	directed outward or serving to direct something outward
out	p	predicate	knocked unconscious by a heavy blow
out	a	attributive	out of power; especially having been unsuccessful in an election

SELECT word,positionid,position,definition FROM senses INNER JOIN senses_adjpositions USING (wordid,synsetid) LEFT JOIN words USING (wordid) LEFT JOIN synsets USING (synsetid) INNER JOIN adjpositions USING (positionid) WHERE word = 'big'

word	positionid	position	definition
big	a	attributive	prodigious
big	p	predicate	in an advanced stage of pregnancy