SELECT p.*,n.cost1,n.code1 from productmaster p,master_groups m,newproducts n where p.product_id=9257 and m.product_id=p.product_id and m.product_code=n.code1 order by n.cost1 ASC LIMIT 1Index newproducts is corrupted