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
  • NASCAR Nationwide Series Preview: Road America
  • Special Statement from Harry Scott Jr. regarding the Charlie Dean Leffler Discretionary Trust
  • Buescher to Make First NASCAR Nationwide Series Start of 2013 at Road America
  • Piquet Jr. Leaves Michigan with a Top-10 Finish
  • Allgaier Comes Home 12th from Michigan International Speedway
  • Larson Ties Career Best NNS Finish with Second Place at Michigan International Speedway
  • Charlie Dean Leffler Charity Fund Established

NASCAR Nationwide Series Preview: Road America

Piquet Jr. returns to defend his race title, Buescher makes his 2013 Nationwide Series debut

READ MORE

Special Statement from Harry Scott Jr. regarding the Charlie Dean Leffler Discretionary Trust

READ MORE

Buescher to Make First NASCAR Nationwide Series Start of 2013 at Road America

Will drive the No. 34 Wolfpack Energy Services Chevy Camaro

READ MORE

Piquet Jr. Leaves Michigan with a Top-10 Finish

The No. 30 WORX Tools team earns its first top 10 of the season.

READ MORE

Allgaier Comes Home 12th from Michigan International Speedway

Allgaier is currently third, one point behind second-place Sam Hornish Jr., in the NASCAR Nationwide Series Driver Point Standings

READ MORE

Larson Ties Career Best NNS Finish with Second Place at Michigan International Speedway

Late race charge comes up a few laps short, earns his second top five in a row.

READ MORE

Charlie Dean Leffler Charity Fund Established

Funeral Services for Jason Leffler Announced

READ MORE

NASCAR Nationwide Series

Results

Alliance Truck Parts 250

Nelson Piquet

#30 WORX Chevrolet Camaro

21 9

Justin Allgaier

#31 Brandt Chevrolet Camaro

7 12

Kyle Larson

#32 Cessna Chevrolet Camaro

11 2

NASCAR Camping World Truck Series

Results

WinStar World Casino 400

James Buescher

#31 Ruud Chevy Silverado

18 9

Miguel Paludo

#32 AccuDocs Chevy Silverado

5 10

Jeb Burton

#4 Arrowhead Chevy Silverado

3 1

Nascar Nationwide Schedule

Next Event

Johnsonville Sausage 200

Road America, Elkhart Lake, WI

22 Jun

Nascar Camping World Schedule

Next Event

UNOH 225

Kentucky Speedway, Sparta, KY

27 Jun