Assuming recordowner is required, the following result was found.
AS "DataSource", date(t1."ModifiedTime") AS "Date", t1."RecordID" AS "Record ID", t1."RecordName" AS "Record Name", t1."RecordOwner" AS "Record Owner", img."ZohoAnalytics Image URL" AS "Status Image" FROM ( SELECT acc."Id" AS "RecordID", acc."Account...