(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` = 77417 WHERE `RP`.`player` = 77417 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125245,128194,129011,130040,204176,209456,209609,209698,280803,280805,280812,280815,280818,280824,301754,303586,303591,303596,338256,338262,338265,338270,338273,338275,10370736,10370737,10370743,10398140,10398146,10398149,10398154,10398157,10398159,10441199,10441204,10441206,10442081,10442240,10443324,10479101,10479106,10479109,10479114,10479117,10479122,10512408,10513332,10513333,10513339,10542323,10542328,10542331,10542336,10542339,10542344,10567345,10604628,10604634,10604637,10604642,10604645,10604647,10662926,10662932,10662935,10662940,10662943,10662945,10726606,10726609,10726612,10726615,10726622,10726625,10796824,10796827,10796830,10796833,10796840,10796843,10876390,10876393,10876396,10876399,10876406,10876409,10893760,10893761,10893767,10919978,10919981,10919984,10919987,10919994,10919997,10964244,10964247,10964250,10964253,10964260,10964263,11014870,11014875,11014880,11014881,11014888,11014891,11038306,11038307,11038313,11038753,11069703,11069708,11069710,11069716,11069719,11069721,11085714,11085715,11085721,11122014,11122015,11122021,11122025,11122028,11122034,11140299,11140304,11140306,11141172,11141806,11141976,11170477,11170482,11170485,11170490,11170493,11170498,11186263,11213915,11213920,11213923,11213928,11213931,11213936,11229113,11266667,11266672,11266675,11266680,11266683,11266688,11323381,11323386,11323388,11323394,11323397,11323399,11374956,11374961,11374966,11374967,11374974,11374977,11418760,11418765,11418770,11418771,11418778,11418781,11464806,11464811,11464816,11464817,11464824,11464827,11513994,11513995,11514001,11514005,11514008,11514014,11531578,11531579,11531585,11531958,11556807,11556812,11556814,11556820,11556823,11556825,11600775,11600780,11600782,11600788,11600791,11600793,11649580,11649581,11649587,11649591,11649594,11649600,11671557,11671562,11671564,11671570,11671573,11671575,11739171,11739172,11739178,11739182,11739185,11739191,11787029,11787030,11787036,11787040,11787043,11787049,11837122,11837127,11837129,11837135,11837138,11837140,11853454,11853459,11853461,11868824,11868829,11868831,11868837,11868840,11868842,11924161,11924162,11924168,11924172,11924175,11924181,11964193,11964198,11964203,11964204,11964211,11964214,11980327,11980451,11980456,11980461,11981349,12004365,12004370,12004375,12004376,12004383,12004386,12045427,12045428,12045434,12045438,12045441,12045447,12084789,12084790,12084796,12084800,12084803,12084809,20212,20213,20219,20223,20226,20232,48027,48032,48034,71803,71808,71810,71816,71819,71821,86481,86486,86488,111700,111701,111707,111711,111714,111720,126202,127054,127059,127064,128625,158527,158532,158534,158540,158543,158545,192920,192921,192927,192931,192934,192940,210105,232400,232401,232407,232411,232414,232420,273259,273264,273266,273272,273275,273277,312482,312483,312489,312493,312496,312502,357386,357387,357393,357397,357400,357406,372002,372832,372837,372842) ) 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` = 77417 WHERE `RP`.`player` = 77417 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125245,128194,129011,130040,204176,209456,209609,209698,280803,280805,280812,280815,280818,280824,301754,303586,303591,303596,338256,338262,338265,338270,338273,338275,10370736,10370737,10370743,10398140,10398146,10398149,10398154,10398157,10398159,10441199,10441204,10441206,10442081,10442240,10443324,10479101,10479106,10479109,10479114,10479117,10479122,10512408,10513332,10513333,10513339,10542323,10542328,10542331,10542336,10542339,10542344,10567345,10604628,10604634,10604637,10604642,10604645,10604647,10662926,10662932,10662935,10662940,10662943,10662945,10726606,10726609,10726612,10726615,10726622,10726625,10796824,10796827,10796830,10796833,10796840,10796843,10876390,10876393,10876396,10876399,10876406,10876409,10893760,10893761,10893767,10919978,10919981,10919984,10919987,10919994,10919997,10964244,10964247,10964250,10964253,10964260,10964263,11014870,11014875,11014880,11014881,11014888,11014891,11038306,11038307,11038313,11038753,11069703,11069708,11069710,11069716,11069719,11069721,11085714,11085715,11085721,11122014,11122015,11122021,11122025,11122028,11122034,11140299,11140304,11140306,11141172,11141806,11141976,11170477,11170482,11170485,11170490,11170493,11170498,11186263,11213915,11213920,11213923,11213928,11213931,11213936,11229113,11266667,11266672,11266675,11266680,11266683,11266688,11323381,11323386,11323388,11323394,11323397,11323399,11374956,11374961,11374966,11374967,11374974,11374977,11418760,11418765,11418770,11418771,11418778,11418781,11464806,11464811,11464816,11464817,11464824,11464827,11513994,11513995,11514001,11514005,11514008,11514014,11531578,11531579,11531585,11531958,11556807,11556812,11556814,11556820,11556823,11556825,11600775,11600780,11600782,11600788,11600791,11600793,11649580,11649581,11649587,11649591,11649594,11649600,11671557,11671562,11671564,11671570,11671573,11671575,11739171,11739172,11739178,11739182,11739185,11739191,11787029,11787030,11787036,11787040,11787043,11787049,11837122,11837127,11837129,11837135,11837138,11837140,11853454,11853459,11853461,11868824,11868829,11868831,11868837,11868840,11868842,11924161,11924162,11924168,11924172,11924175,11924181,11964193,11964198,11964203,11964204,11964211,11964214,11980327,11980451,11980456,11980461,11981349,12004365,12004370,12004375,12004376,12004383,12004386,12045427,12045428,12045434,12045438,12045441,12045447,12084789,12084790,12084796,12084800,12084803,12084809,20212,20213,20219,20223,20226,20232,48027,48032,48034,71803,71808,71810,71816,71819,71821,86481,86486,86488,111700,111701,111707,111711,111714,111720,126202,127054,127059,127064,128625,158527,158532,158534,158540,158543,158545,192920,192921,192927,192931,192934,192940,210105,232400,232401,232407,232411,232414,232420,273259,273264,273266,273272,273275,273277,312482,312483,312489,312493,312496,312502,357386,357387,357393,357397,357400,357406,372002,372832,372837,372842) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: