SELECT D.*,G.gl_name,G.gl_tel 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 WHERE 1=1 AND ( gd_sdate < date_format('2025-12-18', '%Y-%m-%d 23:59:59') AND gd_edate > date_format('2025-12-18', '%Y-%m-%d 00:00:00') ) AND D.gd_state = 'Y' and D.gd_type = 'L' group by D.gd_code ORDER BY D.gd_code desc limit 220,20
Got error 28 from storage engine