SELECT o. *
FROM hq_goods g
LEFT JOIN hq_orders o ON o.goods_id = g.id
WHERE o.user_id =73
AND o.state =1
AND o.id not in( select c.order_id from hq_comment as c where c.user_id=73 and c.goods_id=g.id )
LIMIT 0 , 30
SELECT o. *
FROM hq_goods g
LEFT JOIN hq_orders o ON o.goods_id = g.id
WHERE o.user_id =73
AND o.state =1
AND o.id not in( select c.order_id from hq_comment as c where c.user_id=73 and c.goods_id=g.id )
LIMIT 0 , 30
转载于:https://www.cnblogs.com/yuwensong/p/3759267.html