Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 10 | 3 | 0 | 4 | 120 | 53 | 1 | 15 | 6.95 | 690 |
Национальная сборная | 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 |
Молодежная сборная | 10 | 3 | 0 | 4 | 120 | 53 | 1 | 15 | 6.95 | 690 |
Отборочный турнир | 7 | 2 | 0 | 3 | 94 | 45 | 1 | 11 | 7.14 | 515 |
Финальный турнир | 3 | 1 | 0 | 1 | 26 | 8 | 0 | 4 | 6.50 | 175 |
ТОВЫ сборных | 7 | 7 | 3 | 1 | 105 | 59 | 0 | 10 | 8.57 | 339 |
Всего за сборные | 17 | 10 | 3 | 5 | 225 | 112 | 1 | 25 | 7.62 | 1029 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 71032 WHERE `RP`.`player` = 71032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126318,128167,128982,130011,206056,209427,209584,209667,280875,280877,280884,280887,280890,280896,301750,338113,338115,338122,338125,338128,338134,10369063,10398164,10398170,10398173,10398178,10398181,10398183,10440270,10479150,10479156,10479159,10479164,10479167,10479169,10542253,10542255,10542262,10542265,10542268,10542274,10604580,10604586,10604589,10604594,10604597,10604599,10662880,10662883,10662886,10662889,10662896,10662899,10726534,10726537,10726540,10726543,10726550,10726553,10796608,10796611,10796614,10796617,10796624,10796627,10876270,10876273,10876276,10876279,10876286,10876289,10919882,10919885,10919888,10919891,10919898,10919901,10964388,10964391,10964394,10964397,10964404,10964407,10981495,11014798,11014803,11014808,11014809,11014816,11014819,11069630,11069635,11069640,11069641,11069648,11069651,11122061,11122066,11122068,11122074,11122077,11122079,11170672,11170673,11170679,11170683,11170686,11170692,11213966,11213967,11213973,11213977,11213980,11213986,11266646,11266647,11266653,11266657,11266660,11266666,11323451,11323456,11323459,11323464,11323467,11323472,11375027,11375032,11375035,11375040,11375043,11375048,11391969,11418615,11418620,11418623,11418628,11418631,11418636,11464639,11464644,11464646,11464652,11464655,11464657,11513873,11513878,11513880,11513886,11513889,11513891,11556928,11556929,11556935,11556939,11556942,11556948,11573292,11600704,11600705,11600711,11600715,11600718,11600724,11649481,11649486,11649489,11649494,11649497,11649502,11671701,11671706,11671708,11671714,11671717,11671719,11739242,11739247,11739249,11739255,11739258,11739260,11787101,11787102,11787108,11787112,11787115,11787121,11837240,11837245,11837248,11837253,11837256,11837261,11868966,11868971,11868974,11868979,11868982,11868987,11924062,11924067,11924070,11924075,11924078,11924083,11964024,11964029,11964032,11964037,11964040,11964045,12004364,12004369,12004372,12004377,12004380,12004385,12045472,12045477,12045480,12045485,12045488,12045493,12084810,12084815,12084818,12084823,12084826,12084831,20185,20190,20193,20198,20201,20206,71753,71758,71761,71766,71769,71774,111793,111798,111801,111806,111809,111814,158383,158388,158390,158396,158399,158401,172827,192751,192756,192758,192764,192767,192769,232421,232426,232429,232434,232437,232442,273425,273430,273433,273438,273441,273446,312575,312580,312583,312588,312591,312596,357287,357292,357295,357300,357303,357308) ) 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` = 71032 WHERE `RP`.`player` = 71032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126318,128167,128982,130011,206056,209427,209584,209667,280875,280877,280884,280887,280890,280896,301750,338113,338115,338122,338125,338128,338134,10369063,10398164,10398170,10398173,10398178,10398181,10398183,10440270,10479150,10479156,10479159,10479164,10479167,10479169,10542253,10542255,10542262,10542265,10542268,10542274,10604580,10604586,10604589,10604594,10604597,10604599,10662880,10662883,10662886,10662889,10662896,10662899,10726534,10726537,10726540,10726543,10726550,10726553,10796608,10796611,10796614,10796617,10796624,10796627,10876270,10876273,10876276,10876279,10876286,10876289,10919882,10919885,10919888,10919891,10919898,10919901,10964388,10964391,10964394,10964397,10964404,10964407,10981495,11014798,11014803,11014808,11014809,11014816,11014819,11069630,11069635,11069640,11069641,11069648,11069651,11122061,11122066,11122068,11122074,11122077,11122079,11170672,11170673,11170679,11170683,11170686,11170692,11213966,11213967,11213973,11213977,11213980,11213986,11266646,11266647,11266653,11266657,11266660,11266666,11323451,11323456,11323459,11323464,11323467,11323472,11375027,11375032,11375035,11375040,11375043,11375048,11391969,11418615,11418620,11418623,11418628,11418631,11418636,11464639,11464644,11464646,11464652,11464655,11464657,11513873,11513878,11513880,11513886,11513889,11513891,11556928,11556929,11556935,11556939,11556942,11556948,11573292,11600704,11600705,11600711,11600715,11600718,11600724,11649481,11649486,11649489,11649494,11649497,11649502,11671701,11671706,11671708,11671714,11671717,11671719,11739242,11739247,11739249,11739255,11739258,11739260,11787101,11787102,11787108,11787112,11787115,11787121,11837240,11837245,11837248,11837253,11837256,11837261,11868966,11868971,11868974,11868979,11868982,11868987,11924062,11924067,11924070,11924075,11924078,11924083,11964024,11964029,11964032,11964037,11964040,11964045,12004364,12004369,12004372,12004377,12004380,12004385,12045472,12045477,12045480,12045485,12045488,12045493,12084810,12084815,12084818,12084823,12084826,12084831,20185,20190,20193,20198,20201,20206,71753,71758,71761,71766,71769,71774,111793,111798,111801,111806,111809,111814,158383,158388,158390,158396,158399,158401,172827,192751,192756,192758,192764,192767,192769,232421,232426,232429,232434,232437,232442,273425,273430,273433,273438,273441,273446,312575,312580,312583,312588,312591,312596,357287,357292,357295,357300,357303,357308) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: