Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 47 | 4 | 0 | 239 | 528 | 2 | 67 | 10 | 7.12 | 4371 |
Национальная сборная | 36 | 3 | 0 | 174 | 405 | 0 | 53 | 7 | 7.03 | 3444 |
Отборочный турнир | 18 | 1 | 0 | 106 | 241 | 0 | 34 | 5 | 7.31 | 1629 |
Финальный турнир | 18 | 2 | 0 | 68 | 164 | 0 | 19 | 2 | 6.75 | 1815 |
Молодежная сборная | 11 | 1 | 0 | 65 | 123 | 2 | 14 | 3 | 7.41 | 927 |
Отборочный турнир | 3 | 1 | 0 | 27 | 38 | 1 | 6 | 1 | 7.50 | 277 |
Финальный турнир | 8 | 0 | 0 | 38 | 85 | 1 | 8 | 2 | 7.38 | 650 |
ТОВЫ сборных | 26 | 2 | 0 | 163 | 282 | 3 | 42 | 4 | 6.83 | 2196 |
Всего за сборные | 73 | 6 | 0 | 402 | 810 | 5 | 109 | 14 | 7.01 | 6567 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 70515 WHERE `RP`.`player` = 70515 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125205,128158,129061,130310,132008,132003,204134,209420,209571,209659,210932,209750,280657,280662,280665,280670,280673,280678,301763,303369,338375,338380,338383,338388,338391,338396,10369081,10370568,10398576,10398582,10398585,10398590,10398593,10398595,10440285,10479365,10479370,10479373,10479378,10479381,10479386,10541964,10541970,10541973,10541978,10541981,10541983,10567352,10604891,10604896,10604899,10604904,10604907,10604912,10662974,10662980,10662983,10662988,10662991,10662993,10726220,10726226,10726229,10726234,10726237,10726239,10757375,10797085,10797090,10797093,10797098,10797101,10797106,10825101,10876555,10876560,10876563,10876568,10876571,10876576,10919567,10919572,10919575,10919580,10919583,10919588,10936986,10964579,10964584,10964587,10964592,10964595,10964600,11015063,11015068,11015070,11015076,11015079,11015081,11036232,11069296,11069297,11069303,11069307,11069310,11069316,11122349,11122354,11122356,11122362,11122365,11122367,11170288,11170289,11170295,11170299,11170302,11170308,11214157,11214162,11214164,11214170,11214173,11214175,11229101,11266739,11266744,11266747,11266752,11266755,11266760,11323043,11323048,11323051,11323056,11323059,11323064,11374547,11374552,11374555,11374560,11374563,11374568,11418279,11418284,11418287,11418292,11418295,11418300,11433511,11464517,11464522,11464525,11464530,11464533,11464538,11513607,11513612,11513615,11513620,11513623,11513628,11530191,11556685,11556690,11556693,11556698,11556701,11556706,11600389,11600394,11600397,11600402,11600405,11600410,11616918,11649313,11649318,11649321,11649326,11649329,11649334,11671437,11671442,11671444,11671450,11671453,11671455,11738952,11738957,11738960,11738965,11738968,11738973,11786834,11786839,11786842,11786847,11786850,11786855,11836784,11836789,11836792,11836797,11836800,11836805,11868558,11868563,11868566,11868571,11868574,11868579,11895834,11923894,11923899,11923902,11923907,11923910,11923915,11963928,11963933,11963936,11963941,11963944,11963949,12003980,12003985,12003988,12003993,12003996,12004001,12045136,12045141,12045144,12045149,12045152,12045157,12084354,12084359,12084362,12084367,12084370,12084375,20041,20046,20049,20054,20057,20062,71465,71470,71473,71478,71481,71486,111409,111414,111417,111422,111425,111430,158285,158290,158293,158298,158301,158306,172816,192629,192634,192637,192642,192645,192650,232565,232570,232573,232578,232581,232586,273067,273072,273074,273080,273083,273085,312409,312414,312416,312422,312425,312427,331794,357073,357078,357080,357086,357089,357091) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 70515 WHERE `RP`.`player` = 70515 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125205,128158,129061,130310,132008,132003,204134,209420,209571,209659,210932,209750,280657,280662,280665,280670,280673,280678,301763,303369,338375,338380,338383,338388,338391,338396,10369081,10370568,10398576,10398582,10398585,10398590,10398593,10398595,10440285,10479365,10479370,10479373,10479378,10479381,10479386,10541964,10541970,10541973,10541978,10541981,10541983,10567352,10604891,10604896,10604899,10604904,10604907,10604912,10662974,10662980,10662983,10662988,10662991,10662993,10726220,10726226,10726229,10726234,10726237,10726239,10757375,10797085,10797090,10797093,10797098,10797101,10797106,10825101,10876555,10876560,10876563,10876568,10876571,10876576,10919567,10919572,10919575,10919580,10919583,10919588,10936986,10964579,10964584,10964587,10964592,10964595,10964600,11015063,11015068,11015070,11015076,11015079,11015081,11036232,11069296,11069297,11069303,11069307,11069310,11069316,11122349,11122354,11122356,11122362,11122365,11122367,11170288,11170289,11170295,11170299,11170302,11170308,11214157,11214162,11214164,11214170,11214173,11214175,11229101,11266739,11266744,11266747,11266752,11266755,11266760,11323043,11323048,11323051,11323056,11323059,11323064,11374547,11374552,11374555,11374560,11374563,11374568,11418279,11418284,11418287,11418292,11418295,11418300,11433511,11464517,11464522,11464525,11464530,11464533,11464538,11513607,11513612,11513615,11513620,11513623,11513628,11530191,11556685,11556690,11556693,11556698,11556701,11556706,11600389,11600394,11600397,11600402,11600405,11600410,11616918,11649313,11649318,11649321,11649326,11649329,11649334,11671437,11671442,11671444,11671450,11671453,11671455,11738952,11738957,11738960,11738965,11738968,11738973,11786834,11786839,11786842,11786847,11786850,11786855,11836784,11836789,11836792,11836797,11836800,11836805,11868558,11868563,11868566,11868571,11868574,11868579,11895834,11923894,11923899,11923902,11923907,11923910,11923915,11963928,11963933,11963936,11963941,11963944,11963949,12003980,12003985,12003988,12003993,12003996,12004001,12045136,12045141,12045144,12045149,12045152,12045157,12084354,12084359,12084362,12084367,12084370,12084375,20041,20046,20049,20054,20057,20062,71465,71470,71473,71478,71481,71486,111409,111414,111417,111422,111425,111430,158285,158290,158293,158298,158301,158306,172816,192629,192634,192637,192642,192645,192650,232565,232570,232573,232578,232581,232586,273067,273072,273074,273080,273083,273085,312409,312414,312416,312422,312425,312427,331794,357073,357078,357080,357086,357089,357091) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: