http://turner.cdn.racersites.com/prod/photos/341732/HOME.jpg|NASCAR Nationwide Series Preview: Road America|341732 http://turner.cdn.racersites.com/prod/photos/341388/HOME.jpg|Special Statement from Harry Scott Jr. regarding the Charlie Dean Leffler Discretionary Trust|341388 http://turner.cdn.racersites.com/prod/photos/341699/HOME.jpg|Buescher to Make First NASCAR Nationwide Series Start of 2013 at Road America|341699 http://turner.cdn.racersites.com/prod/photos/341697/HOME.jpg|Piquet Jr. Leaves Michigan with a Top-10 Finish|341697 http://turner.cdn.racersites.com/prod/photos/341698/HOME.jpg|Allgaier Comes Home 12th from Michigan International Speedway|341698 http://turner.cdn.racersites.com/prod/photos/341696/HOME.jpg|Larson Ties Career Best NNS Finish with Second Place at Michigan International Speedway|341696 http://turner.cdn.racersites.com/prod/photos/341695/HOME.jpg|Charlie Dean Leffler Charity Fund Established|341695 http://turner.cdn.racersites.com/prod/photos/

query
RESULTSET	query   BYLINE CAT_ID HEADLINE ID MAIN_PID PUBLISH_AFTER PUBLISH_DATE PUBLISH_TIME_HOUR PUBLISH_TIME_MIN RETIRE_AFTER RETIRE_DATE RETIRE_TIME_HOUR RETIRE_TIME_MIN ROW_NUMBER TEASER THE_AMPM THE_DATE THE_HOUR THE_MIN THE_TYPE YOUTUBE_ID 1   535 NASCAR Nationwide Series Preview: Road America 51394 341732 0 2013-06-18 00:00:00.0 12 0 0 2013-06-18 00:00:00.0 12 0 1 Piquet Jr. returns to defend his race title, Buescher makes his 2013 Nationwide Series debut 0 2013-06-18 00:00:00.0 5 0 content [empty string] 2   535 Special Statement from Harry Scott Jr. regarding the Charlie Dean Leffler Discretionary Trust 51396 341388 0 2013-06-18 00:00:00.0 12 0 0 2013-06-18 00:00:00.0 12 0 2 [empty string] 0 2013-06-18 00:00:00.0 0 0 content [empty string] 3   535 Buescher to Make First NASCAR Nationwide Series Start of 2013 at Road America 51395 341699 0 2013-06-17 00:00:00.0 12 0 0 2013-06-17 00:00:00.0 12 0 3 Will drive the No. 34 Wolfpack Energy Services Chevy Camaro 0 2013-06-17 00:00:00.0 0 0 content [empty string] 4   535 Piquet Jr. Leaves Michigan with a Top-10 Finish 51391 341697 0 2013-06-16 00:00:00.0 12 0 0 2013-06-16 00:00:00.0 12 0 4 The No. 30 WORX Tools team earns its first top 10 of the season. 0 2013-06-16 00:00:00.0 0 0 content [empty string] 5   535 Allgaier Comes Home 12th from Michigan International Speedway 51392 341698 0 2013-06-17 00:00:00.0 12 0 0 2013-06-17 00:00:00.0 12 0 5 Allgaier is currently third, one point behind second-place Sam Hornish Jr., in the NASCAR Nationwide Series Driver Point Standings 0 2013-06-16 00:00:00.0 0 0 content [empty string] 6   535 Larson Ties Career Best NNS Finish with Second Place at Michigan International Speedway 51393 341696 0 2013-06-16 00:00:00.0 12 0 0 2013-06-16 00:00:00.0 12 0 6 Late race charge comes up a few laps short, earns his second top five in a row. 0 2013-06-16 00:00:00.0 0 0 content [empty string] 7   535 Charlie Dean Leffler Charity Fund Established 51390 341695 0 2013-06-15 00:00:00.0 12 0 0 2013-06-15 00:00:00.0 12 0 7 Funeral Services for Jason Leffler Announced 0 2013-06-15 00:00:00.0 0 0 content [empty string]
CACHED	false
EXECUTIONTIME	49
SQL	SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT TOP 7 ROW_NUMBER() OVER( ORDER BY the_date DESC, the_ampm DESC, the_hour DESC, the_min DESC ) AS 'row_number', * From ( SELECT content.cid AS id, content.cat_id, content_date AS the_date, 'content' AS the_type, headline, byline, teaser, content_time_ampm AS the_ampm, content_time_hour AS the_hour, content_time_min AS the_min, NULL AS youtube_id, ( SELECT TOP 1 related_photos.pid FROM tbl_admin_content_related_photos AS related_photos WHERE related_photos.cid = content.cid ORDER BY related_photos.sort, related_photos.id ) AS main_pid, content.publish_after, content.publish_date, content.publish_time_hour, content.publish_time_min, content.retire_after, content.retire_date, content.retire_time_hour, content.retire_time_min FROM tbl_admin_content AS content INNER JOIN tbl_admin_content_category AS content_category ON content.cat_id = content_category.cat_id WHERE content.site_id = ? AND content.visible = 1 AND content_category.cat_id IN (535) AND ( ( content.publish_after = 0 AND content.retire_after = 0 ) OR ( content.publish_after = 1 AND content.retire_after = 0 AND DATEADD("MINUTE",content.publish_time_min,DATEADD("hh",content.publish_time_hour,content.publish_date)) < GETDATE() ) OR ( content.publish_after = 0 AND content.retire_after = 1 AND DATEADD("MINUTE",content.retire_time_min,DATEADD("hh",content.retire_time_hour,content.retire_date)) > GETDATE() ) OR ( content.publish_after = 1 AND content.retire_after = 1 AND DATEADD("MINUTE",content.publish_time_min,DATEADD("hh",content.publish_time_hour,content.publish_date)) < GETDATE() AND DATEADD("MINUTE",content.retire_time_min,DATEADD("hh",content.retire_time_hour,content.retire_date)) > GETDATE() ) ) UNION ALL SELECT content.mid AS id, content.cat_id, clip_date AS the_date, 'multimedia' AS the_type, clip_name AS headline, clip_source AS byline, clip_desc AS teaser, clip_time_ampm AS the_ampm, clip_time_hour AS the_hour, clip_time_min AS the_min, url_id AS youtube_id, ( SELECT TOP 1 related_photos.pid FROM tbl_admin_multimedia_related_photos AS related_photos WHERE related_photos.mid = content.mid ORDER BY related_photos.sort, related_photos.id ) AS main_pid, content.publish_after, content.publish_date, content.publish_time_hour, content.publish_time_min, content.retire_after, content.retire_date, content.retire_time_hour, content.retire_time_min FROM tbl_admin_multimedia AS content INNER JOIN tbl_admin_multimedia_category AS content_category ON content.cat_id = content_category.cat_id WHERE content.site_id = ? AND content.is_deleted = 0 AND content.is_active = 1 AND content_category.cat_id IN (0) AND ( ( content.publish_after = 0 AND content.retire_after = 0 ) OR ( content.publish_after = 1 AND content.retire_after = 0 AND DATEADD("MINUTE",content.publish_time_min,DATEADD("hh",content.publish_time_hour,content.publish_date)) < GETDATE() ) OR ( content.publish_after = 0 AND content.retire_after = 1 AND DATEADD("MINUTE",content.retire_time_min,DATEADD("hh",content.retire_time_hour,content.retire_date)) > GETDATE() ) OR ( content.publish_after = 1 AND content.retire_after = 1 AND DATEADD("MINUTE",content.publish_time_min,DATEADD("hh",content.publish_time_hour,content.publish_date)) < GETDATE() AND DATEADD("MINUTE",content.retire_time_min,DATEADD("hh",content.retire_time_hour,content.retire_date)) > GETDATE() ) ) UNION ALL SELECT content.lid AS id, content.cat_id, link_date AS the_date, 'extlink' AS the_type, link_name AS headline, link_path AS byline, link_target AS teaser, link_time_ampm AS the_ampm, link_time_hour AS the_hour, link_time_min AS the_min, NULL AS youtube_id, ( SELECT TOP 1 related_photos.pid FROM tbl_admin_external_links_related_photos AS related_photos WHERE related_photos.lid = content.lid ORDER BY related_photos.sort, related_photos.id ) AS main_pid, content.publish_after, content.publish_date, content.publish_time_hour, content.publish_time_min, content.retire_after, content.retire_date, content.retire_time_hour, content.retire_time_min FROM tbl_admin_external_links AS content INNER JOIN tbl_admin_external_links_category AS content_category ON content.cat_id = content_category.cat_id WHERE content.site_id = ? AND content.is_deleted = 0 AND content_category.cat_id IN (0) AND ( ( content.publish_after = 0 AND content.retire_after = 0 ) OR ( content.publish_after = 1 AND content.retire_after = 0 AND DATEADD("MINUTE",content.publish_time_min,DATEADD("hh",content.publish_time_hour,content.publish_date)) < GETDATE() ) OR ( content.publish_after = 0 AND content.retire_after = 1 AND DATEADD("MINUTE",content.retire_time_min,DATEADD("hh",content.retire_time_hour,content.retire_date)) > GETDATE() ) OR ( content.publish_after = 1 AND content.retire_after = 1 AND DATEADD("MINUTE",content.publish_time_min,DATEADD("hh",content.publish_time_hour,content.publish_date)) < GETDATE() AND DATEADD("MINUTE",content.retire_time_min,DATEADD("hh",content.retire_time_hour,content.retire_date)) > GETDATE() ) ) UNION ALL SELECT galleries.gid AS id, galleries.cat_id, galleries.gallery_date AS the_date, 'gallery' AS the_type, galleries.gallery_title AS headline, NULL AS byline, galleries.gallery_desc AS teaser, NULL AS the_ampm, NULL AS the_hour, NULL AS the_min, NULL AS youtube_id, ( SELECT TOP 1 photos.pid FROM tbl_admin_photos AS photos INNER JOIN tbl_admin_photos_rank AS photo_rank ON photo_rank.pid = photos.pid WHERE photos.gid = galleries.gid AND photos.is_visible = 1 AND photos.is_deleted = 0 ORDER BY photo_rank.display_rank ) AS main_pid, NULL AS publish_after, NULL AS publish_date, NULL AS publish_time_hour, NULL AS publish_time_min, NULL AS retire_after, NULL AS retire_date, NULL AS retire_time_hour, NULL AS retire_time_min FROM tbl_admin_photos_galleries AS galleries WHERE galleries.site_id = ? AND galleries.cat_id IN (0) AND galleries.is_active = 1 AND galleries.is_deleted = 0 ) InnerQuery
SQLPARAMETERS	array 1 94 2 94 3 94 4 94

• Home
• Features
• Partners
• Racing
• Schedule
• Showcar
• Contact

All Contents © Copyright Turner Scott Motorsports LLC. 2011, All Rights Reserved.

Website Design and Development by RACERSITES

Racersites