select DISTINCT t.*,g.sGroup_Name,g.enGroup_Name,g.enSGroup_Name,s.Description FROM `time` AS t JOIN `grp_name` AS g ON t.group_num=g.Group_Num LEFT JOIN `sub_sift` AS s ON s.Group_Num=g.Group_Num and s.SubNo=t.subno where t.date='1131125' group by t.item order by t.item*1,s.Description DESC