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(218,250,253,266,270,285,287,219,220,222,225,227,228,230,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,251,252,254,255,256,257,258,259,260,261,263,264,265,267,268,269,271,272,273,274,275,280,281,282,283,11) 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))+',',',,86,215,661,267,,')=0 then len(',86,215,661,267,')+1 else charindex(','+cast(rtrim(BrandID) as varchar(20))+',',',,86,215,661,267,,') end,Hits desc