select product.name,product.idx,product.id,product.introduce,product.estitle,product.price1,product.zk,product.ozk,product.zk_title,product.adddate,product.picSmall,product.stock,product.zk_lx,product.discount,product.amount,product.rank,product.same_pr,product.image,product.qdl,product.qu,[C].mprice1,[C].fxu,[C].p_zs from Product inner join (select COUNT(1) OVER() AS p_zs,same_pr,MAX(id) as id,row_number() over(order by max(X_TAG_LIST.xu) desc,sum(X_TAG_LIST.qty) desc) as fxu,MIN(price1) as mprice1 from product where zk_ing=1 and stock>0 and amount=1 group by same_pr) as [C] on product.id=[C].id where fxu between 1 and 60 order by fxuNothing Products!
|
English
Español
Order Tracking
Contact Us
Live chat , click , no need install
Help Center
Cart: 
