49 сезон
Межсезонье
Вход в систему
Вход через VK
ПБ-ВИКИ

Эрик Смит

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных1000346306.0092
Национальная сборная1000346306.0092
     Отборочный турнир1000346306.0092
     Финальный турнир000000000.000
Молодежная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
ТОВЫ сборных000000000.000
Всего за сборные1000346306.0092
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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` = 61133 WHERE `RP`.`player` = 61133 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` = 61133 WHERE `RP`.`player` = 61133 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.075 сек (2)
Size=(58684)