select distinct b.df_id as id, ABS(SUBSTRING(b.df_id, 4)) as no, b.jp_name as name, b.exhi_date date, b.regist_date from M_BOOTH b, M_GENRE g, R_GENRE r where b.df_id = r.df_id and r.genre_id = g.genre_id and b.del = '0' and SUBSTRING(b.df_id, 2, 2) = '27' order by b.regist_date desc, b.df_id desc limit 784, 28 [nativecode=145 ** Table './df_booth/M_BOOTH' is marked as crashed and should be repaired]