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

Эйрик Скосхейм

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных2004374205.50151
Национальная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
Молодежная сборная2004374205.50151
     Отборочный турнир2004374205.50151
     Финальный турнир000000000.000
ТОВЫ сборных60167920106.17294
Всего за сборные8011011624306.00445
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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` = 52032 WHERE `RP`.`player` = 52032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125248,126347,129017,130046,204181,206083,209615,209704,280921,280926,280929,280934,280937,280942,338088,338094,338097,338102,338105,338107,10398235,10398240,10398243,10398248,10398251,10398256,10479006,10479012,10479015,10479020,10479023,10479025,10542299,10542304,10542307,10542312,10542315,10542320,10567343,10604555,10604560,10604563,10604568,10604571,10604576,10662951,10662953,10662960,10662963,10662966,10662972,10726603,10726608,10726611,10726616,10726619,10726624,10796605,10796610,10796613,10796618,10796621,10796626,10825107,10876387,10876392,10876395,10876400,10876403,10876408,10919832,10919838,10919841,10919846,10919849,10919851,10936974,10964315,10964317,10964324,10964327,10964330,10964336,10981501,11014920,11014921,11014927,11014931,11014934,11014940,11069606,11069611,11069616,11069617,11069624,11069627,11084879,11122110,11122111,11122117,11122121,11122124,11122130,11170525,11170530,11170533,11170538,11170541,11170546,11213771,11213776,11213779,11213784,11213787,11213792,11266573,11266578,11266580,11266586,11266589,11266591,11323283,11323288,11323291,11323296,11323299,11323304,11374981,11374986,11374988,11374994,11374997,11374999,11418546,11418547,11418553,11418557,11418560,11418566,11464734,11464739,11464744,11464745,11464752,11464755,11513992,11513997,11514002,11514003,11514010,11514013,11556830,11556835,11556840,11556841,11556848,11556851,11600534,11600539,11600544,11600545,11600552,11600555,11649458,11649463,11649468,11649469,11649476,11649479,11671532,11671537,11671542,11671543,11671550,11671553,11711139,11739315,11739316,11739322,11739326,11739329,11739335,11786932,11786937,11786939,11786945,11786948,11786950,11837074,11837079,11837081,11837087,11837090,11837092,11868825,11868826,11868832,11868836,11868839,11868845,11923991,11923996,11924001,11924002,11924009,11924012,11964049,11964054,11964059,11964060,11964067,11964070,12004271,12004272,12004278,12004282,12004285,12004291,12021343,12045619,12045620,12045626,12045630,12045633,12045639,12061187,12084645,12084646,12084652,12084656,12084659,12084665,20354,20359,20364,20365,20372,20375,71706,71711,71716,71717,71724,71727,85605,111867,111872,111874,111880,111883,111885,158502,158507,158512,158513,158520,158523,192822,192827,192832,192833,192840,192843,232374,232379,232384,232385,232392,232395,273236,273237,273243,273247,273250,273256,288015,312602,312603,312609,312613,312616,312622,357314,357315,357321,357325,357328,357334) ) 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` = 52032 WHERE `RP`.`player` = 52032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125248,126347,129017,130046,204181,206083,209615,209704,280921,280926,280929,280934,280937,280942,338088,338094,338097,338102,338105,338107,10398235,10398240,10398243,10398248,10398251,10398256,10479006,10479012,10479015,10479020,10479023,10479025,10542299,10542304,10542307,10542312,10542315,10542320,10567343,10604555,10604560,10604563,10604568,10604571,10604576,10662951,10662953,10662960,10662963,10662966,10662972,10726603,10726608,10726611,10726616,10726619,10726624,10796605,10796610,10796613,10796618,10796621,10796626,10825107,10876387,10876392,10876395,10876400,10876403,10876408,10919832,10919838,10919841,10919846,10919849,10919851,10936974,10964315,10964317,10964324,10964327,10964330,10964336,10981501,11014920,11014921,11014927,11014931,11014934,11014940,11069606,11069611,11069616,11069617,11069624,11069627,11084879,11122110,11122111,11122117,11122121,11122124,11122130,11170525,11170530,11170533,11170538,11170541,11170546,11213771,11213776,11213779,11213784,11213787,11213792,11266573,11266578,11266580,11266586,11266589,11266591,11323283,11323288,11323291,11323296,11323299,11323304,11374981,11374986,11374988,11374994,11374997,11374999,11418546,11418547,11418553,11418557,11418560,11418566,11464734,11464739,11464744,11464745,11464752,11464755,11513992,11513997,11514002,11514003,11514010,11514013,11556830,11556835,11556840,11556841,11556848,11556851,11600534,11600539,11600544,11600545,11600552,11600555,11649458,11649463,11649468,11649469,11649476,11649479,11671532,11671537,11671542,11671543,11671550,11671553,11711139,11739315,11739316,11739322,11739326,11739329,11739335,11786932,11786937,11786939,11786945,11786948,11786950,11837074,11837079,11837081,11837087,11837090,11837092,11868825,11868826,11868832,11868836,11868839,11868845,11923991,11923996,11924001,11924002,11924009,11924012,11964049,11964054,11964059,11964060,11964067,11964070,12004271,12004272,12004278,12004282,12004285,12004291,12021343,12045619,12045620,12045626,12045630,12045633,12045639,12061187,12084645,12084646,12084652,12084656,12084659,12084665,20354,20359,20364,20365,20372,20375,71706,71711,71716,71717,71724,71727,85605,111867,111872,111874,111880,111883,111885,158502,158507,158512,158513,158520,158523,192822,192827,192832,192833,192840,192843,232374,232379,232384,232385,232392,232395,273236,273237,273243,273247,273250,273256,288015,312602,312603,312609,312613,312616,312622,357314,357315,357321,357325,357328,357334) ) 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.069 сек (10)
Size=(58846)