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