Untitled
public text v1 · immutableSELECT 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;