16 :
17 :
18 : <CFQUERY NAME="TopSeriesDetail" DATASOURCE="TvOnline">
19 : SELECT top 500 Program_Id, LongChannelName, Language, Country, Title, LittleSummary, Type, TimeStamp AS DayTime, Left(LittleSummary,200) as BeginSummary
20 : FROM TvStations INNER JOIN TVOnline ON TvStations.EuroTvShortName = TVOnline.EuroTvShortName
|