gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml | ●●●●● patch | view | raw | blame | history |
gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml
@@ -41,7 +41,7 @@ a.*, sum(b.quantity) quantity, sum(b.stock) stock, max(b.present_price) maxPrice min(b.present_price) minPrice from xzx_score_goods a inner join xzx_score_goods_sku b on a.id=b.goods_id and b.del_flag=0 <where> @@ -73,7 +73,7 @@ order by quantity desc </if> <if test="record.sort == 3"> order by maxPrice desc order by minPrice desc </if> </select>