MYSQL

SELECT lemma,COUNT(DISTINCT position) AS N,GROUP_CONCAT(position),GROUP_CONCAT(senseid) FROM adjectiveswithpositions GROUP BY wordid HAVING N >1 ORDER BY N DESC

lemma	N	GROUP_CONCAT(position)	GROUP_CONCAT(senseid)
at rest	2	p,a	11893,11892
big	2	a,p	18258,18262
certain	2	p,p,a	30982,30981,30986
dead	2	a,p,p,a	47328,47339,47335,47338
down	2	p,p,a,a,p	54639,54641,54637,54636,54635
downward	2	ip,a	54723,54722
gone	2	p,a	81491,81490
heavy	2	a,p	87070,87064
in	2	a,p	94002,94003
leading	2	p,a	105321,105319
left	2	a,p	105715,105716
low-density	2	p,a	109995,109994
out	2	p,p,a,p,p,a,a,p	130199,130203,130208,130206,130209,130204,130211,130205
previous	2	a,p,a	143542,143541,143543
proper	2	ip,a	144902,144901
several	2	a,p,a	164440,164438,164439
square	2	p,a	174217,174216
supposed	2	a,p	180091,180088
throwaway	2	p,a	186270,186271
true	2	p,a,a,a,a	190782,190777,190781,190779,190780
up	2	p,p,p,p,a	196018,196020,196017,196019,196016

SELECT lemma,position,positionname,definition FROM adjectiveswithpositions INNER JOIN adjpositiontypes USING (position) WHERE lemma = 'out'

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

SELECT lemma,position,positionname,definition FROM adjectiveswithpositions INNER JOIN adjpositiontypes USING (position) WHERE lemma = 'big'

lemma	position	positionname	definition
big	p	predicate	in an advanced stage of pregnancy
big	a	attributive	prodigious