(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` = 42712 WHERE `RP`.`player` = 42712 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125212,126315,128164,128978,130019,204143,206051,209426,209580,209675,280899,280901,280908,280911,280914,280920,338305,338307,338314,338317,338320,338326,10398309,10398311,10398318,10398321,10398324,10398330,10479174,10479180,10479183,10479188,10479191,10479193,10542326,10542329,10542332,10542335,10542342,10542345,10604581,10604583,10604590,10604593,10604596,10604602,10662903,10662905,10662912,10662915,10662918,10662924,10726390,10726393,10726396,10726399,10726406,10726409,10796775,10796777,10796784,10796787,10796790,10796796,10876509,10876511,10876518,10876521,10876524,10876530,10892869,10919977,10919979,10919986,10919989,10919992,10919998,10936981,10964338,10964344,10964347,10964352,10964355,10964357,11014845,11014850,11014853,11014858,11014861,11014866,11069632,11069633,11069639,11069643,11069646,11069652,11122134,11122135,11122141,11122145,11122148,11122154,11139733,11170600,11170601,11170607,11170611,11170614,11170620,11213870,11213871,11213877,11213881,11213884,11213890,11266596,11266601,11266606,11266607,11266614,11266617,11323358,11323359,11323365,11323369,11323372,11323378,11374790,11374791,11374797,11374801,11374804,11374810,11418690,11418691,11418697,11418701,11418704,11418710,11464784,11464785,11464791,11464795,11464798,11464804,11479170,11513850,11513851,11513857,11513861,11513864,11513870,11556950,11556955,11556960,11556961,11556968,11556971,11600654,11600659,11600664,11600665,11600672,11600675,11649530,11649535,11649540,11649541,11649548,11649551,11671676,11671681,11671686,11671687,11671694,11671697,11739363,11739364,11739370,11739374,11739377,11739383,11787028,11787033,11787035,11787041,11787044,11787046,11837026,11837031,11837033,11837039,11837042,11837044,11869065,11869066,11869072,11869076,11869079,11869085,11923993,11923994,11924000,11924004,11924007,11924013,11940017,11964169,11964174,11964179,11964180,11964187,11964190,12004221,12004226,12004231,12004232,12004239,12004242,12045593,12045598,12045603,12045604,12045611,12045614,12084765,12084766,12084772,12084776,12084779,12084785,20115,20120,20122,20128,20131,20133,71683,71688,71690,71696,71699,71701,111772,111773,111779,111783,111786,111792,126200,158408,158409,158415,158419,158422,158428,192968,192969,192975,192979,192982,192988,232326,232331,232336,232337,232344,232347,273332,273333,273339,273343,273346,273352,312506,312507,312513,312517,312520,312526,357359,357364,357367,357372,357375,357380) ) 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` = 42712 WHERE `RP`.`player` = 42712 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125212,126315,128164,128978,130019,204143,206051,209426,209580,209675,280899,280901,280908,280911,280914,280920,338305,338307,338314,338317,338320,338326,10398309,10398311,10398318,10398321,10398324,10398330,10479174,10479180,10479183,10479188,10479191,10479193,10542326,10542329,10542332,10542335,10542342,10542345,10604581,10604583,10604590,10604593,10604596,10604602,10662903,10662905,10662912,10662915,10662918,10662924,10726390,10726393,10726396,10726399,10726406,10726409,10796775,10796777,10796784,10796787,10796790,10796796,10876509,10876511,10876518,10876521,10876524,10876530,10892869,10919977,10919979,10919986,10919989,10919992,10919998,10936981,10964338,10964344,10964347,10964352,10964355,10964357,11014845,11014850,11014853,11014858,11014861,11014866,11069632,11069633,11069639,11069643,11069646,11069652,11122134,11122135,11122141,11122145,11122148,11122154,11139733,11170600,11170601,11170607,11170611,11170614,11170620,11213870,11213871,11213877,11213881,11213884,11213890,11266596,11266601,11266606,11266607,11266614,11266617,11323358,11323359,11323365,11323369,11323372,11323378,11374790,11374791,11374797,11374801,11374804,11374810,11418690,11418691,11418697,11418701,11418704,11418710,11464784,11464785,11464791,11464795,11464798,11464804,11479170,11513850,11513851,11513857,11513861,11513864,11513870,11556950,11556955,11556960,11556961,11556968,11556971,11600654,11600659,11600664,11600665,11600672,11600675,11649530,11649535,11649540,11649541,11649548,11649551,11671676,11671681,11671686,11671687,11671694,11671697,11739363,11739364,11739370,11739374,11739377,11739383,11787028,11787033,11787035,11787041,11787044,11787046,11837026,11837031,11837033,11837039,11837042,11837044,11869065,11869066,11869072,11869076,11869079,11869085,11923993,11923994,11924000,11924004,11924007,11924013,11940017,11964169,11964174,11964179,11964180,11964187,11964190,12004221,12004226,12004231,12004232,12004239,12004242,12045593,12045598,12045603,12045604,12045611,12045614,12084765,12084766,12084772,12084776,12084779,12084785,20115,20120,20122,20128,20131,20133,71683,71688,71690,71696,71699,71701,111772,111773,111779,111783,111786,111792,126200,158408,158409,158415,158419,158422,158428,192968,192969,192975,192979,192982,192988,232326,232331,232336,232337,232344,232347,273332,273333,273339,273343,273346,273352,312506,312507,312513,312517,312520,312526,357359,357364,357367,357372,357375,357380) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: