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 = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '2494' 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` = '2494' AND `race_date` REGEXP '2022' AND race_series REGEXP 'World of Outlaws Sprint Cars' 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 = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '2494' 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 = '2494' AND race_points != '0' AND `race_date` REGEXP '2022' AND race_series REGEXP 'World of Outlaws Sprint Cars' 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 = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '2494' 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 = '2494' AND race_points != '0' AND `race_date` REGEXP '2022' AND race_series REGEXP 'World of Outlaws Sprint Cars' 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 = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '2494' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '2494' 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 = '2494' AND race_points != '0' AND `race_date` REGEXP '2022' AND race_series REGEXP 'World of Outlaws Sprint Cars' ORDER BY race_date ASC

Date	Track	Series	Cars	Start	Finish	#	Laps	Led	Status	Money	Points
02/10/22	Volusia Speedway Park	World of Outlaws Sprint Cars	36	25	25	6	0	0	Running	$1,000	102
02/11/22	Volusia Speedway Park	World of Outlaws Sprint Cars	34	B5	B8	6	12	0	Running	$200	194
02/11/22	Volusia Speedway Park	World of Outlaws Sprint Cars	34	25	23	6	28	0	Running	$0	194
02/12/22	Volusia Speedway Park	World of Outlaws Sprint Cars	32	25	25	6	10	0	Running	$200	102
03/04/22	Cotton Bowl Speedway	World of Outlaws Sprint Cars	29	B8	B10	6	12	0	Running	$200	90
03/05/22	Cotton Bowl Speedway	World of Outlaws Sprint Cars	29	B6	B10	6	12	0	Running	$200	90
03/11/22	Thunderbowl Raceway	World of Outlaws Sprint Cars	32	B10	B12	6	11	0	Running	$200	90
03/12/22	Thunderbowl Raceway	World of Outlaws Sprint Cars	32	B11	B11	6	11	0	Running	$200	90
03/18/22	Merced Speedway	World of Outlaws Sprint Cars	33	B13	B12	6	11	0	Running	$200	90
03/25/22	Bakersfield Speedway	World of Outlaws Sprint Cars	27	B7	B7	6	12	0	Running	$300	90
03/26/22	Perris Auto Speedway	World of Outlaws Sprint Cars	26	B8	B8	6	11	0	Running	$250	90
03/29/22	Vado Speedway Park	World of Outlaws Sprint Cars	22	16	18	6	13	0	Running	$1,000	114
04/02/22	Devil's Bowl Speedway	World of Outlaws Sprint Cars	32	24	23	6	15	0	Running	$1,000	104
04/09/22	Lake Ozark Speedway	World of Outlaws Sprint Cars	38	B18	B14	6	12	0	Running	$200	90
04/16/22	Federated Auto Parts I-55 Raceway	World of Outlaws Sprint Cars	37	B11	B12	6	4	0	Running	$200	90
04/23/22	Tri-State Speedway	World of Outlaws Sprint Cars	27	22	19	6	38	0	Running	$1,000	112
04/29/22	Bristol Motor Speedway	World of Outlaws Sprint Cars	24	19	18	6	22	0	Running	$2,000	114
04/30/22	Bristol Motor Speedway	World of Outlaws Sprint Cars	24	16	16	6	25	0	Running	$2,000	118
05/11/22	Lincoln Speedway	World of Outlaws Sprint Cars	55	27	24	6	33	0	Running	$125	102
05/14/22	Williams Grove Speedway	World of Outlaws Sprint Cars	41	B21	B20	6	0	0	Running	$200	90
05/17/22	Bridgeport Speedway	World of Outlaws Sprint Cars	33	19	20	6	24	0	Running	$1,000	110
05/20/22	Attica Raceway Park	World of Outlaws Sprint Cars	41	26	22	6	37	0	Running	$200	106
05/28/22	Atomic Speedway	World of Outlaws Sprint Cars	39	B8	B6	6	12	0	Running	$250	90
05/30/22	Lawrenceburg Speedway	World of Outlaws Sprint Cars	43	B17	B12	6	11	0	Running	$200	90
06/11/22	Knoxville Raceway	World of Outlaws Sprint Cars	47	B23	B20	6	10	0	DNF	$200	90
06/17/22	Beaver Dam Raceway	World of Outlaws Sprint Cars	33	B7	B5	6	12	0	Running	$300	90
06/18/22	Beaver Dam Raceway	World of Outlaws Sprint Cars	31	B13	B10	6	11	0	Running	$200	90
07/01/22	Cedar Lake Speedway	World of Outlaws Sprint Cars	27	21	17	6	34	0	Running	$900	116
07/02/22	Cedar Lake Speedway	World of Outlaws Sprint Cars	27	23	18	6	34	0	Running	$1,000	114
07/09/22	Wilmot Raceway	World of Outlaws Sprint Cars	31	16	15	6	38	0	Running	$1,050	120
07/16/22	Eldora Speedway	World of Outlaws Sprint Cars	54	B18	B15	6	15	0	Running	$650	90
07/20/22	Port Royal Speedway	World of Outlaws Sprint Cars	33	B13	B12	6	12	0	Running	$200	90
07/22/22	Williams Grove Speedway	World of Outlaws Sprint Cars	36	B14	B13	6	8	0	Running	$200	90
07/30/22	Weedsport Speedway	World of Outlaws Sprint Cars	29	B7	B10	6	12	0	Running	$200	90
07/31/22	Weedsport Speedway	World of Outlaws Sprint Cars	29	25	24	6	16	0	Running	$1,000	102
08/05/22	Federated Auto Parts I-55 Raceway	World of Outlaws Sprint Cars	39	23	17	6	27	0	Running	$900	116
08/06/22	Federated Auto Parts I-55 Raceway	World of Outlaws Sprint Cars	38	B10	B5	6	12	0	Running	$300	90
08/19/22	Jackson Motorplex	World of Outlaws Sprint Cars	40	B11	B11	6	12	0	Running	$200	90
08/20/22	Jackson Motorplex	World of Outlaws Sprint Cars	38	B9	B8	6	12	0	Running	$700	90
08/26/22	River Cities Speedway	World of Outlaws Sprint Cars	35	16	17	6	31	0	Running	$1,000	116
08/27/22	Red River Valley Speedway	World of Outlaws Sprint Cars	29	18	15	6	29	0	Running	$1,050	120
09/03/22	Skagit Speedway	World of Outlaws Sprint Cars	32	B9	B10	6	12	0	Running	$200	90
09/05/22	Grays Harbor Raceway	World of Outlaws Sprint Cars	30	B10	B8	6	12	0	Running	$250	90
09/16/22	Keller Auto Speedway at Kings Fairgrounds	World of Outlaws Sprint Cars	32	B7	B8	6	12	0	Running	$225	90
10/07/22	Port Royal Speedway	World of Outlaws Sprint Cars	40	B17	B15	6	12	0	Running	$200	90
10/14/22	I-80 Speedway	World of Outlaws Sprint Cars	39	B18	B13	6	12	0	Running	$200	90
10/15/22	Lakeside Speedway	World of Outlaws Sprint Cars	37	25	22	6	12	0	DNF	$0	106
10/22/22	Williams Grove Speedway	World of Outlaws Sprint Cars	44	B15	B12	6	11	0	Running	$200	90
11/02/22	The Dirt Track at Charlotte	World of Outlaws Sprint Cars	52	29	25	6	28	0	Running	$0	102
11/05/22	The Dirt Track at Charlotte	World of Outlaws Sprint Cars	0	25	24	6	13	0	DNF	$1,200	102
	Feature Stats			22.1	20.3		507	0		$17,625	4912