Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин | Официальные матчи сборных | 1 | 0 | 0 | 1 | 7 | 8 | 2 | 0 | 6.00 | 0 |
Национальная сборная | 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 | 1 | 7 | 8 | 2 | 0 | 6.00 | 0 |
Отборочный турнир | 1 | 0 | 0 | 1 | 7 | 8 | 2 | 0 | 6.00 | 0 |
Финальный турнир | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.00 | 0 |
ТОВЫ сборных | 1 | 0 | 0 | 0 | 9 | 2 | 4 | 0 | 4.50 | 0 |
Всего за сборные | 2 | 0 | 0 | 1 | 16 | 10 | 6 | 0 | 5.25 | 0 |
Номинация | Матчи | Голы | Голевые передачи | Отборы | Передачи | Дриблинг | Перехваты | Удары | Оц | Мин |
(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` = 38639 WHERE `RP`.`player` = 38639 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126322,128171,128986,130015,206060,209431,209588,209671,280780,280783,280786,280789,280796,280799,301745,303562,303567,303572,303671,338184,338190,338193,338198,338201,338203,10398308,10398314,10398317,10398322,10398325,10398327,10479055,10479057,10479064,10479067,10479070,10479076,10542397,10542399,10542406,10542409,10542412,10542418,10604509,10604511,10604518,10604521,10604524,10604530,10639538,10639539,10639545,10640812,10662734,10662740,10662743,10662748,10662751,10662753,10726629,10726631,10726638,10726641,10726644,10726650,10796752,10796755,10796758,10796761,10796768,10796771,10825111,10876437,10876439,10876446,10876449,10876452,10876458,10919858,10919861,10919864,10919867,10919874,10919877,10937960,10937961,10937967,10964387,10964389,10964396,10964399,10964402,10964408,11014728,11014729,11014735,11014739,11014742,11014748,11069702,11069707,11069712,11069713,11069720,11069723,11122180,11122185,11122190,11122191,11122198,11122201,11139735,11170502,11170507,11170512,11170513,11170520,11170523,11213916,11213921,11213926,11213927,11213934,11213937,11266668,11266673,11266678,11266679,11266686,11266689,11323404,11323409,11323414,11323415,11323422,11323425,11337852,11374934,11374935,11374941,11374945,11374948,11374954,11391973,11392980,11392985,11392990,11418641,11418646,11418648,11418654,11418657,11418659,11464592,11464593,11464599,11464603,11464606,11464612,11513970,11513971,11513977,11513981,11513984,11513990,11556832,11556833,11556839,11556843,11556846,11556852,11600776,11600777,11600783,11600787,11600790,11600796,11618534,11618535,11618541,11649532,11649533,11649539,11649543,11649546,11649552,11671702,11671703,11671709,11671713,11671716,11671722,11739193,11739198,11739203,11739204,11739211,11739214,11787051,11787056,11787061,11787062,11787069,11787072,11837025,11837030,11837035,11837036,11837043,11837046,11869039,11869044,11869049,11869050,11869057,11869060,11924087,11924092,11924097,11924098,11924105,11924108,11940010,11940913,11940918,11940923,11964121,11964126,11964131,11964132,11964139,11964142,11980331,12004223,12004224,12004230,12004234,12004237,12004243,12021334,12045547,12045548,12045554,12045558,12045561,12045567,12084717,12084718,12084724,12084728,12084731,12084737,12101939,12101940,12101946,20332,20333,20339,20343,20346,20352,71780,71781,71787,71791,71794,71800,86469,86474,86476,111699,111704,111706,111712,111715,111717,127041,127046,127049,128628,128771,128862,158453,158458,158461,158466,158469,158474,172830,173660,173665,173670,192799,192804,192806,192812,192815,192817,232399,232404,232406,232412,232415,232417,273476,273477,273483,273487,273490,273496,312578,312579,312585,312589,312592,312598,357432,357437,357442,357443,357450,357453) ) 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` = 38639 WHERE `RP`.`player` = 38639 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (126322,128171,128986,130015,206060,209431,209588,209671,280780,280783,280786,280789,280796,280799,301745,303562,303567,303572,303671,338184,338190,338193,338198,338201,338203,10398308,10398314,10398317,10398322,10398325,10398327,10479055,10479057,10479064,10479067,10479070,10479076,10542397,10542399,10542406,10542409,10542412,10542418,10604509,10604511,10604518,10604521,10604524,10604530,10639538,10639539,10639545,10640812,10662734,10662740,10662743,10662748,10662751,10662753,10726629,10726631,10726638,10726641,10726644,10726650,10796752,10796755,10796758,10796761,10796768,10796771,10825111,10876437,10876439,10876446,10876449,10876452,10876458,10919858,10919861,10919864,10919867,10919874,10919877,10937960,10937961,10937967,10964387,10964389,10964396,10964399,10964402,10964408,11014728,11014729,11014735,11014739,11014742,11014748,11069702,11069707,11069712,11069713,11069720,11069723,11122180,11122185,11122190,11122191,11122198,11122201,11139735,11170502,11170507,11170512,11170513,11170520,11170523,11213916,11213921,11213926,11213927,11213934,11213937,11266668,11266673,11266678,11266679,11266686,11266689,11323404,11323409,11323414,11323415,11323422,11323425,11337852,11374934,11374935,11374941,11374945,11374948,11374954,11391973,11392980,11392985,11392990,11418641,11418646,11418648,11418654,11418657,11418659,11464592,11464593,11464599,11464603,11464606,11464612,11513970,11513971,11513977,11513981,11513984,11513990,11556832,11556833,11556839,11556843,11556846,11556852,11600776,11600777,11600783,11600787,11600790,11600796,11618534,11618535,11618541,11649532,11649533,11649539,11649543,11649546,11649552,11671702,11671703,11671709,11671713,11671716,11671722,11739193,11739198,11739203,11739204,11739211,11739214,11787051,11787056,11787061,11787062,11787069,11787072,11837025,11837030,11837035,11837036,11837043,11837046,11869039,11869044,11869049,11869050,11869057,11869060,11924087,11924092,11924097,11924098,11924105,11924108,11940010,11940913,11940918,11940923,11964121,11964126,11964131,11964132,11964139,11964142,11980331,12004223,12004224,12004230,12004234,12004237,12004243,12021334,12045547,12045548,12045554,12045558,12045561,12045567,12084717,12084718,12084724,12084728,12084731,12084737,12101939,12101940,12101946,20332,20333,20339,20343,20346,20352,71780,71781,71787,71791,71794,71800,86469,86474,86476,111699,111704,111706,111712,111715,111717,127041,127046,127049,128628,128771,128862,158453,158458,158461,158466,158469,158474,172830,173660,173665,173670,192799,192804,192806,192812,192815,192817,232399,232404,232406,232412,232415,232417,273476,273477,273483,273487,273490,273496,312578,312579,312585,312589,312592,312598,357432,357437,357442,357443,357450,357453) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: