Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 5 | 0 | 0 | 12 | 23 | 0 | 5 | 0 | 7.00 | 403 |
Национальная сборная | 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 |
Молодежная сборная | 5 | 0 | 0 | 12 | 23 | 0 | 5 | 0 | 7.00 | 403 |
Отборочный турнир | 4 | 0 | 0 | 12 | 18 | 0 | 5 | 0 | 7.00 | 311 |
Финальный турнир | 1 | 0 | 0 | 0 | 5 | 0 | 0 | 0 | 7.00 | 92 |
ТОВЫ сборных | 3 | 0 | 0 | 15 | 31 | 0 | 4 | 0 | 6.83 | 236 |
Всего за сборные | 8 | 0 | 0 | 27 | 54 | 0 | 9 | 0 | 6.94 | 639 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 56839 WHERE `RP`.`player` = 56839 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125237,126339,128188,129007,130034,204168,206075,209450,209605,209692,280753,280758,280761,280766,280769,280774,301748,338207,338212,338215,338220,338223,338228,10398236,10398242,10398245,10398250,10398253,10398255,10479029,10479034,10479037,10479042,10479045,10479050,10512404,10542396,10542402,10542405,10542410,10542413,10542415,10604460,10604466,10604469,10604474,10604477,10604479,10637412,10662830,10662836,10662839,10662844,10662847,10662849,10726628,10726634,10726637,10726642,10726645,10726647,10796653,10796658,10796661,10796666,10796669,10796674,10876435,10876440,10876443,10876448,10876451,10876456,10892870,10919999,10920004,10920007,10920012,10920015,10920020,10964265,10964270,10964273,10964278,10964281,10964286,11014941,11014946,11014949,11014954,11014957,11014962,11069631,11069636,11069638,11069644,11069647,11069649,11084887,11122037,11122042,11122044,11122050,11122053,11122055,11170528,11170529,11170535,11170539,11170542,11170548,11186264,11213749,11213754,11213756,11213762,11213765,11213767,11266691,11266696,11266699,11266704,11266707,11266712,11323406,11323407,11323413,11323417,11323420,11323426,11375004,11375009,11375014,11375015,11375022,11375025,11418618,11418619,11418625,11418629,11418632,11418638,11433518,11464567,11464572,11464574,11464580,11464583,11464585,11479165,11513871,11513876,11513879,11513884,11513887,11513892,11556877,11556882,11556885,11556890,11556893,11556898,11600701,11600706,11600709,11600714,11600717,11600722,11649603,11649608,11649610,11649616,11649619,11649621,11671677,11671682,11671684,11671690,11671693,11671695,11739147,11739148,11739154,11739158,11739161,11739167,11787074,11787079,11787082,11787087,11787090,11787095,11837192,11837197,11837200,11837205,11837208,11837213,11852584,11869016,11869021,11869023,11869029,11869032,11869034,11924160,11924165,11924167,11924173,11924176,11924178,11964240,11964245,11964248,11964253,11964256,11964261,11980326,12004222,12004227,12004229,12004235,12004238,12004240,12045544,12045549,12045552,12045557,12045560,12045565,12084786,12084791,12084794,12084799,12084802,12084807,20355,20360,20362,20368,20371,20373,71731,71736,71738,71744,71747,71749,111795,111800,111802,111808,111811,111813,158477,158482,158485,158490,158493,158498,192821,192826,192829,192834,192837,192842,232253,232258,232261,232266,232269,232274,247356,273331,273336,273338,273344,273347,273349,312505,312510,312512,312518,312521,312523,331809,357265,357270,357272,357278,357281,357283) ) 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` = 56839 WHERE `RP`.`player` = 56839 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125237,126339,128188,129007,130034,204168,206075,209450,209605,209692,280753,280758,280761,280766,280769,280774,301748,338207,338212,338215,338220,338223,338228,10398236,10398242,10398245,10398250,10398253,10398255,10479029,10479034,10479037,10479042,10479045,10479050,10512404,10542396,10542402,10542405,10542410,10542413,10542415,10604460,10604466,10604469,10604474,10604477,10604479,10637412,10662830,10662836,10662839,10662844,10662847,10662849,10726628,10726634,10726637,10726642,10726645,10726647,10796653,10796658,10796661,10796666,10796669,10796674,10876435,10876440,10876443,10876448,10876451,10876456,10892870,10919999,10920004,10920007,10920012,10920015,10920020,10964265,10964270,10964273,10964278,10964281,10964286,11014941,11014946,11014949,11014954,11014957,11014962,11069631,11069636,11069638,11069644,11069647,11069649,11084887,11122037,11122042,11122044,11122050,11122053,11122055,11170528,11170529,11170535,11170539,11170542,11170548,11186264,11213749,11213754,11213756,11213762,11213765,11213767,11266691,11266696,11266699,11266704,11266707,11266712,11323406,11323407,11323413,11323417,11323420,11323426,11375004,11375009,11375014,11375015,11375022,11375025,11418618,11418619,11418625,11418629,11418632,11418638,11433518,11464567,11464572,11464574,11464580,11464583,11464585,11479165,11513871,11513876,11513879,11513884,11513887,11513892,11556877,11556882,11556885,11556890,11556893,11556898,11600701,11600706,11600709,11600714,11600717,11600722,11649603,11649608,11649610,11649616,11649619,11649621,11671677,11671682,11671684,11671690,11671693,11671695,11739147,11739148,11739154,11739158,11739161,11739167,11787074,11787079,11787082,11787087,11787090,11787095,11837192,11837197,11837200,11837205,11837208,11837213,11852584,11869016,11869021,11869023,11869029,11869032,11869034,11924160,11924165,11924167,11924173,11924176,11924178,11964240,11964245,11964248,11964253,11964256,11964261,11980326,12004222,12004227,12004229,12004235,12004238,12004240,12045544,12045549,12045552,12045557,12045560,12045565,12084786,12084791,12084794,12084799,12084802,12084807,20355,20360,20362,20368,20371,20373,71731,71736,71738,71744,71747,71749,111795,111800,111802,111808,111811,111813,158477,158482,158485,158490,158493,158498,192821,192826,192829,192834,192837,192842,232253,232258,232261,232266,232269,232274,247356,273331,273336,273338,273344,273347,273349,312505,312510,312512,312518,312521,312523,331809,357265,357270,357272,357278,357281,357283) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: