SELECT TABLE_SCHEMA FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA like '%agency%' group by TABLE_SCHEMA

Duplicate Schedules

SET innodb_strict_mode = 0; SELECT Progress_ID , COUNT(*) as tot_count FROM #Request.prefix_db_agency#.pProgress WHERE Status = 0 GROUP BY Progress_ID HAVING COUNT(*) > 1

Progress_ID	Total_counts	Agency database
#Progress_ID#	#tot_count#	#Request.prefix_db_agency#