Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин | Официальные матчи сборных | 14 | 0 | 0 | 0 | 77 | 0 | 0 | 73 | 7.18 | 1281 |
Национальная сборная | 3 | 0 | 0 | 0 | 24 | 0 | 0 | 26 | 8.00 | 279 |
Отборочный турнир | 1 | 0 | 0 | 0 | 4 | 0 | 0 | 5 | 8.50 | 93 |
Финальный турнир | 2 | 0 | 0 | 0 | 20 | 0 | 0 | 21 | 7.75 | 186 |
Молодежная сборная | 11 | 0 | 0 | 0 | 53 | 0 | 0 | 47 | 6.95 | 1002 |
Отборочный турнир | 8 | 0 | 0 | 0 | 39 | 0 | 0 | 35 | 7.19 | 729 |
Финальный турнир | 3 | 0 | 0 | 0 | 14 | 0 | 0 | 12 | 6.33 | 273 |
ТОВЫ сборных | 15 | 0 | 0 | 0 | 79 | 0 | 0 | 71 | 7.47 | 1373 |
Всего за сборные | 29 | 0 | 0 | 0 | 156 | 0 | 0 | 144 | 7.33 | 2654 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Сэйвы | Оц | Мин |
(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, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 44832 WHERE `RP`.`player` = 44832 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125225,126327,128176,128995,130022,204156,206063,209438,209593,209680,280969,280974,280977,280982,280985,280990,301747,303550,303555,303560,303674,304767,305252,338183,338188,338191,338196,338199,338204,10370721,10370726,10370729,10371764,10398307,10398312,10398315,10398320,10398323,10398328,10479126,10479132,10479135,10479140,10479143,10479145,10513367,10513372,10513374,10514098,10514365,10514497,10542371,10542376,10542379,10542384,10542387,10542392,10569137,10569142,10569145,10570044,10570146,10570552,10604531,10604536,10604539,10604544,10604547,10604552,10639535,10639540,10639543,10662757,10662762,10662765,10662770,10662773,10662778,10726459,10726464,10726467,10726472,10726475,10726480,10757384,10758454,10758459,10758464,10760398,10796797,10796802,10796805,10796810,10796813,10796818,10876461,10876463,10876470,10876473,10876476,10876482,10893772,10893773,10893779,10893987,10894519,10895373,10919856,10919862,10919865,10919870,10919873,10919875,10936979,10964314,10964320,10964323,10964328,10964331,10964333,11014704,11014705,11014711,11014715,11014718,11014724,11069728,11069729,11069735,11069739,11069742,11069748,11084888,11085712,11085717,11085722,11122206,11122207,11122213,11122217,11122220,11122226,11140276,11140277,11140283,11141167,11170597,11170602,11170605,11170610,11170613,11170618,11213894,11213895,11213901,11213905,11213908,11213914,11266598,11266599,11266605,11266609,11266612,11266618,11323214,11323215,11323221,11323225,11323228,11323234,11374908,11374913,11374918,11374919,11374926,11374929,11392994,11392995,11393001,11394297,11418570,11418571,11418577,11418581,11418584,11418590,11464686,11464691,11464696,11464697,11464704,11464707,11479174,11513826,11513827,11513833,11513837,11513840,11513846,11556976,11556977,11556983,11556987,11556990,11556996,11574790,11574791,11574797,11600631,11600636,11600638,11600644,11600647,11600649,11649484,11649485,11649491,11649495,11649498,11649504,11666274,11671653,11671658,11671660,11671666,11671669,11671671,11739267,11739268,11739274,11739278,11739281,11739287,11787077,11787078,11787084,11787088,11787091,11787097,11837051,11837052,11837058,11837062,11837065,11837071,11853443,11853444,11853450,11854413,11854680,11855212,11868920,11868925,11868927,11868933,11868936,11868938,11895850,11896711,11896716,11896721,11923990,11923995,11923998,11924003,11924006,11924011,11964000,11964005,11964008,11964013,11964016,11964021,12004389,12004394,12004399,12004400,12004407,12004410,12045617,12045622,12045627,12045628,12045635,12045638,12061977,12061978,12061984,12062543,12084620,12084625,12084627,12084633,12084636,12084638,12101936,12101941,12101944,12102558,12103525,12103700,20281,20286,20289,20294,20297,20302,47384,71681,71686,71689,71694,71697,71702,85609,86480,86485,86490,87293,111769,111774,111777,111782,111785,111790,127077,127082,127085,128624,128773,128859,158405,158410,158413,158418,158421,158426,172824,192869,192874,192877,192882,192885,192890,210109,210960,210965,210970,232373,232378,232381,232386,232389,232394,247352,273427,273432,273434,273440,273443,273445,288849,288854,288857,312695,312700,312703,312708,312711,312716,331810,333266,333271,333276,357433,357438,357440,357446,357449,357451) ) 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, 208) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 44832 WHERE `RP`.`player` = 44832 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125225,126327,128176,128995,130022,204156,206063,209438,209593,209680,280969,280974,280977,280982,280985,280990,301747,303550,303555,303560,303674,304767,305252,338183,338188,338191,338196,338199,338204,10370721,10370726,10370729,10371764,10398307,10398312,10398315,10398320,10398323,10398328,10479126,10479132,10479135,10479140,10479143,10479145,10513367,10513372,10513374,10514098,10514365,10514497,10542371,10542376,10542379,10542384,10542387,10542392,10569137,10569142,10569145,10570044,10570146,10570552,10604531,10604536,10604539,10604544,10604547,10604552,10639535,10639540,10639543,10662757,10662762,10662765,10662770,10662773,10662778,10726459,10726464,10726467,10726472,10726475,10726480,10757384,10758454,10758459,10758464,10760398,10796797,10796802,10796805,10796810,10796813,10796818,10876461,10876463,10876470,10876473,10876476,10876482,10893772,10893773,10893779,10893987,10894519,10895373,10919856,10919862,10919865,10919870,10919873,10919875,10936979,10964314,10964320,10964323,10964328,10964331,10964333,11014704,11014705,11014711,11014715,11014718,11014724,11069728,11069729,11069735,11069739,11069742,11069748,11084888,11085712,11085717,11085722,11122206,11122207,11122213,11122217,11122220,11122226,11140276,11140277,11140283,11141167,11170597,11170602,11170605,11170610,11170613,11170618,11213894,11213895,11213901,11213905,11213908,11213914,11266598,11266599,11266605,11266609,11266612,11266618,11323214,11323215,11323221,11323225,11323228,11323234,11374908,11374913,11374918,11374919,11374926,11374929,11392994,11392995,11393001,11394297,11418570,11418571,11418577,11418581,11418584,11418590,11464686,11464691,11464696,11464697,11464704,11464707,11479174,11513826,11513827,11513833,11513837,11513840,11513846,11556976,11556977,11556983,11556987,11556990,11556996,11574790,11574791,11574797,11600631,11600636,11600638,11600644,11600647,11600649,11649484,11649485,11649491,11649495,11649498,11649504,11666274,11671653,11671658,11671660,11671666,11671669,11671671,11739267,11739268,11739274,11739278,11739281,11739287,11787077,11787078,11787084,11787088,11787091,11787097,11837051,11837052,11837058,11837062,11837065,11837071,11853443,11853444,11853450,11854413,11854680,11855212,11868920,11868925,11868927,11868933,11868936,11868938,11895850,11896711,11896716,11896721,11923990,11923995,11923998,11924003,11924006,11924011,11964000,11964005,11964008,11964013,11964016,11964021,12004389,12004394,12004399,12004400,12004407,12004410,12045617,12045622,12045627,12045628,12045635,12045638,12061977,12061978,12061984,12062543,12084620,12084625,12084627,12084633,12084636,12084638,12101936,12101941,12101944,12102558,12103525,12103700,20281,20286,20289,20294,20297,20302,47384,71681,71686,71689,71694,71697,71702,85609,86480,86485,86490,87293,111769,111774,111777,111782,111785,111790,127077,127082,127085,128624,128773,128859,158405,158410,158413,158418,158421,158426,172824,192869,192874,192877,192882,192885,192890,210109,210960,210965,210970,232373,232378,232381,232386,232389,232394,247352,273427,273432,273434,273440,273443,273445,288849,288854,288857,312695,312700,312703,312708,312711,312716,331810,333266,333271,333276,357433,357438,357440,357446,357449,357451) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: