Database error: Invalid SQL: select a.artkey, a.secid, a.ord, a.vol, a.no, a.artsubid, if(a.havepdf = 'y', 1, 0) as havepdf, if(n.pdfdate <= now(), 1, 0) as canpdf, a.actdate, a.deactdate, a.urlname, a.startpage, a.endpage, a.pdfpages, s.name as sname, s.nameen as snameen, a.doi, a.doiblok, d.crstatus, cn.ctx as aname, ca.ctx as authors, cs.ctx as comment , ce.ctx as anameen, cf.ctx as commenten , (select group_concat(cast(vtid as char)) from art_virthemes vt where vt.artkey=a.artkey) as vtlist , (select sum(showed) from logarts ah where ah.artkey=a.artkey order by yr desc, fmon desc limit 999) as view_count from articles a join magnos n using (mag, vol, no) join sections s using (mag, secid) left outer join dois d on (a.artkey = d.artkey) left join ctx ca on (a.artkey = ca.artkey and ca.type = 1 and ca.paraid=0) left join ctx cn on (a.artkey = cn.artkey and cn.type = 2 and cn.paraid=0) left join ctx cs on (a.artkey = cs.artkey and cs.type = 4 and cs.paraid=0) left join ctx ce on (a.artkey = ce.artkey and ce.type = 12 and ce.paraid=0) left join ctx cf on (a.artkey = cf.artkey and cf.type = 14 and cf.paraid=0) where a.mag = 'aip' and a.vol = '2026' and a.no = '3' and a.actdate <= now() order by s.ord, a.secid, CAST(if(a.startpage='X',999,a.startpage) as unsigned), a.artkey
MySQL Error: 1030 (Got error 28 from storage engine)