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

Мирче Натков

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных5002912751207.30396
Национальная сборная1003271607.0065
     Отборочный турнир000000000.000
     Финальный турнир1003271607.0065
Молодежная сборная400261004607.38331
     Отборочный турнир400261004607.38331
     Финальный турнир000000000.000
ТОВЫ сборных11006020843407.36968
Всего за сборные16008933594607.341364
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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` = 65439 WHERE `RP`.`player` = 65439 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125210,126311,128160,128977,130018,204141,206047,209422,209577,209676,280730,280736,280739,280744,280747,280749,303561,303566,303569,303668,338087,338092,338095,338100,338103,338108,10369066,10398115,10398120,10398123,10398128,10398131,10398136,10441185,10441190,10441193,10479053,10479058,10479061,10479066,10479069,10479074,10513365,10513370,10513373,10514101,10542227,10542232,10542235,10542240,10542243,10542248,10604483,10604488,10604491,10604496,10604499,10604504,10662733,10662738,10662741,10662746,10662749,10662754,10690379,10726508,10726514,10726517,10726522,10726525,10726527,10757383,10796750,10796756,10796759,10796764,10796767,10796769,10876317,10876319,10876326,10876329,10876332,10876338,10892861,10893746,10893751,10893756,10893992,10894517,10895374,10920047,10920052,10920055,10920060,10920063,10920068,10937933,10937938,10937941,10964409,10964414,10964417,10964422,10964425,10964430,10981499,11014773,11014778,11014781,11014786,11014789,11014794,11038291,11038296,11038299,11069509,11069514,11069517,11069522,11069525,11069530,11085701,11085706,11085708,11121989,11121994,11121996,11122002,11122005,11122007,11140273,11140278,11140281,11170717,11170722,11170725,11170730,11170733,11170738,11213845,11213850,11213852,11213858,11213861,11213863,11266621,11266626,11266628,11266634,11266637,11266639,11284043,11323453,11323458,11323460,11323466,11323469,11323471,11337855,11375005,11375010,11375012,11375018,11375021,11375023,11418688,11418693,11418698,11418699,11418706,11418709,11464782,11464787,11464792,11464793,11464800,11464803,11513754,11513755,11513761,11513765,11513768,11513774,11530208,11531600,11531605,11531610,11556975,11556980,11556982,11556988,11556991,11556993,11600703,11600708,11600710,11600716,11600719,11600721,11616923,11649412,11649413,11649419,11649423,11649426,11649432,11671510,11671511,11671517,11671521,11671524,11671530,11739291,11739292,11739298,11739302,11739305,11739311,11786933,11786934,11786940,11786944,11786947,11786953,11805291,11805292,11805298,11837195,11837196,11837202,11837206,11837209,11837215,11868897,11868898,11868904,11868908,11868911,11868917,11895848,11896735,11896740,11896745,11924134,11924139,11924142,11924147,11924150,11924155,11964170,11964175,11964177,11964183,11964186,11964188,12004174,12004179,12004181,12004187,12004190,12004192,12045425,12045430,12045435,12045436,12045443,12045446,12084691,12084696,12084701,12084702,12084709,12084712,12101116,20188,20189,20195,20199,20202,20208,71682,71687,71692,71693,71700,71703,111722,111727,111732,111733,111740,111743,126207,127078,127083,127088,158456,158457,158463,158467,158470,158476,192752,192753,192759,192763,192766,192772,232352,232353,232359,232363,232366,232372,248178,248179,248185,273308,273309,273315,273319,273322,273328,288009,288886,288891,288896,312577,312582,312584,312590,312593,312595,331805,357362,357363,357369,357373,357376,357382) ) 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` = 65439 WHERE `RP`.`player` = 65439 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125210,126311,128160,128977,130018,204141,206047,209422,209577,209676,280730,280736,280739,280744,280747,280749,303561,303566,303569,303668,338087,338092,338095,338100,338103,338108,10369066,10398115,10398120,10398123,10398128,10398131,10398136,10441185,10441190,10441193,10479053,10479058,10479061,10479066,10479069,10479074,10513365,10513370,10513373,10514101,10542227,10542232,10542235,10542240,10542243,10542248,10604483,10604488,10604491,10604496,10604499,10604504,10662733,10662738,10662741,10662746,10662749,10662754,10690379,10726508,10726514,10726517,10726522,10726525,10726527,10757383,10796750,10796756,10796759,10796764,10796767,10796769,10876317,10876319,10876326,10876329,10876332,10876338,10892861,10893746,10893751,10893756,10893992,10894517,10895374,10920047,10920052,10920055,10920060,10920063,10920068,10937933,10937938,10937941,10964409,10964414,10964417,10964422,10964425,10964430,10981499,11014773,11014778,11014781,11014786,11014789,11014794,11038291,11038296,11038299,11069509,11069514,11069517,11069522,11069525,11069530,11085701,11085706,11085708,11121989,11121994,11121996,11122002,11122005,11122007,11140273,11140278,11140281,11170717,11170722,11170725,11170730,11170733,11170738,11213845,11213850,11213852,11213858,11213861,11213863,11266621,11266626,11266628,11266634,11266637,11266639,11284043,11323453,11323458,11323460,11323466,11323469,11323471,11337855,11375005,11375010,11375012,11375018,11375021,11375023,11418688,11418693,11418698,11418699,11418706,11418709,11464782,11464787,11464792,11464793,11464800,11464803,11513754,11513755,11513761,11513765,11513768,11513774,11530208,11531600,11531605,11531610,11556975,11556980,11556982,11556988,11556991,11556993,11600703,11600708,11600710,11600716,11600719,11600721,11616923,11649412,11649413,11649419,11649423,11649426,11649432,11671510,11671511,11671517,11671521,11671524,11671530,11739291,11739292,11739298,11739302,11739305,11739311,11786933,11786934,11786940,11786944,11786947,11786953,11805291,11805292,11805298,11837195,11837196,11837202,11837206,11837209,11837215,11868897,11868898,11868904,11868908,11868911,11868917,11895848,11896735,11896740,11896745,11924134,11924139,11924142,11924147,11924150,11924155,11964170,11964175,11964177,11964183,11964186,11964188,12004174,12004179,12004181,12004187,12004190,12004192,12045425,12045430,12045435,12045436,12045443,12045446,12084691,12084696,12084701,12084702,12084709,12084712,12101116,20188,20189,20195,20199,20202,20208,71682,71687,71692,71693,71700,71703,111722,111727,111732,111733,111740,111743,126207,127078,127083,127088,158456,158457,158463,158467,158470,158476,192752,192753,192759,192763,192766,192772,232352,232353,232359,232363,232366,232372,248178,248179,248185,273308,273309,273315,273319,273322,273328,288009,288886,288891,288896,312577,312582,312584,312590,312593,312595,331805,357362,357363,357369,357373,357376,357382) ) 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.114 сек (4)
Size=(59547)