find content

declare @Asite varchar(2)

set @Asite = 'mb'

/* articles */
select COUNT(*) Articles
from web.dbo.Artikkler (nolock) 
where Avis=@Asite

/*teasers*/


/*story archives*/ 

/*galleries*/
select COUNT(*) Galleries
from web.dbo.Artikler_photoalbum (nolock) 
where Avis=@Asite

/*article assets*/ 
select COUNT(*) ArticleAssets
from web.dbo.MediaFiles (nolock)
where Avis=@Asite

/*guides*/
select COUNT(*) Guides
from portal.dbo.Guide (nolock) 
where RegAvis=@Asite

/*link directory*/ 
select COUNT(*)  LinkDirectoryLinks
from portal.dbo.Links (nolock) 
where Site=@Asite