SQL that finds all the alerts set in 10 content dbs

select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content1.dbo.schedsubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content2.dbo.schedsubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content3.dbo.schedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content4.dbo.schedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content5.dbo.schedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content6.dbo.schedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content7.dbo.schedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content8.dbo.schedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content9.dbo.schedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content10.dbo.schedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content1.dbo.immedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content2.dbo.immedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content3.dbo.immedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content4.dbo.immedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content5.dbo.immedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content6.dbo.immedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content7.dbo.immedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content8.dbo.immedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content9.dbo.immedSubscriptions
union
select distinct WebUrl, UserEmail from PROD_MOSS_EMPLOYEEMAIN_Site_Content10.dbo.immedSubscriptions
order by UserEmail