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

Габриэль Гудмундссон

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных12151175151010837.83916
Национальная сборная12151175151010837.83916
     Отборочный турнир5025121944307.40400
     Финальный турнир7136629666538.14516
Молодежная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
ТОВЫ сборных16111116602011817.281031
Всего за сборные282622811753022647.521947
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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(140) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 71207 WHERE `RP`.`player` = 71207 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125171,126356,129029,130274,130653,131988,204100,206094,209558,209627,210911,209716,280633,280638,280641,280646,280649,280654,338376,338382,338385,338390,338393,338395,10398552,10398558,10398561,10398566,10398569,10398571,10479318,10479324,10479327,10479332,10479335,10479337,10542108,10542114,10542117,10542122,10542125,10542127,10604677,10604679,10604686,10604689,10604692,10604698,10663166,10663172,10663175,10663180,10663183,10663185,10726291,10726296,10726299,10726304,10726307,10726312,10796989,10796994,10796997,10797002,10797005,10797010,10876604,10876610,10876613,10876618,10876621,10876623,10919687,10919692,10919695,10919700,10919703,10919708,10964507,10964512,10964515,10964520,10964523,10964528,11015205,11015210,11015213,11015218,11015221,11015226,11069461,11069466,11069469,11069474,11069477,11069482,11084875,11122443,11122448,11122451,11122456,11122459,11122464,11170312,11170313,11170319,11170323,11170326,11170332,11213990,11213991,11213997,11214001,11214004,11214010,11266814,11266815,11266821,11266825,11266828,11266834,11323022,11323023,11323029,11323033,11323036,11323042,11374622,11374623,11374629,11374633,11374636,11374642,11391967,11418305,11418310,11418312,11418318,11418321,11418323,11464543,11464548,11464550,11464556,11464559,11464561,11479156,11513537,11513542,11513544,11513550,11513553,11513555,11530196,11556591,11556596,11556598,11556604,11556607,11556609,11600320,11600321,11600327,11600331,11600334,11600340,11649172,11649173,11649179,11649183,11649186,11649192,11666266,11671462,11671463,11671469,11671473,11671476,11671482,11739099,11739100,11739106,11739110,11739113,11739119,11786621,11786622,11786628,11786632,11786635,11786641,11836955,11836956,11836962,11836966,11836969,11836975,11852596,11868705,11868706,11868712,11868716,11868719,11868725,11923895,11923900,11923905,11923906,11923913,11923916,11963883,11963884,11963890,11963894,11963897,11963903,12004053,12004058,12004063,12004064,12004071,12004074,12045161,12045166,12045171,12045172,12045179,12045182,12084452,12084457,12084459,12084465,12084468,12084470,19969,19974,19977,19982,19985,19990,71419,71424,71426,71432,71435,71437,111531,111536,111538,111544,111547,111549,126191,158119,158124,158126,158132,158135,158137,172821,192583,192588,192590,192596,192599,192601,232592,232593,232599,232603,232606,232612,273043,273048,273050,273056,273059,273061,288008,312313,312318,312320,312326,312329,312331,357098,357099,357105,357109,357112,357118) ) 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(140) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 71207 WHERE `RP`.`player` = 71207 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125171,126356,129029,130274,130653,131988,204100,206094,209558,209627,210911,209716,280633,280638,280641,280646,280649,280654,338376,338382,338385,338390,338393,338395,10398552,10398558,10398561,10398566,10398569,10398571,10479318,10479324,10479327,10479332,10479335,10479337,10542108,10542114,10542117,10542122,10542125,10542127,10604677,10604679,10604686,10604689,10604692,10604698,10663166,10663172,10663175,10663180,10663183,10663185,10726291,10726296,10726299,10726304,10726307,10726312,10796989,10796994,10796997,10797002,10797005,10797010,10876604,10876610,10876613,10876618,10876621,10876623,10919687,10919692,10919695,10919700,10919703,10919708,10964507,10964512,10964515,10964520,10964523,10964528,11015205,11015210,11015213,11015218,11015221,11015226,11069461,11069466,11069469,11069474,11069477,11069482,11084875,11122443,11122448,11122451,11122456,11122459,11122464,11170312,11170313,11170319,11170323,11170326,11170332,11213990,11213991,11213997,11214001,11214004,11214010,11266814,11266815,11266821,11266825,11266828,11266834,11323022,11323023,11323029,11323033,11323036,11323042,11374622,11374623,11374629,11374633,11374636,11374642,11391967,11418305,11418310,11418312,11418318,11418321,11418323,11464543,11464548,11464550,11464556,11464559,11464561,11479156,11513537,11513542,11513544,11513550,11513553,11513555,11530196,11556591,11556596,11556598,11556604,11556607,11556609,11600320,11600321,11600327,11600331,11600334,11600340,11649172,11649173,11649179,11649183,11649186,11649192,11666266,11671462,11671463,11671469,11671473,11671476,11671482,11739099,11739100,11739106,11739110,11739113,11739119,11786621,11786622,11786628,11786632,11786635,11786641,11836955,11836956,11836962,11836966,11836969,11836975,11852596,11868705,11868706,11868712,11868716,11868719,11868725,11923895,11923900,11923905,11923906,11923913,11923916,11963883,11963884,11963890,11963894,11963897,11963903,12004053,12004058,12004063,12004064,12004071,12004074,12045161,12045166,12045171,12045172,12045179,12045182,12084452,12084457,12084459,12084465,12084468,12084470,19969,19974,19977,19982,19985,19990,71419,71424,71426,71432,71435,71437,111531,111536,111538,111544,111547,111549,126191,158119,158124,158126,158132,158135,158137,172821,192583,192588,192590,192596,192599,192601,232592,232593,232599,232603,232606,232612,273043,273048,273050,273056,273059,273061,288008,312313,312318,312320,312326,312329,312331,357098,357099,357105,357109,357112,357118) ) 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.118 сек (3)
Size=(58918)