Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 27 | 0 | 1 | 82 | 520 | 17 | 104 | 3 | 6.74 | 0 |
Национальная сборная | 13 | 0 | 1 | 36 | 264 | 3 | 68 | 0 | 6.69 | 0 |
Отборочный турнир | 11 | 0 | 1 | 35 | 230 | 3 | 63 | 0 | 6.36 | 0 |
Финальный турнир | 2 | 0 | 0 | 1 | 34 | 0 | 5 | 0 | 8.50 | 0 |
Молодежная сборная | 14 | 0 | 0 | 46 | 256 | 14 | 36 | 3 | 6.79 | 0 |
Отборочный турнир | 14 | 0 | 0 | 46 | 256 | 14 | 36 | 3 | 6.79 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 35 | 1 | 1 | 89 | 620 | 47 | 157 | 3 | 7.10 | 0 |
Всего за сборные | 62 | 1 | 2 | 171 | 1140 | 64 | 261 | 6 | 6.95 | 0 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 7858 WHERE `RP`.`player` = 7858 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125189,126374,128139,129047,130294,204118,206112,209399,209645,209734,246866,246871,246876,250351,250962,251094,280489,280494,280497,280502,280505,280510,303537,303542,303545,303662,304765,305271,338519,338524,338527,338532,338535,338540,10369079,10398551,10398556,10398559,10398564,10398567,10398572,10479366,10479372,10479375,10479380,10479383,10479385,10512410,10513282,10513287,10513292,10514094,10541940,10541946,10541949,10541954,10541957,10541959,10569187,10569192,10569194,10604748,10604754,10604757,10604762,10604765,10604767,10639525,10639530,10639532,10663094,10663100,10663103,10663108,10663111,10663113,10726148,10726154,10726157,10726162,10726165,10726167,10757378,10758430,10758435,10758440,10796846,10796852,10796855,10796860,10796863,10796865,10876748,10876754,10876757,10876762,10876765,10876767,10892858,10919712,10919718,10919721,10919726,10919729,10919731,10964653,10964655,10964662,10964665,10964668,10964674,11015182,11015187,11015192,11015193,11015200,11015203,11069416,11069417,11069423,11069427,11069430,11069436,11085747,11085752,11085755,11122229,11122234,11122236,11122242,11122245,11122247,11139724,11140226,11140231,11140236,11141175,11141802,11141971,11170429,11170434,11170437,11170442,11170445,11170450,11186638,11186639,11186645,11188243,11214035,11214040,11214043,11214048,11214051,11214056,11229100,11229604,11229605,11229611,11266813,11266818,11266820,11266826,11266829,11266831,11286141,11286146,11286148,11323139,11323144,11323147,11323152,11323155,11323160,11339739,11339744,11339746,11374645,11374650,11374652,11374658,11374661,11374663,11391961,11418521,11418526,11418528,11418534,11418537,11418539,11464302,11464307,11464312,11464313,11464320,11464323,11513728,11513733,11513738,11513739,11513746,11513749,11556710,11556715,11556720,11556721,11556728,11556731,11600318,11600323,11600328,11600329,11600336,11600339,11616914,11649170,11649175,11649180,11649181,11649188,11649191,11671316,11671321,11671326,11671327,11671334,11671337,11739073,11739078,11739083,11739084,11739091,11739094,11786667,11786672,11786677,11786678,11786685,11786688,11836857,11836862,11836867,11836868,11836875,11836878,11868561,11868562,11868568,11868572,11868575,11868581,11923705,11923706,11923712,11923716,11923719,11923725,11963785,11963790,11963795,11963796,11963803,11963806,12003957,12003962,12003967,12003968,12003975,12003978,12045305,12045310,12045315,12045316,12045323,12045326,12084331,12084336,12084341,12084342,12084349,12084352,12101108,12101889,12101894,12101899,19922,19927,19932,19933,19940,19943,47378,48086,48091,48096,71540,71541,71547,71551,71554,71560,85598,111507,111512,111514,111520,111523,111525,158215,158220,158222,158228,158231,158233,192704,192705,192711,192715,192718,192724,232710,232715,232720,232721,232728,232731,247346,272994,272999,273004,273005,273012,273015,312288,312293,312298,312299,312306,312309,356978,356979,356985,356989,356992,356998) ) 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, 207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 7858 WHERE `RP`.`player` = 7858 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125189,126374,128139,129047,130294,204118,206112,209399,209645,209734,246866,246871,246876,250351,250962,251094,280489,280494,280497,280502,280505,280510,303537,303542,303545,303662,304765,305271,338519,338524,338527,338532,338535,338540,10369079,10398551,10398556,10398559,10398564,10398567,10398572,10479366,10479372,10479375,10479380,10479383,10479385,10512410,10513282,10513287,10513292,10514094,10541940,10541946,10541949,10541954,10541957,10541959,10569187,10569192,10569194,10604748,10604754,10604757,10604762,10604765,10604767,10639525,10639530,10639532,10663094,10663100,10663103,10663108,10663111,10663113,10726148,10726154,10726157,10726162,10726165,10726167,10757378,10758430,10758435,10758440,10796846,10796852,10796855,10796860,10796863,10796865,10876748,10876754,10876757,10876762,10876765,10876767,10892858,10919712,10919718,10919721,10919726,10919729,10919731,10964653,10964655,10964662,10964665,10964668,10964674,11015182,11015187,11015192,11015193,11015200,11015203,11069416,11069417,11069423,11069427,11069430,11069436,11085747,11085752,11085755,11122229,11122234,11122236,11122242,11122245,11122247,11139724,11140226,11140231,11140236,11141175,11141802,11141971,11170429,11170434,11170437,11170442,11170445,11170450,11186638,11186639,11186645,11188243,11214035,11214040,11214043,11214048,11214051,11214056,11229100,11229604,11229605,11229611,11266813,11266818,11266820,11266826,11266829,11266831,11286141,11286146,11286148,11323139,11323144,11323147,11323152,11323155,11323160,11339739,11339744,11339746,11374645,11374650,11374652,11374658,11374661,11374663,11391961,11418521,11418526,11418528,11418534,11418537,11418539,11464302,11464307,11464312,11464313,11464320,11464323,11513728,11513733,11513738,11513739,11513746,11513749,11556710,11556715,11556720,11556721,11556728,11556731,11600318,11600323,11600328,11600329,11600336,11600339,11616914,11649170,11649175,11649180,11649181,11649188,11649191,11671316,11671321,11671326,11671327,11671334,11671337,11739073,11739078,11739083,11739084,11739091,11739094,11786667,11786672,11786677,11786678,11786685,11786688,11836857,11836862,11836867,11836868,11836875,11836878,11868561,11868562,11868568,11868572,11868575,11868581,11923705,11923706,11923712,11923716,11923719,11923725,11963785,11963790,11963795,11963796,11963803,11963806,12003957,12003962,12003967,12003968,12003975,12003978,12045305,12045310,12045315,12045316,12045323,12045326,12084331,12084336,12084341,12084342,12084349,12084352,12101108,12101889,12101894,12101899,19922,19927,19932,19933,19940,19943,47378,48086,48091,48096,71540,71541,71547,71551,71554,71560,85598,111507,111512,111514,111520,111523,111525,158215,158220,158222,158228,158231,158233,192704,192705,192711,192715,192718,192724,232710,232715,232720,232721,232728,232731,247346,272994,272999,273004,273005,273012,273015,312288,312293,312298,312299,312306,312309,356978,356979,356985,356989,356992,356998) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: