Re: How to design

[Bob Field]

SELECT g1.itemID, g2.groupID
FROM grouptest AS g1
LEFT JOIN grouptest AS g2 ON g1.groupID = g2.groupID AND g1.groupID != 0 AND g1.score < g2.score
WHERE keywords LIKE '%apple%'
AND g2.itemID IS NULL;