All pastes #2068312 Raw Edit

Untitled

public text v1 · immutable
#2068312 ·published 2011-05-24 12:10 UTC
rendered paste body
SELECT annot FROM 
		(SELECT sid, (qgram.i-query.i) as diag FROM qgram, query WHERE qgram.qg = query.qg 	GROUP BY sid, diag HAVING count(sid)>1) AS P 	
	INNER JOIN 	
		pstring 		
	ON pstring.sid=P.sid  GROUP BY annot;