Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 3 | 0 | 0 | 0 | 1 | 8 | 0 | 3 | 6.17 | 95 |
Национальная сборная | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Отборочный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 3 | 0 | 0 | 0 | 1 | 8 | 0 | 3 | 6.17 | 95 |
Отборочный турнир | 3 | 0 | 0 | 0 | 1 | 8 | 0 | 3 | 6.17 | 95 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 4 | 1 | 0 | 0 | 2 | 6 | 0 | 9 | 6.00 | 217 |
Всего за сборные | 7 | 1 | 0 | 0 | 3 | 14 | 0 | 12 | 6.07 | 312 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 50003 WHERE `RP`.`player` = 50003 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125221,126320,128170,130013,204150,206058,209432,209669,246915,246920,246922,280897,280902,280905,280910,280913,280918,303585,303590,303593,303670,338280,338286,338289,338294,338297,338299,10369061,10370724,10370725,10370731,10398187,10398192,10398195,10398200,10398203,10398208,10440278,10479198,10479204,10479207,10479212,10479215,10479217,10513343,10513348,10513350,10514096,10514366,10514495,10542275,10542280,10542283,10542288,10542291,10542296,10567348,10569150,10569155,10569160,10570045,10604507,10604512,10604515,10604520,10604523,10604528,10662925,10662930,10662933,10662938,10662941,10662946,10726413,10726415,10726422,10726425,10726428,10726434,10757385,10758478,10758483,10758488,10760391,10760869,10761817,10796749,10796754,10796757,10796762,10796765,10796770,10826253,10826258,10826261,10876483,10876488,10876491,10876496,10876499,10876504,10919927,10919932,10919935,10919940,10919943,10919948,10936977,10937958,10937963,10937968,10964217,10964222,10964225,10964230,10964233,10964238,11014821,11014826,11014829,11014834,11014837,11014842,11069727,11069732,11069734,11069740,11069743,11069745,11085737,11085742,11085744,11087187,11087487,11087616,11122035,11122040,11122043,11122048,11122051,11122056,11170552,11170553,11170559,11170563,11170566,11170572,11186267,11213965,11213970,11213972,11213978,11213981,11213983,11229116,11266717,11266722,11266724,11266730,11266733,11266735,11323382,11323383,11323389,11323393,11323396,11323402,11337857,11374909,11374914,11374916,11374922,11374925,11374927,11418544,11418549,11418554,11418555,11418562,11418565,11464712,11464713,11464719,11464723,11464726,11464732,11479173,11481234,11481239,11481244,11481640,11513801,11513806,11513808,11513814,11513817,11513819,11530205,11556853,11556858,11556861,11556866,11556869,11556874,11574777,11574782,11574784,11600535,11600540,11600542,11600548,11600551,11600553,11618521,11618526,11618528,11649433,11649438,11649441,11649446,11649449,11649454,11667133,11667138,11667140,11667366,11671483,11671488,11671491,11671496,11671499,11671504,11739264,11739269,11739272,11739277,11739280,11739285,11757851,11757854,11757846,11786906,11786911,11786914,11786919,11786922,11786927,11805214,11805289,11805294,11805299,11806986,11837170,11837175,11837177,11837183,11837186,11837188,11868848,11868853,11868855,11868861,11868864,11868866,11923945,11923946,11923952,11923956,11923959,11923965,11940891,11940892,11940898,11964002,11964007,11964009,11964015,11964018,11964020,11980464,11980469,11980471,12004342,12004347,12004349,12004355,12004358,12004360,12021338,12021493,12021498,12021503,12021999,12045376,12045381,12045384,12045389,12045392,12045397,12061190,12084834,12084839,12084842,12084847,12084850,12084855,12101938,12101943,12101945,20211,20216,20218,20224,20227,20229,71684,71685,71691,71695,71698,71704,111820,111821,111827,111831,111834,111840,158600,158601,158607,158611,158614,158620,172831,192895,192900,192902,192908,192911,192913,210961,210966,210968,212515,212676,212766,232445,232450,232453,232458,232461,232466,248201,248206,248208,273329,273334,273337,273342,273345,273350,288010,312481,312486,312488,312494,312497,312499,357385,357390,357392,357398,357401,357403) ) 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` = 50003 WHERE `RP`.`player` = 50003 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125221,126320,128170,130013,204150,206058,209432,209669,246915,246920,246922,280897,280902,280905,280910,280913,280918,303585,303590,303593,303670,338280,338286,338289,338294,338297,338299,10369061,10370724,10370725,10370731,10398187,10398192,10398195,10398200,10398203,10398208,10440278,10479198,10479204,10479207,10479212,10479215,10479217,10513343,10513348,10513350,10514096,10514366,10514495,10542275,10542280,10542283,10542288,10542291,10542296,10567348,10569150,10569155,10569160,10570045,10604507,10604512,10604515,10604520,10604523,10604528,10662925,10662930,10662933,10662938,10662941,10662946,10726413,10726415,10726422,10726425,10726428,10726434,10757385,10758478,10758483,10758488,10760391,10760869,10761817,10796749,10796754,10796757,10796762,10796765,10796770,10826253,10826258,10826261,10876483,10876488,10876491,10876496,10876499,10876504,10919927,10919932,10919935,10919940,10919943,10919948,10936977,10937958,10937963,10937968,10964217,10964222,10964225,10964230,10964233,10964238,11014821,11014826,11014829,11014834,11014837,11014842,11069727,11069732,11069734,11069740,11069743,11069745,11085737,11085742,11085744,11087187,11087487,11087616,11122035,11122040,11122043,11122048,11122051,11122056,11170552,11170553,11170559,11170563,11170566,11170572,11186267,11213965,11213970,11213972,11213978,11213981,11213983,11229116,11266717,11266722,11266724,11266730,11266733,11266735,11323382,11323383,11323389,11323393,11323396,11323402,11337857,11374909,11374914,11374916,11374922,11374925,11374927,11418544,11418549,11418554,11418555,11418562,11418565,11464712,11464713,11464719,11464723,11464726,11464732,11479173,11481234,11481239,11481244,11481640,11513801,11513806,11513808,11513814,11513817,11513819,11530205,11556853,11556858,11556861,11556866,11556869,11556874,11574777,11574782,11574784,11600535,11600540,11600542,11600548,11600551,11600553,11618521,11618526,11618528,11649433,11649438,11649441,11649446,11649449,11649454,11667133,11667138,11667140,11667366,11671483,11671488,11671491,11671496,11671499,11671504,11739264,11739269,11739272,11739277,11739280,11739285,11757851,11757854,11757846,11786906,11786911,11786914,11786919,11786922,11786927,11805214,11805289,11805294,11805299,11806986,11837170,11837175,11837177,11837183,11837186,11837188,11868848,11868853,11868855,11868861,11868864,11868866,11923945,11923946,11923952,11923956,11923959,11923965,11940891,11940892,11940898,11964002,11964007,11964009,11964015,11964018,11964020,11980464,11980469,11980471,12004342,12004347,12004349,12004355,12004358,12004360,12021338,12021493,12021498,12021503,12021999,12045376,12045381,12045384,12045389,12045392,12045397,12061190,12084834,12084839,12084842,12084847,12084850,12084855,12101938,12101943,12101945,20211,20216,20218,20224,20227,20229,71684,71685,71691,71695,71698,71704,111820,111821,111827,111831,111834,111840,158600,158601,158607,158611,158614,158620,172831,192895,192900,192902,192908,192911,192913,210961,210966,210968,212515,212676,212766,232445,232450,232453,232458,232461,232466,248201,248206,248208,273329,273334,273337,273342,273345,273350,288010,312481,312486,312488,312494,312497,312499,357385,357390,357392,357398,357401,357403) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: