|
1
2
3
4
5
6
7
|
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 |