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

Томаш Иванчик

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных1232131591187.12148
Национальная сборная1032030561167.20148
     Отборочный турнир921027501147.0091
     Финальный турнир111036029.0057
Молодежная сборная200113026.750
     Отборочный турнир100013028.500
     Финальный турнир100100005.000
ТОВЫ сборных1464730465186.5475
Всего за сборные26968611056366.81223
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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` = 9290 WHERE `RP`.`player` = 9290 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125239,126336,128189,129009,130038,204170,206074,209449,209607,209696,280804,280807,280810,280813,280820,280823,338258,338261,338264,338267,338274,338277,10398118,10398121,10398124,10398127,10398134,10398137,10479008,10479011,10479014,10479017,10479024,10479027,10542278,10542281,10542284,10542287,10542294,10542297,10604582,10604585,10604588,10604591,10604598,10604601,10637415,10639536,10639541,10639546,10662735,10662737,10662744,10662747,10662750,10662756,10691372,10691373,10691379,10692377,10692490,10693164,10726556,10726562,10726565,10726570,10726573,10726575,10796679,10796681,10796688,10796691,10796694,10796700,10825114,10826242,10826247,10826252,10826546,10826633,10827309,10876315,10876320,10876323,10876328,10876331,10876336,10893747,10893752,10893754,10893985,10920048,10920054,10920057,10920062,10920065,10920067,10964363,10964365,10964372,10964375,10964378,10964384,11014800,11014801,11014807,11014811,11014814,11014820,11038294,11038295,11038301,11069511,11069516,11069518,11069524,11069527,11069529,11122038,11122039,11122045,11122049,11122052,11122058,11139740,11170503,11170508,11170510,11170516,11170519,11170521,11186268,11186660,11186665,11186670,11213869,11213874,11213876,11213882,11213885,11213887,11229114,11229614,11229619,11229624,11230836,11266499,11266504,11266507,11266512,11266515,11266520,11323286,11323287,11323293,11323297,11323300,11323306,11337854,11374838,11374839,11374845,11374849,11374852,11374858,11418736,11418741,11418746,11418747,11418754,11418757,11434204,11434205,11434211,11464640,11464641,11464647,11464651,11464654,11464660,11513753,11513758,11513760,11513766,11513769,11513771,11556951,11556956,11556958,11556964,11556967,11556969,11600702,11600707,11600712,11600713,11600720,11600723,11649554,11649559,11649564,11649565,11649572,11649575,11671604,11671609,11671614,11671615,11671622,11671625,11711135,11739169,11739174,11739179,11739180,11739187,11739190,11756963,11757840,11757845,11757835,11786981,11786982,11786988,11786992,11786995,11787001,11837193,11837198,11837203,11837204,11837211,11837214,11868873,11868874,11868880,11868884,11868887,11868893,11923967,11923972,11923977,11923978,11923985,11923988,11940013,11964171,11964172,11964178,11964182,11964185,11964191,11980450,11980455,11980458,12004388,12004393,12004396,12004401,12004404,12004409,12021458,12021463,12021465,12045378,12045383,12045385,12045391,12045394,12045396,12061952,12061957,12061959,12062545,12062944,12063059,12084642,12084647,12084650,12084655,12084658,12084663,20164,20165,20171,20175,20178,20184,71754,71759,71764,71765,71772,71775,111698,111703,111708,111709,111716,111719,158550,158555,158560,158561,158568,158571,192750,192755,192760,192761,192768,192771,232280,232281,232287,232291,232294,232300,273428,273429,273435,273439,273442,273448,288016,288850,288855,288860,289798,312457,312462,312464,312470,312473,312475,357242,357243,357249,357253,357256,357262,372001) ) 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` = 9290 WHERE `RP`.`player` = 9290 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125239,126336,128189,129009,130038,204170,206074,209449,209607,209696,280804,280807,280810,280813,280820,280823,338258,338261,338264,338267,338274,338277,10398118,10398121,10398124,10398127,10398134,10398137,10479008,10479011,10479014,10479017,10479024,10479027,10542278,10542281,10542284,10542287,10542294,10542297,10604582,10604585,10604588,10604591,10604598,10604601,10637415,10639536,10639541,10639546,10662735,10662737,10662744,10662747,10662750,10662756,10691372,10691373,10691379,10692377,10692490,10693164,10726556,10726562,10726565,10726570,10726573,10726575,10796679,10796681,10796688,10796691,10796694,10796700,10825114,10826242,10826247,10826252,10826546,10826633,10827309,10876315,10876320,10876323,10876328,10876331,10876336,10893747,10893752,10893754,10893985,10920048,10920054,10920057,10920062,10920065,10920067,10964363,10964365,10964372,10964375,10964378,10964384,11014800,11014801,11014807,11014811,11014814,11014820,11038294,11038295,11038301,11069511,11069516,11069518,11069524,11069527,11069529,11122038,11122039,11122045,11122049,11122052,11122058,11139740,11170503,11170508,11170510,11170516,11170519,11170521,11186268,11186660,11186665,11186670,11213869,11213874,11213876,11213882,11213885,11213887,11229114,11229614,11229619,11229624,11230836,11266499,11266504,11266507,11266512,11266515,11266520,11323286,11323287,11323293,11323297,11323300,11323306,11337854,11374838,11374839,11374845,11374849,11374852,11374858,11418736,11418741,11418746,11418747,11418754,11418757,11434204,11434205,11434211,11464640,11464641,11464647,11464651,11464654,11464660,11513753,11513758,11513760,11513766,11513769,11513771,11556951,11556956,11556958,11556964,11556967,11556969,11600702,11600707,11600712,11600713,11600720,11600723,11649554,11649559,11649564,11649565,11649572,11649575,11671604,11671609,11671614,11671615,11671622,11671625,11711135,11739169,11739174,11739179,11739180,11739187,11739190,11756963,11757840,11757845,11757835,11786981,11786982,11786988,11786992,11786995,11787001,11837193,11837198,11837203,11837204,11837211,11837214,11868873,11868874,11868880,11868884,11868887,11868893,11923967,11923972,11923977,11923978,11923985,11923988,11940013,11964171,11964172,11964178,11964182,11964185,11964191,11980450,11980455,11980458,12004388,12004393,12004396,12004401,12004404,12004409,12021458,12021463,12021465,12045378,12045383,12045385,12045391,12045394,12045396,12061952,12061957,12061959,12062545,12062944,12063059,12084642,12084647,12084650,12084655,12084658,12084663,20164,20165,20171,20175,20178,20184,71754,71759,71764,71765,71772,71775,111698,111703,111708,111709,111716,111719,158550,158555,158560,158561,158568,158571,192750,192755,192760,192761,192768,192771,232280,232281,232287,232291,232294,232300,273428,273429,273435,273439,273442,273448,288016,288850,288855,288860,289798,312457,312462,312464,312470,312473,312475,357242,357243,357249,357253,357256,357262,372001) ) 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.058 сек (3)
Size=(60134)