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

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

在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个回复

联系我们

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

QR code