关于分销插件的的问题 不理解求解答

haixun 分类:问答

在plugins/distribution/admin/actions/addGoodsAction.class.php的代码片段,

$sql01 = "select min(b.num) as num,min(a.attribute) attribute,min(a.price) price,min(a.id) AS attr_id,min(b.id) id,min(b.product_title) product_title,min(b.imgurl) imgurl
        from lkt_configure as a 
        left join lkt_product_list as b on a.pid = b.id 
        where b.recycle = 0 and b.num >0 and a.num > 0 and b.status = 0 group by a.pid ";
$res = $db->select($sql01);

我不明白这条SQL是什么意思

回复

共1条回复 我来回复

联系我们

商务:叶经理
技术:ketter

QR code