48 сезон
Чемпионат Европы
Вход в систему
Вход через VK
ПБ-ВИКИ

Трдат Сукиасян

    Игрок   Статистика   История   Травмы   Достижения   Сборные   Трансферы
 

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных14007516221626.501213
Национальная сборная600358811206.17558
     Отборочный турнир600358811206.17558
     Финальный турнир000000000.000
Молодежная сборная80040741426.75655
     Отборочный турнир60035620427.00497
     Финальный турнир2005121006.00158
ТОВЫ сборных70057990126.79593
Всего за сборные210013226121746.601806
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(SELECT `RP`.*, 0 as `sezon`, `PG`.*, 0 as `sezon`, `PG`.`id` as `gid`, `PG`.`lastchangetable` as `sort`, `PT`.`pl_time` FROM `p_roster_pl` `RP` LEFT JOIN `p_rosters` `PR` ON `PR`.`id` = `RP`.`roster` RIGHT JOIN `p_games` `PG` ON `PG`.`id` = `PR`.`game` AND `PG`.`tournament` IN(139) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 68032 WHERE `RP`.`player` = 68032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126348,128197,129014,130047,206086,209457,209614,209703,280851,280853,280860,280863,280866,280872,338089,338091,338098,338101,338104,338110,10398190,10398193,10398196,10398199,10398206,10398209,10479080,10479083,10479086,10479089,10479096,10479099,10542302,10542305,10542308,10542311,10542318,10542321,10604630,10604633,10604636,10604639,10604646,10604649,10637414,10662952,10662955,10662958,10662961,10662968,10662971,10690381,10726580,10726586,10726589,10726594,10726597,10726599,10796751,10796753,10796760,10796763,10796766,10796772,10876293,10876295,10876302,10876305,10876308,10876314,10920001,10920003,10920010,10920013,10920016,10920022,10936973,10964290,10964296,10964299,10964304,10964307,10964309,10981498,11014896,11014897,11014903,11014907,11014910,11014916,11069582,11069587,11069592,11069593,11069600,11069603,11121964,11121969,11121974,11121975,11121982,11121985,11170670,11170675,11170680,11170681,11170688,11170691,11213821,11213826,11213828,11213834,11213837,11213839,11266619,11266624,11266627,11266632,11266635,11266640,11323403,11323408,11323411,11323416,11323419,11323424,11374859,11374864,11374867,11374872,11374875,11374880,11418663,11418668,11418671,11418676,11418679,11418684,11464565,11464570,11464573,11464578,11464581,11464586,11513775,11513780,11513783,11513788,11513791,11513796,11556829,11556834,11556837,11556842,11556845,11556850,11600773,11600778,11600781,11600786,11600789,11600794,11616930,11649651,11649656,11649658,11649664,11649667,11649669,11666271,11671629,11671634,11671636,11671642,11671645,11671647,11739194,11739199,11739201,11739207,11739210,11739212,11786908,11786913,11786915,11786921,11786924,11786926,11837075,11837076,11837082,11837086,11837089,11837095,11852582,11868992,11868997,11868999,11869005,11869008,11869010,11923944,11923949,11923951,11923957,11923960,11923962,11964219,11964220,11964226,11964230,11964233,11964239,12004319,12004320,12004326,12004330,12004333,12004339,12021339,12045594,12045599,12045601,12045607,12045610,12045612,12084597,12084598,12084604,12084608,12084611,12084617,20236,20237,20243,20247,20250,20256,71778,71783,71788,71789,71796,71799,111914,111919,111924,111925,111932,111935,126199,158503,158508,158510,158516,158519,158521,192848,192849,192855,192859,192862,192868,232279,232284,232286,232292,232295,232297,273355,273360,273362,273368,273371,273373,312458,312459,312465,312469,312472,312478,357408,357413,357418,357419,357426,357429) ) UNION (SELECT `RP`.*, `PG`.*, `PG`.`id` as `gid`, `PG`.`lastchangetable` as `sort`, `PT`.`pl_time` FROM `p_roster_pl_arch` `RP` LEFT JOIN `p_rosters_arch` `PR` ON `PR`.`id` = `RP`.`roster` RIGHT JOIN `p_games_arch` `PG` ON `PG`.`id` = `PR`.`game` AND `PG`.`tournament` IN(139) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 68032 WHERE `RP`.`player` = 68032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126348,128197,129014,130047,206086,209457,209614,209703,280851,280853,280860,280863,280866,280872,338089,338091,338098,338101,338104,338110,10398190,10398193,10398196,10398199,10398206,10398209,10479080,10479083,10479086,10479089,10479096,10479099,10542302,10542305,10542308,10542311,10542318,10542321,10604630,10604633,10604636,10604639,10604646,10604649,10637414,10662952,10662955,10662958,10662961,10662968,10662971,10690381,10726580,10726586,10726589,10726594,10726597,10726599,10796751,10796753,10796760,10796763,10796766,10796772,10876293,10876295,10876302,10876305,10876308,10876314,10920001,10920003,10920010,10920013,10920016,10920022,10936973,10964290,10964296,10964299,10964304,10964307,10964309,10981498,11014896,11014897,11014903,11014907,11014910,11014916,11069582,11069587,11069592,11069593,11069600,11069603,11121964,11121969,11121974,11121975,11121982,11121985,11170670,11170675,11170680,11170681,11170688,11170691,11213821,11213826,11213828,11213834,11213837,11213839,11266619,11266624,11266627,11266632,11266635,11266640,11323403,11323408,11323411,11323416,11323419,11323424,11374859,11374864,11374867,11374872,11374875,11374880,11418663,11418668,11418671,11418676,11418679,11418684,11464565,11464570,11464573,11464578,11464581,11464586,11513775,11513780,11513783,11513788,11513791,11513796,11556829,11556834,11556837,11556842,11556845,11556850,11600773,11600778,11600781,11600786,11600789,11600794,11616930,11649651,11649656,11649658,11649664,11649667,11649669,11666271,11671629,11671634,11671636,11671642,11671645,11671647,11739194,11739199,11739201,11739207,11739210,11739212,11786908,11786913,11786915,11786921,11786924,11786926,11837075,11837076,11837082,11837086,11837089,11837095,11852582,11868992,11868997,11868999,11869005,11869008,11869010,11923944,11923949,11923951,11923957,11923960,11923962,11964219,11964220,11964226,11964230,11964233,11964239,12004319,12004320,12004326,12004330,12004333,12004339,12021339,12045594,12045599,12045601,12045607,12045610,12045612,12084597,12084598,12084604,12084608,12084611,12084617,20236,20237,20243,20247,20250,20256,71778,71783,71788,71789,71796,71799,111914,111919,111924,111925,111932,111935,126199,158503,158508,158510,158516,158519,158521,192848,192849,192855,192859,192862,192868,232279,232284,232286,232292,232295,232297,273355,273360,273362,273368,273371,273373,312458,312459,312465,312469,312472,312478,357408,357413,357418,357419,357426,357429) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}:
(c) 2002-2025 Дмитрий Язынин
Время создания страницы: 0.087 сек (3)
Size=(59110)