SELECT b.ocrfilename, b.ocrfilepath, b.ocrpageno, c.acsdoclevel, c.acsdocdate, c.doctype,
d.acddocinfo, c.docsubtype, c.acsdocitemref, c.acsdocinfo, b.ocrxytext, c.acsdref,
i.aciimg_type, p.ocrpagex, p.ocrpagey
FROM ocrcrossref a INNER JOIN imageocrtext b ON b.ocrref = a.ocrref
INNER JOIN fullsubdocumentdetails c ON c.acsdref = a.sdref
INNER JOIN documentdetails d ON d.acddref = a.TLDREF
INNER JOIN imagereferences i ON  i.aciref = a.imglinkref
LEFT JOIN imageocrtextpagedimns p ON p.ocrref = a.ocrref
WHERE TEXTSEARCHjaegerer' IN b.ocrtext)
ORDER BY c.acsdocdate