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

Якуб Шматула

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыСэйвыОцМин
Официальные матчи сборных100270017.000
Национальная сборная100270017.000
     Отборочный турнир100270017.000
     Финальный турнир000000000.000
Молодежная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
ТОВЫ сборных000000000.000
Всего за сборные100270017.000
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыСэйвыОцМин
(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` = 3441 WHERE `RP`.`player` = 3441 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125175,126365,128126,129033,130276,204104,206101,209388,209631,209718,280587,280589,280596,280599,280602,280608,338592,338598,338601,338606,338609,338611,10398480,10398486,10398489,10398494,10398497,10398499,10440287,10479438,10479444,10479447,10479452,10479455,10479457,10542036,10542042,10542045,10542050,10542053,10542055,10567357,10604700,10604706,10604709,10604714,10604717,10604719,10637427,10663046,10663052,10663055,10663060,10663063,10663065,10726149,10726151,10726158,10726161,10726164,10726170,10797087,10797089,10797096,10797099,10797102,10797108,10876652,10876658,10876661,10876666,10876669,10876671,10892856,10919664,10919670,10919673,10919678,10919681,10919683,10936984,10964676,10964682,10964685,10964690,10964693,10964695,11014991,11014996,11014998,11015004,11015007,11015009,11069224,11069225,11069231,11069235,11069238,11069244,11122252,11122257,11122262,11122263,11122270,11122273,11170286,11170291,11170296,11170297,11170304,11170307,11214156,11214161,11214166,11214167,11214174,11214177,11266931,11266936,11266939,11266944,11266947,11266952,11284029,11322971,11322976,11322979,11322984,11322987,11322992,11374595,11374600,11374603,11374608,11374611,11374616,11418327,11418332,11418335,11418340,11418343,11418348,11464493,11464498,11464501,11464506,11464509,11464514,11479155,11513487,11513492,11513495,11513500,11513503,11513508,11556757,11556762,11556765,11556770,11556773,11556778,11600511,11600516,11600518,11600524,11600527,11600529,11616917,11649195,11649200,11649202,11649208,11649211,11649213,11671342,11671343,11671349,11671353,11671356,11671362,11711126,11738979,11738980,11738986,11738990,11738993,11738999,11756957,11786813,11786814,11786820,11786824,11786827,11786833,11805207,11836762,11836767,11836769,11836775,11836778,11836780,11868608,11868613,11868615,11868621,11868624,11868626,11895842,11923752,11923757,11923759,11923765,11923768,11923770,11963931,11963932,11963938,11963942,11963945,11963951,12004055,12004056,12004062,12004066,12004069,12004075,12045258,12045263,12045265,12045271,12045274,12045276,12084498,12084503,12084506,12084511,12084514,12084519,19873,19878,19881,19886,19889,19894,71513,71518,71521,71526,71529,71534,85602,111457,111462,111465,111470,111473,111478,158237,158242,158245,158250,158253,158258,192557,192562,192565,192570,192573,192578,232661,232666,232669,232674,232677,232682,272969,272974,272977,272982,272985,272990,288002,312215,312220,312223,312228,312231,312236,357025,357030,357032,357038,357041,357043) ) 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` = 3441 WHERE `RP`.`player` = 3441 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125175,126365,128126,129033,130276,204104,206101,209388,209631,209718,280587,280589,280596,280599,280602,280608,338592,338598,338601,338606,338609,338611,10398480,10398486,10398489,10398494,10398497,10398499,10440287,10479438,10479444,10479447,10479452,10479455,10479457,10542036,10542042,10542045,10542050,10542053,10542055,10567357,10604700,10604706,10604709,10604714,10604717,10604719,10637427,10663046,10663052,10663055,10663060,10663063,10663065,10726149,10726151,10726158,10726161,10726164,10726170,10797087,10797089,10797096,10797099,10797102,10797108,10876652,10876658,10876661,10876666,10876669,10876671,10892856,10919664,10919670,10919673,10919678,10919681,10919683,10936984,10964676,10964682,10964685,10964690,10964693,10964695,11014991,11014996,11014998,11015004,11015007,11015009,11069224,11069225,11069231,11069235,11069238,11069244,11122252,11122257,11122262,11122263,11122270,11122273,11170286,11170291,11170296,11170297,11170304,11170307,11214156,11214161,11214166,11214167,11214174,11214177,11266931,11266936,11266939,11266944,11266947,11266952,11284029,11322971,11322976,11322979,11322984,11322987,11322992,11374595,11374600,11374603,11374608,11374611,11374616,11418327,11418332,11418335,11418340,11418343,11418348,11464493,11464498,11464501,11464506,11464509,11464514,11479155,11513487,11513492,11513495,11513500,11513503,11513508,11556757,11556762,11556765,11556770,11556773,11556778,11600511,11600516,11600518,11600524,11600527,11600529,11616917,11649195,11649200,11649202,11649208,11649211,11649213,11671342,11671343,11671349,11671353,11671356,11671362,11711126,11738979,11738980,11738986,11738990,11738993,11738999,11756957,11786813,11786814,11786820,11786824,11786827,11786833,11805207,11836762,11836767,11836769,11836775,11836778,11836780,11868608,11868613,11868615,11868621,11868624,11868626,11895842,11923752,11923757,11923759,11923765,11923768,11923770,11963931,11963932,11963938,11963942,11963945,11963951,12004055,12004056,12004062,12004066,12004069,12004075,12045258,12045263,12045265,12045271,12045274,12045276,12084498,12084503,12084506,12084511,12084514,12084519,19873,19878,19881,19886,19889,19894,71513,71518,71521,71526,71529,71534,85602,111457,111462,111465,111470,111473,111478,158237,158242,158245,158250,158253,158258,192557,192562,192565,192570,192573,192578,232661,232666,232669,232674,232677,232682,272969,272974,272977,272982,272985,272990,288002,312215,312220,312223,312228,312231,312236,357025,357030,357032,357038,357041,357043) ) 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.038 сек (4)
Size=(58720)