(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` = 47722 WHERE `RP`.`player` = 47722 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125233,126330,128183,129003,130032,204164,206068,209443,209601,209690,280850,280856,280859,280864,280867,280869,338255,338260,338263,338268,338271,338276,10398141,10398143,10398150,10398153,10398156,10398162,10479007,10479009,10479016,10479019,10479022,10479028,10542254,10542257,10542260,10542263,10542270,10542273,10604557,10604559,10604566,10604569,10604572,10604578,10637419,10662854,10662860,10662863,10662868,10662871,10662873,10726436,10726442,10726445,10726450,10726453,10726455,10796629,10796634,10796637,10796642,10796645,10796650,10876364,10876370,10876373,10876378,10876381,10876383,10892865,10920025,10920027,10920034,10920037,10920040,10920046,10964411,10964413,10964420,10964423,10964426,10964432,11014702,11014707,11014712,11014713,11014720,11014723,11069558,11069563,11069568,11069569,11069576,11069579,11122084,11122089,11122094,11122095,11122102,11122105,11170550,11170555,11170560,11170561,11170568,11170571,11213892,11213897,11213902,11213903,11213910,11213913,11266622,11266623,11266629,11266633,11266636,11266642,11323308,11323313,11323318,11323319,11323326,11323329,11374837,11374842,11374844,11374850,11374853,11374855,11418617,11418622,11418624,11418630,11418633,11418635,11464591,11464596,11464598,11464604,11464607,11464609,11513993,11513998,11514000,11514006,11514009,11514011,11530203,11557047,11557052,11557054,11557060,11557063,11557065,11573290,11600632,11600633,11600639,11600643,11600646,11600652,11649436,11649437,11649443,11649447,11649450,11649456,11671606,11671607,11671613,11671617,11671620,11671626,11739289,11739294,11739299,11739300,11739307,11739310,11756960,11787075,11787080,11787085,11787086,11787093,11787096,11837049,11837054,11837059,11837060,11837067,11837070,11868847,11868852,11868857,11868858,11868865,11868868,11924111,11924116,11924121,11924122,11924129,11924132,11964073,11964078,11964083,11964084,11964091,11964094,12004341,12004346,12004351,12004352,12004359,12004362,12045449,12045454,12045459,12045460,12045467,12045470,12084715,12084720,12084725,12084726,12084733,12084736,20210,20215,20220,20221,20228,20231,71730,71735,71740,71741,71748,71751,111675,111680,111682,111688,111691,111693,158597,158602,158605,158610,158613,158618,192797,192802,192805,192810,192813,192818,232397,232402,232405,232410,232413,232418,273473,273478,273481,273486,273489,273494,312503,312508,312511,312516,312519,312524,357289,357294,357296,357302,357305,357307) ) 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` = 47722 WHERE `RP`.`player` = 47722 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125233,126330,128183,129003,130032,204164,206068,209443,209601,209690,280850,280856,280859,280864,280867,280869,338255,338260,338263,338268,338271,338276,10398141,10398143,10398150,10398153,10398156,10398162,10479007,10479009,10479016,10479019,10479022,10479028,10542254,10542257,10542260,10542263,10542270,10542273,10604557,10604559,10604566,10604569,10604572,10604578,10637419,10662854,10662860,10662863,10662868,10662871,10662873,10726436,10726442,10726445,10726450,10726453,10726455,10796629,10796634,10796637,10796642,10796645,10796650,10876364,10876370,10876373,10876378,10876381,10876383,10892865,10920025,10920027,10920034,10920037,10920040,10920046,10964411,10964413,10964420,10964423,10964426,10964432,11014702,11014707,11014712,11014713,11014720,11014723,11069558,11069563,11069568,11069569,11069576,11069579,11122084,11122089,11122094,11122095,11122102,11122105,11170550,11170555,11170560,11170561,11170568,11170571,11213892,11213897,11213902,11213903,11213910,11213913,11266622,11266623,11266629,11266633,11266636,11266642,11323308,11323313,11323318,11323319,11323326,11323329,11374837,11374842,11374844,11374850,11374853,11374855,11418617,11418622,11418624,11418630,11418633,11418635,11464591,11464596,11464598,11464604,11464607,11464609,11513993,11513998,11514000,11514006,11514009,11514011,11530203,11557047,11557052,11557054,11557060,11557063,11557065,11573290,11600632,11600633,11600639,11600643,11600646,11600652,11649436,11649437,11649443,11649447,11649450,11649456,11671606,11671607,11671613,11671617,11671620,11671626,11739289,11739294,11739299,11739300,11739307,11739310,11756960,11787075,11787080,11787085,11787086,11787093,11787096,11837049,11837054,11837059,11837060,11837067,11837070,11868847,11868852,11868857,11868858,11868865,11868868,11924111,11924116,11924121,11924122,11924129,11924132,11964073,11964078,11964083,11964084,11964091,11964094,12004341,12004346,12004351,12004352,12004359,12004362,12045449,12045454,12045459,12045460,12045467,12045470,12084715,12084720,12084725,12084726,12084733,12084736,20210,20215,20220,20221,20228,20231,71730,71735,71740,71741,71748,71751,111675,111680,111682,111688,111691,111693,158597,158602,158605,158610,158613,158618,192797,192802,192805,192810,192813,192818,232397,232402,232405,232410,232413,232418,273473,273478,273481,273486,273489,273494,312503,312508,312511,312516,312519,312524,357289,357294,357296,357302,357305,357307) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: