SELECT D.*, G.gl_name FROM dj_gallery_display D LEFT JOIN dj_gallery_connect C ON D.gd_code=C.gd_code LEFT JOIN dj_gallery G ON C.gl_code = G.gl_code LEFT JOIN dj_display_connect Z ON D.gd_code=Z.gd_code WHERE 1=1 and D.gd_state = 'Y' and D.s_ready = '1' group by D.gd_code ORDER BY D.gd_edate desc limit 80,10
Incorrect key file for table '/mysql_tmp/#sql_d59_2.MYI'; try to repair it