All pastes #284897 Raw Edit

JasonSQL

public text v1 · immutable
#284897 ·published 2006-12-19 12:08 UTC
rendered paste body
SELECT spot.SpotID as ID, spot.ProgrammeName AS Programme, channel.ChannelName AS Channel, spot.DateTime AS DateTime, spot.Cost AS Cost, SUM(spot.ImpactsAdults+spot.ImpactsChildren) AS Impacts, SUM(spot.TVRsAdults+spot.TVRsChildren) AS TVRs spot.Sec AS Length, FROM spot, channel WHERE spot.ChannelID = channel.ChannelID AND spot.ProductID = 1 AND spot.DateTime >= 1009843200 AND spot.DateTime <= 1041487200