select a.shorttitle,a.title,a.keywords,b.body fromarchives as a right join content as b on a.id=b.aid where a.typeid=46
