query
RESULTSET
query
  CAR_NUMBER CAT_ID CAT_NAME DID EID EVENT_DATE_START EVENT_NAME FIRST_NAME IS_COMPLETE IS_POINTSRACE LAST_NAME POINTS_BEHIND POINTS_EARNED POSITION_FINISH POSITION_STANDINGS POSITION_START TEAM_NAME TRACKMAP_PHOTO_PATH TRACK_CITY TRACK_NAME TRACK_STATE
1 31 209 2012 NASCAR Nationwide Series [empty string] 3568 2012-02-25 00:00:00.0 DRIVE4COPD 300 [empty string] 1 0 [empty string] [empty string] 0 33 [empty string] 12 #31 Brandt Chevrolet /images/tracks/track8.png Daytona Daytona International Speedway FL
2 31 209 2012 NASCAR Nationwide Series [empty string] 3828 2012-03-03 00:00:00.0 Bashas Supermarkets 200 [empty string] 1 0 [empty string] [empty string] 0 15 [empty string] 13 #31 Brandt Chevrolet /images/tracks/track20.png Avondale Phoenix International Raceway AZ
3 31 209 2012 NASCAR Nationwide Series [empty string] 3829 2012-03-10 00:00:00.0 Sam's Town 300 [empty string] 1 0 [empty string] [empty string] 0 8 [empty string] 8 #31 Brandt Chevrolet /images/tracks/track14.png Las Vegas Las Vegas Motor Speedway NV
4 31 209 2012 NASCAR Nationwide Series [empty string] 3830 2012-03-17 00:00:00.0 Ford EcoBoost 300 [empty string] 1 0 [empty string] [empty string] 0 7 [empty string] 10 #31 Brandt Chevrolet /images/tracks/track3.png Bristol Bristol Motor Speedway TN
5 31 209 2012 NASCAR Nationwide Series [empty string] 3831 2012-03-24 00:00:00.0 Royal Purple 300 [empty string] 1 0 [empty string] [empty string] 0 32 [empty string] 2 #31 Brandt Chevrolet /images/tracks/track2.png Fontana Auto Club Speedway CA
6 31 209 2012 NASCAR Nationwide Series [empty string] 3832 2012-04-13 00:00:00.0 O'Reilly Auto Parts 300 [empty string] 1 0 [empty string] [empty string] 0 7 [empty string] 16 #31 Brandt Chevrolet /images/tracks/track25.png Ft. Worth Texas Motor Speedway TX
7 31 209 2012 NASCAR Nationwide Series [empty string] 3833 2012-04-27 00:00:00.0 BUBBA Burger 250 [empty string] 1 0 [empty string] [empty string] 0 15 [empty string] 13 #31 Brandt Chevrolet /images/tracks/track22.png Richmond Richmond International Raceway VA
8 31 209 2012 NASCAR Nationwide Series [empty string] 3834 2012-05-05 00:00:00.0 Aaron's 312 [empty string] 1 0 [empty string] [empty string] 0 8 [empty string] 13 #31 Brandt Chevrolet /images/tracks/track24.png Talladega Talladega Superspeedway AL
9 31 209 2012 NASCAR Nationwide Series [empty string] 3835 2012-05-11 00:00:00.0 Darlington 200 [empty string] 1 0 [empty string] [empty string] 0 13 [empty string] 10 #31 Brandt Chevrolet /images/tracks/track7.png Darlington Darlington Raceway SC
10 31 209 2012 NASCAR Nationwide Series [empty string] 3836 2012-05-20 00:00:00.0 John Deere Dealers 250 [empty string] 1 0 [empty string] [empty string] 0 6 [empty string] 5 #31 Brandt Chevrolet /images/tracks/track11.png Newton Iowa Speedway IA
11 31 209 2012 NASCAR Nationwide Series [empty string] 3837 2012-05-26 00:00:00.0 Charlotte 300 [empty string] 1 0 [empty string] [empty string] 0 8 [empty string] 16 #31 Brandt Chevrolet /images/tracks/track4.png Concord Charlotte Motor Speedway NC
12 31 209 2012 NASCAR Nationwide Series [empty string] 3838 2012-06-02 00:00:00.0 5-Hour Energy 200 [empty string] 1 0 [empty string] [empty string] 0 5 [empty string] 7 #31 Brandt Chevrolet /images/tracks/track9.png Dover Dover International Speedway DE
13 31 209 2012 NASCAR Nationwide Series [empty string] 3839 2012-06-16 00:00:00.0 Alliance Truck Parts 250 [empty string] 1 0 [empty string] [empty string] 0 13 [empty string] 8 #31 Brandt Chevrolet /images/tracks/track17.png Brooklyn Michigan International Speedway MI
14 31 209 2012 NASCAR Nationwide Series [empty string] 3840 2012-06-23 00:00:00.0 Bucyrus 200 [empty string] 1 0 [empty string] [empty string] 0 10 [empty string] 7 #31 Brandt Chevrolet /images/tracks/track23.png Elkhart Lake Road America WI
15 31 209 2012 NASCAR Nationwide Series [empty string] 3841 2012-06-26 00:00:00.0 Feed The Children 300 [empty string] 1 0 [empty string] [empty string] 0 5 [empty string] 7 #31 Brandt Chevrolet /images/tracks/track13.png Sparta Kentucky Speedway KY
16 31 209 2012 NASCAR Nationwide Series [empty string] 3842 2012-07-06 00:00:00.0 Subway Jalapeño 250 [empty string] 1 0 [empty string] [empty string] 0 7 [empty string] 21 #31 Brandt Chevrolet /images/tracks/track8.png Daytona Daytona International Speedway FL
17 31 209 2012 NASCAR Nationwide Series [empty string] 3843 2012-07-14 00:00:00.0 New Hampshire 200 [empty string] 1 0 [empty string] [empty string] 0 8 [empty string] 13 #31 Brandt Chevrolet /images/tracks/track19.png Loudon New Hampshire Motor Speedway NH
18 31 209 2012 NASCAR Nationwide Series [empty string] 3844 2012-07-22 00:00:00.0 STP 300 [empty string] 1 0 [empty string] [empty string] 43 3 [empty string] 16 #31 Brandt Chevrolet /images/tracks/track5.png Joliet Chicagoland Speedway IL
19 31 209 2012 NASCAR Nationwide Series [empty string] 3845 2012-07-28 00:00:00.0 Indianpolis Motor Speedway [empty string] 1 0 [empty string] [empty string] 32 12 [empty string] 14 #31 Brandt Chevrolet [empty string] Speedway Indianapolis Motor Speedway IN
20 31 209 2012 NASCAR Nationwide Series [empty string] 3846 2012-08-04 00:00:00.0 US Cellular 250 [empty string] 1 0 [empty string] [empty string] 44 2 [empty string] 5 #31 Brandt Chevrolet /images/tracks/track11.png Newton Iowa Speedway IA
21 31 209 2012 NASCAR Nationwide Series [empty string] 3847 2012-08-11 00:00:00.0 Zippo 200 [empty string] 1 0 [empty string] [empty string] 37 9 [empty string] 8 #31 Brandt Chevrolet [empty string] Watkins Glen Watkins Glen International NY
22 31 209 2012 NASCAR Nationwide Series [empty string] 3848 2012-08-18 00:00:00.0 NAPA Auto Parts 200 [empty string] 1 0 [empty string] [empty string] 0 1 [empty string] 15 #31 Brandt Chevrolet /images/tracks/track6.png Montreal Circuit Gilles Villeneuve Quebec
23 31 209 2012 NASCAR Nationwide Series [empty string] 3849 2012-08-24 00:00:00.0 Food City 250 [empty string] 1 0 [empty string] [empty string] 14 30 [empty string] 6 #31 Brandt Chevrolet /images/tracks/track3.png Bristol Bristol Motor Speedway TN
24 31 209 2012 NASCAR Nationwide Series [empty string] 3850 2012-09-01 00:00:00.0 Great Clips 300 [empty string] 1 0 [empty string] [empty string] 41 5 [empty string] 13 #31 Brandt Chevrolet /images/tracks/track1.png Hampton Atlanta Motor Speedway GA
25 31 209 2012 NASCAR Nationwide Series [empty string] 3851 2012-09-07 00:00:00.0 Virginia 529 College Savings 250 [empty string] 1 0 [empty string] [empty string] 31 13 [empty string] 10 #31 Brandt Chevrolet /images/tracks/track22.png Richmond Richmond International Raceway VA
26 31 209 2012 NASCAR Nationwide Series [empty string] 3852 2012-09-15 00:00:00.0 Chicago 300 [empty string] 1 0 [empty string] [empty string] 35 11 [empty string] 10 #31 Brandt Chevrolet /images/tracks/track5.png Joliet Chicagoland Speedway IL
27 31 209 2012 NASCAR Nationwide Series [empty string] 3853 2012-09-22 00:00:00.0 Kentucky 300 [empty string] 1 0 [empty string] [empty string] 36 8 [empty string] 10 #31 Brandt Chevrolet /images/tracks/track13.png Sparta Kentucky Speedway KY
28 31 209 2012 NASCAR Nationwide Series [empty string] 3854 2012-09-29 00:00:00.0 OneMain Financial 200 [empty string] 1 0 [empty string] [empty string] 16 30 [empty string] 2 #31 Brandt Chevrolet /images/tracks/track9.png Dover Dover International Speedway DE
29 31 209 2012 NASCAR Nationwide Series [empty string] 3855 2012-10-12 00:00:00.0 Dollar General 300 Miles of Courage [empty string] 1 0 [empty string] [empty string] 10 34 [empty string] 16 #31 Brandt Chevrolet /images/tracks/track4.png Concord Charlotte Motor Speedway NC
30 31 209 2012 NASCAR Nationwide Series [empty string] 3856 2012-10-20 00:00:00.0 Kansas Lottery 300 [empty string] 1 0 [empty string] [empty string] 39 7 [empty string] 21 #31 Brandt Chevrolet /images/tracks/track12.png Kansas City Kansas Speedway KS
31 31 209 2012 NASCAR Nationwide Series [empty string] 3857 2012-11-03 00:00:00.0 O'Reilly Auto Parts Challenge [empty string] 1 0 [empty string] [empty string] 36 8 [empty string] 17 #31 Brandt Chevrolet /images/tracks/track25.png Ft. Worth Texas Motor Speedway TX
32 31 209 2012 NASCAR Nationwide Series [empty string] 3858 2012-11-10 00:00:00.0 Great Clips 200 [empty string] 1 0 [empty string] [empty string] 33 11 [empty string] 12 #31 Brandt Chevrolet /images/tracks/track20.png Avondale Phoenix International Raceway AZ
33 31 209 2012 NASCAR Nationwide Series [empty string] 3859 2012-11-17 00:00:00.0 Ford 300 [empty string] 1 0 [empty string] [empty string] 33 11 [empty string] 6 #31 Brandt Chevrolet /images/tracks/track10.png Homestead Homestead-Miami Speedway FL
34 31 267 2013 NASCAR Nationwide Series [empty string] 5310 2013-02-23 00:00:00.0 DRIVE4COPD 300 [empty string] 1 0 [empty string] [empty string] 39 7 [empty string] 14 #31 Brandt Chevrolet /images/tracks/track8.png Daytona Daytona International Speedway FL
35 31 267 2013 NASCAR Nationwide Series [empty string] 5311 2013-03-02 00:00:00.0 DOLLAR GENERAL 200 FUELED BY AMERIGAS [empty string] 1 0 [empty string] [empty string] 41 3 [empty string] 5 #31 Brandt Chevrolet /images/tracks/track20.png Avondale Phoenix International Raceway AZ
36 31 267 2013 NASCAR Nationwide Series [empty string] 5312 2013-03-09 00:00:00.0 SAM'S TOWN 300 [empty string] 1 0 [empty string] [empty string] 29 15 [empty string] 10 #31 Brandt Chevrolet /images/tracks/track14.png Las Vegas Las Vegas Motor Speedway NV
37 31 267 2013 NASCAR Nationwide Series [empty string] 5313 2013-03-16 00:00:00.0 JEFF FOXWORTHY'S GRIT CHIPS 300 [empty string] 1 0 [empty string] [empty string] 38 8 [empty string] 1 #31 Brandt Chevrolet /images/tracks/track3.png Bristol Bristol Motor Speedway TN
38 31 267 2013 NASCAR Nationwide Series [empty string] 5314 2013-03-23 00:00:00.0 ROYAL PURPLE 300 [empty string] 1 0 [empty string] [empty string] 33 11 [empty string] 18 #31 Brandt Chevrolet /images/tracks/track2.png Fontana Auto Club Speedway CA
39 31 267 2013 NASCAR Nationwide Series [empty string] 5315 2013-04-12 00:00:00.0 O'REILLY AUTO PARTS 300 [empty string] 1 0 [empty string] [empty string] 34 10 [empty string] 14 #31 Brandt Chevrolet /images/tracks/track25.png Ft. Worth Texas Motor Speedway TX
40 31 267 2013 NASCAR Nationwide Series [empty string] 5316 2013-04-26 00:00:00.0 TOYOTACARE 250 [empty string] 1 0 [empty string] [empty string] 13 31 [empty string] 11 #31 Brandt Chevrolet /images/tracks/track22.png Richmond Richmond International Raceway VA
41 31 267 2013 NASCAR Nationwide Series [empty string] 5317 2013-05-04 00:00:00.0 AARON'S 312 [empty string] 1 0 [empty string] [empty string] 41 5 [empty string] 5 #31 Brandt Chevrolet /images/tracks/track24.png Talladega Talladega Superspeedway AL
42 31 267 2013 NASCAR Nationwide Series [empty string] 5318 2013-05-10 00:00:00.0 DARLINGTON 200 [empty string] 1 0 [empty string] [empty string] 34 10 [empty string] 5 #31 Brandt Chevrolet /images/tracks/track7.png Darlington Darlington Raceway SC
43 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5319 2013-05-25 00:00:00.0 HISTORY 300 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track4.png Concord Charlotte Motor Speedway NC
44 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5320 2013-06-01 00:00:00.0 5-HOUR ENERGY 200 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track9.png Dover Dover International Speedway DE
45 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5321 2013-06-08 00:00:00.0 DUPONT PIONEER 250 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track11.png Newton Iowa Speedway IA
46 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5322 2013-06-15 00:00:00.0 ALLIANCE TRUCK PARTS 250 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track17.png Brooklyn Michigan International Speedway MI
47 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5323 2013-06-22 00:00:00.0 ROAD AMERICA 200 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track23.png Elkhart Lake Road America WI
48 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5324 2013-06-28 00:00:00.0 FEED THE CHILDREN 300 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track13.png Sparta Kentucky Speedway KY
49 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5325 2013-07-05 00:00:00.0 SUBWAY JALAPENO 250 POWERED BY COCA-COLA [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track8.png Daytona Daytona International Speedway FL
50 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5326 2013-07-13 00:00:00.0 F.W. WEBB 200 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track19.png Loudon New Hampshire Motor Speedway NH
51 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5327 2013-07-21 00:00:00.0 STP 300 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track5.png Joliet Chicagoland Speedway IL
52 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5328 2013-07-27 00:00:00.0 INDIANA 250 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Speedway Indianapolis Motor Speedway IN
53 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5329 2013-08-03 00:00:00.0 U.S. CELLULAR 250 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track11.png Newton Iowa Speedway IA
54 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5330 2013-08-10 00:00:00.0 ZIPPO 200 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Watkins Glen Watkins Glen International NY
55 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5331 2013-08-17 00:00:00.0 NATIONWIDE CHILDREN'S HOSPITAL 200 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] Lexington Mid-Ohio Sports Car Course OH
56 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5332 2013-08-23 00:00:00.0 FOOD CITY 250 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track3.png Bristol Bristol Motor Speedway TN
57 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5333 2013-08-31 00:00:00.0 ATLANTA 300 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track1.png Hampton Atlanta Motor Speedway GA
58 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5334 2013-09-06 00:00:00.0 VIRGINIA 529 COLLEGE SAVINGS 250 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track22.png Richmond Richmond International Raceway VA
59 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5335 2013-09-14 00:00:00.0 DOLLAR GENERAL 300 POWERED BY COCA-COLA [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track5.png Joliet Chicagoland Speedway IL
60 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5336 2013-09-21 00:00:00.0 KENTUCKY 300 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track13.png Sparta Kentucky Speedway KY
61 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5337 2013-09-28 00:00:00.0 DOVER 200 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track9.png Dover Dover International Speedway DE
62 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5338 2013-10-05 00:00:00.0 KANSAS LOTTERY 300 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track12.png Kansas City Kansas Speedway KS
63 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5339 2013-10-11 00:00:00.0 DOLLAR GENERAL 300 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track4.png Concord Charlotte Motor Speedway NC
64 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5340 2013-11-02 00:00:00.0 O'REILLY AUTO PARTS CHALLENGE [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track25.png Ft. Worth Texas Motor Speedway TX
65 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5341 2013-11-09 00:00:00.0 GREAT CLIPS 200 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track20.png Avondale Phoenix International Raceway AZ
66 [empty string] 267 2013 NASCAR Nationwide Series [empty string] 5342 2013-11-16 00:00:00.0 FORD ECOBOOST 300 [empty string] 0 0 [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] [empty string] /images/tracks/track10.png Homestead Homestead-Miami Speedway FL
CACHED false
EXECUTIONTIME 47
SQL SELECT drivers.did, entrylist.car_number, detail.position_start, detail.position_finish, detail.points_earned, detail.points_behind, detail.position_standings, schedule.eid, schedule.event_name, schedule.event_date_start, schedule.is_pointsrace, schedule.is_complete, sched_cat.cat_name, sched_cat.cat_id, teams.team_name, drivers.first_name, drivers.last_name, track.track_name, track.track_city, track.track_state, track.trackmap_photo_path FROM tbl_admin_series series INNER JOIN tbl_admin_schedule schedule ON series.sid = schedule.sid INNER JOIN tbl_admin_schedule_category sched_cat ON schedule.cat_id = sched_cat.cat_id LEFT JOIN tbl_admin_schedule_entrylist entrylist ON schedule.eid = entrylist.eid LEFT JOIN tbl_admin_teams teams ON entrylist.tid = teams.tid LEFT JOIN tbl_admin_schedule_entrylist_drivers el_drivers ON entrylist.xid = el_drivers.xid LEFT JOIN tbl_admin_schedule_session_detail detail ON el_drivers.xid = detail.xid LEFT JOIN tbl_admin_drivers drivers ON el_drivers.did = drivers.did LEFT JOIN tbl_admin_tracks track ON schedule.tid = track.tid WHERE series.site_id = ? AND ((entrylist.is_deleted = 0 AND entrylist.is_active = 1) OR entrylist.eid IS NULL ) AND schedule.is_deleted = 0 AND schedule.is_active = 1 AND schedule.cat_id <> ? AND schedule.event_date_start BETWEEN '2012/1/1' AND '2013/12/31' ORDER BY schedule.event_date_start ASC;
SQLPARAMETERS
array
1 106
2 282
Justin Allgaier Events

SCHEDULE

NASCAR Nationwide Series | Other


UPCOMING RACES

PAST RACE RESULTS