SELECT
wst_jxc_goods.goodsId,
wst_jxc_goods.goodsName,
wst_jxc_screening_goods_relation.relation_id,
count(wst_jxc_screening_goods_relation.goods_id) countTmp
FROM
wst_jxc_screening_goods_relation
INNER JOIN wst_jxc_goods ON wst_jxc_goods.goodsId = wst_jxc_screening_goods_relation.goods_id
WHERE
wst_jxc_screening_goods_relation.is_delete = 0 AND
(wst_jxc_screening_goods_relation.screening_id = 6 or wst_jxc_screening_goods_relation.screening_id = 7 or wst_jxc_screening_goods_relation.screening_id = 8)
GROUP BY
wst_jxc_screening_goods_relation.goods_id having count(wst_jxc_screening_goods_relation.screening_id) = 3
LIMIT 10
因为属性也是需要支持多个属性组合筛选,具体有空再做详细解释,这里仅记录一下