pg12-15-fdw.sql.txt

SELECT
    *
FROM
    foobar.sys_data_table_info AS tbl
    INNER JOIN foobar.sys_folder_items fi ON tbl.table_id = fi.item_id
        AND fi.item_type = 'TABLE'
    LEFT JOIN foobar.sys_user_foreign uc ON tbl.created_by = uc.user_id
    LEFT JOIN foobar.sys_user_foreign uu ON tbl.updated_by = uu.user_id
WHERE
    tbl.table_status = 'A'
    AND tbl.table_id <> 1
    AND tbl.table_id <> - 2
ORDER BY
    updated_at DESC NULLS LAST