SELECT id,title,createtime,Model,Price,Series,Pic.value('(/root/pic)[1]/@pics','varchar(256)') as PicS,Spec,PriceA,Unit,[+BrandName],PicEff.value('(/root/pic)[1]/@id','varchar(15)') as PicEff_ID,PicEff.value('(/root/pic)[1]/@title','varchar(256)') as PicEff_Title,PicEff.value('(/root/pic)[1]/@pics','varchar(256)') as PicEff_PicS,PriceD,Stat07,ClassID,[+ClassName],usescore FROM View_Products where classid in(140,152,207,224,448,449,450,142,144,146,150,153,154,155,157,159,161,162,164,175,184,202,204,210,212,214,221,223,329,434,226,15) order by case when charindex(','+cast(rtrim(id) as varchar(50))+',',',,,,')=0 then len(',,')+1 else charindex(','+cast(rtrim(id) as varchar(20))+',',',,,,') end,Stat03 desc,Stat04 desc,case when charindex(','+cast(rtrim(BrandID) as varchar(20))+',',',,137,655,655,137,260,483,,')=0 then len(',137,655,655,137,260,483,')+1 else charindex(','+cast(rtrim(BrandID) as varchar(20))+',',',,137,655,655,137,260,483,,') end,Hits desc