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

Игор Марайцески

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
Официальные матчи сборных30062301306.170
Национальная сборная30062301306.170
     Отборочный турнир30062301306.170
     Финальный турнир000000000.000
Молодежная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
ТОВЫ сборных400122802107.380
Всего за сборные700185103406.860
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыУдарыОцМин
(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, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 16865 WHERE `RP`.`player` = 16865 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125162,126351,128112,129019,130266,204093,206087,209374,209617,209708,280683,280685,280692,280695,280698,280704,338521,338523,338530,338533,338536,338542,10398602,10398605,10398608,10398611,10398618,10398621,10440282,10441270,10441275,10441280,10442088,10479294,10479300,10479303,10479308,10479311,10479313,10513319,10513324,10513326,10542012,10542018,10542021,10542026,10542029,10542031,10567355,10604699,10604704,10604707,10604712,10604715,10604720,10639487,10639492,10639495,10663070,10663076,10663079,10663084,10663087,10663089,10690365,10726364,10726370,10726373,10726378,10726381,10726383,10758441,10758446,10758449,10760384,10760873,10761821,10796917,10796922,10796925,10796930,10796933,10796938,10876747,10876752,10876755,10876760,10876763,10876768,10893697,10893702,10893705,10919663,10919668,10919671,10919676,10919679,10919684,10937995,10938000,10938002,10964627,10964632,10964635,10964640,10964643,10964648,10981483,11014989,11014994,11014997,11015002,11015005,11015010,11038327,11038332,11038335,11038802,11069413,11069418,11069421,11069426,11069429,11069434,11122251,11122256,11122259,11122264,11122267,11122272,11140251,11140256,11140258,11141177,11170285,11170290,11170293,11170298,11170301,11170306,11186274,11186612,11186617,11186622,11188241,11188362,11188468,11214227,11214232,11214235,11214240,11214243,11214248,11229601,11229606,11229609,11266955,11266960,11266963,11266968,11266971,11266976,11286163,11286168,11286171,11323163,11323168,11323171,11323176,11323179,11323184,11339761,11339766,11339769,11340349,11340453,11341831,11374763,11374768,11374771,11374776,11374779,11374784,11392943,11392948,11392951,11394286,11394688,11394857,11418399,11418404,11418407,11418412,11418415,11418420,11464421,11464426,11464429,11464434,11464437,11464442,11513561,11513566,11513568,11513574,11513577,11513579,11531541,11531546,11531548,11556567,11556572,11556574,11556580,11556583,11556585,11573275,11600487,11600492,11600494,11600500,11600503,11600505,11616913,11618472,11618477,11618482,11619489,11620215,11620369,11649289,11649294,11649297,11649302,11649305,11649310,11671221,11671226,11671228,11671234,11671237,11671239,11711128,11711963,11711968,11711973,11739027,11739028,11739034,11739038,11739041,11739047,11756954,11786836,11786841,11786843,11786849,11786852,11786854,11836810,11836815,11836817,11836823,11836826,11836828,11868753,11868754,11868760,11868764,11868767,11868773,11923824,11923829,11923831,11923837,11923840,11923842,11940004,11963978,11963983,11963985,11963991,11963994,11963996,11980316,11980427,11980432,11980437,11981355,12003910,12003915,12003917,12003923,12003926,12003928,12021410,12021415,12021417,12021993,12045210,12045215,12045217,12045223,12045226,12045228,12061174,12061927,12061932,12061937,12062550,12084332,12084337,12084339,12084345,12084348,12084350,20067,20072,20074,20080,20083,20085,71492,71493,71499,71503,71506,71512,111627,111632,111634,111640,111643,111645,126192,158239,158244,158246,158252,158255,158257,172822,192655,192660,192662,192668,192671,192673,232616,232617,232623,232627,232630,232636,273115,273120,273122,273128,273131,273133,312410,312411,312417,312421,312424,312430,357146,357147,357153,357157,357160,357166) ) 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, 207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 16865 WHERE `RP`.`player` = 16865 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125162,126351,128112,129019,130266,204093,206087,209374,209617,209708,280683,280685,280692,280695,280698,280704,338521,338523,338530,338533,338536,338542,10398602,10398605,10398608,10398611,10398618,10398621,10440282,10441270,10441275,10441280,10442088,10479294,10479300,10479303,10479308,10479311,10479313,10513319,10513324,10513326,10542012,10542018,10542021,10542026,10542029,10542031,10567355,10604699,10604704,10604707,10604712,10604715,10604720,10639487,10639492,10639495,10663070,10663076,10663079,10663084,10663087,10663089,10690365,10726364,10726370,10726373,10726378,10726381,10726383,10758441,10758446,10758449,10760384,10760873,10761821,10796917,10796922,10796925,10796930,10796933,10796938,10876747,10876752,10876755,10876760,10876763,10876768,10893697,10893702,10893705,10919663,10919668,10919671,10919676,10919679,10919684,10937995,10938000,10938002,10964627,10964632,10964635,10964640,10964643,10964648,10981483,11014989,11014994,11014997,11015002,11015005,11015010,11038327,11038332,11038335,11038802,11069413,11069418,11069421,11069426,11069429,11069434,11122251,11122256,11122259,11122264,11122267,11122272,11140251,11140256,11140258,11141177,11170285,11170290,11170293,11170298,11170301,11170306,11186274,11186612,11186617,11186622,11188241,11188362,11188468,11214227,11214232,11214235,11214240,11214243,11214248,11229601,11229606,11229609,11266955,11266960,11266963,11266968,11266971,11266976,11286163,11286168,11286171,11323163,11323168,11323171,11323176,11323179,11323184,11339761,11339766,11339769,11340349,11340453,11341831,11374763,11374768,11374771,11374776,11374779,11374784,11392943,11392948,11392951,11394286,11394688,11394857,11418399,11418404,11418407,11418412,11418415,11418420,11464421,11464426,11464429,11464434,11464437,11464442,11513561,11513566,11513568,11513574,11513577,11513579,11531541,11531546,11531548,11556567,11556572,11556574,11556580,11556583,11556585,11573275,11600487,11600492,11600494,11600500,11600503,11600505,11616913,11618472,11618477,11618482,11619489,11620215,11620369,11649289,11649294,11649297,11649302,11649305,11649310,11671221,11671226,11671228,11671234,11671237,11671239,11711128,11711963,11711968,11711973,11739027,11739028,11739034,11739038,11739041,11739047,11756954,11786836,11786841,11786843,11786849,11786852,11786854,11836810,11836815,11836817,11836823,11836826,11836828,11868753,11868754,11868760,11868764,11868767,11868773,11923824,11923829,11923831,11923837,11923840,11923842,11940004,11963978,11963983,11963985,11963991,11963994,11963996,11980316,11980427,11980432,11980437,11981355,12003910,12003915,12003917,12003923,12003926,12003928,12021410,12021415,12021417,12021993,12045210,12045215,12045217,12045223,12045226,12045228,12061174,12061927,12061932,12061937,12062550,12084332,12084337,12084339,12084345,12084348,12084350,20067,20072,20074,20080,20083,20085,71492,71493,71499,71503,71506,71512,111627,111632,111634,111640,111643,111645,126192,158239,158244,158246,158252,158255,158257,172822,192655,192660,192662,192668,192671,192673,232616,232617,232623,232627,232630,232636,273115,273120,273122,273128,273131,273133,312410,312411,312417,312421,312424,312430,357146,357147,357153,357157,357160,357166) ) 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.048 сек (2)
Size=(59881)