|
| Имя: | Арман Исмуратов | | Страна: |  Казахстан | | Город: | Астана | | Возраст: | 39 | | Строгость: | средний | | Доп. инфо: | нет |
| Статистика текущего сезона |
|---|
| Турнир | Матчи | ЖК | 2ЖК | КК | Пен | ЖК/матч | К/матч |
|---|
| Чемпионаты стран | 4 | 20 | 0 | 0 | 0 | 5.00 | 5.00 | | Кубки стран | 1 | 4 | 0 | 0 | 1 | 4.00 | 4.00 | Query:
select mst.*, tm1.id as hosts, tm2.id as guests,
tm1.name as hosts_name, tm2.name as guests_name,
tm1.country as hosts_country, tm2.country as guests_country,
DATE_FORMAT(d.date, '%d/%m/%y') as game_date
from tournaments t, teams tm1, teams tm2, days d,
tournament_stages tst, match_schedule msc,
match_statistics mst, tournament_schedule tsc
where msc.referee = 2348 and tsc.id = msc.tour_sch
and tm1.id = msc.hosts and tm2.id = msc.guests and d.day = tsc.day
and tsc.tour_stage = tst.id and mst.game = msc.id
and tst.tournament = t.id and t.id = 3
and d.day >= 12487 order by d.day
error: Out of resources when opening file './fb/teams.MYD' (Errcode: 24)
|
