(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` = 42112 WHERE `RP`.`player` = 42112 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125172,126358,128123,129026,130275,131985,204103,206096,209383,209553,209626,209715,280418,280424,280427,280432,280435,280437,338641,338643,338650,338653,338656,338662,10398458,10398461,10398464,10398467,10398474,10398477,10479344,10479347,10479350,10479353,10479360,10479363,10542085,10542087,10542094,10542097,10542100,10542106,10569164,10569165,10569171,10604869,10604871,10604878,10604881,10604884,10604890,10663024,10663027,10663030,10663033,10663040,10663043,10726294,10726297,10726300,10726303,10726310,10726313,10797064,10797067,10797070,10797073,10797080,10797083,10876582,10876585,10876588,10876591,10876598,10876601,10892851,10919785,10919787,10919794,10919797,10919800,10919806,10938020,10938021,10938027,10964677,10964679,10964686,10964689,10964692,10964698,10982920,10982921,10982927,11015207,11015212,11015214,11015220,11015223,11015225,11038353,11038358,11038360,11069367,11069372,11069374,11069380,11069383,11069385,11122445,11122450,11122452,11122458,11122461,11122463,11170264,11170265,11170271,11170275,11170278,11170284,11186276,11186624,11186629,11186634,11214205,11214210,11214212,11214218,11214221,11214223,11229105,11229590,11229595,11229600,11266766,11266767,11266773,11266777,11266780,11266786,11322998,11322999,11323005,11323009,11323012,11323018,11337864,11339762,11339767,11339772,11374573,11374578,11374580,11374586,11374589,11374591,11391960,11392956,11392961,11392966,11394290,11394686,11394858,11418519,11418524,11418527,11418532,11418535,11418540,11433509,11434130,11434135,11434140,11464325,11464330,11464333,11464338,11464341,11464346,11481197,11481202,11481205,11513535,11513540,11513543,11513548,11513551,11513556,11556735,11556740,11556742,11556748,11556751,11556753,11573276,11574730,11574731,11574737,11600295,11600300,11600302,11600308,11600311,11600313,11618449,11618454,11618456,11619487,11649145,11649150,11649153,11649158,11649161,11649166,11667083,11667088,11667091,11671435,11671440,11671443,11671448,11671451,11671456,11711122,11739072,11739077,11739080,11739085,11739088,11739093,11756953,11757799,11757804,11757809,11786786,11786791,11786794,11786799,11786802,11786807,11805242,11805247,11805249,11806994,11807247,11807847,11837000,11837005,11837008,11837013,11837016,11837021,11852593,11853419,11853420,11853426,11854427,11868702,11868707,11868710,11868715,11868718,11868723,11896662,11896667,11896670,11896910,11923918,11923923,11923926,11923931,11923934,11923939,11940001,11940855,11940856,11940862,11963880,11963885,11963888,11963893,11963896,11963901,11980321,12004100,12004105,12004108,12004113,12004116,12004121,12045162,12045167,12045169,12045175,12045178,12045180,12084429,12084430,12084436,12084440,12084443,12084449,19900,19901,19907,19911,19914,19920,48099,48104,48106,71369,71374,71377,71382,71385,71390,86421,86426,86428,111601,111606,111609,111614,111617,111622,158191,158196,158198,158204,158207,158209,172820,173636,173641,173646,192535,192540,192542,192548,192551,192553,210938,210939,210945,232615,232620,232622,232628,232631,232633,248142,248143,248149,272995,273000,273002,273008,273011,273013,288000,312433,312438,312440,312446,312449,312451,331799,333218,333223,333228,357001,357006,357008,357014,357017,357019) ) 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` = 42112 WHERE `RP`.`player` = 42112 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125172,126358,128123,129026,130275,131985,204103,206096,209383,209553,209626,209715,280418,280424,280427,280432,280435,280437,338641,338643,338650,338653,338656,338662,10398458,10398461,10398464,10398467,10398474,10398477,10479344,10479347,10479350,10479353,10479360,10479363,10542085,10542087,10542094,10542097,10542100,10542106,10569164,10569165,10569171,10604869,10604871,10604878,10604881,10604884,10604890,10663024,10663027,10663030,10663033,10663040,10663043,10726294,10726297,10726300,10726303,10726310,10726313,10797064,10797067,10797070,10797073,10797080,10797083,10876582,10876585,10876588,10876591,10876598,10876601,10892851,10919785,10919787,10919794,10919797,10919800,10919806,10938020,10938021,10938027,10964677,10964679,10964686,10964689,10964692,10964698,10982920,10982921,10982927,11015207,11015212,11015214,11015220,11015223,11015225,11038353,11038358,11038360,11069367,11069372,11069374,11069380,11069383,11069385,11122445,11122450,11122452,11122458,11122461,11122463,11170264,11170265,11170271,11170275,11170278,11170284,11186276,11186624,11186629,11186634,11214205,11214210,11214212,11214218,11214221,11214223,11229105,11229590,11229595,11229600,11266766,11266767,11266773,11266777,11266780,11266786,11322998,11322999,11323005,11323009,11323012,11323018,11337864,11339762,11339767,11339772,11374573,11374578,11374580,11374586,11374589,11374591,11391960,11392956,11392961,11392966,11394290,11394686,11394858,11418519,11418524,11418527,11418532,11418535,11418540,11433509,11434130,11434135,11434140,11464325,11464330,11464333,11464338,11464341,11464346,11481197,11481202,11481205,11513535,11513540,11513543,11513548,11513551,11513556,11556735,11556740,11556742,11556748,11556751,11556753,11573276,11574730,11574731,11574737,11600295,11600300,11600302,11600308,11600311,11600313,11618449,11618454,11618456,11619487,11649145,11649150,11649153,11649158,11649161,11649166,11667083,11667088,11667091,11671435,11671440,11671443,11671448,11671451,11671456,11711122,11739072,11739077,11739080,11739085,11739088,11739093,11756953,11757799,11757804,11757809,11786786,11786791,11786794,11786799,11786802,11786807,11805242,11805247,11805249,11806994,11807247,11807847,11837000,11837005,11837008,11837013,11837016,11837021,11852593,11853419,11853420,11853426,11854427,11868702,11868707,11868710,11868715,11868718,11868723,11896662,11896667,11896670,11896910,11923918,11923923,11923926,11923931,11923934,11923939,11940001,11940855,11940856,11940862,11963880,11963885,11963888,11963893,11963896,11963901,11980321,12004100,12004105,12004108,12004113,12004116,12004121,12045162,12045167,12045169,12045175,12045178,12045180,12084429,12084430,12084436,12084440,12084443,12084449,19900,19901,19907,19911,19914,19920,48099,48104,48106,71369,71374,71377,71382,71385,71390,86421,86426,86428,111601,111606,111609,111614,111617,111622,158191,158196,158198,158204,158207,158209,172820,173636,173641,173646,192535,192540,192542,192548,192551,192553,210938,210939,210945,232615,232620,232622,232628,232631,232633,248142,248143,248149,272995,273000,273002,273008,273011,273013,288000,312433,312438,312440,312446,312449,312451,331799,333218,333223,333228,357001,357006,357008,357014,357017,357019) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: