select table_schema,table_name
FROM INFORMATION_SCHEMA.TABLES b
WHERE
b.TABLE_SCHEMA not in ('METRICS_SCHEMA','mysql','INFORMATION_SCHEMA','PERFORMANCE_SCHEMA','test') and table_type='BASE TABLE' and
(table_schema, table_name) not in
(select TABLE_SCHEMA,TABLE_NAME from
(select TABLE_SCH…