Jimmy Owens's Stats
SELECT DISTINCT `race_mrp_id` as `race`, race_date, track_name, race_series, race_start, race_finish, race_laps_completed, race_laps_led, race_money_won, race_points, race_mrp_id, race_driver_car_number, race_dns, race_dnf, race_dq, (SELECT ifnull((SELECT (race_points) from woo_a_main WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0)) as `Total_Points` FROM woo_a_main LEFT JOIN `woo_tracks` ON woo_a_main.`race_track` = woo_tracks.`track_mrp_id` WHERE `race_driver_id` = '67607' AND `race_date` REGEXP '2022' UNION ALL SELECT DISTINCT `race_mrp_id` as `race`, race_date, track_name, race_series, concat('B', race_start), concat('B', `race_finish`), race_laps_completed, race_laps_led, race_money_won, race_points, race_mrp_id, race_driver_car_number, race_dns, race_dnf, race_dq, (SELECT ifnull((SELECT (race_points) from woo_a_main WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0)) as `Total_Points` FROM woo_b_main LEFT JOIN `woo_tracks` ON woo_b_main.`race_track` = woo_tracks.`track_mrp_id` WHERE race_driver_id = '67607' AND race_points != '0' AND `race_date` REGEXP '2022' UNION ALL SELECT DISTINCT `race_mrp_id` as `race`, race_date, track_name, race_series, concat('B', race_start), concat('B', `race_finish`), race_laps_completed, race_laps_led, race_money_won, race_points, race_mrp_id, race_driver_car_number, race_dns, race_dnf, race_dq, (SELECT ifnull((SELECT (race_points) from woo_a_main WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0)) as `Total_Points` FROM woo_b_main_2 LEFT JOIN `woo_tracks` ON woo_b_main_2.`race_track` = woo_tracks.`track_mrp_id` WHERE race_driver_id = '67607' AND race_points != '0' AND `race_date` REGEXP '2022' UNION ALL SELECT DISTINCT `race_mrp_id` as `race`, race_date, track_name, race_series, concat('B', race_start), concat('B', `race_finish`), race_laps_completed, race_laps_led, race_money_won, race_points, race_mrp_id, race_driver_car_number, race_dns, race_dnf, race_dq, (SELECT ifnull((SELECT (race_points) from woo_a_main WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '67607' AND race_mrp_id = `race`), 0)) as `Total_Points` FROM woo_b_main_3 LEFT JOIN `woo_tracks` ON woo_b_main_3.`race_track` = woo_tracks.`track_mrp_id` WHERE race_driver_id = '67607' AND race_points != '0' AND `race_date` REGEXP '2022' ORDER BY race_date ASC
DateTrackSeriesCarsStartFinish#LapsLedStatusMoneyPoints
01/20/22Volusia Speedway ParkWorld of Outlaws Late Models47162320120DNF$1,000104
01/21/22Volusia Speedway ParkWorld of Outlaws Late Models4514292000DNS$11090
04/29/22Bristol Motor SpeedwayWorld of Outlaws Late Models4617620300Running$4,000138
04/30/22Bristol Motor SpeedwayWorld of Outlaws Late Models45111020300Running$2,600130
05/05/22Mississippi Thunder SpeedwayWorld of Outlaws Late Models38B11B920100Running$11090
05/06/22Mississippi Thunder SpeedwayWorld of Outlaws Late Models4011620400Running$2,300138
05/07/22Mississippi Thunder SpeedwayWorld of Outlaws Late Models397620750Running$4,500138
07/25/22Boone SpeedwayWorld of Outlaws Late Models3361120500Running$2,000128
07/30/22Fairbury SpeedwayWorld of Outlaws Late Models0132620280DNF$2,000102
08/06/22Cedar Lake SpeedwayWorld of Outlaws Late Models0112720270DNF$3,00090
09/02/22Smoky Mountain SpeedwayWorld of Outlaws Late Models3111204040Running$10,000150
09/23/22Boyd's SpeedwayWorld of Outlaws Late Models4111204040Running$10,000150
09/24/22Boyd's SpeedwayWorld of Outlaws Late Models417720500Running$2,800136
11/02/22The Dirt Track at CharlotteWorld of Outlaws Late Models1175720400Running$2,300136
11/03/22The Dirt Track at CharlotteWorld of Outlaws Late Models30181920400Running$1,000112
11/05/22The Dirt Track at CharlotteWorld of Outlaws Late Models06920500Running$2,800132
Feature Stats9.612.555280$50,4101964

Which Schedule Would You like to Add to Your Calendar

2022_CASE_LMS_LOGO