Error Number: 1030

Got error 28 from storage engine

SELECT S.*, PD.pay_detail_id FROM (`t_shop` S) LEFT JOIN (SELECT * FROM t_shop_treat WHERE active_flag = 1) ST ON S.shop_id = ST.shop_id LEFT JOIN `t_pay_detail` PD ON S.shop_id = PD.shop_id WHERE S.offer_type = 1 AND S.tiiki_id = 5 AND job_type_id = 19 GROUP BY S.shop_id ORDER BY S.bonita_shop_level DESC, `rand_no` ASC LIMIT 20