I am using unions to get data from about 10 tables for one database

Now to union this in each of my databases is a lot of queries but works

Have you...