(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 84733 WHERE `RP`.`player` = 84733 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125235,126334,128181,129002,130029,205838,206072,209441,209602,209685,280900,280903,280906,280909,280916,280919,301746,338114,338117,338120,338123,338130,338133,10398142,10398145,10398148,10398151,10398158,10398161,10479031,10479033,10479040,10479043,10479046,10479052,10542228,10542234,10542237,10542242,10542245,10542247,10567340,10604579,10604584,10604587,10604592,10604595,10604600,10662829,10662834,10662837,10662842,10662845,10662850,10726579,10726584,10726587,10726592,10726595,10726600,10796677,10796682,10796685,10796690,10796693,10796698,10876291,10876296,10876299,10876304,10876307,10876312,10919831,10919836,10919839,10919844,10919847,10919852,10964242,10964248,10964251,10964256,10964259,10964261,10981494,11014872,11014873,11014879,11014883,11014886,11014892,11069536,11069537,11069543,11069547,11069550,11069556,11122182,11122183,11122189,11122193,11122196,11122202,11170696,11170697,11170703,11170707,11170710,11170716,11213748,11213753,11213758,11213759,11213766,11213769,11266574,11266575,11266581,11266585,11266588,11266594,11323428,11323433,11323438,11323439,11323446,11323449,11375028,11375033,11375038,11375039,11375046,11375049,11418640,11418645,11418650,11418651,11418658,11418661,11433519,11464664,11464665,11464671,11464675,11464678,11464684,11513874,11513875,11513881,11513885,11513888,11513894,11530207,11556903,11556908,11556910,11556916,11556919,11556921,11573286,11600559,11600564,11600566,11600572,11600575,11600577,11649409,11649414,11649417,11649422,11649425,11649430,11666276,11671507,11671512,11671515,11671520,11671523,11671528,11739168,11739173,11739176,11739181,11739184,11739189,11787052,11787057,11787059,11787065,11787068,11787070,11837219,11837220,11837226,11837230,11837233,11837239,11852588,11869064,11869069,11869071,11869077,11869080,11869082,11924016,11924021,11924023,11924029,11924032,11924034,11964146,11964151,11964153,11964159,11964162,11964164,11980328,12004198,12004203,12004205,12004211,12004214,12004216,12021335,12045568,12045573,12045576,12045581,12045584,12045589,12084740,12084745,12084747,12084753,12084756,12084758,20139,20144,20146,20152,20155,20157,47381,71755,71760,71762,71768,71771,71773,111916,111917,111923,111927,111930,111936,158407,158412,158414,158420,158423,158425,192943,192948,192950,192956,192959,192961,232255,232260,232262,232268,232271,232273,273356,273357,273363,273367,273370,273376,312623,312628,312631,312636,312639,312644,357407,357412,357415,357420,357423,357428) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 84733 WHERE `RP`.`player` = 84733 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125235,126334,128181,129002,130029,205838,206072,209441,209602,209685,280900,280903,280906,280909,280916,280919,301746,338114,338117,338120,338123,338130,338133,10398142,10398145,10398148,10398151,10398158,10398161,10479031,10479033,10479040,10479043,10479046,10479052,10542228,10542234,10542237,10542242,10542245,10542247,10567340,10604579,10604584,10604587,10604592,10604595,10604600,10662829,10662834,10662837,10662842,10662845,10662850,10726579,10726584,10726587,10726592,10726595,10726600,10796677,10796682,10796685,10796690,10796693,10796698,10876291,10876296,10876299,10876304,10876307,10876312,10919831,10919836,10919839,10919844,10919847,10919852,10964242,10964248,10964251,10964256,10964259,10964261,10981494,11014872,11014873,11014879,11014883,11014886,11014892,11069536,11069537,11069543,11069547,11069550,11069556,11122182,11122183,11122189,11122193,11122196,11122202,11170696,11170697,11170703,11170707,11170710,11170716,11213748,11213753,11213758,11213759,11213766,11213769,11266574,11266575,11266581,11266585,11266588,11266594,11323428,11323433,11323438,11323439,11323446,11323449,11375028,11375033,11375038,11375039,11375046,11375049,11418640,11418645,11418650,11418651,11418658,11418661,11433519,11464664,11464665,11464671,11464675,11464678,11464684,11513874,11513875,11513881,11513885,11513888,11513894,11530207,11556903,11556908,11556910,11556916,11556919,11556921,11573286,11600559,11600564,11600566,11600572,11600575,11600577,11649409,11649414,11649417,11649422,11649425,11649430,11666276,11671507,11671512,11671515,11671520,11671523,11671528,11739168,11739173,11739176,11739181,11739184,11739189,11787052,11787057,11787059,11787065,11787068,11787070,11837219,11837220,11837226,11837230,11837233,11837239,11852588,11869064,11869069,11869071,11869077,11869080,11869082,11924016,11924021,11924023,11924029,11924032,11924034,11964146,11964151,11964153,11964159,11964162,11964164,11980328,12004198,12004203,12004205,12004211,12004214,12004216,12021335,12045568,12045573,12045576,12045581,12045584,12045589,12084740,12084745,12084747,12084753,12084756,12084758,20139,20144,20146,20152,20155,20157,47381,71755,71760,71762,71768,71771,71773,111916,111917,111923,111927,111930,111936,158407,158412,158414,158420,158423,158425,192943,192948,192950,192956,192959,192961,232255,232260,232262,232268,232271,232273,273356,273357,273363,273367,273370,273376,312623,312628,312631,312636,312639,312644,357407,357412,357415,357420,357423,357428) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: