(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(140, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 71267 WHERE `RP`.`player` = 71267 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125171,126356,129029,130274,130653,131988,204100,206094,209558,209627,210911,209716,246901,246906,246909,280633,280638,280641,280646,280649,280654,303539,303544,303546,338376,338382,338385,338390,338393,338395,10370784,10370785,10370791,10398552,10398558,10398561,10398566,10398569,10398571,10441247,10441252,10441254,10479318,10479324,10479327,10479332,10479335,10479337,10542108,10542114,10542117,10542122,10542125,10542127,10604677,10604679,10604686,10604689,10604692,10604698,10639489,10639494,10639496,10663166,10663172,10663175,10663180,10663183,10663185,10691443,10691448,10691450,10692387,10692493,10693168,10726291,10726296,10726299,10726304,10726307,10726312,10796989,10796994,10796997,10797002,10797005,10797010,10876604,10876610,10876613,10876618,10876621,10876623,10893711,10893716,10893718,10893997,10894522,10895368,10919687,10919692,10919695,10919700,10919703,10919708,10937993,10937998,10938001,10939489,10940486,10941588,10964507,10964512,10964515,10964520,10964523,10964528,10982929,10982934,10982937,10983328,11015205,11015210,11015213,11015218,11015221,11015226,11069461,11069466,11069469,11069474,11069477,11069482,11084875,11122443,11122448,11122451,11122456,11122459,11122464,11170312,11170313,11170319,11170323,11170326,11170332,11213990,11213991,11213997,11214001,11214004,11214010,11266814,11266815,11266821,11266825,11266828,11266834,11323022,11323023,11323029,11323033,11323036,11323042,11374622,11374623,11374629,11374633,11374636,11374642,11391967,11392944,11392949,11392954,11394289,11418305,11418310,11418312,11418318,11418321,11418323,11434155,11434160,11434162,11464543,11464548,11464550,11464556,11464559,11464561,11479156,11513537,11513542,11513544,11513550,11513553,11513555,11530196,11556591,11556596,11556598,11556604,11556607,11556609,11600320,11600321,11600327,11600331,11600334,11600340,11649172,11649173,11649179,11649183,11649186,11649192,11666266,11671462,11671463,11671469,11671473,11671476,11671482,11739099,11739100,11739106,11739110,11739113,11739119,11757801,11757802,11757808,11786621,11786622,11786628,11786632,11786635,11786641,11836955,11836956,11836962,11836966,11836969,11836975,11852596,11868705,11868706,11868712,11868716,11868719,11868725,11923895,11923900,11923905,11923906,11923913,11923916,11963883,11963884,11963890,11963894,11963897,11963903,12004053,12004058,12004063,12004064,12004071,12004074,12045161,12045166,12045171,12045172,12045179,12045182,12061941,12061942,12061948,12062554,12062940,12063055,12084452,12084457,12084459,12084465,12084468,12084470,12101914,12101919,12101921,19969,19974,19977,19982,19985,19990,71419,71424,71426,71432,71435,71437,111531,111536,111538,111544,111547,111549,126191,127030,127035,127040,158119,158124,158126,158132,158135,158137,172821,173648,173653,173658,192583,192588,192590,192596,192599,192601,232592,232593,232599,232603,232606,232612,248154,248155,248161,249067,249209,249766,273043,273048,273050,273056,273059,273061,288008,312313,312318,312320,312326,312329,312331,357098,357099,357105,357109,357112,357118,372773,372778,372780) ) 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(140, 207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 71267 WHERE `RP`.`player` = 71267 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125171,126356,129029,130274,130653,131988,204100,206094,209558,209627,210911,209716,246901,246906,246909,280633,280638,280641,280646,280649,280654,303539,303544,303546,338376,338382,338385,338390,338393,338395,10370784,10370785,10370791,10398552,10398558,10398561,10398566,10398569,10398571,10441247,10441252,10441254,10479318,10479324,10479327,10479332,10479335,10479337,10542108,10542114,10542117,10542122,10542125,10542127,10604677,10604679,10604686,10604689,10604692,10604698,10639489,10639494,10639496,10663166,10663172,10663175,10663180,10663183,10663185,10691443,10691448,10691450,10692387,10692493,10693168,10726291,10726296,10726299,10726304,10726307,10726312,10796989,10796994,10796997,10797002,10797005,10797010,10876604,10876610,10876613,10876618,10876621,10876623,10893711,10893716,10893718,10893997,10894522,10895368,10919687,10919692,10919695,10919700,10919703,10919708,10937993,10937998,10938001,10939489,10940486,10941588,10964507,10964512,10964515,10964520,10964523,10964528,10982929,10982934,10982937,10983328,11015205,11015210,11015213,11015218,11015221,11015226,11069461,11069466,11069469,11069474,11069477,11069482,11084875,11122443,11122448,11122451,11122456,11122459,11122464,11170312,11170313,11170319,11170323,11170326,11170332,11213990,11213991,11213997,11214001,11214004,11214010,11266814,11266815,11266821,11266825,11266828,11266834,11323022,11323023,11323029,11323033,11323036,11323042,11374622,11374623,11374629,11374633,11374636,11374642,11391967,11392944,11392949,11392954,11394289,11418305,11418310,11418312,11418318,11418321,11418323,11434155,11434160,11434162,11464543,11464548,11464550,11464556,11464559,11464561,11479156,11513537,11513542,11513544,11513550,11513553,11513555,11530196,11556591,11556596,11556598,11556604,11556607,11556609,11600320,11600321,11600327,11600331,11600334,11600340,11649172,11649173,11649179,11649183,11649186,11649192,11666266,11671462,11671463,11671469,11671473,11671476,11671482,11739099,11739100,11739106,11739110,11739113,11739119,11757801,11757802,11757808,11786621,11786622,11786628,11786632,11786635,11786641,11836955,11836956,11836962,11836966,11836969,11836975,11852596,11868705,11868706,11868712,11868716,11868719,11868725,11923895,11923900,11923905,11923906,11923913,11923916,11963883,11963884,11963890,11963894,11963897,11963903,12004053,12004058,12004063,12004064,12004071,12004074,12045161,12045166,12045171,12045172,12045179,12045182,12061941,12061942,12061948,12062554,12062940,12063055,12084452,12084457,12084459,12084465,12084468,12084470,12101914,12101919,12101921,19969,19974,19977,19982,19985,19990,71419,71424,71426,71432,71435,71437,111531,111536,111538,111544,111547,111549,126191,127030,127035,127040,158119,158124,158126,158132,158135,158137,172821,173648,173653,173658,192583,192588,192590,192596,192599,192601,232592,232593,232599,232603,232606,232612,248154,248155,248161,249067,249209,249766,273043,273048,273050,273056,273059,273061,288008,312313,312318,312320,312326,312329,312331,357098,357099,357105,357109,357112,357118,372773,372778,372780) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: