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

Якоб Угланн

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных13500108360246.62987
Национальная сборная3200133046.00204
     Отборочный турнир3200133046.00204
     Финальный турнир000000000.000
Молодежная сборная1030095330206.80783
     Отборочный турнир820072280176.81671
     Финальный турнир2100235036.75112
ТОВЫ сборных1052398290207.30661
Всего за сборные231023206650446.911648
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 73697 WHERE `RP`.`player` = 73697 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125206,126397,128156,129063,130311,130668,204137,206133,209418,209661,210928,209749,280609,280614,280617,280622,280625,280630,338353,338355,338362,338365,338368,338374,10370808,10370809,10370815,10371774,10398409,10398411,10398418,10398421,10398424,10398430,10440286,10479270,10479276,10479279,10479284,10479287,10479289,10512417,10542157,10542159,10542166,10542169,10542172,10542178,10604894,10604897,10604900,10604903,10604910,10604913,10663071,10663073,10663080,10663083,10663086,10663092,10726150,10726153,10726156,10726159,10726166,10726169,10758419,10758424,10758426,10797038,10797044,10797047,10797052,10797055,10797057,10876724,10876730,10876733,10876738,10876741,10876743,10919689,10919691,10919698,10919701,10919704,10919710,10964605,10964607,10964614,10964617,10964620,10964626,11015136,11015137,11015143,11015147,11015150,11015156,11069366,11069371,11069376,11069377,11069384,11069387,11084872,11122398,11122399,11122405,11122409,11122412,11122418,11170262,11170267,11170272,11170273,11170280,11170283,11214012,11214017,11214022,11214023,11214030,11214033,11229568,11229569,11229575,11266740,11266745,11266750,11266751,11266758,11266761,11323190,11323191,11323197,11323201,11323204,11323210,11337863,11374718,11374719,11374725,11374729,11374732,11374738,11391962,11392932,11392937,11392942,11418281,11418286,11418288,11418294,11418297,11418299,11464351,11464356,11464358,11464364,11464367,11464369,11513730,11513731,11513737,11513741,11513744,11513750,11556664,11556665,11556671,11556675,11556678,11556684,11600416,11600417,11600423,11600427,11600430,11600436,11649338,11649343,11649348,11649349,11649356,11649359,11671270,11671271,11671277,11671281,11671284,11671290,11738953,11738958,11738963,11738964,11738971,11738974,11756952,11786595,11786600,11786605,11786606,11786613,11786616,11836833,11836838,11836843,11836844,11836851,11836854,11868727,11868732,11868737,11868738,11868745,11868748,11923703,11923708,11923713,11923714,11923721,11923724,11963905,11963910,11963915,11963916,11963923,11963926,12004005,12004010,12004015,12004016,12004023,12004026,12021329,12021433,12021438,12021443,12021991,12045139,12045140,12045146,12045150,12045153,12045159,12061905,12061906,12061912,12062555,12084500,12084505,12084507,12084513,12084516,12084518,19971,19976,19978,19984,19987,19989,48076,48077,48083,71444,71445,71451,71455,71458,71464,111554,111559,111564,111565,111572,111575,126197,158216,158217,158223,158227,158230,158236,173649,173654,173656,174566,192487,192492,192494,192500,192503,192505,232591,232596,232598,232604,232607,232609,273212,273213,273219,273223,273226,273232,312290,312291,312297,312301,312304,312310,331796,333254,333259,333264,357050,357051,357057,357061,357064,357070) ) 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, 207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 73697 WHERE `RP`.`player` = 73697 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125206,126397,128156,129063,130311,130668,204137,206133,209418,209661,210928,209749,280609,280614,280617,280622,280625,280630,338353,338355,338362,338365,338368,338374,10370808,10370809,10370815,10371774,10398409,10398411,10398418,10398421,10398424,10398430,10440286,10479270,10479276,10479279,10479284,10479287,10479289,10512417,10542157,10542159,10542166,10542169,10542172,10542178,10604894,10604897,10604900,10604903,10604910,10604913,10663071,10663073,10663080,10663083,10663086,10663092,10726150,10726153,10726156,10726159,10726166,10726169,10758419,10758424,10758426,10797038,10797044,10797047,10797052,10797055,10797057,10876724,10876730,10876733,10876738,10876741,10876743,10919689,10919691,10919698,10919701,10919704,10919710,10964605,10964607,10964614,10964617,10964620,10964626,11015136,11015137,11015143,11015147,11015150,11015156,11069366,11069371,11069376,11069377,11069384,11069387,11084872,11122398,11122399,11122405,11122409,11122412,11122418,11170262,11170267,11170272,11170273,11170280,11170283,11214012,11214017,11214022,11214023,11214030,11214033,11229568,11229569,11229575,11266740,11266745,11266750,11266751,11266758,11266761,11323190,11323191,11323197,11323201,11323204,11323210,11337863,11374718,11374719,11374725,11374729,11374732,11374738,11391962,11392932,11392937,11392942,11418281,11418286,11418288,11418294,11418297,11418299,11464351,11464356,11464358,11464364,11464367,11464369,11513730,11513731,11513737,11513741,11513744,11513750,11556664,11556665,11556671,11556675,11556678,11556684,11600416,11600417,11600423,11600427,11600430,11600436,11649338,11649343,11649348,11649349,11649356,11649359,11671270,11671271,11671277,11671281,11671284,11671290,11738953,11738958,11738963,11738964,11738971,11738974,11756952,11786595,11786600,11786605,11786606,11786613,11786616,11836833,11836838,11836843,11836844,11836851,11836854,11868727,11868732,11868737,11868738,11868745,11868748,11923703,11923708,11923713,11923714,11923721,11923724,11963905,11963910,11963915,11963916,11963923,11963926,12004005,12004010,12004015,12004016,12004023,12004026,12021329,12021433,12021438,12021443,12021991,12045139,12045140,12045146,12045150,12045153,12045159,12061905,12061906,12061912,12062555,12084500,12084505,12084507,12084513,12084516,12084518,19971,19976,19978,19984,19987,19989,48076,48077,48083,71444,71445,71451,71455,71458,71464,111554,111559,111564,111565,111572,111575,126197,158216,158217,158223,158227,158230,158236,173649,173654,173656,174566,192487,192492,192494,192500,192503,192505,232591,232596,232598,232604,232607,232609,273212,273213,273219,273223,273226,273232,312290,312291,312297,312301,312304,312310,331796,333254,333259,333264,357050,357051,357057,357061,357064,357070) ) 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.084 сек (6)
Size=(59209)