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

Томаш Фрейлах

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных1901151701072076.6860
Национальная сборная100179770067.4060
     Отборочный турнир100179770067.4060
     Финальный турнир000000000.000
Молодежная сборная900873372015.890
     Отборочный турнир600654251715.750
     Финальный турнир30021912306.170
ТОВЫ сборных263115213148997.26341
Всего за сборные45323038325529167.02401
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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, 140, 207, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 32751 WHERE `RP`.`player` = 32751 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125223,125176,126367,128172,128128,128987,129032,130012,130289,204152,204107,206103,209434,209390,209587,209632,209670,209727,280828,280514,280831,280520,280834,280523,280837,280528,280844,280531,280847,280533,303528,303588,303529,303589,303535,303595,303673,338304,338495,338310,338500,338313,338503,338318,338508,338321,338511,338323,338516,10398260,10398432,10398266,10398438,10398269,10398441,10398274,10398446,10398277,10398449,10398279,10398451,10441248,10441223,10441249,10441228,10441255,10441230,10442089,10478982,10479485,10478988,10479490,10478991,10479493,10478996,10479498,10478999,10479501,10479001,10479506,10512411,10513344,10513345,10513351,10542325,10542107,10542327,10542112,10542334,10542115,10542337,10542120,10542340,10542123,10542346,10542128,10569115,10569120,10569122,10604532,10604796,10604538,10604802,10604541,10604805,10604546,10604810,10604549,10604813,10604551,10604815,10637420,10639501,10639506,10639508,10640814,10640942,10641033,10662879,10663165,10662881,10663170,10662888,10663173,10662891,10663178,10662894,10663181,10662900,10663186,10691359,10691364,10691366,10726387,10726292,10726392,10726298,10726395,10726301,10726400,10726306,10726403,10726309,10726408,10726311,10757388,10757381,10758442,10758480,10758447,10758481,10758452,10758487,10760387,10760871,10761822,10796606,10796965,10796612,10796970,10796615,10796973,10796620,10796978,10796623,10796981,10796625,10796986,10825097,10826255,10826260,10826262,10876459,10876675,10876464,10876680,10876467,10876683,10876472,10876688,10876475,10876691,10876480,10876696,10892860,10919976,10919736,10919982,10919742,10919985,10919745,10919990,10919750,10919993,10919753,10919995,10919755,10937959,10937964,10937966,10939498,10964386,10964580,10964392,10964586,10964395,10964589,10964400,10964594,10964403,10964597,10964405,10964599,10982907,10982912,10982914,11014847,11015087,11014852,11015092,11014854,11015094,11014860,11015100,11014863,11015103,11014865,11015105,11069485,11069368,11069490,11069369,11069493,11069375,11069498,11069379,11069501,11069382,11069506,11069388,11085774,11085775,11085781,11122013,11122253,11122018,11122258,11122020,11122260,11122026,11122266,11122029,11122269,11122031,11122271,11170576,11170239,11170577,11170244,11170583,11170246,11170587,11170252,11170590,11170255,11170596,11170257,11213822,11214038,11213823,11214039,11213829,11214045,11213833,11214049,11213836,11214052,11213842,11214058,11229567,11229572,11229574,11230821,11231878,11232731,11266572,11266837,11266577,11266842,11266582,11266844,11266583,11266850,11266590,11266853,11266593,11266855,11323238,11323116,11323239,11323121,11323245,11323126,11323249,11323127,11323252,11323134,11323258,11323137,11337859,11374958,11374646,11374959,11374647,11374965,11374653,11374969,11374657,11374972,11374660,11374978,11374666,11392934,11392935,11392941,11418713,11418473,11418718,11418478,11418720,11418480,11418726,11418486,11418729,11418489,11418731,11418491,11433521,11434190,11434195,11434200,11464735,11464424,11464740,11464425,11464742,11464431,11464748,11464435,11464751,11464438,11464753,11464444,11481188,11481189,11481195,11513825,11513488,11513830,11513493,11513832,11513498,11513838,11513499,11513841,11513506,11513843,11513509,11556808,11556686,11556809,11556691,11556815,11556696,11556819,11556697,11556822,11556704,11556828,11556707,11600656,11600392,11600657,11600393,11600663,11600399,11600667,11600403,11600670,11600406,11600676,11600412,11649652,11649268,11649653,11649269,11649659,11649275,11649663,11649279,11649666,11649282,11649672,11649288,11671630,11671436,11671631,11671441,11671637,11671446,11671641,11671447,11671644,11671454,11671650,11671457,11712000,11712005,11712007,11739266,11739075,11739271,11739076,11739273,11739082,11739279,11739086,11739282,11739089,11739284,11739095,11756961,11757777,11757828,11757778,11757833,11757784,11757823,11786907,11786741,11786912,11786742,11786917,11786748,11786918,11786752,11786925,11786755,11786928,11786761,11805267,11805268,11805274,11806996,11837099,11837002,11837100,11837007,11837106,11837009,11837110,11837015,11837113,11837018,11837119,11837020,11853394,11853399,11853401,11854422,11854673,11855209,11868993,11868582,11868994,11868587,11869000,11868590,11869004,11868595,11869007,11868598,11869013,11868603,11896688,11896693,11896695,11924135,11923870,11924140,11923875,11924145,11923878,11924146,11923883,11924153,11923886,11924156,11923891,11940011,11940852,11940857,11940860,11942512,11942649,11942743,11964217,11963760,11964222,11963765,11964227,11963768,11964228,11963773,11964235,11963776,11964238,11963781,11980438,11980453,11980454,11980443,11980446,11980460,11981356,12004391,12004076,12004392,12004081,12004398,12004084,12004402,12004089,12004405,12004092,12004411,12004097,12045401,12045208,12045406,12045213,12045411,12045216,12045412,12045221,12045419,12045224,12045422,12045229,12061185,12061965,12061966,12061972,12062542,12062945,12063057,12084618,12084450,12084623,12084455,12084626,12084458,12084631,12084463,12084634,12084466,12084639,12084471,12101121,12101975,12101976,12101982,12102568,20305,19851,20310,19856,20313,19858,20318,19864,20321,19867,20326,19869,47383,48087,48028,48092,48029,48094,48035,48364,48817,49102,71777,71467,71782,71472,71785,71474,71790,71480,71793,71483,71798,71485,85604,111817,111436,111822,111437,111825,111443,111830,111447,111833,111450,111838,111456,126203,127080,127081,127087,158599,158288,158604,158289,158606,158295,158612,158299,158615,158302,158617,158308,192728,192582,192729,192587,192735,192592,192739,192593,192742,192600,192748,192603,232302,232590,232307,232595,232312,232600,232313,232601,232320,232608,232323,232611,248190,248191,248197,273378,273210,273383,273215,273388,273220,273389,273221,273396,273228,273399,273231,312600,312264,312605,312269,312610,312274,312611,312275,312618,312282,312621,312285,331793,333280,333281,333287,333579,334622,335000,357263,356953,357268,356958,357271,356960,357276,356966,357279,356969,357284,356971,372000) ) 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, 140, 207, 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` = 32751 WHERE `RP`.`player` = 32751 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125223,125176,126367,128172,128128,128987,129032,130012,130289,204152,204107,206103,209434,209390,209587,209632,209670,209727,280828,280514,280831,280520,280834,280523,280837,280528,280844,280531,280847,280533,303528,303588,303529,303589,303535,303595,303673,338304,338495,338310,338500,338313,338503,338318,338508,338321,338511,338323,338516,10398260,10398432,10398266,10398438,10398269,10398441,10398274,10398446,10398277,10398449,10398279,10398451,10441248,10441223,10441249,10441228,10441255,10441230,10442089,10478982,10479485,10478988,10479490,10478991,10479493,10478996,10479498,10478999,10479501,10479001,10479506,10512411,10513344,10513345,10513351,10542325,10542107,10542327,10542112,10542334,10542115,10542337,10542120,10542340,10542123,10542346,10542128,10569115,10569120,10569122,10604532,10604796,10604538,10604802,10604541,10604805,10604546,10604810,10604549,10604813,10604551,10604815,10637420,10639501,10639506,10639508,10640814,10640942,10641033,10662879,10663165,10662881,10663170,10662888,10663173,10662891,10663178,10662894,10663181,10662900,10663186,10691359,10691364,10691366,10726387,10726292,10726392,10726298,10726395,10726301,10726400,10726306,10726403,10726309,10726408,10726311,10757388,10757381,10758442,10758480,10758447,10758481,10758452,10758487,10760387,10760871,10761822,10796606,10796965,10796612,10796970,10796615,10796973,10796620,10796978,10796623,10796981,10796625,10796986,10825097,10826255,10826260,10826262,10876459,10876675,10876464,10876680,10876467,10876683,10876472,10876688,10876475,10876691,10876480,10876696,10892860,10919976,10919736,10919982,10919742,10919985,10919745,10919990,10919750,10919993,10919753,10919995,10919755,10937959,10937964,10937966,10939498,10964386,10964580,10964392,10964586,10964395,10964589,10964400,10964594,10964403,10964597,10964405,10964599,10982907,10982912,10982914,11014847,11015087,11014852,11015092,11014854,11015094,11014860,11015100,11014863,11015103,11014865,11015105,11069485,11069368,11069490,11069369,11069493,11069375,11069498,11069379,11069501,11069382,11069506,11069388,11085774,11085775,11085781,11122013,11122253,11122018,11122258,11122020,11122260,11122026,11122266,11122029,11122269,11122031,11122271,11170576,11170239,11170577,11170244,11170583,11170246,11170587,11170252,11170590,11170255,11170596,11170257,11213822,11214038,11213823,11214039,11213829,11214045,11213833,11214049,11213836,11214052,11213842,11214058,11229567,11229572,11229574,11230821,11231878,11232731,11266572,11266837,11266577,11266842,11266582,11266844,11266583,11266850,11266590,11266853,11266593,11266855,11323238,11323116,11323239,11323121,11323245,11323126,11323249,11323127,11323252,11323134,11323258,11323137,11337859,11374958,11374646,11374959,11374647,11374965,11374653,11374969,11374657,11374972,11374660,11374978,11374666,11392934,11392935,11392941,11418713,11418473,11418718,11418478,11418720,11418480,11418726,11418486,11418729,11418489,11418731,11418491,11433521,11434190,11434195,11434200,11464735,11464424,11464740,11464425,11464742,11464431,11464748,11464435,11464751,11464438,11464753,11464444,11481188,11481189,11481195,11513825,11513488,11513830,11513493,11513832,11513498,11513838,11513499,11513841,11513506,11513843,11513509,11556808,11556686,11556809,11556691,11556815,11556696,11556819,11556697,11556822,11556704,11556828,11556707,11600656,11600392,11600657,11600393,11600663,11600399,11600667,11600403,11600670,11600406,11600676,11600412,11649652,11649268,11649653,11649269,11649659,11649275,11649663,11649279,11649666,11649282,11649672,11649288,11671630,11671436,11671631,11671441,11671637,11671446,11671641,11671447,11671644,11671454,11671650,11671457,11712000,11712005,11712007,11739266,11739075,11739271,11739076,11739273,11739082,11739279,11739086,11739282,11739089,11739284,11739095,11756961,11757777,11757828,11757778,11757833,11757784,11757823,11786907,11786741,11786912,11786742,11786917,11786748,11786918,11786752,11786925,11786755,11786928,11786761,11805267,11805268,11805274,11806996,11837099,11837002,11837100,11837007,11837106,11837009,11837110,11837015,11837113,11837018,11837119,11837020,11853394,11853399,11853401,11854422,11854673,11855209,11868993,11868582,11868994,11868587,11869000,11868590,11869004,11868595,11869007,11868598,11869013,11868603,11896688,11896693,11896695,11924135,11923870,11924140,11923875,11924145,11923878,11924146,11923883,11924153,11923886,11924156,11923891,11940011,11940852,11940857,11940860,11942512,11942649,11942743,11964217,11963760,11964222,11963765,11964227,11963768,11964228,11963773,11964235,11963776,11964238,11963781,11980438,11980453,11980454,11980443,11980446,11980460,11981356,12004391,12004076,12004392,12004081,12004398,12004084,12004402,12004089,12004405,12004092,12004411,12004097,12045401,12045208,12045406,12045213,12045411,12045216,12045412,12045221,12045419,12045224,12045422,12045229,12061185,12061965,12061966,12061972,12062542,12062945,12063057,12084618,12084450,12084623,12084455,12084626,12084458,12084631,12084463,12084634,12084466,12084639,12084471,12101121,12101975,12101976,12101982,12102568,20305,19851,20310,19856,20313,19858,20318,19864,20321,19867,20326,19869,47383,48087,48028,48092,48029,48094,48035,48364,48817,49102,71777,71467,71782,71472,71785,71474,71790,71480,71793,71483,71798,71485,85604,111817,111436,111822,111437,111825,111443,111830,111447,111833,111450,111838,111456,126203,127080,127081,127087,158599,158288,158604,158289,158606,158295,158612,158299,158615,158302,158617,158308,192728,192582,192729,192587,192735,192592,192739,192593,192742,192600,192748,192603,232302,232590,232307,232595,232312,232600,232313,232601,232320,232608,232323,232611,248190,248191,248197,273378,273210,273383,273215,273388,273220,273389,273221,273396,273228,273399,273231,312600,312264,312605,312269,312610,312274,312611,312275,312618,312282,312621,312285,331793,333280,333281,333287,333579,334622,335000,357263,356953,357268,356958,357271,356960,357276,356966,357279,356969,357284,356971,372000) ) 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.073 сек (3)
Size=(66222)