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

Мате Шинко

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

НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыСэйвыОцМин
Официальные матчи сборных120009300517.711093
Национальная сборная000000000.000
     Отборочный турнир000000000.000
     Финальный турнир000000000.000
Молодежная сборная120009300517.711093
     Отборочный турнир60005500287.92546
     Финальный турнир60003800237.50547
ТОВЫ сборных90005700497.44821
Всего за сборные21000150001007.601914
НоминацияМатчиГолыГолевые передачиОтборыПередачиДриблингПерехватыСэйвыОцМин
(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` = 84792 WHERE `RP`.`player` = 84792 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125213,126310,128163,128981,130020,204142,206048,209423,209581,209678,280923,280925,280932,280935,280938,280944,301753,338281,338283,338290,338293,338296,338302,10398285,10398287,10398294,10398297,10398300,10398306,10479127,10479129,10479136,10479139,10479142,10479148,10512401,10542206,10542209,10542212,10542215,10542222,10542225,10604605,10604607,10604614,10604617,10604620,10604626,10662808,10662811,10662814,10662817,10662824,10662827,10726630,10726633,10726636,10726639,10726646,10726649,10796704,10796707,10796710,10796713,10796720,10796723,10876294,10876297,10876300,10876303,10876310,10876313,10920050,10920053,10920056,10920059,10920066,10920069,10964172,10964175,10964178,10964181,10964188,10964191,11014774,11014779,11014784,11014785,11014792,11014795,11069510,11069515,11069520,11069521,11069528,11069531,11122132,11122137,11122142,11122143,11122150,11122153,11170718,11170723,11170728,11170729,11170736,11170739,11213796,11213801,11213806,11213807,11213814,11213817,11229112,11266502,11266503,11266509,11266513,11266516,11266522,11284044,11323213,11323218,11323220,11323226,11323229,11323231,11374933,11374938,11374940,11374946,11374949,11374951,11418737,11418742,11418744,11418750,11418753,11418755,11464615,11464620,11464622,11464628,11464631,11464633,11479171,11513897,11513902,11513904,11513910,11513913,11513915,11556927,11556932,11556934,11556940,11556943,11556945,11600581,11600586,11600589,11600594,11600597,11600602,11649577,11649582,11649585,11649590,11649593,11649598,11671531,11671536,11671539,11671544,11671547,11671552,11739336,11739341,11739344,11739349,11739352,11739357,11756959,11787026,11787031,11787034,11787039,11787042,11787047,11837120,11837125,11837128,11837133,11837136,11837141,11868870,11868875,11868878,11868883,11868886,11868891,11895851,11924136,11924141,11924143,11924149,11924152,11924154,11964075,11964076,11964082,11964086,11964089,11964095,12004196,12004201,12004204,12004209,12004212,12004217,12045474,12045479,12045481,12045487,12045490,12045492,12084836,12084841,12084843,12084849,12084852,12084854,20284,20285,20291,20295,20298,20304,71636,71637,71643,71647,71650,71656,85612,111771,111776,111778,111784,111787,111789,158455,158460,158462,158468,158471,158473,192967,192972,192974,192980,192983,192985,210110,232303,232308,232310,232316,232319,232321,273403,273408,273410,273416,273419,273421,312626,312627,312633,312637,312640,312646,331811,357410,357411,357417,357421,357424,357430) ) 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` = 84792 WHERE `RP`.`player` = 84792 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125213,126310,128163,128981,130020,204142,206048,209423,209581,209678,280923,280925,280932,280935,280938,280944,301753,338281,338283,338290,338293,338296,338302,10398285,10398287,10398294,10398297,10398300,10398306,10479127,10479129,10479136,10479139,10479142,10479148,10512401,10542206,10542209,10542212,10542215,10542222,10542225,10604605,10604607,10604614,10604617,10604620,10604626,10662808,10662811,10662814,10662817,10662824,10662827,10726630,10726633,10726636,10726639,10726646,10726649,10796704,10796707,10796710,10796713,10796720,10796723,10876294,10876297,10876300,10876303,10876310,10876313,10920050,10920053,10920056,10920059,10920066,10920069,10964172,10964175,10964178,10964181,10964188,10964191,11014774,11014779,11014784,11014785,11014792,11014795,11069510,11069515,11069520,11069521,11069528,11069531,11122132,11122137,11122142,11122143,11122150,11122153,11170718,11170723,11170728,11170729,11170736,11170739,11213796,11213801,11213806,11213807,11213814,11213817,11229112,11266502,11266503,11266509,11266513,11266516,11266522,11284044,11323213,11323218,11323220,11323226,11323229,11323231,11374933,11374938,11374940,11374946,11374949,11374951,11418737,11418742,11418744,11418750,11418753,11418755,11464615,11464620,11464622,11464628,11464631,11464633,11479171,11513897,11513902,11513904,11513910,11513913,11513915,11556927,11556932,11556934,11556940,11556943,11556945,11600581,11600586,11600589,11600594,11600597,11600602,11649577,11649582,11649585,11649590,11649593,11649598,11671531,11671536,11671539,11671544,11671547,11671552,11739336,11739341,11739344,11739349,11739352,11739357,11756959,11787026,11787031,11787034,11787039,11787042,11787047,11837120,11837125,11837128,11837133,11837136,11837141,11868870,11868875,11868878,11868883,11868886,11868891,11895851,11924136,11924141,11924143,11924149,11924152,11924154,11964075,11964076,11964082,11964086,11964089,11964095,12004196,12004201,12004204,12004209,12004212,12004217,12045474,12045479,12045481,12045487,12045490,12045492,12084836,12084841,12084843,12084849,12084852,12084854,20284,20285,20291,20295,20298,20304,71636,71637,71643,71647,71650,71656,85612,111771,111776,111778,111784,111787,111789,158455,158460,158462,158468,158471,158473,192967,192972,192974,192980,192983,192985,210110,232303,232308,232310,232316,232319,232321,273403,273408,273410,273416,273419,273421,312626,312627,312633,312637,312640,312646,331811,357410,357411,357417,357421,357424,357430) ) 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.061 сек (4)
Size=(58471)