Rico Abreu's Stats
World of Outlaws Sprint Cars
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 = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '18691' 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` = '18691' 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 = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '18691' 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 = '18691' 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 = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '18691' 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 = '18691' 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 = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main WHERE race_driver_id = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_2 WHERE race_driver_id = '18691' AND race_mrp_id = `race`), 0) + ifnull((SELECT (race_points) from woo_b_main_3 WHERE race_driver_id = '18691' 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 = '18691' AND race_points != '0' AND `race_date` REGEXP '2022' AND race_series REGEXP 'World of Outlaws Sprint Cars' ORDER BY race_date ASC
DateTrackSeriesCarsStartFinish#LapsLedStatusMoneyPoints
03/04/22Cotton Bowl SpeedwayWorld of Outlaws Sprint Cars29181224300Running$1,200126
03/05/22Cotton Bowl SpeedwayWorld of Outlaws Sprint Cars29181024300Running$2,000130
03/11/22Thunderbowl RacewayWorld of Outlaws Sprint Cars323424350Running$2,600142
03/12/22Thunderbowl RacewayWorld of Outlaws Sprint Cars3214524350Running$2,500140
03/18/22Merced SpeedwayWorld of Outlaws Sprint Cars3311924350Running$2,050132
03/25/22Bakersfield SpeedwayWorld of Outlaws Sprint Cars2741724350Running$1,000116
03/26/22Perris Auto SpeedwayWorld of Outlaws Sprint Cars26151324310Running$1,200124
04/09/22Lake Ozark SpeedwayWorld of Outlaws Sprint Cars3812724300Running$2,425136
04/16/22Federated Auto Parts I-55 RacewayWorld of Outlaws Sprint Cars377624350Running$2,300138
04/23/22Tri-State SpeedwayWorld of Outlaws Sprint Cars27111624390Running$1,000118
04/29/22Bristol Motor SpeedwayWorld of Outlaws Sprint Cars24151424240Running$2,200122
04/30/22Bristol Motor SpeedwayWorld of Outlaws Sprint Cars244424260Running$5,000142
05/11/22Lincoln SpeedwayWorld of Outlaws Sprint Cars554624350Running$2,300138
05/14/22Williams Grove SpeedwayWorld of Outlaws Sprint Cars413324300Running$3,500144
05/17/22Bridgeport SpeedwayWorld of Outlaws Sprint Cars335724250Running$2,200136
05/20/22Attica Raceway ParkWorld of Outlaws Sprint Cars41121524400Running$1,050120
06/10/22Knoxville RacewayWorld of Outlaws Sprint Cars52161224250Running$1,200126
06/11/22Knoxville RacewayWorld of Outlaws Sprint Cars47181024250Running$2,000130
06/17/22Beaver Dam RacewayWorld of Outlaws Sprint Cars338724350Running$2,100136
06/18/22Beaver Dam RacewayWorld of Outlaws Sprint Cars3161524400Running$1,050120
06/22/22Huset's SpeedwayWorld of Outlaws Sprint Cars46121224300Running$1,400126
06/23/22Huset's SpeedwayWorld of Outlaws Sprint Cars49141124350Running$1,600128
06/24/22Huset's SpeedwayWorld of Outlaws Sprint Cars484232480Running$1,500104
06/25/22Huset's SpeedwayWorld of Outlaws Sprint Cars0211524400Running$3,10090
07/12/22Attica Raceway ParkWorld of Outlaws Sprint Cars44211424400Running$1,100122
07/13/22Eldora SpeedwayWorld of Outlaws Sprint Cars5512624250Running$2,300138
07/14/22Eldora SpeedwayWorld of Outlaws Sprint Cars598324403Running$15,00090
07/15/22Eldora SpeedwayWorld of Outlaws Sprint Cars521224259Running$6,000146
07/16/22Eldora SpeedwayWorld of Outlaws Sprint Cars54141224400Running$5,85090
08/05/22Federated Auto Parts I-55 RacewayWorld of Outlaws Sprint Cars39B2B142478Running$20090
08/06/22Federated Auto Parts I-55 RacewayWorld of Outlaws Sprint Cars3813624550Running$2,300138
08/12/22Knoxville RacewayWorld of Outlaws Sprint Cars722124R2525Running$4,0000
08/13/22Knoxville RacewayWorld of Outlaws Sprint Cars0211324R500Running$13,00090
08/19/22Jackson MotorplexWorld of Outlaws Sprint Cars40201524240Running$1,050120
08/20/22Jackson MotorplexWorld of Outlaws Sprint Cars38101224350Running$2,40090
09/23/22Eldora SpeedwayWorld of Outlaws Sprint Cars4431243024Running$10,000150
09/30/22Williams Grove SpeedwayWorld of Outlaws Sprint Cars51131324100Running$1,200124
11/02/22The Dirt Track at CharlotteWorld of Outlaws Sprint Cars525424300Running$2,900142
11/04/22The Dirt Track at CharlotteWorld of Outlaws Sprint Cars52122224270DNF$1,000106
11/05/22The Dirt Track at CharlotteWorld of Outlaws Sprint Cars04624300Running$3,750138
Feature Stats10.69.8123961$120,3254838

Which Schedule Would You like to Add to Your Calendar

2022_CASE_LMS_LOGO