(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` = 76739 WHERE `RP`.`player` = 76739 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125217,126316,128166,130009,204146,206054,209428,209665,280922,280928,280931,280936,280939,280941,338282,338285,338288,338291,338298,338301,10398189,10398191,10398198,10398201,10398204,10398210,10479223,10479225,10479232,10479235,10479238,10479244,10512403,10513354,10513359,10513364,10542300,10542306,10542309,10542314,10542317,10542319,10569125,10569130,10569133,10570038,10604652,10604658,10604661,10604666,10604669,10604671,10639537,10639542,10639544,10640805,10640946,10641037,10662781,10662786,10662789,10662794,10662797,10662802,10726460,10726466,10726469,10726474,10726477,10726479,10796654,10796660,10796663,10796668,10796671,10796673,10876510,10876513,10876516,10876519,10876526,10876529,10920002,10920005,10920008,10920011,10920018,10920021,10937971,10937976,10937978,10964410,10964416,10964419,10964424,10964427,10964429,11014727,11014732,11014734,11014740,11014743,11014745,11036241,11069583,11069588,11069590,11069596,11069599,11069601,11122133,11122138,11122140,11122146,11122149,11122151,11170574,11170579,11170584,11170585,11170592,11170595,11213820,11213825,11213830,11213831,11213838,11213841,11266550,11266551,11266557,11266561,11266564,11266570,11323452,11323457,11323462,11323463,11323470,11323473,11374884,11374889,11374894,11374895,11374902,11374905,11418664,11418669,11418674,11418675,11418682,11418685,11464638,11464643,11464648,11464649,11464656,11464659,11479166,11513802,11513803,11513809,11513813,11513816,11513822,11531577,11531582,11531584,11556999,11557004,11557006,11557012,11557015,11557017,11600655,11600660,11600662,11600668,11600671,11600673,11616928,11618508,11618513,11618518,11649411,11649416,11649418,11649424,11649427,11649429,11667145,11667150,11667152,11667370,11668034,11668170,11671723,11671728,11671731,11671736,11671739,11671744,11712024,11712029,11712031,11739192,11739197,11739200,11739205,11739208,11739213,11757853,11757855,11757848,11786978,11786983,11786986,11786991,11786994,11786999,11805288,11805293,11805296,11837096,11837101,11837104,11837109,11837112,11837117,11852585,11853477,11853482,11853487,11854412,11869062,11869067,11869070,11869075,11869078,11869083,11896736,11896741,11896743,11923992,11923997,11923999,11924005,11924008,11924010,11940902,11940907,11940909,11942501,11964168,11964173,11964176,11964181,11964184,11964189,12004390,12004395,12004397,12004403,12004406,12004408,12021340,12021457,12021462,12021467,12021996,12045448,12045453,12045456,12045461,12045464,12045469,12084644,12084649,12084651,12084657,12084660,12084662,12101972,12101977,12101980,20283,20288,20290,20296,20299,20301,71851,71856,71858,71864,71867,71869,86455,86460,86463,87291,87430,87504,111889,111894,111897,111902,111905,111910,127053,127058,127061,158525,158530,158533,158538,158541,158546,172828,192965,192970,192973,192978,192981,192986,210959,210964,210967,232277,232282,232285,232290,232293,232298,248163,248168,248171,273377,273382,273385,273390,273393,273398,288011,312527,312532,312535,312540,312543,312548,357239,357244,357247,357252,357255,357260,372831,372836,372839,373746) ) 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` = 76739 WHERE `RP`.`player` = 76739 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125217,126316,128166,130009,204146,206054,209428,209665,280922,280928,280931,280936,280939,280941,338282,338285,338288,338291,338298,338301,10398189,10398191,10398198,10398201,10398204,10398210,10479223,10479225,10479232,10479235,10479238,10479244,10512403,10513354,10513359,10513364,10542300,10542306,10542309,10542314,10542317,10542319,10569125,10569130,10569133,10570038,10604652,10604658,10604661,10604666,10604669,10604671,10639537,10639542,10639544,10640805,10640946,10641037,10662781,10662786,10662789,10662794,10662797,10662802,10726460,10726466,10726469,10726474,10726477,10726479,10796654,10796660,10796663,10796668,10796671,10796673,10876510,10876513,10876516,10876519,10876526,10876529,10920002,10920005,10920008,10920011,10920018,10920021,10937971,10937976,10937978,10964410,10964416,10964419,10964424,10964427,10964429,11014727,11014732,11014734,11014740,11014743,11014745,11036241,11069583,11069588,11069590,11069596,11069599,11069601,11122133,11122138,11122140,11122146,11122149,11122151,11170574,11170579,11170584,11170585,11170592,11170595,11213820,11213825,11213830,11213831,11213838,11213841,11266550,11266551,11266557,11266561,11266564,11266570,11323452,11323457,11323462,11323463,11323470,11323473,11374884,11374889,11374894,11374895,11374902,11374905,11418664,11418669,11418674,11418675,11418682,11418685,11464638,11464643,11464648,11464649,11464656,11464659,11479166,11513802,11513803,11513809,11513813,11513816,11513822,11531577,11531582,11531584,11556999,11557004,11557006,11557012,11557015,11557017,11600655,11600660,11600662,11600668,11600671,11600673,11616928,11618508,11618513,11618518,11649411,11649416,11649418,11649424,11649427,11649429,11667145,11667150,11667152,11667370,11668034,11668170,11671723,11671728,11671731,11671736,11671739,11671744,11712024,11712029,11712031,11739192,11739197,11739200,11739205,11739208,11739213,11757853,11757855,11757848,11786978,11786983,11786986,11786991,11786994,11786999,11805288,11805293,11805296,11837096,11837101,11837104,11837109,11837112,11837117,11852585,11853477,11853482,11853487,11854412,11869062,11869067,11869070,11869075,11869078,11869083,11896736,11896741,11896743,11923992,11923997,11923999,11924005,11924008,11924010,11940902,11940907,11940909,11942501,11964168,11964173,11964176,11964181,11964184,11964189,12004390,12004395,12004397,12004403,12004406,12004408,12021340,12021457,12021462,12021467,12021996,12045448,12045453,12045456,12045461,12045464,12045469,12084644,12084649,12084651,12084657,12084660,12084662,12101972,12101977,12101980,20283,20288,20290,20296,20299,20301,71851,71856,71858,71864,71867,71869,86455,86460,86463,87291,87430,87504,111889,111894,111897,111902,111905,111910,127053,127058,127061,158525,158530,158533,158538,158541,158546,172828,192965,192970,192973,192978,192981,192986,210959,210964,210967,232277,232282,232285,232290,232293,232298,248163,248168,248171,273377,273382,273385,273390,273393,273398,288011,312527,312532,312535,312540,312543,312548,357239,357244,357247,357252,357255,357260,372831,372836,372839,373746) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: