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

Карен Сагомонян

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных4000205125.38258
Национальная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
Молодежная сборная4000205125.38258
     Отборочный турнир4000205125.38258
     Финальный турнир000000000.000
ТОВЫ сборных62117633076.42399
Всего за сборные102119638196.00657
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 63532 WHERE `RP`.`player` = 63532 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,10639572,10639577,10639582,10662952,10662955,10662958,10662961,10662968,10662971,10690381,10691394,10691399,10691404,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,10937970,10937975,10937980,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,11186674,11186675,11186681,11188247,11188367,11188471,11213821,11213826,11213828,11213834,11213837,11213839,11229625,11229630,11229633,11230833,11231880,11232728,11266619,11266624,11266627,11266632,11266635,11266640,11286103,11286108,11286111,11286603,11286696,11287738,11323403,11323408,11323411,11323416,11323419,11323424,11339785,11339790,11339793,11374859,11374864,11374867,11374872,11374875,11374880,11418663,11418668,11418671,11418676,11418679,11418684,11434189,11434194,11434197,11464565,11464570,11464573,11464578,11464581,11464586,11481247,11481252,11481254,11513775,11513780,11513783,11513788,11513791,11513796,11531565,11531570,11531572,11556829,11556834,11556837,11556842,11556845,11556850,11574787,11574792,11574795,11575590,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,11853441,11853446,11853451,11854406,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,127066,127071,127076,128626,128772,128860,158503,158508,158510,158516,158519,158521,192848,192849,192855,192859,192862,192868,210973,210978,210980,212516,232279,232284,232286,232292,232295,232297,273355,273360,273362,273368,273371,273373,312458,312459,312465,312469,312472,312478,333292,333293,333299,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, 208) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 63532 WHERE `RP`.`player` = 63532 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,10639572,10639577,10639582,10662952,10662955,10662958,10662961,10662968,10662971,10690381,10691394,10691399,10691404,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,10937970,10937975,10937980,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,11186674,11186675,11186681,11188247,11188367,11188471,11213821,11213826,11213828,11213834,11213837,11213839,11229625,11229630,11229633,11230833,11231880,11232728,11266619,11266624,11266627,11266632,11266635,11266640,11286103,11286108,11286111,11286603,11286696,11287738,11323403,11323408,11323411,11323416,11323419,11323424,11339785,11339790,11339793,11374859,11374864,11374867,11374872,11374875,11374880,11418663,11418668,11418671,11418676,11418679,11418684,11434189,11434194,11434197,11464565,11464570,11464573,11464578,11464581,11464586,11481247,11481252,11481254,11513775,11513780,11513783,11513788,11513791,11513796,11531565,11531570,11531572,11556829,11556834,11556837,11556842,11556845,11556850,11574787,11574792,11574795,11575590,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,11853441,11853446,11853451,11854406,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,127066,127071,127076,128626,128772,128860,158503,158508,158510,158516,158519,158521,192848,192849,192855,192859,192862,192868,210973,210978,210980,212516,232279,232284,232286,232292,232295,232297,273355,273360,273362,273368,273371,273373,312458,312459,312465,312469,312472,312478,333292,333293,333299,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.080 сек (2)
Size=(59870)