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

Менахем Корецки

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыСэйвыОцМин
Официальные матчи сборных50002500237.10367
Национальная сборная50002500237.10367
     Отборочный турнир40002000197.25276
     Финальный турнир100050046.5091
Молодежная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
ТОВЫ сборных3000140065.6791
Всего за сборные80003900296.56458
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыСэйвыОцМин
(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` = 7753 WHERE `RP`.`player` = 7753 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125185,126372,128131,129040,130661,131992,204114,206110,209391,209562,209640,210919,280444,280447,280450,280453,280460,280463,338522,338525,338528,338531,338538,338541,10398386,10398389,10398392,10398395,10398402,10398405,10479368,10479371,10479374,10479377,10479384,10479387,10541942,10541945,10541948,10541951,10541958,10541961,10604822,10604825,10604828,10604831,10604838,10604841,10663096,10663099,10663102,10663105,10663112,10663115,10690370,10726270,10726273,10726276,10726279,10726286,10726289,10797040,10797043,10797046,10797049,10797056,10797059,10876534,10876537,10876540,10876543,10876550,10876553,10919786,10919789,10919792,10919795,10919802,10919805,10936992,10964606,10964609,10964612,10964615,10964622,10964625,11015040,11015041,11015047,11015051,11015054,11015060,11036236,11069343,11069348,11069350,11069356,11069359,11069361,11122325,11122330,11122332,11122338,11122341,11122343,11170384,11170385,11170391,11170395,11170398,11170404,11214158,11214159,11214165,11214169,11214172,11214178,11266790,11266791,11266797,11266801,11266804,11266810,11323164,11323169,11323174,11323175,11323182,11323185,11337866,11374669,11374674,11374676,11374682,11374685,11374687,11418351,11418356,11418359,11418364,11418367,11418372,11464301,11464306,11464309,11464314,11464317,11464322,11513727,11513732,11513735,11513740,11513743,11513748,11530195,11556637,11556642,11556645,11556650,11556653,11556658,11600271,11600276,11600278,11600284,11600287,11600289,11616916,11649267,11649272,11649274,11649280,11649283,11649285,11671389,11671394,11671396,11671402,11671405,11671407,11711125,11738883,11738884,11738890,11738894,11738897,11738903,11786764,11786769,11786771,11786777,11786780,11786782,11836832,11836837,11836840,11836845,11836848,11836853,11868750,11868755,11868758,11868763,11868766,11868771,11895836,11923776,11923781,11923783,11923789,11923792,11923794,11939998,11963738,11963743,11963745,11963751,11963754,11963756,12004127,12004128,12004134,12004138,12004141,12004147,12045113,12045118,12045123,12045124,12045131,12045134,12084524,12084529,12084531,12084537,12084540,12084542,19924,19925,19931,19935,19938,19944,71490,71495,71500,71501,71508,71511,111532,111533,111539,111543,111546,111552,158286,158291,158296,158297,158304,158307,192632,192633,192639,192643,192646,192652,232494,232499,232504,232505,232512,232515,273186,273191,273196,273197,273204,273207,312314,312315,312321,312325,312328,312334,357024,357029,357034,357035,357042,357045) ) 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` = 7753 WHERE `RP`.`player` = 7753 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125185,126372,128131,129040,130661,131992,204114,206110,209391,209562,209640,210919,280444,280447,280450,280453,280460,280463,338522,338525,338528,338531,338538,338541,10398386,10398389,10398392,10398395,10398402,10398405,10479368,10479371,10479374,10479377,10479384,10479387,10541942,10541945,10541948,10541951,10541958,10541961,10604822,10604825,10604828,10604831,10604838,10604841,10663096,10663099,10663102,10663105,10663112,10663115,10690370,10726270,10726273,10726276,10726279,10726286,10726289,10797040,10797043,10797046,10797049,10797056,10797059,10876534,10876537,10876540,10876543,10876550,10876553,10919786,10919789,10919792,10919795,10919802,10919805,10936992,10964606,10964609,10964612,10964615,10964622,10964625,11015040,11015041,11015047,11015051,11015054,11015060,11036236,11069343,11069348,11069350,11069356,11069359,11069361,11122325,11122330,11122332,11122338,11122341,11122343,11170384,11170385,11170391,11170395,11170398,11170404,11214158,11214159,11214165,11214169,11214172,11214178,11266790,11266791,11266797,11266801,11266804,11266810,11323164,11323169,11323174,11323175,11323182,11323185,11337866,11374669,11374674,11374676,11374682,11374685,11374687,11418351,11418356,11418359,11418364,11418367,11418372,11464301,11464306,11464309,11464314,11464317,11464322,11513727,11513732,11513735,11513740,11513743,11513748,11530195,11556637,11556642,11556645,11556650,11556653,11556658,11600271,11600276,11600278,11600284,11600287,11600289,11616916,11649267,11649272,11649274,11649280,11649283,11649285,11671389,11671394,11671396,11671402,11671405,11671407,11711125,11738883,11738884,11738890,11738894,11738897,11738903,11786764,11786769,11786771,11786777,11786780,11786782,11836832,11836837,11836840,11836845,11836848,11836853,11868750,11868755,11868758,11868763,11868766,11868771,11895836,11923776,11923781,11923783,11923789,11923792,11923794,11939998,11963738,11963743,11963745,11963751,11963754,11963756,12004127,12004128,12004134,12004138,12004141,12004147,12045113,12045118,12045123,12045124,12045131,12045134,12084524,12084529,12084531,12084537,12084540,12084542,19924,19925,19931,19935,19938,19944,71490,71495,71500,71501,71508,71511,111532,111533,111539,111543,111546,111552,158286,158291,158296,158297,158304,158307,192632,192633,192639,192643,192646,192652,232494,232499,232504,232505,232512,232515,273186,273191,273196,273197,273204,273207,312314,312315,312321,312325,312328,312334,357024,357029,357034,357035,357042,357045) ) 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.068 сек (2)
Size=(58857)