SELECT row_num, `First Name`, `Last Name`, total_with_condition FROM ( SELECT CASE WHEN driver_fulltime= '1' THEN sum(points) + 300 ELSE sum(points) END AS total_with_condition, driver_first_name AS `First Name`, driver_last_name AS `Last Name`, ROW_NUMBER() OVER (ORDER BY CASE WHEN driver_fulltime= '1' THEN sum(points) + 300 ELSE sum(points) END DESC, `driver_last_name` DESC) AS row_num FROM results LEFT JOIN `drivers` ON (`results`.`driver_ID` = `drivers`.`driver_mrp_ID`) WHERE (race_type_ID BETWEEN '1' AND '7') AND `date` REGEXP '2024' AND series_ID = '1' GROUP BY `results`.driver_ID ) AS subquery WHERE `First Name` REGEXP 'Spencer' AND `Last Name` REGEXP 'Bayston' ORDER BY total_with_condition DESC, `Last Name` DESC;