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