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

Ристо Дориев

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

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