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 = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '1092' 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` = '1092' 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 = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '1092' 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 = '1092' 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 = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '1092' 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 = '1092' 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 = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '1092' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '1092' 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 = '1092' 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	14	11	11	25	0	Running	$1,600	128
02/11/22	Volusia Speedway Park	World of Outlaws Sprint Cars	34	5	15	11	30	0	Running	$1,050	120
02/12/22	Volusia Speedway Park	World of Outlaws Sprint Cars	32	12	13	11	30	0	Running	$1,200	124
03/11/22	Thunderbowl Raceway	World of Outlaws Sprint Cars	32	17	11	83JR	35	0	Running	$1,400	128
03/12/22	Thunderbowl Raceway	World of Outlaws Sprint Cars	32	20	25	83JR	0	0	Running	$1,000	102
03/18/22	Merced Speedway	World of Outlaws Sprint Cars	33	8	6	83JR	35	0	Running	$2,300	138
03/25/22	Bakersfield Speedway	World of Outlaws Sprint Cars	27	13	9	83JR	35	0	Running	$2,050	132
03/26/22	Perris Auto Speedway	World of Outlaws Sprint Cars	26	17	16	83JR	31	0	Running	$1,000	118
04/16/22	Federated Auto Parts I-55 Raceway	World of Outlaws Sprint Cars	37	21	20	83JR	24	0	Running	$1,000	110
04/29/22	Bristol Motor Speedway	World of Outlaws Sprint Cars	24	12	11	83JR	25	0	Running	$2,500	128
04/30/22	Bristol Motor Speedway	World of Outlaws Sprint Cars	24	6	6	83JR	26	0	Running	$4,000	138
06/11/22	Knoxville Raceway	World of Outlaws Sprint Cars	47	21	21	83JR	18	0	Running	$1,000	108
07/12/22	Attica Raceway Park	World of Outlaws Sprint Cars	44	3	6	83JR	40	0	Running	$2,300	138
07/13/22	Eldora Speedway	World of Outlaws Sprint Cars	55	22	14	83JR	25	0	Running	$1,100	122
07/14/22	Eldora Speedway	World of Outlaws Sprint Cars	59	4	15	83JR	39	0	Running	$4,575	90
07/15/22	Eldora Speedway	World of Outlaws Sprint Cars	52	18	16	83JR	25	0	Running	$1,000	118
07/16/22	Eldora Speedway	World of Outlaws Sprint Cars	54	2	10	83JR	40	6	Running	$6,000	90
08/05/22	Federated Auto Parts I-55 Raceway	World of Outlaws Sprint Cars	39	14	23	83JR	0	0	Running	$900	104
08/06/22	Federated Auto Parts I-55 Raceway	World of Outlaws Sprint Cars	38	9	11	83JR	54	0	Running	$1,600	128
08/12/22	Knoxville Raceway	World of Outlaws Sprint Cars	72	4	2	83JR	25	0	Running	$4,000	0
08/13/22	Knoxville Raceway	World of Outlaws Sprint Cars	0	22	15	83JR	50	0	Running	$11,000	90
08/19/22	Jackson Motorplex	World of Outlaws Sprint Cars	40	B8	B5	83JR	12	0	Running	$300	90
08/20/22	Jackson Motorplex	World of Outlaws Sprint Cars	38	15	13	83JR	35	0	Running	$2,300	90
09/01/22	Skagit Speedway	World of Outlaws Sprint Cars	31	5	6	83JR	30	0	Running	$2,150	138
09/02/22	Skagit Speedway	World of Outlaws Sprint Cars	31	11	13	83JR	30	0	Running	$1,200	124
09/03/22	Skagit Speedway	World of Outlaws Sprint Cars	32	17	16	83JR	35	0	Running	$1,000	118
09/05/22	Grays Harbor Raceway	World of Outlaws Sprint Cars	30	22	7	83JR	30	0	Running	$2,200	136
09/09/22	Silver Dollar Speedway	World of Outlaws Sprint Cars	29	9	9	83JR	30	0	Running	$0	0
09/10/22	Silver Dollar Speedway	World of Outlaws Sprint Cars	0	19	19	83JR	40	0	Running	$2,000	90
09/16/22	Keller Auto Speedway at Kings Fairgrounds	World of Outlaws Sprint Cars	32	15	15	83JR	35	0	Running	$1,050	120
	Feature Stats			13.0	12.9		877	6		$64,475	3260