谁能看得懂这条SQL 求解释

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

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