SELECT
									s.date_time,
									c.campaignname,
									s.campaign_id,
									c.revenue_type,
									s.revenue,
									s.costs,
									s.impressions,
									s.conversions,
									i.icat_id
								FROM
									db02.mnt_compiled_stats_realtime s
								LEFT JOIN db02.ox_campaigns c ON
									c.campaignid = s.campaign_id
								LEFT JOIN db02.mnt_icat_campaigns_mapping i ON
									i.campaign_id = s.campaign_id
								where
									s.date_time BETWEEN TIMESTAMPADD( SQL_TSI_HOUR,- 48, now()) and now()