Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 10 | 0 | 0 | 44 | 78 | 1 | 11 | 0 | 6.20 | 748 |
Национальная сборная | 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 | 0 | 0 | 44 | 78 | 1 | 11 | 0 | 6.20 | 748 |
Отборочный турнир | 4 | 0 | 0 | 19 | 33 | 0 | 5 | 0 | 6.25 | 292 |
Финальный турнир | 6 | 0 | 0 | 25 | 45 | 1 | 6 | 0 | 6.17 | 456 |
ТОВЫ сборных | 2 | 0 | 0 | 4 | 18 | 0 | 1 | 0 | 6.00 | 114 |
Всего за сборные | 12 | 0 | 0 | 48 | 96 | 1 | 12 | 0 | 6.17 | 862 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 52130 WHERE `RP`.`player` = 52130 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125230,126331,128180,128999,130030,204163,206067,209442,209597,209688,246913,246918,246921,250359,250966,251098,280825,280830,280833,280838,280841,280846,338135,338140,338143,338148,338151,338156,10370757,10370762,10370765,10398188,10398194,10398197,10398202,10398205,10398207,10441221,10441226,10441229,10442083,10442239,10443326,10479197,10479202,10479205,10479210,10479213,10479218,10542324,10542330,10542333,10542338,10542341,10542343,10604533,10604535,10604542,10604545,10604548,10604554,10662711,10662713,10662720,10662723,10662726,10662732,10690374,10691370,10691375,10691380,10726510,10726513,10726516,10726519,10726526,10726529,10796632,10796635,10796638,10796641,10796648,10796651,10876438,10876441,10876444,10876447,10876454,10876457,10893784,10893785,10893791,10920000,10920006,10920009,10920014,10920017,10920019,10964316,10964319,10964322,10964325,10964332,10964335,11014918,11014923,11014928,11014929,11014936,11014939,11038281,11038286,11038288,11069679,11069684,11069686,11069692,11069695,11069697,11122060,11122065,11122070,11122071,11122078,11122081,11170646,11170651,11170656,11170657,11170664,11170667,11213844,11213849,11213854,11213855,11213862,11213865,11266548,11266553,11266558,11266559,11266566,11266569,11323284,11323289,11323294,11323295,11323302,11323305,11339824,11339825,11339831,11340358,11374861,11374866,11374868,11374874,11374877,11374879,11393015,11393020,11393023,11394299,11394689,11394856,11418759,11418764,11418767,11418772,11418775,11418780,11433520,11434192,11434193,11434199,11435312,11464685,11464690,11464693,11464698,11464701,11464706,11481209,11481214,11481217,11481635,11513823,11513828,11513831,11513836,11513839,11513844,11531575,11531580,11531583,11531961,11556901,11556906,11556909,11556914,11556917,11556922,11574775,11574780,11574783,11575589,11575879,11576021,11600605,11600610,11600613,11600618,11600621,11600626,11618507,11618512,11618515,11619501,11649457,11649462,11649465,11649470,11649473,11649478,11671627,11671632,11671635,11671640,11671643,11671648,11739170,11739175,11739177,11739183,11739186,11739188,11757839,11757842,11757834,11758752,11786882,11786887,11786890,11786895,11786898,11786903,11837146,11837151,11837153,11837159,11837162,11837164,11868872,11868877,11868879,11868885,11868888,11868890,11924041,11924042,11924048,11924052,11924055,11924061,11940012,11940925,11940930,11940935,11964122,11964127,11964129,11964135,11964138,11964140,12004245,12004250,12004255,12004256,12004263,12004266,12045473,12045478,12045483,12045484,12045491,12045494,12084643,12084648,12084653,12084654,12084661,12084664,12101114,20260,20261,20267,20271,20274,20280,48039,48044,48046,71852,71853,71859,71863,71866,71872,85603,86456,86461,86466,111844,111845,111851,111855,111858,111864,126205,158384,158385,158391,158395,158398,158404,173673,173678,173680,192775,192780,192782,192788,192791,192793,232423,232428,232430,232436,232439,232441,247357,273260,273261,273267,273271,273274,273280,288875,288880,288882,289793,312553,312558,312560,312566,312569,312571,357312,357317,357322,357323,357330,357333,372858,372859,372865) ) 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` = 52130 WHERE `RP`.`player` = 52130 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125230,126331,128180,128999,130030,204163,206067,209442,209597,209688,246913,246918,246921,250359,250966,251098,280825,280830,280833,280838,280841,280846,338135,338140,338143,338148,338151,338156,10370757,10370762,10370765,10398188,10398194,10398197,10398202,10398205,10398207,10441221,10441226,10441229,10442083,10442239,10443326,10479197,10479202,10479205,10479210,10479213,10479218,10542324,10542330,10542333,10542338,10542341,10542343,10604533,10604535,10604542,10604545,10604548,10604554,10662711,10662713,10662720,10662723,10662726,10662732,10690374,10691370,10691375,10691380,10726510,10726513,10726516,10726519,10726526,10726529,10796632,10796635,10796638,10796641,10796648,10796651,10876438,10876441,10876444,10876447,10876454,10876457,10893784,10893785,10893791,10920000,10920006,10920009,10920014,10920017,10920019,10964316,10964319,10964322,10964325,10964332,10964335,11014918,11014923,11014928,11014929,11014936,11014939,11038281,11038286,11038288,11069679,11069684,11069686,11069692,11069695,11069697,11122060,11122065,11122070,11122071,11122078,11122081,11170646,11170651,11170656,11170657,11170664,11170667,11213844,11213849,11213854,11213855,11213862,11213865,11266548,11266553,11266558,11266559,11266566,11266569,11323284,11323289,11323294,11323295,11323302,11323305,11339824,11339825,11339831,11340358,11374861,11374866,11374868,11374874,11374877,11374879,11393015,11393020,11393023,11394299,11394689,11394856,11418759,11418764,11418767,11418772,11418775,11418780,11433520,11434192,11434193,11434199,11435312,11464685,11464690,11464693,11464698,11464701,11464706,11481209,11481214,11481217,11481635,11513823,11513828,11513831,11513836,11513839,11513844,11531575,11531580,11531583,11531961,11556901,11556906,11556909,11556914,11556917,11556922,11574775,11574780,11574783,11575589,11575879,11576021,11600605,11600610,11600613,11600618,11600621,11600626,11618507,11618512,11618515,11619501,11649457,11649462,11649465,11649470,11649473,11649478,11671627,11671632,11671635,11671640,11671643,11671648,11739170,11739175,11739177,11739183,11739186,11739188,11757839,11757842,11757834,11758752,11786882,11786887,11786890,11786895,11786898,11786903,11837146,11837151,11837153,11837159,11837162,11837164,11868872,11868877,11868879,11868885,11868888,11868890,11924041,11924042,11924048,11924052,11924055,11924061,11940012,11940925,11940930,11940935,11964122,11964127,11964129,11964135,11964138,11964140,12004245,12004250,12004255,12004256,12004263,12004266,12045473,12045478,12045483,12045484,12045491,12045494,12084643,12084648,12084653,12084654,12084661,12084664,12101114,20260,20261,20267,20271,20274,20280,48039,48044,48046,71852,71853,71859,71863,71866,71872,85603,86456,86461,86466,111844,111845,111851,111855,111858,111864,126205,158384,158385,158391,158395,158398,158404,173673,173678,173680,192775,192780,192782,192788,192791,192793,232423,232428,232430,232436,232439,232441,247357,273260,273261,273267,273271,273274,273280,288875,288880,288882,289793,312553,312558,312560,312566,312569,312571,357312,357317,357322,357323,357330,357333,372858,372859,372865) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: