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

Джон Маккенна

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных11004714512226.77422
Национальная сборная500197301616.60422
     Отборочный турнир500197301616.60422
     Финальный турнир000000000.000
Молодежная сборная60028721616.920
     Отборочный турнир30017371407.000
     Финальный турнир30011350216.830
ТОВЫ сборных9002810601506.5691
Всего за сборные20007525113726.67513
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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` = 35857 WHERE `RP`.`player` = 35857 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125191,126378,128137,129046,130291,204120,206116,209397,209646,209729,280443,280445,280452,280455,280458,280464,338593,338595,338602,338605,338608,338614,10398578,10398581,10398584,10398587,10398594,10398597,10479320,10479323,10479326,10479329,10479336,10479339,10512415,10541941,10541943,10541950,10541953,10541956,10541962,10604750,10604753,10604756,10604759,10604766,10604769,10637428,10639512,10639517,10639522,10640818,10640940,10641036,10663047,10663049,10663056,10663059,10663062,10663068,10726269,10726271,10726278,10726281,10726284,10726290,10797015,10797017,10797024,10797027,10797030,10797036,10876677,10876679,10876686,10876689,10876692,10876698,10919545,10919547,10919554,10919557,10919560,10919566,10964582,10964585,10964588,10964591,10964598,10964601,10981489,11015016,11015017,11015023,11015027,11015030,11015036,11036229,11038316,11038321,11038326,11038801,11038881,11038977,11069464,11069465,11069471,11069475,11069478,11069484,11122374,11122375,11122381,11122385,11122388,11122394,11170430,11170435,11170440,11170441,11170448,11170451,11186272,11186600,11186605,11186610,11188244,11188361,11188466,11214014,11214015,11214021,11214025,11214028,11214034,11266886,11266887,11266893,11266897,11266900,11266906,11323068,11323073,11323078,11323079,11323086,11323089,11374644,11374649,11374654,11374655,11374662,11374665,11418306,11418307,11418313,11418317,11418320,11418326,11433505,11464304,11464305,11464311,11464315,11464318,11464324,11479157,11513634,11513635,11513641,11513645,11513648,11513654,11556592,11556593,11556599,11556603,11556606,11556612,11600390,11600395,11600400,11600401,11600408,11600411,11649146,11649151,11649156,11649157,11649164,11649167,11666267,11667084,11667089,11667094,11667358,11668032,11668167,11671269,11671274,11671276,11671282,11671285,11671287,11711938,11711943,11711946,11739024,11739029,11739032,11739037,11739040,11739045,11757774,11757779,11757782,11786666,11786671,11786674,11786679,11786682,11786687,11805266,11805271,11805273,11836880,11836885,11836888,11836893,11836896,11836901,11852597,11853417,11853422,11853427,11854424,11854672,11855207,11868774,11868779,11868782,11868787,11868790,11868795,11923702,11923707,11923710,11923715,11923718,11923723,11940007,11963786,11963791,11963793,11963799,11963802,11963804,11980320,11980403,11980408,11980413,12003982,12003987,12003989,12003995,12003998,12004000,12045354,12045359,12045361,12045367,12045370,12045372,12061904,12061909,12061911,12084330,12084335,12084338,12084343,12084346,12084351,12101902,12101907,12101909,12102550,19849,19854,19857,19862,19865,19870,47379,71417,71422,71425,71430,71433,71438,85600,86408,86413,86418,111435,111440,111442,111448,111451,111453,127019,127024,127026,158141,158146,158149,158154,158157,158162,172817,173650,173651,173657,174569,192701,192706,192709,192714,192717,192722,210098,210900,210905,210910,232589,232594,232597,232602,232605,232610,247345,248128,248133,248138,249065,249210,249764,273185,273190,273193,273198,273201,273206,287999,288814,288819,288824,289784,290022,290579,312191,312196,312199,312204,312207,312212,356951,356956,356959,356964,356967,356972,372795,372800,372803,373737) ) 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` = 35857 WHERE `RP`.`player` = 35857 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125191,126378,128137,129046,130291,204120,206116,209397,209646,209729,280443,280445,280452,280455,280458,280464,338593,338595,338602,338605,338608,338614,10398578,10398581,10398584,10398587,10398594,10398597,10479320,10479323,10479326,10479329,10479336,10479339,10512415,10541941,10541943,10541950,10541953,10541956,10541962,10604750,10604753,10604756,10604759,10604766,10604769,10637428,10639512,10639517,10639522,10640818,10640940,10641036,10663047,10663049,10663056,10663059,10663062,10663068,10726269,10726271,10726278,10726281,10726284,10726290,10797015,10797017,10797024,10797027,10797030,10797036,10876677,10876679,10876686,10876689,10876692,10876698,10919545,10919547,10919554,10919557,10919560,10919566,10964582,10964585,10964588,10964591,10964598,10964601,10981489,11015016,11015017,11015023,11015027,11015030,11015036,11036229,11038316,11038321,11038326,11038801,11038881,11038977,11069464,11069465,11069471,11069475,11069478,11069484,11122374,11122375,11122381,11122385,11122388,11122394,11170430,11170435,11170440,11170441,11170448,11170451,11186272,11186600,11186605,11186610,11188244,11188361,11188466,11214014,11214015,11214021,11214025,11214028,11214034,11266886,11266887,11266893,11266897,11266900,11266906,11323068,11323073,11323078,11323079,11323086,11323089,11374644,11374649,11374654,11374655,11374662,11374665,11418306,11418307,11418313,11418317,11418320,11418326,11433505,11464304,11464305,11464311,11464315,11464318,11464324,11479157,11513634,11513635,11513641,11513645,11513648,11513654,11556592,11556593,11556599,11556603,11556606,11556612,11600390,11600395,11600400,11600401,11600408,11600411,11649146,11649151,11649156,11649157,11649164,11649167,11666267,11667084,11667089,11667094,11667358,11668032,11668167,11671269,11671274,11671276,11671282,11671285,11671287,11711938,11711943,11711946,11739024,11739029,11739032,11739037,11739040,11739045,11757774,11757779,11757782,11786666,11786671,11786674,11786679,11786682,11786687,11805266,11805271,11805273,11836880,11836885,11836888,11836893,11836896,11836901,11852597,11853417,11853422,11853427,11854424,11854672,11855207,11868774,11868779,11868782,11868787,11868790,11868795,11923702,11923707,11923710,11923715,11923718,11923723,11940007,11963786,11963791,11963793,11963799,11963802,11963804,11980320,11980403,11980408,11980413,12003982,12003987,12003989,12003995,12003998,12004000,12045354,12045359,12045361,12045367,12045370,12045372,12061904,12061909,12061911,12084330,12084335,12084338,12084343,12084346,12084351,12101902,12101907,12101909,12102550,19849,19854,19857,19862,19865,19870,47379,71417,71422,71425,71430,71433,71438,85600,86408,86413,86418,111435,111440,111442,111448,111451,111453,127019,127024,127026,158141,158146,158149,158154,158157,158162,172817,173650,173651,173657,174569,192701,192706,192709,192714,192717,192722,210098,210900,210905,210910,232589,232594,232597,232602,232605,232610,247345,248128,248133,248138,249065,249210,249764,273185,273190,273193,273198,273201,273206,287999,288814,288819,288824,289784,290022,290579,312191,312196,312199,312204,312207,312212,356951,356956,356959,356964,356967,356972,372795,372800,372803,373737) ) 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.081 сек (3)
Size=(60543)