MySQL statement set (ii)

SELECT *,count (*) as num from ' Wms_stock ' GROUP by SKU_ID,BATCH_SN have count (*) >1

After-sale refund an order with two export batches for the same item, multiple packages, refunds with multiple records resulting in duplicate data

SELECT salerefund.created, SALEREFUND.REFUND_SN, if (batched > 0, 1, 0) as Isbatch, WMSBATCHBASE.BATCH_SN                , salerefund.cust_name,saleorder.sp_name,saleorder.sup_name,sellerbase.seller_name,salerefund.sku_id, Goodssku.sku_name, Goodsbase.tax_fee, goodstypespec1.spec_name as specname1,saleorder.store_id, G Oodstypespec2.spec_name as SpecName2, Goodsunit.sale_unit, Salerefund.sku_num, Saleorderitem.sku_price, Sal Eorderitem.sale_price, Saleorderitem.tax_rate, SALEORDER.ORDER_SN, Saleorder.pay_name, SaleRefund.refund_mo Ney, Saleorder.real_total, Salerepay.repay_status, Salerepay.repay, salerefund.order_id, SaleOrder.ship_nam  E, Salerefund.note,sellerstore.store_name, goodscategory1.cat_name as catName1, goodscategory2.cat_name as Catname2,adminuser.user_name, Goodscategory3.cat_name as CatName3, Goodsbase.commission, Sa Leorder.refund_total,gooDsbase.sale_type,goodsbase.note as goods_note,salerepay.repay_id, Saleorderitem.sale_num, SaleRefund.refund                    _status, (SELECT group_concat (exp_no SEPARATOR '; ') From Wms_package as Wmspackage left JOIN Wms_package_item as Wmspackage  Item on wmspackageitem.pack_id = wmspackage.pack_id WHERE wmspackage.order_id = wmsorderbase.order_id and wmspackageitem.sku_id = saleorderitem.sku_id and Wm                       Spackage.pack_status <>) as Exp_no, (SELECT                        Stock_price from Wms_order_item as Wmsorderitem WHERE wmsorderitem.order_id = wmsorderbase.order_id and wmsorderitem.sku_id = Saleorderitem. sku_id ORder by batch_sn desc LIMIT 1) as StockPrice from                Sale_refund as Salerefund left JOIN Goods_sku as goodssku on goodssku.sku_id = salerefund.sku_id Left JOIN Sale_order_item as saleorderitem on saleorderitem.order_id = salerefund.order_id and Saleorderite                m.sku_id = salerefund.sku_id left JOIN sale_order as saleorder on saleorder.order_id = salerefund.order_id Left join Goods_base as goodsbase in goodsbase.goods_id = goodssku.goods_id LEFT JOIN seller _base as Sellerbase on sellerbase.seller_id=saleorder.seller_id left JOIN Goods_category as GoodsCategory1 On goodscategory1.cat_id = Goodsbase.cat_id1 left JOIN goods_category as GoodsCategory2 on goodscategory2.c at_id = Goodsbase.cat_id2 left JOIN goods_category as GoodsCategory3 on goodscategory3.cat_id = goodsbase.c AT_ID3 LEFT join Goods_type_spec as GOODSTYPESPEC1 on goodstypespec1.spec_id = GOODSSKU.SKU_SPEC1 LEFT Join Goods_ty Pe_spec as GoodsTypeSpec2 on goodstypespec2.spec_id = goodssku.sku_spec2 left JOIN goods_unit as Goodsunit On goodsunit.unit_id = goodsbase.unit_id left JOIN admin_user as AdminUser on adminuser.user_id = Salerefun D.created_user left JOIN Sale_repay as salerepay on salerepay.refund_id = salerefund.refund_id and Salerep ay.repay_type=2 and Salerepay.repay_status <>99 left joins Wms_batch_base as Wmsbatchbase on WMSBATCHB  ase.batch_id = salerefund.batch_id and Wmsbatchbase.batch_status=1 and wmsbatchbase.type_id = left JOIN Seller_store as Sellerstore on sellerstore.store_id = saleorder.store_id left JOIN wms_order_base as WmsO               Rderbase on wmsorderbase.out_order_id = saleorder.order_id and Wmsorderbase.order_status No in (98,99) WHERE    1 = 1%s        ORDER by salerefund.created Desc LIMIT%d,%d 

　　

MySQL statement set (ii)