Video

Featured video - Brad Pitt: Latest dramatic scenes from Glasgow movie set

To view content in the STV player you need to enable Javascript.

Summary: The picture, from zombie flick World War Z, shows a bin lorry colliding into a row of cars as pedestrians flee for their lives.

Popular on STV Player

>  ColdBox Debugging Information
 

Framework Info:
ColdBox 2.6.3 RENEWED
Application Name:
STV Video (production)
Template:
/var/www/webapps/video.stv.tv/index.cfm
TimeStamp:
Feb-23-2012 02:26:45 PM
Query String:
urlparam=/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/
Server Instance:
stv-web2
Current Event:
general.index
Current Layout:
Layout.Main.cfm
Current View:
home
Timestamp Execution Time Framework Method RC Snapshot
02:26:41.887 PM 3 ms interception [afterAspectsLoad] View
{urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/}}
02:26:42.186 PM 0 ms interception [afterPluginCreation] View
{urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} path_info={/}}
02:26:42.230 PM 0 ms interception [afterHandlerCreation] View
{urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} event={general.index} path_info={/}}
02:26:42.231 PM 0 ms invoking runEvent [main.onAppInit] View
{urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} event={general.index} path_info={/}}
02:26:42.233 PM 2 ms interception [preProcess] View
{urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} event={general.index} path_info={/}}
02:26:42.234 PM 0 ms interception [afterHandlerCreation] View
{urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} event={general.index} path_info={/}}
02:26:42.250 PM 1 ms interception [afterPluginCreation] View
{urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} event={general.index} path_info={/}}
02:26:45.276 PM 3042 ms invoking runEvent [main.onRequestStart] View
{event={general.index} pagekeywords={stv video tv shows soaps clips latest news sport entertainment showbiz gossip} urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} MOSTPOPULAR={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vl.plays_trend vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now() interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 611 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |plays_trend |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20946874001 | |Ella Edmondson sings |Ella Edmondson da...|{ts '1970-01-01 00...|ella-edmondson-sings |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |55221454001 | |Rangers say Boyd d...|Martin Bain tells ...|{ts '1970-01-01 00...|rangers-say-boyd-d...|sport-football-boy...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |6262033001 | |Islanders mark 90-...|Residents of Lewis...|{ts '1970-01-01 00...|islanders-mark-90-...|news-headlines-nt-...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1847316428 | |Glen Michael is back |Glen Michael prob...|{ts '1970-01-01 00...|glen-michael-is-back |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577224001 | |Central Scotland w...|The latest weather...|{ts '1970-01-01 00...|central-scotland-w...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577222001 | |North of Scotland ...|The latest weather...|{ts '1970-01-01 00...|north-of-scotland-...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |30481332001 | |Weather forecast f...|Sean Batty takes a...|{ts '1970-01-01 00...|weather-forecast-f...|scotland-thegather...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20229945001 | |Old Firm English P...|Chairman of Englis...|{ts '1970-01-01 00...|old-firm-english-p...|news-090420-l2-old...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |18160924001 | |Scottish heather i...|"We want to turn t...|{ts '1970-01-01 00...|scottish-heather-i...|news-headlines-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |16951175001 | |Pressley: fearless...|Steven Pressley is...|{ts '1970-01-01 00...|pressley-fearless-...|sport-football-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } appname={STV Video} JUSTADDED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10 --------------------------------------------------- Execution Time: 9 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467673285001 | |STV News (Central ...|The Labour MP for ...|{ts '1970-01-01 00...|stv-news-central-e...|catchup-ac2-stvnew...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467646329001 | |catchup-ac2-mez-lo...|catchup-ac2-mez-lo...|{ts '1970-01-01 00...|catchup-ac2-mez-lo...|catchup-ac2-mez-lo...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467679919001 | |Welfare changes 'd...|Citizen's Advice: ...|{ts '1970-01-01 00...|welfare-changes-de...|news-120223-l-welfare| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467682242001 | |catchup-ac2-mez-st...|catchup-ac2-mez-st...|{ts '1970-01-01 00...|catchup-ac2-mez-st...|catchup-ac2-mez-st...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467566135001 | |Paul Dixon can get...|Peter Houston has ...|{ts '1970-01-01 00...|paul-dixon-can-get...|sport-houston-2012...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467637160001 | |Stephen Hester: 'R...|"RBS CEO Stephen H...|{ts '1970-01-01 00...|stephen-hester-rbs...|ITN_230212_uklsrbs...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467637152001 | |Dog trained to loo...|Jury told by scene...|{ts '1970-01-01 00...|dog-trained-to-loo...|news-120223-l-pilley | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467526068001 | |catchup-ac2-mez-th...|catchup-ac2-mez-th...|{ts '1970-01-01 00...|catchup-ac2-mez-th...|catchup-ac2-mez-th...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467534815001 | |Labour MP punching...|"John Bercow bans ...|{ts '1970-01-01 00...|labour-mp-punching...|ITN_230212_uklsjoy...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1464747327001 | |Glasgow Music and ...|STV talked to memb...|{ts '1970-01-01 00...|glasgow-music-and-...|entertainment-gff-...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } popularepisodes={Query --------------------------------------------------- select pl.plays_total pl.plays_trailing_week prog.programmeName prog.archive prog.catchupSlug if(length(prog.programmeNiceName)>30 prog.programmeShortName prog.programmeNiceName) as programmeNiceName prog.programmeURL vc.videoDescription as summary tvl.runDateTime concat('/programmes/' programmeName '/' date_format(runDateTime '%Y-%m-%d-%H%i') '/') as permalink pc.slug as categorySlug pc.genre find_in_set("=GUIDANCE" vc.videoTags) as guidance concat(programmeName '-' date_format(runDateTime '%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate 10) vc.videoRefID order by pl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 1317 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |plays_total |plays_trailing_week |programmeName |archive |catchupSlug |programmeNiceName |programmeURL |summary |runDateTime |permalink |categorySlug |genre |guidance |episodeName | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3925 |3925 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|An angry altercati...|{ts '2012-02-06 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3549 |3549 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Will Carla turn he...|{ts '2012-02-06 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3462 |3462 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Has Carla and Pete...|{ts '2012-02-09 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3395 |3395 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Can Rosie make ame...|{ts '2012-02-10 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3297 |3297 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Rosie is in turmoi...|{ts '2012-02-10 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2412 |2412 |love-hate |0 |catchup-lovehate |Love/Hate |http://programmes....|Drama series set i...|{ts '2012-02-09 21...|/programmes/love-h...|drama-series |Drama Series |8 |love-hate-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2283 |2283 |take-me-out |0 |catchup-takemeout |Take Me Out | |Paddy McGuinness t...|{ts '2012-02-11 20...|/programmes/take-m...|entertainment |Entertainment |0 |take-me-out-2012-0...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2241 |2241 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|The Pollards final...|{ts '2012-02-06 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2041 |2041 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Moira's worst fear...|{ts '2012-02-08 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2029 |2029 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|John makes a big d...|{ts '2012-02-07 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } pagedescription={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} pagetitle={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} path_info={/} MOSTCOMMENTED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10 --------------------------------------------------- Execution Time: 27 --------------------------------------------------- Recordcount: 5 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |7031877001 | |Get Fit Rachel - L...|The five thirty sh...|{ts '1970-01-01 00...|get-fit-rachel-lac...|entertainment-five...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |25652378001 | |The world’s only w...|Islay woman Ailsa ...|{ts '1970-01-01 00...|the-worlds-only-wh...|entertainment-theh...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |54208705001 | |Supermarket under ...|Alcohol campaigner...|{ts '1970-01-01 00...|supermarket-under-...|news-091204-l2-drink | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |48371638001 | |When Bon Jovi rock...|New Jersey rockers...|{ts '1970-01-01 00...|when-bon-jovi-rock...|news-archive-09110...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |43211611001 | |Mowbray: I will bu...|Celtic boss lookin...|{ts '1970-01-01 00...|mowbray-i-will-buy...|sport-football-mow...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ }}
02:26:45.292 PM 1 ms interception [afterHandlerCreation] View
{event={general.index} pagekeywords={stv video tv shows soaps clips latest news sport entertainment showbiz gossip} urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} MOSTPOPULAR={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vl.plays_trend vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now() interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 611 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |plays_trend |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20946874001 | |Ella Edmondson sings |Ella Edmondson da...|{ts '1970-01-01 00...|ella-edmondson-sings |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |55221454001 | |Rangers say Boyd d...|Martin Bain tells ...|{ts '1970-01-01 00...|rangers-say-boyd-d...|sport-football-boy...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |6262033001 | |Islanders mark 90-...|Residents of Lewis...|{ts '1970-01-01 00...|islanders-mark-90-...|news-headlines-nt-...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1847316428 | |Glen Michael is back |Glen Michael prob...|{ts '1970-01-01 00...|glen-michael-is-back |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577224001 | |Central Scotland w...|The latest weather...|{ts '1970-01-01 00...|central-scotland-w...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577222001 | |North of Scotland ...|The latest weather...|{ts '1970-01-01 00...|north-of-scotland-...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |30481332001 | |Weather forecast f...|Sean Batty takes a...|{ts '1970-01-01 00...|weather-forecast-f...|scotland-thegather...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20229945001 | |Old Firm English P...|Chairman of Englis...|{ts '1970-01-01 00...|old-firm-english-p...|news-090420-l2-old...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |18160924001 | |Scottish heather i...|"We want to turn t...|{ts '1970-01-01 00...|scottish-heather-i...|news-headlines-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |16951175001 | |Pressley: fearless...|Steven Pressley is...|{ts '1970-01-01 00...|pressley-fearless-...|sport-football-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } appname={STV Video} JUSTADDED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10 --------------------------------------------------- Execution Time: 9 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467673285001 | |STV News (Central ...|The Labour MP for ...|{ts '1970-01-01 00...|stv-news-central-e...|catchup-ac2-stvnew...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467646329001 | |catchup-ac2-mez-lo...|catchup-ac2-mez-lo...|{ts '1970-01-01 00...|catchup-ac2-mez-lo...|catchup-ac2-mez-lo...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467679919001 | |Welfare changes 'd...|Citizen's Advice: ...|{ts '1970-01-01 00...|welfare-changes-de...|news-120223-l-welfare| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467682242001 | |catchup-ac2-mez-st...|catchup-ac2-mez-st...|{ts '1970-01-01 00...|catchup-ac2-mez-st...|catchup-ac2-mez-st...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467566135001 | |Paul Dixon can get...|Peter Houston has ...|{ts '1970-01-01 00...|paul-dixon-can-get...|sport-houston-2012...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467637160001 | |Stephen Hester: 'R...|"RBS CEO Stephen H...|{ts '1970-01-01 00...|stephen-hester-rbs...|ITN_230212_uklsrbs...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467637152001 | |Dog trained to loo...|Jury told by scene...|{ts '1970-01-01 00...|dog-trained-to-loo...|news-120223-l-pilley | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467526068001 | |catchup-ac2-mez-th...|catchup-ac2-mez-th...|{ts '1970-01-01 00...|catchup-ac2-mez-th...|catchup-ac2-mez-th...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467534815001 | |Labour MP punching...|"John Bercow bans ...|{ts '1970-01-01 00...|labour-mp-punching...|ITN_230212_uklsjoy...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1464747327001 | |Glasgow Music and ...|STV talked to memb...|{ts '1970-01-01 00...|glasgow-music-and-...|entertainment-gff-...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } popularepisodes={Query --------------------------------------------------- select pl.plays_total pl.plays_trailing_week prog.programmeName prog.archive prog.catchupSlug if(length(prog.programmeNiceName)>30 prog.programmeShortName prog.programmeNiceName) as programmeNiceName prog.programmeURL vc.videoDescription as summary tvl.runDateTime concat('/programmes/' programmeName '/' date_format(runDateTime '%Y-%m-%d-%H%i') '/') as permalink pc.slug as categorySlug pc.genre find_in_set("=GUIDANCE" vc.videoTags) as guidance concat(programmeName '-' date_format(runDateTime '%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate 10) vc.videoRefID order by pl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 1317 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |plays_total |plays_trailing_week |programmeName |archive |catchupSlug |programmeNiceName |programmeURL |summary |runDateTime |permalink |categorySlug |genre |guidance |episodeName | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3925 |3925 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|An angry altercati...|{ts '2012-02-06 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3549 |3549 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Will Carla turn he...|{ts '2012-02-06 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3462 |3462 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Has Carla and Pete...|{ts '2012-02-09 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3395 |3395 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Can Rosie make ame...|{ts '2012-02-10 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3297 |3297 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Rosie is in turmoi...|{ts '2012-02-10 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2412 |2412 |love-hate |0 |catchup-lovehate |Love/Hate |http://programmes....|Drama series set i...|{ts '2012-02-09 21...|/programmes/love-h...|drama-series |Drama Series |8 |love-hate-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2283 |2283 |take-me-out |0 |catchup-takemeout |Take Me Out | |Paddy McGuinness t...|{ts '2012-02-11 20...|/programmes/take-m...|entertainment |Entertainment |0 |take-me-out-2012-0...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2241 |2241 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|The Pollards final...|{ts '2012-02-06 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2041 |2041 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Moira's worst fear...|{ts '2012-02-08 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2029 |2029 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|John makes a big d...|{ts '2012-02-07 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } pagedescription={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} pagetitle={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} path_info={/} MOSTCOMMENTED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10 --------------------------------------------------- Execution Time: 27 --------------------------------------------------- Recordcount: 5 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |7031877001 | |Get Fit Rachel - L...|The five thirty sh...|{ts '1970-01-01 00...|get-fit-rachel-lac...|entertainment-five...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |25652378001 | |The world’s only w...|Islay woman Ailsa ...|{ts '1970-01-01 00...|the-worlds-only-wh...|entertainment-theh...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |54208705001 | |Supermarket under ...|Alcohol campaigner...|{ts '1970-01-01 00...|supermarket-under-...|news-091204-l2-drink | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |48371638001 | |When Bon Jovi rock...|New Jersey rockers...|{ts '1970-01-01 00...|when-bon-jovi-rock...|news-archive-09110...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |43211611001 | |Mowbray: I will bu...|Celtic boss lookin...|{ts '1970-01-01 00...|mowbray-i-will-buy...|sport-football-mow...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ }}
02:26:45.322 PM 27 ms invoking runEvent [general.index] View
{welcomemessage={Welcome to ColdBox!} pagekeywords={stv video tv shows soaps clips latest news sport entertainment showbiz gossip} EDITORSPICKS={Query --------------------------------------------------- select vp.playlistNiceName vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_playlist_titles vpt on vpt.videoid = vc.videoid inner join video_playlists vp on vp.playlistID = vpt.playlistID where vp.playlistrefid = 'Editors-Picks' and isCatchup = 0 order by vpt.playlistRank asc limit 7 --------------------------------------------------- Execution Time: 19 --------------------------------------------------- Recordcount: 7 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |playlistNiceName |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1118657956001 | |Brad Pitt: Latest ...|The picture from ...|{ts '1970-01-01 00...|brad-pitt-latest-d...|stv-news-bradpitt | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1115914203001 | |Alexandra Burke & ...|Daily poll alert! ...|{ts '1970-01-01 00...|alexandra-burke-be...|xfactor2011-110808...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1115425249001 | |Bagpuss interviews...|It’s the interview...|{ts '1970-01-01 00...|bagpuss-interviews...|entertainment-fest...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1101773767001 | |Jedward sing Oops ...|Jedward performing...|{ts '1970-01-01 00...|jedward-sing-oops-...|xfactor2011-110808...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1117333807001 | |Gary Barlow reveal...|X Factor judge Gar...|{ts '1970-01-01 00...|gary-barlow-reveal...|xfactor2011-110819...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1112147714001 | |Back to School: Dr...|Psychiatrist Dr Al...|{ts '1970-01-01 00...|back-to-school-dr-...|entertainment-web-...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1092144367001 | |The X Factor Final...|The X Factor final...|{ts '1970-01-01 00...|the-x-factor-final...|xfactor2011-110802...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} pageid={home} path_info={/} VIDEOSTRUCT={{VIDEOSEQUENCE={1118657956001 1115914203001 1115425249001 1101773767001 1117333807001 1112147714001 1092144367001} VIDEOTOTAL={7} CURRENTVIDEO={1118657956001}}} JUSTADDED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10 --------------------------------------------------- Execution Time: 9 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467673285001 | |STV News (Central ...|The Labour MP for ...|{ts '1970-01-01 00...|stv-news-central-e...|catchup-ac2-stvnew...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467646329001 | |catchup-ac2-mez-lo...|catchup-ac2-mez-lo...|{ts '1970-01-01 00...|catchup-ac2-mez-lo...|catchup-ac2-mez-lo...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467679919001 | |Welfare changes 'd...|Citizen's Advice: ...|{ts '1970-01-01 00...|welfare-changes-de...|news-120223-l-welfare| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467682242001 | |catchup-ac2-mez-st...|catchup-ac2-mez-st...|{ts '1970-01-01 00...|catchup-ac2-mez-st...|catchup-ac2-mez-st...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467566135001 | |Paul Dixon can get...|Peter Houston has ...|{ts '1970-01-01 00...|paul-dixon-can-get...|sport-houston-2012...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467637160001 | |Stephen Hester: 'R...|"RBS CEO Stephen H...|{ts '1970-01-01 00...|stephen-hester-rbs...|ITN_230212_uklsrbs...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467637152001 | |Dog trained to loo...|Jury told by scene...|{ts '1970-01-01 00...|dog-trained-to-loo...|news-120223-l-pilley | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467526068001 | |catchup-ac2-mez-th...|catchup-ac2-mez-th...|{ts '1970-01-01 00...|catchup-ac2-mez-th...|catchup-ac2-mez-th...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467534815001 | |Labour MP punching...|"John Bercow bans ...|{ts '1970-01-01 00...|labour-mp-punching...|ITN_230212_uklsjoy...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1464747327001 | |Glasgow Music and ...|STV talked to memb...|{ts '1970-01-01 00...|glasgow-music-and-...|entertainment-gff-...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } appname={STV Video} FEATUREDPLAYLISTS={Query --------------------------------------------------- select * from video_playlists where featured = 1 order by rand() --------------------------------------------------- Execution Time: 4 --------------------------------------------------- Recordcount: 0 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |id |playlistName |playlistNiceName |playlistTags |playlistid |playlistrefid |featured |playlistTotal |playlistThumb |firstVideo |public | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } RUNDATETIME={0} pagedescription={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} popularepisodes={Query --------------------------------------------------- select pl.plays_total pl.plays_trailing_week prog.programmeName prog.archive prog.catchupSlug if(length(prog.programmeNiceName)>30 prog.programmeShortName prog.programmeNiceName) as programmeNiceName prog.programmeURL vc.videoDescription as summary tvl.runDateTime concat('/programmes/' programmeName '/' date_format(runDateTime '%Y-%m-%d-%H%i') '/') as permalink pc.slug as categorySlug pc.genre find_in_set("=GUIDANCE" vc.videoTags) as guidance concat(programmeName '-' date_format(runDateTime '%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate 10) vc.videoRefID order by pl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 1317 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |plays_total |plays_trailing_week |programmeName |archive |catchupSlug |programmeNiceName |programmeURL |summary |runDateTime |permalink |categorySlug |genre |guidance |episodeName | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3925 |3925 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|An angry altercati...|{ts '2012-02-06 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3549 |3549 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Will Carla turn he...|{ts '2012-02-06 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3462 |3462 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Has Carla and Pete...|{ts '2012-02-09 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3395 |3395 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Can Rosie make ame...|{ts '2012-02-10 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3297 |3297 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Rosie is in turmoi...|{ts '2012-02-10 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2412 |2412 |love-hate |0 |catchup-lovehate |Love/Hate |http://programmes....|Drama series set i...|{ts '2012-02-09 21...|/programmes/love-h...|drama-series |Drama Series |8 |love-hate-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2283 |2283 |take-me-out |0 |catchup-takemeout |Take Me Out | |Paddy McGuinness t...|{ts '2012-02-11 20...|/programmes/take-m...|entertainment |Entertainment |0 |take-me-out-2012-0...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2241 |2241 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|The Pollards final...|{ts '2012-02-06 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2041 |2041 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Moira's worst fear...|{ts '2012-02-08 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2029 |2029 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|John makes a big d...|{ts '2012-02-07 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } event={general.index} currentview={home} MOSTCOMMENTED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10 --------------------------------------------------- Execution Time: 27 --------------------------------------------------- Recordcount: 5 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |7031877001 | |Get Fit Rachel - L...|The five thirty sh...|{ts '1970-01-01 00...|get-fit-rachel-lac...|entertainment-five...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |25652378001 | |The world’s only w...|Islay woman Ailsa ...|{ts '1970-01-01 00...|the-worlds-only-wh...|entertainment-theh...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |54208705001 | |Supermarket under ...|Alcohol campaigner...|{ts '1970-01-01 00...|supermarket-under-...|news-091204-l2-drink | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |48371638001 | |When Bon Jovi rock...|New Jersey rockers...|{ts '1970-01-01 00...|when-bon-jovi-rock...|news-archive-09110...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |43211611001 | |Mowbray: I will bu...|Celtic boss lookin...|{ts '1970-01-01 00...|mowbray-i-will-buy...|sport-football-mow...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } MOSTPOPULAR={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vl.plays_trend vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now() interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 611 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |plays_trend |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20946874001 | |Ella Edmondson sings |Ella Edmondson da...|{ts '1970-01-01 00...|ella-edmondson-sings |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |55221454001 | |Rangers say Boyd d...|Martin Bain tells ...|{ts '1970-01-01 00...|rangers-say-boyd-d...|sport-football-boy...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |6262033001 | |Islanders mark 90-...|Residents of Lewis...|{ts '1970-01-01 00...|islanders-mark-90-...|news-headlines-nt-...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1847316428 | |Glen Michael is back |Glen Michael prob...|{ts '1970-01-01 00...|glen-michael-is-back |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577224001 | |Central Scotland w...|The latest weather...|{ts '1970-01-01 00...|central-scotland-w...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577222001 | |North of Scotland ...|The latest weather...|{ts '1970-01-01 00...|north-of-scotland-...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |30481332001 | |Weather forecast f...|Sean Batty takes a...|{ts '1970-01-01 00...|weather-forecast-f...|scotland-thegather...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20229945001 | |Old Firm English P...|Chairman of Englis...|{ts '1970-01-01 00...|old-firm-english-p...|news-090420-l2-old...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |18160924001 | |Scottish heather i...|"We want to turn t...|{ts '1970-01-01 00...|scottish-heather-i...|news-headlines-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |16951175001 | |Pressley: fearless...|Steven Pressley is...|{ts '1970-01-01 00...|pressley-fearless-...|sport-football-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } VIDEOPERMALINK={brad-pitt-latest-dramatic-scenes-from-glasgow-movie-set} currentlayout={Layout.Main.cfm} pagetitle={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip}}
02:26:45.345 PM 0 ms interception [afterPluginCreation] View
{welcomemessage={Welcome to ColdBox!} pagekeywords={stv video tv shows soaps clips latest news sport entertainment showbiz gossip} EDITORSPICKS={Query --------------------------------------------------- select vp.playlistNiceName vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_playlist_titles vpt on vpt.videoid = vc.videoid inner join video_playlists vp on vp.playlistID = vpt.playlistID where vp.playlistrefid = 'Editors-Picks' and isCatchup = 0 order by vpt.playlistRank asc limit 7 --------------------------------------------------- Execution Time: 19 --------------------------------------------------- Recordcount: 7 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |playlistNiceName |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1118657956001 | |Brad Pitt: Latest ...|The picture from ...|{ts '1970-01-01 00...|brad-pitt-latest-d...|stv-news-bradpitt | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1115914203001 | |Alexandra Burke & ...|Daily poll alert! ...|{ts '1970-01-01 00...|alexandra-burke-be...|xfactor2011-110808...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1115425249001 | |Bagpuss interviews...|It’s the interview...|{ts '1970-01-01 00...|bagpuss-interviews...|entertainment-fest...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1101773767001 | |Jedward sing Oops ...|Jedward performing...|{ts '1970-01-01 00...|jedward-sing-oops-...|xfactor2011-110808...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1117333807001 | |Gary Barlow reveal...|X Factor judge Gar...|{ts '1970-01-01 00...|gary-barlow-reveal...|xfactor2011-110819...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1112147714001 | |Back to School: Dr...|Psychiatrist Dr Al...|{ts '1970-01-01 00...|back-to-school-dr-...|entertainment-web-...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |Editor's Picks |1092144367001 | |The X Factor Final...|The X Factor final...|{ts '1970-01-01 00...|the-x-factor-final...|xfactor2011-110802...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } urlparam={/bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/} pageid={home} path_info={/} VIDEOSTRUCT={{VIDEOSEQUENCE={1118657956001 1115914203001 1115425249001 1101773767001 1117333807001 1112147714001 1092144367001} VIDEOTOTAL={7} CURRENTVIDEO={1118657956001}}} JUSTADDED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10 --------------------------------------------------- Execution Time: 9 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467673285001 | |STV News (Central ...|The Labour MP for ...|{ts '1970-01-01 00...|stv-news-central-e...|catchup-ac2-stvnew...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467646329001 | |catchup-ac2-mez-lo...|catchup-ac2-mez-lo...|{ts '1970-01-01 00...|catchup-ac2-mez-lo...|catchup-ac2-mez-lo...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467679919001 | |Welfare changes 'd...|Citizen's Advice: ...|{ts '1970-01-01 00...|welfare-changes-de...|news-120223-l-welfare| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467682242001 | |catchup-ac2-mez-st...|catchup-ac2-mez-st...|{ts '1970-01-01 00...|catchup-ac2-mez-st...|catchup-ac2-mez-st...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467566135001 | |Paul Dixon can get...|Peter Houston has ...|{ts '1970-01-01 00...|paul-dixon-can-get...|sport-houston-2012...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467637160001 | |Stephen Hester: 'R...|"RBS CEO Stephen H...|{ts '1970-01-01 00...|stephen-hester-rbs...|ITN_230212_uklsrbs...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467637152001 | |Dog trained to loo...|Jury told by scene...|{ts '1970-01-01 00...|dog-trained-to-loo...|news-120223-l-pilley | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467526068001 | |catchup-ac2-mez-th...|catchup-ac2-mez-th...|{ts '1970-01-01 00...|catchup-ac2-mez-th...|catchup-ac2-mez-th...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1467534815001 | |Labour MP punching...|"John Bercow bans ...|{ts '1970-01-01 00...|labour-mp-punching...|ITN_230212_uklsjoy...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1464747327001 | |Glasgow Music and ...|STV talked to memb...|{ts '1970-01-01 00...|glasgow-music-and-...|entertainment-gff-...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } appname={STV Video} FEATUREDPLAYLISTS={Query --------------------------------------------------- select * from video_playlists where featured = 1 order by rand() --------------------------------------------------- Execution Time: 4 --------------------------------------------------- Recordcount: 0 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |id |playlistName |playlistNiceName |playlistTags |playlistid |playlistrefid |featured |playlistTotal |playlistThumb |firstVideo |public | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } RUNDATETIME={0} pagedescription={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip} popularepisodes={Query --------------------------------------------------- select pl.plays_total pl.plays_trailing_week prog.programmeName prog.archive prog.catchupSlug if(length(prog.programmeNiceName)>30 prog.programmeShortName prog.programmeNiceName) as programmeNiceName prog.programmeURL vc.videoDescription as summary tvl.runDateTime concat('/programmes/' programmeName '/' date_format(runDateTime '%Y-%m-%d-%H%i') '/') as permalink pc.slug as categorySlug pc.genre find_in_set("=GUIDANCE" vc.videoTags) as guidance concat(programmeName '-' date_format(runDateTime '%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate 10) vc.videoRefID order by pl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 1317 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |plays_total |plays_trailing_week |programmeName |archive |catchupSlug |programmeNiceName |programmeURL |summary |runDateTime |permalink |categorySlug |genre |guidance |episodeName | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3925 |3925 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|An angry altercati...|{ts '2012-02-06 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3549 |3549 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Will Carla turn he...|{ts '2012-02-06 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3462 |3462 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Has Carla and Pete...|{ts '2012-02-09 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3395 |3395 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Can Rosie make ame...|{ts '2012-02-10 20...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |3297 |3297 |coronation-street |0 |catchup-coronation...|Coronation Street |http://programmes....|Rosie is in turmoi...|{ts '2012-02-10 19...|/programmes/corona...|soaps |Soaps |0 |coronation-street-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2412 |2412 |love-hate |0 |catchup-lovehate |Love/Hate |http://programmes....|Drama series set i...|{ts '2012-02-09 21...|/programmes/love-h...|drama-series |Drama Series |8 |love-hate-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2283 |2283 |take-me-out |0 |catchup-takemeout |Take Me Out | |Paddy McGuinness t...|{ts '2012-02-11 20...|/programmes/take-m...|entertainment |Entertainment |0 |take-me-out-2012-0...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2241 |2241 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|The Pollards final...|{ts '2012-02-06 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2041 |2041 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|Moira's worst fear...|{ts '2012-02-08 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |2029 |2029 |emmerdale |0 |catchup-emmerdale |Emmerdale |http://programmes....|John makes a big d...|{ts '2012-02-07 19...|/programmes/emmerd...|soaps |Soaps |0 |emmerdale-2012-02-...| +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } event={general.index} currentview={home} MOSTCOMMENTED={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10 --------------------------------------------------- Execution Time: 27 --------------------------------------------------- Recordcount: 5 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |7031877001 | |Get Fit Rachel - L...|The five thirty sh...|{ts '1970-01-01 00...|get-fit-rachel-lac...|entertainment-five...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |25652378001 | |The world’s only w...|Islay woman Ailsa ...|{ts '1970-01-01 00...|the-worlds-only-wh...|entertainment-theh...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |54208705001 | |Supermarket under ...|Alcohol campaigner...|{ts '1970-01-01 00...|supermarket-under-...|news-091204-l2-drink | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |48371638001 | |When Bon Jovi rock...|New Jersey rockers...|{ts '1970-01-01 00...|when-bon-jovi-rock...|news-archive-09110...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |43211611001 | |Mowbray: I will bu...|Celtic boss lookin...|{ts '1970-01-01 00...|mowbray-i-will-buy...|sport-football-mow...| | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } MOSTPOPULAR={Query --------------------------------------------------- select vc.videoID vc.videoPlaylist vc.video_title vc.videoDescription sec_to_time((vc.videoLength/1000)) as runTime vc.videoSlug as permalink vc.videorefid vl.plays_trend vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now() interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10 --------------------------------------------------- Execution Time: 611 --------------------------------------------------- Recordcount: 10 --------------------------------------------------- +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |videoID |videoPlaylist |video_title |videoDescription |runTime |permalink |videorefid |plays_trend |rating | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20946874001 | |Ella Edmondson sings |Ella Edmondson da...|{ts '1970-01-01 00...|ella-edmondson-sings |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |55221454001 | |Rangers say Boyd d...|Martin Bain tells ...|{ts '1970-01-01 00...|rangers-say-boyd-d...|sport-football-boy...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |6262033001 | |Islanders mark 90-...|Residents of Lewis...|{ts '1970-01-01 00...|islanders-mark-90-...|news-headlines-nt-...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |1847316428 | |Glen Michael is back |Glen Michael prob...|{ts '1970-01-01 00...|glen-michael-is-back |entertainment-five...|1 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577224001 | |Central Scotland w...|The latest weather...|{ts '1970-01-01 00...|central-scotland-w...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |50577222001 | |North of Scotland ...|The latest weather...|{ts '1970-01-01 00...|north-of-scotland-...|stv-news-weather-s...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |30481332001 | |Weather forecast f...|Sean Batty takes a...|{ts '1970-01-01 00...|weather-forecast-f...|scotland-thegather...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |20229945001 | |Old Firm English P...|Chairman of Englis...|{ts '1970-01-01 00...|old-firm-english-p...|news-090420-l2-old...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |18160924001 | |Scottish heather i...|"We want to turn t...|{ts '1970-01-01 00...|scottish-heather-i...|news-headlines-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ |16951175001 | |Pressley: fearless...|Steven Pressley is...|{ts '1970-01-01 00...|pressley-fearless-...|sport-football-200...|0 | | +---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+ } VIDEOPERMALINK={brad-pitt-latest-dramatic-scenes-from-glasgow-movie-set} currentlayout={Layout.Main.cfm} pagetitle={STV Video | Catch up on TV programmes shows soaps clips latest news sport entertainment showbiz gossip}}
02:26:45.372 PM 2 ms rendering View [common/head.cfm] ...
02:26:45.375 PM 1 ms rendering View [common/header.cfm] ...
02:26:45.453 PM 1 ms rendering View [views/viewlets/socialbookmark.cfm] ...
02:26:45.455 PM 1 ms rendering View [views/viewlets/sendtofriend.cfm] ...
02:26:45.514 PM 58 ms rendering View [views/viewlets/featuredvideo.cfm] ...
02:26:45.549 PM 34 ms rendering View [views/viewlets/justadded.cfm] ...
02:26:45.586 PM 36 ms rendering View [views/viewlets/mostdiscussed.cfm] ...
02:26:45.622 PM 36 ms rendering View [views/viewlets/mostpopular.cfm] ...
02:26:45.622 PM 241 ms rendering View [home.cfm] ...
02:26:45.626 PM 3 ms rendering View [common/footer.cfm] ...
02:26:45.628 PM 2 ms rendering View [common/ads.cfm] ...
02:26:45.631 PM 2 ms rendering View [common/javascript.cfm] ...
02:26:45.631 PM 281 ms rendering Layout [Layout.Main.cfm] ...
Total Framework Request Execution Time: 3455 ms
>  ColdBox Cache

Cache Performance
Hit Ratio: 48.72% ==> Hits: 19 | Misses: 20 | Evictions: 0 | Garbage Collections: 0
JVM Memory Stats
27.98 % Free | JVM Threshold:0% (0=Unlimited) | Total Assigned Memory: 1,945,660 KB | Max JVM Memory: 3,063,488 KB
Last Reap
Feb-23-2012 02:26:41 PM
Reap Frequency
Every 1 Minute(s)
Eviction Policy
LRU
Default Timeout
60 Minutes
Last Access Timeout
30 Minutes
Total Objects in Cache
11 / 100 (0=Unlimited)
2206350.2890625 857137.7109375

Cache Content Report (Time: 02:26:45 PM)

Object Hits Timeout (Min) Created Last Accessed Expires On CMDS
interceptor-coldbox.system.interceptors.autowire 1 0 Feb-23
02:26:41 PM		 Feb-23
02:26:41 PM		 ---
interceptor-coldbox.system.interceptors.environmentControl 2 0 Feb-23
02:26:41 PM		 Feb-23
02:26:41 PM		 ---
interceptor-coldbox.system.interceptors.ses 2 0 Feb-23
02:26:41 PM		 Feb-23
02:26:41 PM		 ---
plugin-beanFactory 7 0 Feb-23
02:26:41 PM		 Feb-23
02:26:45 PM		 ---
plugin-json 1 60 Feb-23
02:26:41 PM		 Feb-23
02:26:41 PM		 Feb-23
03:26:41 PM
plugin-logger 1 60 Feb-23
02:26:41 PM		 Feb-23
02:26:41 PM		 Feb-23
03:26:41 PM
plugin-methodInjector 4 60 Feb-23
02:26:42 PM		 Feb-23
02:26:44 PM		 Feb-23
03:26:42 PM
plugin-sessionstorage 2 60 Feb-23
02:26:42 PM		 Feb-23
02:26:45 PM		 Feb-23
03:26:42 PM
plugin-Utilities 4 5 Feb-23
02:26:41 PM		 Feb-23
02:26:45 PM		 Feb-23
02:31:41 PM
programmes 1 0 Feb-23
02:26:42 PM		 Feb-23
02:26:42 PM		 ---
video 9 0 Feb-23
02:26:44 PM		 Feb-23
02:26:45 PM		 ---
>  Request Collection Structure
welcomemessage: Welcome to ColdBox!
pagekeywords: stv, video, tv, shows, soaps, clips, latest news, sport, entertainment, showbiz, gossip
editorspicks:
Query
SQL select vp.playlistNiceName, vc.videoID, vc.videoPlaylist, vc.video_title, vc.videoDescription, sec_to_time((vc.videoLength/1000)) as runTime, vc.videoSlug as permalink, vc.videorefid, vc.rating from videocache_new vc inner join video_playlist_titles vpt on vpt.videoid = vc.videoid inner join video_playlists vp on vp.playlistID = vpt.playlistID where vp.playlistrefid = 'Editors-Picks' and isCatchup = 0 order by vpt.playlistRank asc limit 7
Execution Time (ms) 19
recordcount 7
cached No
result
playlistNiceName videoID videoPlaylist video_title videoDescription runTime permalink videorefid rating
Editor's Picks 1118657956001 Brad Pitt: Latest dramatic scenes from Glasgow movie set The picture, from zombie flick World War Z, shows a bin lorry colliding into a row of cars as pedestrians flee for their lives. {ts '1970-01-01 00:01:51'} brad-pitt-latest-dramatic-scenes-from-glasgow-movie-set stv-news-bradpitt
Editor's Picks 1115914203001 Alexandra Burke & Beyonce's Duet (2008) Daily poll alert! You voted en masse to watch Alexandra Burke's dazzling duet with Beyonce from 2008's X Factor show. 'Listen,' and enjoy! {ts '1970-01-01 00:03:56'} alexandra-burke-beyonces-duet-2008 xfactor2011-110808-ps-alexduet
Editor's Picks 1115425249001 Bagpuss interviews Kevin Cruise at the Edinburgh Fringe 2011 It’s the interview the world has been waiting for, as "old, saggy cloth cat” children’s favourite Bagpuss poses some tough questions for Britain’s Got Talent cruise-ship entertainer Kevin Cruise. {ts '1970-01-01 00:04:27'} bagpuss-interviews-kevin-cruise-at-the-edinburgh-fringe-2011 entertainment-festivals-bagpuss-kevin-cruise-20110817
Editor's Picks 1101773767001 Jedward sing Oops I Did It Again (2009) voted wackiest X Factor moment ever Jedward performing Oops I Did It Again by Britney Spears has been voted X Factor's wackiest moment. Watch the video again. {ts '1970-01-01 00:04:04'} jedward-sing-oops-i-did-it-again-2009-voted-wackiest-x-factor-moment-ever xfactor2011-110808-ps-jedward
Editor's Picks 1117333807001 Gary Barlow reveals all about the X Factor 2011 X Factor judge Gary Barlow gives us a sneak peek into the new series. {ts '1970-01-01 00:02:16'} gary-barlow-reveals-all xfactor2011-110819-bs-gary
Editor's Picks 1112147714001 Back to School: Dr Alex’s tips on settling in without stress Psychiatrist Dr Alex Yellowlees is on The Hour sofa with some tips and advice for young people to minimise anxiety and to help them fit in at school. Broadcast Thursday, August 18, 2011. {ts '1970-01-01 00:02:40'} back-to-school-dr-alexs-tips-on-settling-in-without-stress entertainment-web-thehour-20110816-fitting-in
Editor's Picks 1092144367001 The X Factor Finalists - You Are Not Alone (2009) The X Factor finalists perform Michael Jackson's You Are Not Alone for charity in 2009. {ts '1970-01-01 00:04:13'} the-x-factor-finalists-you-are-not-alone-2009 xfactor2011-110802-ps-s6youarenotalone.mp4
urlparam: /bc/catchup-ac2-politicsnow-part1-20100930-2341/http:/video.stv.tv/bc/catchup-ac2-politicsnow-part1-20100930-2341/
pageid: home
path_info: /
videostruct:
Struct
CURRENTVIDEO
number 1118657956001
VIDEOSEQUENCE
string 1118657956001,1115914203001,1115425249001,1101773767001,1117333807001,1112147714001,1092144367001
VIDEOTOTAL
number 7
justadded:
Query
SQL select vc.videoID, vc.videoPlaylist, vc.video_title, vc.videoDescription, sec_to_time((vc.videoLength/1000)) as runTime, vc.videoSlug as permalink, vc.videorefid, vc.rating from videocache_new vc where vc.isCatchup = 0 group by vc.videoID order by vc.video_ModifiedDate desc limit 10
Execution Time (ms) 9
recordcount 10
cached No
result
videoID videoPlaylist video_title videoDescription runTime permalink videorefid rating
1467673285001 STV News (Central edition) 1.55pm - Thursday, February 23, 3012 The Labour MP for Falkirk, Eric Joyce, has been suspended from the party following allegations of a bar brawl in Westminster. {ts '1970-01-01 00:06:28'} stv-news-central-edition-155pm-thursday-february-23-3012 catchup-ac2-stvnewscentrallunchtimebulletin-20120223-1355
1467646329001 catchup-ac2-mez-loosewomen-20120223-1228.mpg catchup-ac2-mez-loosewomen-20120223-1228.mpg {ts '1970-01-01 00:43:16'} catchup-ac2-mez-loosewomen-20120223-1228mpg catchup-ac2-mez-loosewomen-20120223-1228.mpg
1467679919001 Welfare changes 'devastating' for disabled people Citizen's Advice: The UK Government has redefined what it means to be ill. {ts '1970-01-01 00:00:17'} welfare-changes-devastating-for-disabled-people news-120223-l-welfare
1467682242001 catchup-ac2-mez-stvnewscentrallunchtimebulletin-20120223-1355.mpg catchup-ac2-mez-stvnewscentrallunchtimebulletin-20120223-1355.mpg {ts '1970-01-01 00:06:29'} catchup-ac2-mez-stvnewscentrallunchtimebulletin-20120223-1355mpg catchup-ac2-mez-stvnewscentrallunchtimebulletin-20120223-1355.mpg
1467566135001 Paul Dixon can get England move and Scotland recognition, says manager Peter Houston has said that Paul Dixon’s recent form can be the springboard to greater rewards. {ts '1970-01-01 00:01:27'} paul-dixon-can-get-england-move-and-scotland-recognition-says-manager sport-houston-20120223
1467637160001 Stephen Hester: 'RBS staff must be paid fairly' "RBS CEO Stephen Hester defends the £400m bonus pool awarded at the bank." {ts '1970-01-01 00:03:03'} stephen-hester-rbs-staff-must-be-paid-fairly ITN_230212_uklsrbshester
1467637152001 Dog trained to look for bodies found areas of 'interest' at Suzanne Pilley's work Jury told by scene examiner that dog trained to seach for bodies was interested in the parking bays at Suzanne Pilley's workplace. {ts '1970-01-01 00:01:19'} dog-trained-to-look-for-bodies-found-areas-of-interest-at-suzanne-pilleys-work news-120223-l-pilley
1467526068001 catchup-ac2-mez-thejeremykyleshow-20120223-0925.mpg catchup-ac2-mez-thejeremykyleshow-20120223-0925.mpg {ts '1970-01-01 00:48:35'} catchup-ac2-mez-thejeremykyleshow-20120223-0925mpg catchup-ac2-mez-thejeremykyleshow-20120223-0925.mpg
1467534815001 Labour MP punching Tory allegations barred in Commons "John Bercow bans references to Eric Joyce's alleged attack in the Commons." {ts '1970-01-01 00:00:45'} labour-mp-punching-tory-allegations-barred-in-commons ITN_230212_uklsjoycebercow23
1464747327001 Glasgow Music and Film Festival braces itself for The Psychocinematic Ritual STV talked to members of OV and Psychogeographical Commission about their performances tonight for a special Glasgow Music and Film Festival show, which has been described as “a celebration of ritual, the occult, and the disturbing power of cinema." {ts '1970-01-01 00:15:54'} glasgow-music-and-film-festival-braces-itself-for-the-psychocinematic-ritual entertainment-gff-ov-20120221
appname: STV Video
featuredplaylists:
Query
SQL select * from video_playlists where featured = 1 order by rand()
Execution Time (ms) 4
recordcount 0
cached No
result
id playlistName playlistNiceName playlistTags playlistid playlistrefid featured playlistTotal playlistThumb firstVideo public
rundatetime: 0
pagedescription: STV Video | Catch up on TV programmes, shows, soaps, clips, latest news, sport, entertainment, showbiz, gossip
popularepisodes:
Query
SQL select pl.plays_total, pl.plays_trailing_week, prog.programmeName, prog.archive, prog.catchupSlug, if(length(prog.programmeNiceName)>30,prog.programmeShortName,prog.programmeNiceName) as programmeNiceName, prog.programmeURL, vc.videoDescription as summary, tvl.runDateTime, concat('/programmes/',programmeName,'/',date_format(runDateTime,'%Y-%m-%d-%H%i'),'/') as permalink, pc.slug as categorySlug, pc.genre, find_in_set("=GUIDANCE",vc.videoTags) as guidance, concat(programmeName,'-',date_format(runDateTime,'%Y-%m-%d-%H%i')) as episodeName from player_programmes prog inner join stv_feeds.tvlistings tvl on tvl.programName = prog.programmeNiceName inner join player_categories pc on pc.genre = tvl.genre inner join player_parts pp on pp.scheduleDate = tvl.runDateTime inner join videocache vc on vc.videoRefID = pp.RefID inner join player_logging pl on pl.reference_id = pp.RefID and pp.part = 1 group by left(vc.videoDate,10), vc.videoRefID order by pl.plays_trailing_week desc limit 10
Execution Time (ms) 1317
recordcount 10
cached No
result
plays_total plays_trailing_week programmeName archive catchupSlug programmeNiceName programmeURL summary runDateTime permalink categorySlug genre guidance episodeName
3925 3925 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ An angry altercation leaves Carla more determined than ever. Are Rosie's dreams about to come true? Roy and Sylvia are at loggerheads. {ts '2012-02-06 20:30:00'} /programmes/coronation-street/2012-02-06-2030/ soaps Soaps 0 coronation-street-2012-02-06-2030
3549 3549 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ Will Carla turn her back on Underworld in light of recent events? Steve ups the ante in a bid to push Tracy out. Jason does his best to outwit Owen. {ts '2012-02-06 19:30:00'} /programmes/coronation-street/2012-02-06-1930/ soaps Soaps 0 coronation-street-2012-02-06-1930
3462 3462 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ Has Carla and Peter's relationship reached breaking point? Sophie is left worried by Rosie's decision. Sylvia is delighted by Milton's plans. {ts '2012-02-09 20:30:00'} /programmes/coronation-street/2012-02-09-2030/ soaps Soaps 0 coronation-street-2012-02-09-2030
3395 3395 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ Can Rosie make amends before she leaves Weatherfield for good? Kirsty stops Tyrone from building bridges with Tina. Carla doubts Peter's commitment. {ts '2012-02-10 20:30:00'} /programmes/coronation-street/2012-02-10-2030/ soaps Soaps 0 coronation-street-2012-02-10-2030
3297 3297 coronation-street 0 catchup-coronationstreet Coronation Street http://programmes.stv.tv/coronation-street/ Rosie is in turmoil over her relationship with Jason. Katy risks Joseph's safety. Ken tells Peter to take responsibility. {ts '2012-02-10 19:30:00'} /programmes/coronation-street/2012-02-10-1930/ soaps Soaps 0 coronation-street-2012-02-10-1930
2412 2412 love-hate 0 catchup-lovehate Love/Hate http://programmes.stv.tv/love-hate/ Drama series set in Dublin's gangland. Rosie finally sees what Darren has become and breaks up with him. <strong>GUIDANCE:</strong> Contains strong language from the outset and scenes of violence. {ts '2012-02-09 21:00:00'} /programmes/love-hate/2012-02-09-2100/ drama-series Drama Series 8 love-hate-2012-02-09-2100
2283 2283 take-me-out 0 catchup-takemeout Take Me Out Paddy McGuinness tries to arrange more dates for his line-up of 30 single girls. <strong>COMPETITION:</strong>This is Catch-Up. Competitions, text and phone lines may now be closed; if so, please do not participate. {ts '2012-02-11 20:00:00'} /programmes/take-me-out/2012-02-11-2000/ entertainment Entertainment 0 take-me-out-2012-02-11-2000
2241 2241 emmerdale 0 catchup-emmerdale Emmerdale http://programmes.stv.tv/emmerdale/ The Pollards finally pull together to get Amy back. Rodney offers the Kings a reprieve, but at a price. Moira struggles to keep her emotions in check over John and Chas {ts '2012-02-06 19:00:00'} /programmes/emmerdale/2012-02-06-1900/ soaps Soaps 0 emmerdale-2012-02-06-1900
2041 2041 emmerdale 0 catchup-emmerdale Emmerdale http://programmes.stv.tv/emmerdale/ Moira's worst fears are realised when John asks her for a divorce. Katie tries to adjust to her new home. Val is excited for her holiday, but Diane is suspicious about what she is up to. {ts '2012-02-08 19:00:00'} /programmes/emmerdale/2012-02-08-1900/ soaps Soaps 0 emmerdale-2012-02-08-1900
2029 2029 emmerdale 0 catchup-emmerdale Emmerdale http://programmes.stv.tv/emmerdale/ John makes a big decision about the future of his marriage. Amy is hopeful that a family holiday will reunite Val and Eric. Katie is thoughtful when Declan asks her to move in with him. {ts '2012-02-07 19:00:00'} /programmes/emmerdale/2012-02-07-1900/ soaps Soaps 0 emmerdale-2012-02-07-1900
event: general.index
currentview: home
mostcommented:
Query
SQL select vc.videoID, vc.videoPlaylist, vc.video_title, vc.videoDescription, sec_to_time((vc.videoLength/1000)) as runTime, vc.videoSlug as permalink, vc.videorefid, vc.rating from videocache_new vc inner join video_comment_logging vl on vl.reference_id = vc.videoRefID where vc.isCatchup = 0 order by vl.comments limit 10
Execution Time (ms) 27
recordcount 5
cached No
result
videoID videoPlaylist video_title videoDescription runTime permalink videorefid rating
7031877001 Get Fit Rachel - Lacrosse The five thirty show's Rachel McTavish tries her hand at field sport lacrosse as an alternative way to keeping fit. {ts '1970-01-01 00:03:31'} get-fit-rachel-lacrosse entertainment-fivethirty-20090112-lacrosse
25652378001 The world’s only whisky soap Islay woman Ailsa Hayes has embraced the local ingredients of the island, namely the eight distilleries, to create the world’s only whisky soap. {ts '1970-01-01 00:03:19'} the-worlds-only-whisky-soap entertainment-thehour-20090605-islay-soaps
54208705001 Supermarket under fire over cheap beer prices Alcohol campaigners say selling drink so cheaply will encourage people to buy and consume more than normal. {ts '1970-01-01 00:01:39'} supermarket-under-fire-over-cheap-beer-prices news-091204-l2-drink
48371638001 When Bon Jovi rocked the streets of Glasgow New Jersey rockers brought Argyle Street to a halt in 1995 with a special performance. {ts '1970-01-01 00:01:44'} when-bon-jovi-rocked-the-streets-of-glasgow news-archive-091105-jovi
43211611001 Mowbray: I will buy in January Celtic boss looking to improve squad when transfer window opens. {ts '1970-01-01 00:01:04'} mowbray-i-will-buy-in-january sport-football-mowbray-competition-20091002
mostpopular:
Query
SQL select vc.videoID, vc.videoPlaylist, vc.video_title, vc.videoDescription, sec_to_time((vc.videoLength/1000)) as runTime, vc.videoSlug as permalink, vc.videorefid, vl.plays_trend, vc.rating from videocache_new vc inner join video_logging vl on vl.videoid = vc.videoid where vc.videoDate > date_add(now(),interval -7 day) and vc.isCatchup = 0 order by vl.plays_trailing_week desc limit 10
Execution Time (ms) 611
recordcount 10
cached No
result
videoID videoPlaylist video_title videoDescription runTime permalink videorefid plays_trend rating
20946874001 Ella Edmondson sings Ella Edmondson, daughter of Adrian Edmondson and Jennifer Saunders, makes her STV debut. Doesn't she look like her Mum! {ts '1970-01-01 00:03:32'} ella-edmondson-sings entertainment-fivethirty-20090424-ella-edmondson-peformance 1
55221454001 Rangers say Boyd discussions have opened Martin Bain tells AGM he has had talks with Boyd’s agent. {ts '1970-01-01 00:00:55'} rangers-say-boyd-discussions-have-opened sport-football-boyd-20091208 1
6262033001 Islanders mark 90-year anniversary of Iolaire tragedy Residents of Lewis have commemorated the maritime accident which claimed the lives of 200 sailors. {ts '1970-01-01 00:01:13'} islanders-mark-90-year-anniversary-of-iolaire-tragedy news-headlines-nt-iolaire-090102 1
1847316428 Glen Michael is back Glen Michael, probably the most popular children's entertainer Scotland has ever seen, returns to stv to discuss his new Hollywood film role. {ts '1970-01-01 00:08:18'} glen-michael-is-back entertainment-fivethirty-20081009-glen-michael-int 1
50577224001 Central Scotland weather - Tuesday, November 17 The latest weather forecast for central Scotland, presented by Sean Batty. {ts '1970-01-01 00:01:45'} central-scotland-weather-tuesday-november-17 stv-news-weather-six-central-200911-16 0
50577222001 North of Scotland weather - Tuesday, November 17 The latest weather forecast for the north of Scotland, presented by Sean Batty. {ts '1970-01-01 00:01:46'} north-of-scotland-weather-tuesday-november-17 stv-news-weather-six-north-20091016 0
30481332001 Weather forecast for The Gathering Sean Batty takes a look at the weather forecast for The Gathering event taking place this weekend in Edinburgh. {ts '1970-01-01 00:01:14'} weather-forecast-for-the-gathering scotland-thegathering-20090723-weather-forecast 0
20229945001 Old Firm English Premier League move considered Chairman of English club suggests Celtic and Rangers could join division two of new English Premier League. {ts '1970-01-01 00:01:20'} old-firm-english-premier-league-move-considered news-090420-l2-oldfirm 0
18160924001 Scottish heather is new aphrodisiac "We want to turn the world on to heather and heather to turn the world on", says spokesman. {ts '1970-01-01 00:02:12'} scottish-heather-is-new-aphrodisiac news-headlines-20090401-heather-aphrodisiac-properties 0
16951175001 Pressley: fearless Scotland will have a go against Holland Steven Pressley is backing Scotland’s young guns to come out victorious when they come against the dangerous Holland side in the World Cup qualifier in Amsterdam next week. {ts '1970-01-01 00:01:44'} pressley-fearless-scotland-will-have-a-go-against-holland sport-football-20090319-pressley 0
videopermalink: brad-pitt-latest-dramatic-scenes-from-glasgow-movie-set
currentlayout: Layout.Main.cfm
pagetitle: STV Video | Catch up on TV programmes, shows, soaps, clips, latest news, sport, entertainment, showbiz, gossip
Approximate Debug Rendering Time: 215 ms