SELECT a.ID_NUM,gysmc,a.XL,a.SCCJC,CONVERT(varchar(20),a.zhtjsj, 120) as fbrq,CASE a.bearingid WHEN '70038' THEN CASE WHEN a.ly='_ؼ' THEN wltejia ELSE wltejia end else a.wltejia end as wltejia,
a.wlkgsl,a.qhsl,a.JLDW,LTRIM(RTRIM(a.bearingid)) as bearingid,a.xsgz,a.szqy,CASE a.XZTC WHEN '77' THEN '' else a.spbm end as spbm ,a.zlmc,a.SQDWID,a.wlzt,a.phone,a.ly,a.shop,
a.xsgz,'' as publicity,'' AS publicityPic,'' as fd_hynx, '' as fd_hyjf,'' as shopip,CHECKSUM(NEWID()) AS RandomValue FROM BEARING_JDW.dbo.XHZYBLSWT AS a where a.xhjb > 0 and (a.bearingid <>'70038' or a.bearingid ='70038' and a.shop<>'' and a.wlkgsl>0) and a.xl like '33205%' ORDER BY CASE
WHEN REPLACE(a.xl, ' ', '') = '33205' THEN 100
WHEN LEN(REPLACE(a.xl, ' ', '')) = LEN('33205')+1 and a.xl LIKE '33205[A-Za-z]' AND bearingid='70038' THEN 100
WHEN a.xl LIKE '33205%' THEN 80 - LEN(REPLACE(xl, '33205%', ''))
ELSE 0
END DESC, hl DESC,RandomValue offset 0 rows fetch next 20 rows only
佰联现货中心_中国专业轴承行业网站，始于1999年！
轴承展会
信用分510
腾讯担保支付