DECLARE @startDate AS DateTime
DECLARE @endDate AS DateTime
DECLARE @station AS int

SET @startDate = '2011/01/01'
SET @endDate = '2011/01/31'
SET @station = 2346

SELECT DISTINCT [t0].[CampaignID] AS [CampaignId], [t0].[CampaignPrettyName] AS [CampaignName], [t0].[DateCampaignStart] AS [CampaignStart],
                [t0].[DateCampaignEnd] AS [CampaignEnd], [t3].[Industry] AS [IndustryCode], [t4].[luName] AS [IndustryName],
                [t6].[iStationID] AS [StationId], [t6].[sPrettyName] AS [StationName], [t7].[iStationID] AS [MarketId], [t7].[sPrettyName] AS [MarketName]
FROM [t_AdTraffic_Campaigns] AS [t0]
INNER JOIN [t_AdTraffic_Ads] AS [t1] ON [t0].[CampaignID] = [t1].[CampaignID]
INNER JOIN [t_AdTraffic_AdStations] AS [t2] ON [t1].[AdID] = [t2].[AdID]
INNER JOIN [t_AdTraffic_Advertisers] AS [t3] ON [t0].[AdvertiserID] = ([t3].[AdvertiserID])
INNER JOIN [dbo].[amf_LookupsByluType]('AvoidanceGroups') AS [t4] ON [t3].[Industry] = [t4].[luVal]
INNER JOIN ([t_stationInfo] AS [t5]
    INNER JOIN [t_stationInfo] AS [t6] ON [t5].[iNetworkID] = [t6].[iNetworkID]
    INNER JOIN [t_stationInfo] AS [t7] ON [t6].[irollupstation] = [t7].[iStationID]
    INNER JOIN [t_stationInfo] AS [t8] ON [t6].[iNetworkID] = [t8].[iStationID]) ON [t2].[iStationID] = [t6].[iStationID]
WHERE ([t0].[DateCampaignEnd] >= @startDate) AND ([t0].[DateCampaignStart] <= @endDate) AND ([t1].[Status] = 'A') AND (EXISTS(
    SELECT NULL AS [EMPTY]
    FROM [t_stationInfo] AS [t9]
    WHERE ([t9].[iStationID] = [t2].[iStationID]) AND (([t9].[iStationID] = @station) OR ([t9].[irollupstation] = @station) OR ([t9].[iNetworkID] = @station))
    )) AND ([t5].[iStationID] = @station) AND ([t6].[iNetworkLevel] = 0)