SELECT a_type.id, a_type.g_name, a7_bet.team1,a7_bet.team2,a7_bet.lsid,a7_bet.bet_date,a7_bet.b_let,sd_lsbiao.ys,a7_bet.dian, a_type.g_xin, a_type.g_jpg_60, a_type.g_txt, a_type.g_name_eng, a_to.t_7_b, a_to.t_7_y, a_to.t_7_c, a_to.t_7_p, a_to.t_7_g, a_to.t_30_b, a_to.t_30_y, a_to.t_30_c, a_to.t_30_p, a_to.t_30_g FROM a7_bet LEFT JOIN a_type ON a7_bet.bet_type = a_type.id LEFT JOIN sd_lsbiao ON a7_bet.lsid = sd_lsbiao.lsname LEFT JOIN a_web ON ( a_type.g_web_id= a_web.id ) LEFT JOIN a_to ON (a_to.a_type_id = a_type.id ) WHERE a7_bet.web_id=3 and a7_bet.id=826445 order by a7_bet.id desc
