Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 9 | 0 | 0 | 34 | 86 | 1 | 12 | 0 | 6.89 | 550 |
Национальная сборная | 2 | 0 | 0 | 13 | 38 | 0 | 5 | 0 | 6.50 | 186 |
Отборочный турнир | 2 | 0 | 0 | 13 | 38 | 0 | 5 | 0 | 6.50 | 186 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 7 | 0 | 0 | 21 | 48 | 1 | 7 | 0 | 7.00 | 364 |
Отборочный турнир | 5 | 0 | 0 | 13 | 34 | 0 | 6 | 0 | 6.90 | 268 |
Финальный турнир | 2 | 0 | 0 | 8 | 14 | 1 | 1 | 0 | 7.25 | 96 |
ТОВЫ сборных | 4 | 0 | 0 | 30 | 62 | 1 | 8 | 0 | 6.12 | 367 |
Всего за сборные | 13 | 0 | 0 | 64 | 148 | 2 | 20 | 0 | 6.65 | 917 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 76550 WHERE `RP`.`player` = 76550 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125215,126314,128161,128980,130017,204144,206052,209421,209582,209673,280947,280949,280956,280959,280962,280968,338329,338331,338338,338341,338344,338350,10369069,10398332,10398338,10398341,10398346,10398349,10398351,10479005,10479010,10479013,10479018,10479021,10479026,10512406,10542276,10542282,10542285,10542290,10542293,10542295,10604604,10604610,10604613,10604618,10604621,10604623,10662877,10662882,10662885,10662890,10662893,10662898,10726532,10726538,10726541,10726546,10726549,10726551,10796774,10796780,10796783,10796788,10796791,10796793,10825106,10876316,10876322,10876325,10876330,10876333,10876335,10919904,10919910,10919913,10919918,10919921,10919923,10964194,10964200,10964203,10964208,10964211,10964213,11014871,11014876,11014878,11014884,11014887,11014889,11069680,11069681,11069687,11069691,11069694,11069700,11084880,11121966,11121967,11121973,11121977,11121980,11121986,11170720,11170721,11170727,11170731,11170734,11170740,11213750,11213751,11213757,11213761,11213764,11213770,11229111,11266478,11266479,11266485,11266489,11266492,11266498,11284042,11323333,11323338,11323340,11323346,11323349,11323351,11337850,11374814,11374815,11374821,11374825,11374828,11374834,11418568,11418573,11418578,11418579,11418586,11418589,11433516,11464590,11464595,11464600,11464601,11464608,11464611,11513944,11513949,11513954,11513955,11513962,11513965,11556926,11556931,11556936,11556937,11556944,11556947,11600630,11600635,11600640,11600641,11600648,11600651,11616927,11649604,11649605,11649611,11649615,11649618,11649624,11666275,11671654,11671655,11671661,11671665,11671668,11671674,11711136,11739243,11739244,11739250,11739254,11739257,11739263,11756966,11786861,11786862,11786868,11786872,11786875,11786881,11805222,11837171,11837172,11837178,11837182,11837185,11837191,11869038,11869043,11869046,11869051,11869054,11869059,11924184,11924189,11924191,11924197,11924200,11924202,11940016,11964027,11964028,11964034,11964038,11964041,11964047,11980325,12004268,12004273,12004276,12004281,12004284,12004289,12045498,12045503,12045505,12045511,12045514,12045516,12084738,12084743,12084746,12084751,12084754,12084759,20329,20334,20337,20342,20345,20350,71705,71710,71713,71718,71721,71726,111673,111678,111681,111686,111689,111694,126201,158501,158506,158509,158514,158517,158522,172832,192941,192946,192949,192954,192957,192962,232256,232257,232263,232267,232270,232276,273475,273480,273482,273488,273491,273493,288012,312599,312604,312607,312612,312615,312620,357337,357342,357344,357350,357353,357355) ) 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` = 76550 WHERE `RP`.`player` = 76550 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125215,126314,128161,128980,130017,204144,206052,209421,209582,209673,280947,280949,280956,280959,280962,280968,338329,338331,338338,338341,338344,338350,10369069,10398332,10398338,10398341,10398346,10398349,10398351,10479005,10479010,10479013,10479018,10479021,10479026,10512406,10542276,10542282,10542285,10542290,10542293,10542295,10604604,10604610,10604613,10604618,10604621,10604623,10662877,10662882,10662885,10662890,10662893,10662898,10726532,10726538,10726541,10726546,10726549,10726551,10796774,10796780,10796783,10796788,10796791,10796793,10825106,10876316,10876322,10876325,10876330,10876333,10876335,10919904,10919910,10919913,10919918,10919921,10919923,10964194,10964200,10964203,10964208,10964211,10964213,11014871,11014876,11014878,11014884,11014887,11014889,11069680,11069681,11069687,11069691,11069694,11069700,11084880,11121966,11121967,11121973,11121977,11121980,11121986,11170720,11170721,11170727,11170731,11170734,11170740,11213750,11213751,11213757,11213761,11213764,11213770,11229111,11266478,11266479,11266485,11266489,11266492,11266498,11284042,11323333,11323338,11323340,11323346,11323349,11323351,11337850,11374814,11374815,11374821,11374825,11374828,11374834,11418568,11418573,11418578,11418579,11418586,11418589,11433516,11464590,11464595,11464600,11464601,11464608,11464611,11513944,11513949,11513954,11513955,11513962,11513965,11556926,11556931,11556936,11556937,11556944,11556947,11600630,11600635,11600640,11600641,11600648,11600651,11616927,11649604,11649605,11649611,11649615,11649618,11649624,11666275,11671654,11671655,11671661,11671665,11671668,11671674,11711136,11739243,11739244,11739250,11739254,11739257,11739263,11756966,11786861,11786862,11786868,11786872,11786875,11786881,11805222,11837171,11837172,11837178,11837182,11837185,11837191,11869038,11869043,11869046,11869051,11869054,11869059,11924184,11924189,11924191,11924197,11924200,11924202,11940016,11964027,11964028,11964034,11964038,11964041,11964047,11980325,12004268,12004273,12004276,12004281,12004284,12004289,12045498,12045503,12045505,12045511,12045514,12045516,12084738,12084743,12084746,12084751,12084754,12084759,20329,20334,20337,20342,20345,20350,71705,71710,71713,71718,71721,71726,111673,111678,111681,111686,111689,111694,126201,158501,158506,158509,158514,158517,158522,172832,192941,192946,192949,192954,192957,192962,232256,232257,232263,232267,232270,232276,273475,273480,273482,273488,273491,273493,288012,312599,312604,312607,312612,312615,312620,357337,357342,357344,357350,357353,357355) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: