谁能看得懂这条SQL 求解释
问答 1971
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