Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 25 | 0 | 0 | 152 | 272 | 1 | 18 | 0 | 7.30 | 2045 |
Национальная сборная | 11 | 0 | 0 | 95 | 164 | 0 | 12 | 0 | 7.41 | 842 |
Отборочный турнир | 11 | 0 | 0 | 95 | 164 | 0 | 12 | 0 | 7.41 | 842 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
Молодежная сборная | 14 | 0 | 0 | 57 | 108 | 1 | 6 | 0 | 7.21 | 1203 |
Отборочный турнир | 8 | 0 | 0 | 32 | 68 | 1 | 5 | 0 | 7.06 | 743 |
Финальный турнир | 6 | 0 | 0 | 25 | 40 | 0 | 1 | 0 | 7.42 | 460 |
ТОВЫ сборных | 16 | 0 | 0 | 95 | 186 | 1 | 13 | 1 | 6.50 | 1228 |
Всего за сборные | 41 | 0 | 0 | 247 | 458 | 2 | 31 | 1 | 6.99 | 3273 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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, 208) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 56912 WHERE `RP`.`player` = 56912 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125237,126339,128188,129007,130034,204168,206075,209450,209605,209692,246949,246954,246957,250367,280753,280758,280761,280766,280769,280774,301748,338207,338212,338215,338220,338223,338228,10370735,10370740,10370742,10398236,10398242,10398245,10398250,10398253,10398255,10441209,10441214,10441217,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,10691383,10691388,10691390,10726628,10726634,10726637,10726642,10726645,10726647,10758465,10758470,10758473,10760393,10796653,10796658,10796661,10796666,10796669,10796674,10826265,10826270,10826273,10826544,10826634,10827307,10876435,10876440,10876443,10876448,10876451,10876456,10892870,10893758,10893763,10893768,10893986,10894520,10895369,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,11186684,11186689,11186694,11213749,11213754,11213756,11213762,11213765,11213767,11229627,11229632,11229634,11266691,11266696,11266699,11266704,11266707,11266712,11323406,11323407,11323413,11323417,11323420,11323426,11375004,11375009,11375014,11375015,11375022,11375025,11393006,11393007,11393013,11418618,11418619,11418625,11418629,11418632,11418638,11433518,11434214,11434219,11434224,11435317,11464567,11464572,11464574,11464580,11464583,11464585,11479165,11481222,11481227,11481232,11481639,11481772,11481864,11513871,11513876,11513879,11513884,11513887,11513892,11531601,11531606,11531608,11531963,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,11757841,11757843,11757836,11758749,11758863,11758950,11787074,11787079,11787082,11787087,11787090,11787095,11805300,11805305,11805308,11837192,11837197,11837200,11837205,11837208,11837213,11852584,11869016,11869021,11869023,11869029,11869032,11869034,11896700,11896705,11896707,11924160,11924165,11924167,11924173,11924176,11924178,11964240,11964245,11964248,11964253,11964256,11964261,11980326,12004222,12004227,12004229,12004235,12004238,12004240,12021468,12021473,12021476,12021997,12022389,12022502,12045544,12045549,12045552,12045557,12045560,12045565,12061962,12061967,12061970,12084786,12084791,12084794,12084799,12084802,12084807,20355,20360,20362,20368,20371,20373,48052,48053,48059,48362,71731,71736,71738,71744,71747,71749,111795,111800,111802,111808,111811,111813,127043,127048,127050,128621,128774,128861,158477,158482,158485,158490,158493,158498,173683,173688,173691,174573,192821,192826,192829,192834,192837,192842,210947,210952,210955,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, 208) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 56912 WHERE `RP`.`player` = 56912 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125237,126339,128188,129007,130034,204168,206075,209450,209605,209692,246949,246954,246957,250367,280753,280758,280761,280766,280769,280774,301748,338207,338212,338215,338220,338223,338228,10370735,10370740,10370742,10398236,10398242,10398245,10398250,10398253,10398255,10441209,10441214,10441217,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,10691383,10691388,10691390,10726628,10726634,10726637,10726642,10726645,10726647,10758465,10758470,10758473,10760393,10796653,10796658,10796661,10796666,10796669,10796674,10826265,10826270,10826273,10826544,10826634,10827307,10876435,10876440,10876443,10876448,10876451,10876456,10892870,10893758,10893763,10893768,10893986,10894520,10895369,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,11186684,11186689,11186694,11213749,11213754,11213756,11213762,11213765,11213767,11229627,11229632,11229634,11266691,11266696,11266699,11266704,11266707,11266712,11323406,11323407,11323413,11323417,11323420,11323426,11375004,11375009,11375014,11375015,11375022,11375025,11393006,11393007,11393013,11418618,11418619,11418625,11418629,11418632,11418638,11433518,11434214,11434219,11434224,11435317,11464567,11464572,11464574,11464580,11464583,11464585,11479165,11481222,11481227,11481232,11481639,11481772,11481864,11513871,11513876,11513879,11513884,11513887,11513892,11531601,11531606,11531608,11531963,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,11757841,11757843,11757836,11758749,11758863,11758950,11787074,11787079,11787082,11787087,11787090,11787095,11805300,11805305,11805308,11837192,11837197,11837200,11837205,11837208,11837213,11852584,11869016,11869021,11869023,11869029,11869032,11869034,11896700,11896705,11896707,11924160,11924165,11924167,11924173,11924176,11924178,11964240,11964245,11964248,11964253,11964256,11964261,11980326,12004222,12004227,12004229,12004235,12004238,12004240,12021468,12021473,12021476,12021997,12022389,12022502,12045544,12045549,12045552,12045557,12045560,12045565,12061962,12061967,12061970,12084786,12084791,12084794,12084799,12084802,12084807,20355,20360,20362,20368,20371,20373,48052,48053,48059,48362,71731,71736,71738,71744,71747,71749,111795,111800,111802,111808,111811,111813,127043,127048,127050,128621,128774,128861,158477,158482,158485,158490,158493,158498,173683,173688,173691,174573,192821,192826,192829,192834,192837,192842,210947,210952,210955,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}: