谁能看得懂这条SQL 求解释

qingkong 发布于 4个月前 分类:问答

select a.id,a.product_title,a.volume,a.imgurl,
min(c.price) as price
from lkt_product_list AS a RIGHT JOIN (select min(price) price,pid from lkt_configure group by pid) AS c ON a.id = c.pid
where a.status = 0 and a.num >0 and s_type like \'%4%\'
group by c.pid order by a.volume desc limit 10,10

1个回复

联系我们

工作时间:周一至周六,9:00-18:00

QR code