UPDATE bb_player_skills s SET

s.contact_l_batskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
        JOIN bb_players p ON s.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'),
s.contact_r_batskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
        JOIN bb_players p ON s.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'),
s.eye_batskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
        JOIN bb_players p ON s.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'),
s.fielding_skill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
        JOIN bb_players p ON s.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'),
s.power_l_batskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
        JOIN bb_players p ON s.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'),
s.power_r_batskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
        JOIN bb_players p ON s.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'),
s.speed_batskill = (SELECT l.from_quality FROM bb_quality_of_player_settings l
        JOIN bb_players p ON s.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');