UPDATE bb_player_skills AS s SET
control_l_pit_skill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
                JOIN bb_players p ON bb_players_id=p.id
                JOIN bb_manager m ON p.team_id=m.bb_team_info_id
           WHERE m.LEVEL=l.LEVEL AND l.star=2 AND p.is_bat='false' AND (p.years_left=1 OR p.retirement_age=p.age)),
control_r_pitskill = 2+(SELECT l.from_quality FROM bb_quality_of_player_settings l
                JOIN bb_players p ON bb_players_id=p.id
                JOIN bb_manager m ON p.team_id=m.bb_team_info_id
           WHERE m.LEVEL=l.LEVEL AND l.star=2 AND p.is_bat='true' AND (p.years_left=1 OR p.retirement_age=p.age)),
endurance_pitskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
                JOIN bb_players p ON bb_players_id=p.id
                JOIN bb_manager m ON p.team_id=m.bb_team_info_id
           WHERE m.LEVEL=l.LEVEL AND l.star=2 AND p.is_bat='true' AND (p.years_left=1 OR p.retirement_age=p.age)),
fielding_skill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
                JOIN bb_players p ON bb_players_id=p.id
                JOIN bb_manager m ON p.team_id=m.bb_team_info_id
           WHERE m.LEVEL=l.LEVEL AND l.star=2 AND p.is_bat='true' AND (p.years_left=1 OR p.retirement_age=p.age)),
movement_l_pitskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
                JOIN bb_players p ON bb_players_id=p.id
                JOIN bb_manager m ON p.team_id=m.bb_team_info_id
           WHERE m.LEVEL=l.LEVEL AND l.star=2 AND p.is_bat='true' AND (p.years_left=1 OR p.retirement_age=p.age)),
movement_r_pitskill = 2+(SELECT l.from_quality FROM bb_quality_of_player_settings l
                JOIN bb_players p ON bb_players_id=p.id
                JOIN bb_manager m ON p.team_id=m.bb_team_info_id
           WHERE m.LEVEL=l.LEVEL AND l.star=2 AND p.is_bat='true' AND (p.years_left=1 OR p.retirement_age=p.age)),
mental_pitskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
                JOIN bb_players p ON bb_players_id=p.id
                JOIN bb_manager m ON p.team_id=m.bb_team_info_id
           WHERE m.LEVEL=l.LEVEL AND l.star=2 AND p.is_bat='true' AND (p.years_left=1 OR p.retirement_age=p.age)),
power_pitskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
                JOIN bb_players p ON bb_players_id=p.id
                JOIN bb_manager m ON p.team_id=m.bb_team_info_id
           WHERE m.LEVEL=l.LEVEL AND l.star=2 AND p.is_bat='true' AND (p.years_left=1 OR p.retirement_age=p.age));