select DISTINCT id,cardname,price_net,source,pidname from h_s_card where isshow=1 and issold = 0 and pidname="zuoji" and ((substring(cardname,11,1) = substring(cardname,10,1)+1 and substring(cardname,10,1) = substring(cardname,9,1)+1 and substring(cardname,9,1) = substring(cardname,8,1)+1) or (substring(cardname,11,1) = substring(cardname,10,1)-1 and substring(cardname,10,1) = substring(cardname,9,1)-1 and substring(cardname,9,1) = substring(cardname,8,1)-1)) 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小时同城急速送达,为您提供高效服务
无忧支付
在线支付、转账、货到付款,多种支付选择
便捷购物体验
提供一站式、便捷购物体验