| | |
|---|
| | | </select> |
|---|
| | | <select id="pageShopGoodByApps" resultType="com.panzhihua.common.model.vos.shop.ComShopFlowerGoodsVO"> |
|---|
| | | select csg.id,csg.`name`,csg.store_id,csg.goods_pic,csg.images,csg.`status`,csg.sale,csg.original_price |
|---|
| | | ,csg.price,csg.unit,csg.`order`,csg.stock,csg.details,csg.delivery_type, csg.create_at, |
|---|
| | | (SELECT count(fog.id) FROM com_shop_flower_order_goods as fog WHERE fog.goods_id = 1) as order_num |
|---|
| | | ,csg.price,csg.unit,csg.`order`,csg.details,csg.delivery_type, csg.create_at, |
|---|
| | | (SELECT count(fog.id) FROM com_shop_flower_order_goods as fog WHERE fog.goods_id = csg.id) as order_num, |
|---|
| | | (SELECT ifnull(sum(ga.stock),0) from com_shop_flower_goods_attr ga where ga.goods_id = csg.id ) as stock |
|---|
| | | from com_shop_flower_goods as csg |
|---|
| | | left join com_convenient_merchants as css on css.id = csg.store_id |
|---|
| | | left join com_convenient_goods_scope as cgs on cgs.goods_id = csg.id |
|---|
