谁能看得懂这条SQL 求解释

qingkong 分类:问答

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条回复 我来回复

联系我们

商务:叶经理
技术:ketter

QR code