select DISTINCT cardname,price_net,source,pidname from h_s_card where id in (SELECT id from demo WHERE isshow=1 and issold = 0 and pidname="yidong" and left(cardname,3)="139" and price_net between 2001 and 5000 and ( substring(cardname,-2,2)%11 !=0 and substring(cardname,-2,2) = substring(cardname,-4,2) ) and cardname like "9999%") order by (case source when 'WH' then 1 when 'MR' then 2 when 'CC' then 3 when 'GG' then 4 when 'CB' then 5 when '' then 6 else 7 end)
我们的优势
实体批发
日出卡量1500余张,全区域商家覆盖
个人信息保护
所有相关资料仅用于实名登记
专属客服
7x24小时专属客服贴心服务,专注通讯问题
高效服务
3小时同城急速送达,为您提供高效服务
无忧支付
在线支付、转账、货到付款,多种支付选择
便捷购物体验
提供一站式、便捷购物体验