test---amhyh mtid=31080,rdid=2test---ysj sql1=SELECT a.tp_tm_id, CONCAT(b.pl_cn_name,(case when b.pl_type='AMA' then '' else '' end)) as pl_cn_name,c.gpd_line,a.tp_pl_id,c.gpd_id,d.mp_logo FROM team_player_extend AS a LEFT JOIN `player` AS b ON a.tp_pl_id = b.pl_id LEFT JOIN (SELECT gpd_player,gpd_line,gpd_id FROM `group`,`group_detail` WHERE gp_id = gpd_id AND gp_mt_id = '31080' AND gp_rd_id = '2') AS c ON a.tp_pl_id = c.gpd_player LEFT JOIN match_player d ON d.mp_player_id=a.tp_pl_id and d.mp_match=a.tp_notes WHERE a.tp_rd_id = '2' and a.tp_notes = '31080' ORDER BY a.tp_tm_id ASC,a.tp_tm_id ASC,tp_cdate,tp_seq,pl_country, pl_en_name ASC, pl_idtest---ysj sql2=SELECT a.tp_tm_id, CONCAT(b.pl_cn_name,(case when b.pl_type='AMA' then '' else '' end)) as pl_cn_name,c.gpd_line,a.tp_pl_id,c.gpd_id,d.mp_logo FROM team_player AS a LEFT JOIN `player` AS b ON a.tp_pl_id = b.pl_id LEFT JOIN (SELECT gpd_player,gpd_line,gpd_id FROM `group`,`group_detail` WHERE gp_id = gpd_id AND gp_mt_id = '31080' AND gp_rd_id = '2') AS c ON a.tp_pl_id = c.gpd_player LEFT JOIN match_player d ON d.mp_player_id=a.tp_pl_id and d.mp_match=a.tp_notes WHERE a.tp_notes = '31080' ORDER BY a.tp_tm_id ASC,a.tp_tm_id ASC,tp_cdate,tp_seq,pl_country, pl_en_name ASC, pl_id