Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 2 | 0 | 0 | 3 | 31 | 2 | 2 | 1 | 5.00 | 113 |
Национальная сборная | 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 |
Молодежная сборная | 2 | 0 | 0 | 3 | 31 | 2 | 2 | 1 | 5.00 | 113 |
Отборочный турнир | 2 | 0 | 0 | 3 | 31 | 2 | 2 | 1 | 5.00 | 113 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 2 | 0 | 0 | 4 | 42 | 6 | 10 | 1 | 6.50 | 123 |
Всего за сборные | 4 | 0 | 0 | 7 | 73 | 8 | 12 | 2 | 5.75 | 236 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 81405 WHERE `RP`.`player` = 81405 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125244,126343,129013,130042,204177,206079,209611,209700,280827,280829,280836,280839,280842,280848,338257,338259,338266,338269,338272,338278,10369064,10398213,10398215,10398222,10398225,10398228,10398234,10478983,10478985,10478992,10478995,10478998,10479004,10542445,10542447,10542454,10542457,10542460,10542466,10604414,10604417,10604420,10604423,10604430,10604433,10662928,10662931,10662934,10662937,10662944,10662947,10690382,10726437,10726439,10726446,10726449,10726452,10726458,10796727,10796729,10796736,10796739,10796742,10796748,10876341,10876343,10876350,10876353,10876356,10876362,10892864,10920049,10920051,10920058,10920061,10920064,10920070,10936982,10964243,10964245,10964252,10964255,10964258,10964264,11014824,11014825,11014831,11014835,11014838,11014844,11069488,11069489,11069495,11069499,11069502,11069508,11122062,11122063,11122069,11122073,11122076,11122082,11139739,11170599,11170604,11170606,11170612,11170615,11170617,11213819,11213824,11213827,11213832,11213835,11213840,11266501,11266506,11266508,11266514,11266517,11266519,11323429,11323434,11323436,11323442,11323445,11323447,11374789,11374794,11374796,11374802,11374805,11374807,11391974,11418642,11418643,11418649,11418653,11418656,11418662,11464807,11464812,11464814,11464820,11464823,11464825,11513778,11513779,11513785,11513789,11513792,11513798,11557046,11557051,11557056,11557057,11557064,11557067,11600608,11600609,11600615,11600619,11600622,11600628,11649508,11649509,11649515,11649519,11649522,11649528,11671580,11671585,11671590,11671591,11671598,11671601,11739385,11739390,11739395,11739396,11739403,11739406,11786883,11786888,11786893,11786894,11786901,11786904,11805219,11837265,11837270,11837275,11837276,11837283,11837286,11869063,11869068,11869073,11869074,11869081,11869084,11924039,11924044,11924049,11924050,11924057,11924060,11964001,11964006,11964011,11964012,11964019,11964022,12004269,12004274,12004279,12004280,12004287,12004290,12045377,12045382,12045387,12045388,12045395,12045398,12084763,12084768,12084773,12084774,12084781,12084784,20186,20191,20196,20197,20204,20207,71828,71829,71835,71839,71842,71848,111794,111799,111804,111805,111812,111815,126208,158528,158529,158535,158539,158542,158548,192918,192923,192928,192929,192936,192939,232206,232211,232216,232217,232224,232227,273354,273359,273364,273365,273372,273375,312576,312581,312586,312587,312594,312597,357360,357365,357370,357371,357378,357381,371999) ) 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` = 81405 WHERE `RP`.`player` = 81405 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125244,126343,129013,130042,204177,206079,209611,209700,280827,280829,280836,280839,280842,280848,338257,338259,338266,338269,338272,338278,10369064,10398213,10398215,10398222,10398225,10398228,10398234,10478983,10478985,10478992,10478995,10478998,10479004,10542445,10542447,10542454,10542457,10542460,10542466,10604414,10604417,10604420,10604423,10604430,10604433,10662928,10662931,10662934,10662937,10662944,10662947,10690382,10726437,10726439,10726446,10726449,10726452,10726458,10796727,10796729,10796736,10796739,10796742,10796748,10876341,10876343,10876350,10876353,10876356,10876362,10892864,10920049,10920051,10920058,10920061,10920064,10920070,10936982,10964243,10964245,10964252,10964255,10964258,10964264,11014824,11014825,11014831,11014835,11014838,11014844,11069488,11069489,11069495,11069499,11069502,11069508,11122062,11122063,11122069,11122073,11122076,11122082,11139739,11170599,11170604,11170606,11170612,11170615,11170617,11213819,11213824,11213827,11213832,11213835,11213840,11266501,11266506,11266508,11266514,11266517,11266519,11323429,11323434,11323436,11323442,11323445,11323447,11374789,11374794,11374796,11374802,11374805,11374807,11391974,11418642,11418643,11418649,11418653,11418656,11418662,11464807,11464812,11464814,11464820,11464823,11464825,11513778,11513779,11513785,11513789,11513792,11513798,11557046,11557051,11557056,11557057,11557064,11557067,11600608,11600609,11600615,11600619,11600622,11600628,11649508,11649509,11649515,11649519,11649522,11649528,11671580,11671585,11671590,11671591,11671598,11671601,11739385,11739390,11739395,11739396,11739403,11739406,11786883,11786888,11786893,11786894,11786901,11786904,11805219,11837265,11837270,11837275,11837276,11837283,11837286,11869063,11869068,11869073,11869074,11869081,11869084,11924039,11924044,11924049,11924050,11924057,11924060,11964001,11964006,11964011,11964012,11964019,11964022,12004269,12004274,12004279,12004280,12004287,12004290,12045377,12045382,12045387,12045388,12045395,12045398,12084763,12084768,12084773,12084774,12084781,12084784,20186,20191,20196,20197,20204,20207,71828,71829,71835,71839,71842,71848,111794,111799,111804,111805,111812,111815,126208,158528,158529,158535,158539,158542,158548,192918,192923,192928,192929,192936,192939,232206,232211,232216,232217,232224,232227,273354,273359,273364,273365,273372,273375,312576,312581,312586,312587,312594,312597,357360,357365,357370,357371,357378,357381,371999) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: