筛选商品比较kid等于2的

SELECT kid,
    itemid,
    COUNT( kid )
FROM
    `tp_compare` r
    INNER JOIN `tp_jditems` s ON r.itemids = s.kid 
GROUP BY
    s.kid 
HAVING
    COUNT( kid )>1