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

Каролис Рокас

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных70015499705.790
Национальная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
Молодежная сборная70015499705.790
     Отборочный турнир70015499705.790
     Финальный турнир000000000.000
ТОВЫ сборных60055591606.080
Всего за сборные130020104182305.920
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 3939 WHERE `RP`.`player` = 3939 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125214,126312,128165,128976,130021,204145,206050,209425,209578,209677,280731,280733,280740,280743,280746,280752,338138,338141,338144,338147,338154,338157,10398214,10398217,10398220,10398223,10398230,10398233,10479176,10479179,10479182,10479185,10479192,10479195,10512399,10542421,10542423,10542430,10542433,10542436,10542442,10567346,10604461,10604463,10604470,10604473,10604476,10604482,10662783,10662785,10662792,10662795,10662798,10662804,10726509,10726511,10726518,10726521,10726524,10726530,10796799,10796801,10796808,10796811,10796814,10796820,10876485,10876487,10876494,10876497,10876500,10876506,10919951,10919956,10919959,10919964,10919967,10919972,10936975,10964169,10964174,10964177,10964182,10964185,10964190,11014823,11014828,11014830,11014836,11014839,11014841,11069512,11069513,11069519,11069523,11069526,11069532,11084885,11121987,11121992,11121995,11122000,11122003,11122008,11170479,11170484,11170486,11170492,11170495,11170497,11213726,11213727,11213733,11213737,11213740,11213746,11266716,11266721,11266726,11266727,11266734,11266737,11323356,11323361,11323366,11323367,11323374,11323377,11374955,11374960,11374963,11374968,11374971,11374976,11418783,11418788,11418791,11418796,11418799,11418804,11464805,11464810,11464813,11464818,11464821,11464826,11513919,11513924,11513927,11513932,11513935,11513940,11530209,11557021,11557026,11557029,11557034,11557037,11557042,11573287,11600583,11600588,11600590,11600596,11600599,11600601,11649531,11649536,11649538,11649544,11649547,11649549,11666269,11671486,11671487,11671493,11671497,11671500,11671506,11739313,11739318,11739323,11739324,11739331,11739334,11786955,11786960,11786965,11786966,11786973,11786976,11837097,11837102,11837107,11837108,11837115,11837118,11868871,11868876,11868881,11868882,11868889,11868892,11924137,11924138,11924144,11924148,11924151,11924157,11964192,11964197,11964200,11964205,11964208,11964213,12004294,12004299,12004301,12004307,12004310,12004312,12021336,12045522,12045527,12045529,12045535,12045538,12045540,12084741,12084742,12084748,12084752,12084755,12084761,12101119,20308,20309,20315,20319,20322,20328,71658,71663,71668,71669,71676,71679,111746,111751,111756,111757,111764,111767,158360,158361,158367,158371,158374,158380,192893,192898,192901,192906,192909,192914,232207,232212,232214,232220,232223,232225,247358,273307,273312,273314,273320,273323,273325,312529,312534,312536,312542,312545,312547,357290,357291,357297,357301,357304,357310) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 3939 WHERE `RP`.`player` = 3939 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125214,126312,128165,128976,130021,204145,206050,209425,209578,209677,280731,280733,280740,280743,280746,280752,338138,338141,338144,338147,338154,338157,10398214,10398217,10398220,10398223,10398230,10398233,10479176,10479179,10479182,10479185,10479192,10479195,10512399,10542421,10542423,10542430,10542433,10542436,10542442,10567346,10604461,10604463,10604470,10604473,10604476,10604482,10662783,10662785,10662792,10662795,10662798,10662804,10726509,10726511,10726518,10726521,10726524,10726530,10796799,10796801,10796808,10796811,10796814,10796820,10876485,10876487,10876494,10876497,10876500,10876506,10919951,10919956,10919959,10919964,10919967,10919972,10936975,10964169,10964174,10964177,10964182,10964185,10964190,11014823,11014828,11014830,11014836,11014839,11014841,11069512,11069513,11069519,11069523,11069526,11069532,11084885,11121987,11121992,11121995,11122000,11122003,11122008,11170479,11170484,11170486,11170492,11170495,11170497,11213726,11213727,11213733,11213737,11213740,11213746,11266716,11266721,11266726,11266727,11266734,11266737,11323356,11323361,11323366,11323367,11323374,11323377,11374955,11374960,11374963,11374968,11374971,11374976,11418783,11418788,11418791,11418796,11418799,11418804,11464805,11464810,11464813,11464818,11464821,11464826,11513919,11513924,11513927,11513932,11513935,11513940,11530209,11557021,11557026,11557029,11557034,11557037,11557042,11573287,11600583,11600588,11600590,11600596,11600599,11600601,11649531,11649536,11649538,11649544,11649547,11649549,11666269,11671486,11671487,11671493,11671497,11671500,11671506,11739313,11739318,11739323,11739324,11739331,11739334,11786955,11786960,11786965,11786966,11786973,11786976,11837097,11837102,11837107,11837108,11837115,11837118,11868871,11868876,11868881,11868882,11868889,11868892,11924137,11924138,11924144,11924148,11924151,11924157,11964192,11964197,11964200,11964205,11964208,11964213,12004294,12004299,12004301,12004307,12004310,12004312,12021336,12045522,12045527,12045529,12045535,12045538,12045540,12084741,12084742,12084748,12084752,12084755,12084761,12101119,20308,20309,20315,20319,20322,20328,71658,71663,71668,71669,71676,71679,111746,111751,111756,111757,111764,111767,158360,158361,158367,158371,158374,158380,192893,192898,192901,192906,192909,192914,232207,232212,232214,232220,232223,232225,247358,273307,273312,273314,273320,273323,273325,312529,312534,312536,312542,312545,312547,357290,357291,357297,357301,357304,357310) ) 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.076 сек (12)
Size=(58857)