Database error: Invalid SQL: select a.mag, a.vol, a.no, ifnull(m.name, cast(a.no as char)) as issue, v.volume, a.artsubid as artid, a.artkey, a.startpage, a.endpage, a.urlname, a.havepdf, 0 as epub, s.nameen as snameen, a.doiblok+(select ifnull(sum(ra.doiblok), 0) from revarticles ra where d.doi=ra.doi) as doiblok, if(a.actdate <= now() and (a.deactdate is null or a.deactdate > now()), 1, 0) as isactive, date_format(m.outdate, '%e') as pubdate_d, date_format(m.outdate, '%c') as pubdate_m, date_format(m.outdate, '%Y') as pubdate_y, date_format(a.actdate, '%e') as pubdat2_d, date_format(a.actdate, '%c') as pubdat2_m, date_format(a.actdate, '%Y') as pubdat2_y, cn1.ctx as aname, cc1.ctx as abstract, ca1.ctx as ctxauthors, ck1.ctx as keywords, d.doi, d.crstatus, d.pmstatus, d.pmid, d.refcnt, d.citcnt, d.lastupd, d.citbylu, d.created from articles a join magvols v using (mag, vol) join magnos m on (a.mag = m.mag and a.vol = m.vol and a.no = m.no) left join sections s on (a.mag=s.mag and a.secid=s.secid) left join dois d using (artkey) left join ctx ca1 on (a.artkey=ca1.artkey and ca1.type=1 and ca1.paraid=0) left join ctx cn1 on (a.artkey=cn1.artkey and cn1.type=2 and cn1.paraid=0) left join ctx cc1 on (a.artkey=cc1.artkey and cc1.type=4 and cc1.paraid=0) left join ctx ck1 on (a.artkey=ck1.artkey and ck1.type=3 and ck1.paraid=0) where a.artkey like 'mnt-201801-0104'
MySQL Error: 1146 (Table 'mendelnetdb.dois' doesn't exist)
Session halted.