Samuel
- Создано:
- 30-08-2023 03:10
Samuel de Carvalho Almeida
- Пол:
- Страна:
- Brazil - Fortaleza
- Возраст:
- 40 лет
- Описание:
- Nationality: Brazil Height: 171 cm Weight: 66 kg
Команды
нет
MySQL Error!
MySQL error in file: /engine/classes/main.class.php at line 526
Error Number: 2013
The Error returned was:
Lost connection to MySQL server during query
Lost connection to MySQL server during query
SQL query:
SELECT a.win as win, a.winop as winop, (a.win+a.winop) as countgame, ROUND((a.win/((a.win+a.winop)/100)),2) as ratio FROM ( SELECT tmp.member, sum(tmp.win) as win, sum(tmp.winop) as winop FROM ( Select m.member1 as member, IF(m.win=1,1,0) as win, IF(m.win=2,1,0) as winop FROM hdg_hdg_matches_results as m LEFT OUTER JOIN hdg_hdg_matches as mtch on mtch.id=m.match_id where (m.game = 1 and m.member1 <> -1 and m.member1 <> 0 and m.member2 <>-1 and m.member2 <> 0 and m.is_team_format=2 and (m.line_number2!=0 or m.type_game=21)) and m.member1 = 77638 union all Select m.member2 as member, IF(m.win=2,1,0) as win, IF(m.win=1,1,0) as winop FROM hdg_hdg_matches_results as m LEFT OUTER JOIN hdg_hdg_matches as mtch on mtch.id=m.match_id where (m.game = 1 and m.member1 <>-1 and m.member1 <> 0 and m.member2 <>-1 and m.member2 <> 0 and m.is_team_format=2 and (m.line_number2!=0 or m.type_game=21)) and m.member2 = 77638) tmp group by tmp.member ) a
SELECT a.win as win, a.winop as winop, (a.win+a.winop) as countgame, ROUND((a.win/((a.win+a.winop)/100)),2) as ratio FROM ( SELECT tmp.member, sum(tmp.win) as win, sum(tmp.winop) as winop FROM ( Select m.member1 as member, IF(m.win=1,1,0) as win, IF(m.win=2,1,0) as winop FROM hdg_hdg_matches_results as m LEFT OUTER JOIN hdg_hdg_matches as mtch on mtch.id=m.match_id where (m.game = 1 and m.member1 <> -1 and m.member1 <> 0 and m.member2 <>-1 and m.member2 <> 0 and m.is_team_format=2 and (m.line_number2!=0 or m.type_game=21)) and m.member1 = 77638 union all Select m.member2 as member, IF(m.win=2,1,0) as win, IF(m.win=1,1,0) as winop FROM hdg_hdg_matches_results as m LEFT OUTER JOIN hdg_hdg_matches as mtch on mtch.id=m.match_id where (m.game = 1 and m.member1 <>-1 and m.member1 <> 0 and m.member2 <>-1 and m.member2 <> 0 and m.is_team_format=2 and (m.line_number2!=0 or m.type_game=21)) and m.member2 = 77638) tmp group by tmp.member ) a