select '1' as pc,id,sphoto,title,colors,fonts,subtitle,price,hits,sort,addtime from goods where ishow=1 and fullid like ',0,28,%' and (title like '%新材料%' or subtitle like '%新材料%') union all select '2' as pc,id,sphoto,title,colors,fonts,subtitle,price,hits,sort,addtime from goods where ishow=1 and fullid like ',0,28,%' and (title like '%新材料%' or subtitle like '%新材料%') union all select '3' as pc,id,sphoto,title,colors,fonts,subtitle,price,hits,sort,addtime from goods where ishow=1 and fullid like ',0,28,%' and (title like '%新材料%' or subtitle like '%新材料%') union all select '4' as pc,id,sphoto,title,colors,fonts,subtitle,price,hits,sort,addtime from goods where ishow=1 and fullid like ',0,28,%' and (title like '%新材料%' or subtitle like '%新材料%') union all select '5' as pc,id,sphoto,title,colors,fonts,subtitle,price,hits,sort,addtime from goods where ishow=1 and fullid like ',0,28,%' and (title like '%新材料%' or subtitle like '%新材料%') order by pc, sort,addtime desc