UPDATE bb_player_skills AS s SET
contact_l_batskill = (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)),
contact_r_batskill = (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)),
eye_batskill = (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)),
power_l_batskill = (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_r_batskill = (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)),
speed_batskill = (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));