http://turner.cdn.racersites.com/prod/photos/341599/HOME.jpg|Nationwide Series Race Preview - History 300|341599 http://turner.cdn.racersites.com/prod/photos/341596/HOME.jpg|Paludo Leads 33 Laps En Route to Seventh-Place Finish in Charlotte|341596 http://turner.cdn.racersites.com/prod/photos/341597/HOME.jpg|Burton fights back from a late-race incident for a strong 13th-place finish|341597 http://turner.cdn.racersites.com/prod/photos/341598/HOME.jpg|Hard-Earned Top 10 for Buescher at Charlotte Motor Speedway |341598 http://turner.cdn.racersites.com/prod/photos/341595/HOME.jpg|Jeb Burton Captures Pole for the North Carolina Education Lottery 200|341595 http://turner.cdn.racersites.com/prod/photos/341594/HOME.jpg| Camping World Truck Series Race Preview: North Carolina Education Lottery 200|341594 http://turner.cdn.racersites.com/prod/photos/341592/HOME.jpg|Kangaroo Express Hops on Board the No. 4 Arrowhead Machine |341592 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 Nationwide Series Race Preview - History 300 51365 341599 0 2013-05-22 00:00:00.0 12 0 0 2013-05-22 00:00:00.0 12 0 1 [empty string] 0 2013-05-21 00:00:00.0 0 0 content [empty string] 2   535 Paludo Leads 33 Laps En Route to Seventh-Place Finish in Charlotte 51362 341596 0 2013-05-19 00:00:00.0 12 0 0 2013-05-19 00:00:00.0 12 0 2 Moves up to ninth in the NCWTS Driver Point Standings 0 2013-05-19 00:00:00.0 0 0 content [empty string] 3   535 Burton fights back from a late-race incident for a strong 13th-place finish 51363 341597 0 2013-05-19 00:00:00.0 12 0 0 2013-05-19 00:00:00.0 12 0 3 Strong effort helps keep the No. 4 Arrowhead/Kangaroo Express team second in points 0 2013-05-19 00:00:00.0 0 0 content [empty string] 4   535 Hard-Earned Top 10 for Buescher at Charlotte Motor Speedway 51364 341598 0 2013-05-19 00:00:00.0 12 0 0 2013-05-19 00:00:00.0 12 0 4 Defending NCWTS Champ fights back from a late race incident for a strong top 10 finish 0 2013-05-19 00:00:00.0 0 0 content [empty string] 5   535 Jeb Burton Captures Pole for the North Carolina Education Lottery 200 51361 341595 0 2013-05-17 00:00:00.0 12 0 0 2013-05-17 00:00:00.0 12 0 5 Third Keystone 21 Means 21 Pole Award for The Rookie of the Year Candidate in 2013 0 2013-05-17 00:00:00.0 0 0 content [empty string] 6   535 Camping World Truck Series Race Preview: North Carolina Education Lottery 200 51360 341594 0 2013-05-16 00:00:00.0 12 0 0 2013-05-16 00:00:00.0 12 0 6 [empty string] 0 2013-05-14 00:00:00.0 0 0 content [empty string] 7   535 Kangaroo Express Hops on Board the No. 4 Arrowhead Machine 51359 341592 0 2013-05-13 00:00:00.0 12 0 0 2013-05-13 00:00:00.0 12 0 7 [empty string] 0 2013-05-13 00:00:00.0 0 0 content [empty string]
CACHED	false
EXECUTIONTIME	55
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