Assuming recordname is required, the following result was found.
it as such: SELECT 'CRM Accounts' 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...