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 = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '27863' 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` = '27863' 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 = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '27863' 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 = '27863' 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 = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '27863' 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 = '27863' 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 = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '27863' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '27863' 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 = '27863' 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	B10	B8	20G	11	0	Running	$225	90
02/11/22	Volusia Speedway Park	World of Outlaws Sprint Cars	34	26	21	20G	28	0	Running	$0	198
02/11/22	Volusia Speedway Park	World of Outlaws Sprint Cars	34	B8	B5	20G	12	0	Running	$300	198
02/12/22	Volusia Speedway Park	World of Outlaws Sprint Cars	32	B8	B7	20G	12	0	Running	$225	90
03/04/22	Cotton Bowl Speedway	World of Outlaws Sprint Cars	29	21	22	20G	29	0	Running	$900	106
03/05/22	Cotton Bowl Speedway	World of Outlaws Sprint Cars	29	22	21	20G	29	0	Running	$1,000	108
03/11/22	Thunderbowl Raceway	World of Outlaws Sprint Cars	32	B5	B11	20G	12	0	Running	$200	90
03/12/22	Thunderbowl Raceway	World of Outlaws Sprint Cars	32	25	22	20G	29	0	Running	$225	106
03/18/22	Merced Speedway	World of Outlaws Sprint Cars	33	B12	B11	20G	12	0	Running	$200	90
03/25/22	Bakersfield Speedway	World of Outlaws Sprint Cars	27	21	18	20G	35	0	Running	$1,000	114
03/26/22	Perris Auto Speedway	World of Outlaws Sprint Cars	26	B5	B7	20G	12	0	Running	$300	90
03/29/22	Vado Speedway Park	World of Outlaws Sprint Cars	22	12	17	20G	21	0	Running	$1,000	116
04/02/22	Devil's Bowl Speedway	World of Outlaws Sprint Cars	32	B8	B5	20G	12	0	Running	$300	90
04/09/22	Lake Ozark Speedway	World of Outlaws Sprint Cars	38	B10	B7	20G	12	0	Running	$225	90
04/16/22	Federated Auto Parts I-55 Raceway	World of Outlaws Sprint Cars	37	B3	B11	20G	7	1	Running	$200	90
04/23/22	Tri-State Speedway	World of Outlaws Sprint Cars	27	18	13	20G	40	0	Running	$1,200	124
04/29/22	Bristol Motor Speedway	World of Outlaws Sprint Cars	24	17	17	20G	23	0	Running	$2,000	116
04/30/22	Bristol Motor Speedway	World of Outlaws Sprint Cars	24	19	19	20G	7	0	Running	$2,000	112
05/14/22	Williams Grove Speedway	World of Outlaws Sprint Cars	41	B6	B12	20G	7	0	Running	$200	90
05/17/22	Bridgeport Speedway	World of Outlaws Sprint Cars	33	B11	B12	20G	12	0	Running	$200	90
05/20/22	Attica Raceway Park	World of Outlaws Sprint Cars	41	B10	B7	20G	12	0	Running	$225	90
05/28/22	Atomic Speedway	World of Outlaws Sprint Cars	39	23	22	20G	29	0	Running	$1,000	106
05/30/22	Lawrenceburg Speedway	World of Outlaws Sprint Cars	43	24	14	20G	30	0	Running	$1,100	122
06/03/22	River Cities Speedway	World of Outlaws Sprint Cars	29	17	10	20G	34	0	Running	$2,000	130
06/11/22	Knoxville Raceway	World of Outlaws Sprint Cars	47	B26	B23	20G	0	0	DNS	$200	90
06/17/22	Beaver Dam Raceway	World of Outlaws Sprint Cars	33	21	14	20G	33	0	Running	$950	122
06/18/22	Beaver Dam Raceway	World of Outlaws Sprint Cars	31	16	13	20G	40	0	Running	$1,200	124
06/23/22	Huset's Speedway	World of Outlaws Sprint Cars	49	B6	B6	20G	12	0	Running	$250	90
06/24/22	Huset's Speedway	World of Outlaws Sprint Cars	48	B13	B14	20G	12	0	Running	$200	90
06/25/22	Huset's Speedway	World of Outlaws Sprint Cars	0	B22	B22	20G	0	0	Running	$300	90
07/09/22	Wilmot Raceway	World of Outlaws Sprint Cars	31	21	12	20G	39	0	Running	$1,400	126
07/12/22	Attica Raceway Park	World of Outlaws Sprint Cars	44	B8	B8	20G	12	0	Running	$200	90
07/16/22	Eldora Speedway	World of Outlaws Sprint Cars	54	B14	B20	20G	0	0	Running	$600	90
07/20/22	Port Royal Speedway	World of Outlaws Sprint Cars	33	B12	B10	20G	12	0	Running	$200	90
07/22/22	Williams Grove Speedway	World of Outlaws Sprint Cars	36	B9	B9	20G	13	0	Running	$200	90
07/23/22	Williams Grove Speedway	World of Outlaws Sprint Cars	34	B12	B10	20G	12	0	Running	$200	90
07/30/22	Weedsport Speedway	World of Outlaws Sprint Cars	29	14	17	20G	29	0	Running	$900	116
07/31/22	Weedsport Speedway	World of Outlaws Sprint Cars	29	13	19	20G	29	0	Running	$1,000	112
08/05/22	Federated Auto Parts I-55 Raceway	World of Outlaws Sprint Cars	39	24	13	20G	28	0	Running	$1,000	124
08/06/22	Federated Auto Parts I-55 Raceway	World of Outlaws Sprint Cars	38	11	9	20G	54	0	Running	$2,050	132
08/11/22	Knoxville Raceway	World of Outlaws Sprint Cars	50	17	17	20G	25	0	Running	$1,100	0
08/19/22	Jackson Motorplex	World of Outlaws Sprint Cars	40	23	18	20G	24	0	Running	$1,000	114
08/20/22	Jackson Motorplex	World of Outlaws Sprint Cars	38	12	15	20G	34	0	Running	$2,100	90
08/26/22	River Cities Speedway	World of Outlaws Sprint Cars	35	19	18	20G	28	0	Running	$1,000	114
08/27/22	Red River Valley Speedway	World of Outlaws Sprint Cars	29	14	13	20G	30	0	Running	$1,200	124
09/01/22	Skagit Speedway	World of Outlaws Sprint Cars	31	25	18	20G	30	0	Running	$1,000	114
09/02/22	Skagit Speedway	World of Outlaws Sprint Cars	31	23	18	20G	29	0	Running	$1,000	114
09/03/22	Skagit Speedway	World of Outlaws Sprint Cars	32	B10	B7	20G	12	0	Running	$225	90
09/05/22	Grays Harbor Raceway	World of Outlaws Sprint Cars	30	15	15	20G	30	0	Running	$1,050	120
09/08/22	Silver Dollar Speedway	World of Outlaws Sprint Cars	29	15	19	20G	28	0	Running	$0	0
09/10/22	Silver Dollar Speedway	World of Outlaws Sprint Cars	0	B16	B12	20G	12	0	Running	$200	90
09/16/22	Keller Auto Speedway at Kings Fairgrounds	World of Outlaws Sprint Cars	32	25	22	20G	34	0	Running	$1,000	106
09/24/22	Sharon Speedway	World of Outlaws Sprint Cars	35	10	21	20G	10	0	Running	$1,000	108
09/30/22	Williams Grove Speedway	World of Outlaws Sprint Cars	51	B13	B16	20G	12	0	Running	$200	90
10/07/22	Port Royal Speedway	World of Outlaws Sprint Cars	40	B11	B13	20G	12	0	Running	$200	90
10/08/22	Port Royal Speedway	World of Outlaws Sprint Cars	42	B6	B5	20G	11	0	Running	$300	90
10/14/22	I-80 Speedway	World of Outlaws Sprint Cars	39	20	17	20G	29	0	Running	$1,000	116
10/15/22	Lakeside Speedway	World of Outlaws Sprint Cars	37	B5	B6	20G	12	0	Running	$250	90
11/02/22	The Dirt Track at Charlotte	World of Outlaws Sprint Cars	52	B7	B6	20G	12	0	Running	$250	202
11/02/22	The Dirt Track at Charlotte	World of Outlaws Sprint Cars	52	28	19	20G	29	0	Running	$1,000	202
11/04/22	The Dirt Track at Charlotte	World of Outlaws Sprint Cars	52	27	24	20G	26	0	DNF	$0	102
11/05/22	The Dirt Track at Charlotte	World of Outlaws Sprint Cars	0	24	25	20G	4	0	DNF	$1,200	192
11/05/22	The Dirt Track at Charlotte	World of Outlaws Sprint Cars	0	B6	B18	20G	4	0	DNF	$200	192
	Feature Stats			19.5	17.4		976	0		$36,575	6270