Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 1 | 0 | 0 | 2 | 7 | 1 | 1 | 0 | 5.50 | 46 |
Национальная сборная | 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 |
Молодежная сборная | 1 | 0 | 0 | 2 | 7 | 1 | 1 | 0 | 5.50 | 46 |
Отборочный турнир | 1 | 0 | 0 | 2 | 7 | 1 | 1 | 0 | 5.50 | 46 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 2 | 0 | 0 | 0 | 13 | 1 | 3 | 0 | 6.00 | 90 |
Всего за сборные | 3 | 0 | 0 | 2 | 20 | 2 | 4 | 0 | 5.83 | 136 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 46783 WHERE `RP`.`player` = 46783 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126344,128193,129010,130043,206082,209453,209610,209699,280972,280975,280978,280981,280988,280991,338162,338165,338168,338171,338178,338181,10398094,10398097,10398100,10398103,10398110,10398113,10478984,10478987,10478990,10478993,10479000,10479003,10542374,10542377,10542380,10542383,10542390,10542393,10567344,10604437,10604439,10604446,10604449,10604452,10604458,10662902,10662908,10662911,10662916,10662919,10662921,10690375,10726388,10726394,10726397,10726402,10726405,10726407,10796703,10796705,10796712,10796715,10796718,10796724,10825113,10876388,10876394,10876397,10876402,10876405,10876407,10892863,10920024,10920030,10920033,10920038,10920041,10920043,10964266,10964272,10964275,10964280,10964283,10964285,11014869,11014874,11014877,11014882,11014885,11014890,11036237,11069581,11069586,11069589,11069594,11069597,11069602,11122107,11122112,11122115,11122120,11122123,11122128,11139734,11170501,11170506,11170509,11170514,11170517,11170522,11213725,11213730,11213732,11213738,11213741,11213743,11229110,11266645,11266650,11266652,11266658,11266661,11266663,11284037,11323334,11323335,11323341,11323345,11323348,11323354,11375030,11375031,11375037,11375041,11375044,11375050,11418689,11418694,11418696,11418702,11418705,11418707,11433517,11464687,11464692,11464694,11464700,11464703,11464705,11513921,11513926,11513928,11513934,11513937,11513939,11557000,11557001,11557007,11557011,11557014,11557020,11573289,11600727,11600732,11600734,11600740,11600743,11600745,11649460,11649461,11649467,11649471,11649474,11649480,11671556,11671561,11671566,11671567,11671574,11671577,11711141,11739362,11739367,11739369,11739375,11739378,11739380,11786980,11786985,11786987,11786993,11786996,11786998,11805216,11837243,11837244,11837250,11837254,11837257,11837263,11852591,11868921,11868922,11868928,11868932,11868935,11868941,11924089,11924090,11924096,11924100,11924103,11924109,11964003,11964004,11964010,11964014,11964017,11964023,11980333,12004415,12004416,12004422,12004426,12004429,12004435,12021341,12045523,12045524,12045530,12045534,12045537,12045543,12061189,12084812,12084817,12084819,12084825,12084828,12084830,12101120,20187,20192,20194,20200,20203,20205,47387,71849,71854,71857,71862,71865,71870,111913,111918,111921,111926,111929,111934,158359,158364,158366,158372,158375,158377,192847,192852,192854,192860,192863,192865,232376,232377,232383,232387,232390,232396,273474,273479,273484,273485,273492,273495,312698,312699,312705,312709,312712,312718,357194,357195,357201,357205,357208,357214) ) 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` = 46783 WHERE `RP`.`player` = 46783 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126344,128193,129010,130043,206082,209453,209610,209699,280972,280975,280978,280981,280988,280991,338162,338165,338168,338171,338178,338181,10398094,10398097,10398100,10398103,10398110,10398113,10478984,10478987,10478990,10478993,10479000,10479003,10542374,10542377,10542380,10542383,10542390,10542393,10567344,10604437,10604439,10604446,10604449,10604452,10604458,10662902,10662908,10662911,10662916,10662919,10662921,10690375,10726388,10726394,10726397,10726402,10726405,10726407,10796703,10796705,10796712,10796715,10796718,10796724,10825113,10876388,10876394,10876397,10876402,10876405,10876407,10892863,10920024,10920030,10920033,10920038,10920041,10920043,10964266,10964272,10964275,10964280,10964283,10964285,11014869,11014874,11014877,11014882,11014885,11014890,11036237,11069581,11069586,11069589,11069594,11069597,11069602,11122107,11122112,11122115,11122120,11122123,11122128,11139734,11170501,11170506,11170509,11170514,11170517,11170522,11213725,11213730,11213732,11213738,11213741,11213743,11229110,11266645,11266650,11266652,11266658,11266661,11266663,11284037,11323334,11323335,11323341,11323345,11323348,11323354,11375030,11375031,11375037,11375041,11375044,11375050,11418689,11418694,11418696,11418702,11418705,11418707,11433517,11464687,11464692,11464694,11464700,11464703,11464705,11513921,11513926,11513928,11513934,11513937,11513939,11557000,11557001,11557007,11557011,11557014,11557020,11573289,11600727,11600732,11600734,11600740,11600743,11600745,11649460,11649461,11649467,11649471,11649474,11649480,11671556,11671561,11671566,11671567,11671574,11671577,11711141,11739362,11739367,11739369,11739375,11739378,11739380,11786980,11786985,11786987,11786993,11786996,11786998,11805216,11837243,11837244,11837250,11837254,11837257,11837263,11852591,11868921,11868922,11868928,11868932,11868935,11868941,11924089,11924090,11924096,11924100,11924103,11924109,11964003,11964004,11964010,11964014,11964017,11964023,11980333,12004415,12004416,12004422,12004426,12004429,12004435,12021341,12045523,12045524,12045530,12045534,12045537,12045543,12061189,12084812,12084817,12084819,12084825,12084828,12084830,12101120,20187,20192,20194,20200,20203,20205,47387,71849,71854,71857,71862,71865,71870,111913,111918,111921,111926,111929,111934,158359,158364,158366,158372,158375,158377,192847,192852,192854,192860,192863,192865,232376,232377,232383,232387,232390,232396,273474,273479,273484,273485,273492,273495,312698,312699,312705,312709,312712,312718,357194,357195,357201,357205,357208,357214) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: