##error##SELECT a.* FROM `2011_productInfo` AS a USE index(productInfoList) WHERE Pshop='1000u' AND Pdeleted=0 AND PenglishView = 0 AND Pprice3>0 AND Pstate<10 AND Pagree=1 AND Pweight < '5000' AND (Pcategory2 LIKE 'C01%' or Pcategory3 LIKE 'C01%') AND (a.BRIDX = '50' or a.BRIDX2 = '50') ORDER BY sumCount DESC, IDX DESC LIMIT 0,25