(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) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 73548 WHERE `RP`.`player` = 73548 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125166,126352,128117,129018,130269,204097,206090,209377,209618,209709,280636,280639,280642,280645,280652,280655,338354,338357,338360,338363,338370,338373,10398410,10398413,10398416,10398419,10398426,10398429,10479440,10479443,10479446,10479449,10479456,10479459,10542182,10542185,10542188,10542191,10542198,10542201,10604870,10604873,10604876,10604879,10604886,10604889,10637429,10663144,10663147,10663150,10663153,10663160,10663163,10726317,10726319,10726326,10726329,10726332,10726338,10797062,10797068,10797071,10797076,10797079,10797081,10876749,10876751,10876758,10876761,10876764,10876770,10919570,10919573,10919576,10919579,10919586,10919589,10964484,10964490,10964493,10964498,10964501,10964503,11015088,11015089,11015095,11015099,11015102,11015108,11036231,11069320,11069321,11069327,11069331,11069334,11069340,11122420,11122425,11122430,11122431,11122438,11122441,11170238,11170243,11170248,11170249,11170256,11170259,11214180,11214185,11214190,11214191,11214198,11214201,11266982,11266983,11266989,11266993,11266996,11267002,11323142,11323143,11323149,11323153,11323156,11323162,11374670,11374671,11374677,11374681,11374684,11374690,11418304,11418309,11418314,11418315,11418322,11418325,11464398,11464403,11464408,11464409,11464416,11464419,11513680,11513685,11513690,11513691,11513698,11513701,11556640,11556641,11556647,11556651,11556654,11556660,11600368,11600369,11600375,11600379,11600382,11600388,11649196,11649197,11649203,11649207,11649210,11649216,11666262,11671318,11671319,11671325,11671329,11671332,11671338,11738907,11738908,11738914,11738918,11738921,11738927,11786810,11786815,11786818,11786823,11786826,11786831,11836976,11836981,11836984,11836989,11836992,11836997,11868632,11868637,11868639,11868645,11868648,11868650,11923920,11923925,11923927,11923933,11923936,11923938,11963787,11963788,11963794,11963798,11963801,11963807,12004006,12004011,12004013,12004019,12004022,12004024,12045187,12045188,12045194,12045198,12045201,12045207,12084451,12084456,12084461,12084462,12084469,12084472,20092,20093,20099,20103,20106,20112,71538,71543,71548,71549,71556,71559,111626,111631,111636,111637,111644,111647,158142,158147,158152,158153,158160,158163,192486,192491,192496,192497,192504,192507,232662,232667,232672,232673,232680,232683,272972,272973,272979,272983,272986,272992,312218,312219,312225,312229,312232,312238,356954,356955,356961,356965,356968,356974) ) 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) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 73548 WHERE `RP`.`player` = 73548 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125166,126352,128117,129018,130269,204097,206090,209377,209618,209709,280636,280639,280642,280645,280652,280655,338354,338357,338360,338363,338370,338373,10398410,10398413,10398416,10398419,10398426,10398429,10479440,10479443,10479446,10479449,10479456,10479459,10542182,10542185,10542188,10542191,10542198,10542201,10604870,10604873,10604876,10604879,10604886,10604889,10637429,10663144,10663147,10663150,10663153,10663160,10663163,10726317,10726319,10726326,10726329,10726332,10726338,10797062,10797068,10797071,10797076,10797079,10797081,10876749,10876751,10876758,10876761,10876764,10876770,10919570,10919573,10919576,10919579,10919586,10919589,10964484,10964490,10964493,10964498,10964501,10964503,11015088,11015089,11015095,11015099,11015102,11015108,11036231,11069320,11069321,11069327,11069331,11069334,11069340,11122420,11122425,11122430,11122431,11122438,11122441,11170238,11170243,11170248,11170249,11170256,11170259,11214180,11214185,11214190,11214191,11214198,11214201,11266982,11266983,11266989,11266993,11266996,11267002,11323142,11323143,11323149,11323153,11323156,11323162,11374670,11374671,11374677,11374681,11374684,11374690,11418304,11418309,11418314,11418315,11418322,11418325,11464398,11464403,11464408,11464409,11464416,11464419,11513680,11513685,11513690,11513691,11513698,11513701,11556640,11556641,11556647,11556651,11556654,11556660,11600368,11600369,11600375,11600379,11600382,11600388,11649196,11649197,11649203,11649207,11649210,11649216,11666262,11671318,11671319,11671325,11671329,11671332,11671338,11738907,11738908,11738914,11738918,11738921,11738927,11786810,11786815,11786818,11786823,11786826,11786831,11836976,11836981,11836984,11836989,11836992,11836997,11868632,11868637,11868639,11868645,11868648,11868650,11923920,11923925,11923927,11923933,11923936,11923938,11963787,11963788,11963794,11963798,11963801,11963807,12004006,12004011,12004013,12004019,12004022,12004024,12045187,12045188,12045194,12045198,12045201,12045207,12084451,12084456,12084461,12084462,12084469,12084472,20092,20093,20099,20103,20106,20112,71538,71543,71548,71549,71556,71559,111626,111631,111636,111637,111644,111647,158142,158147,158152,158153,158160,158163,192486,192491,192496,192497,192504,192507,232662,232667,232672,232673,232680,232683,272972,272973,272979,272983,272986,272992,312218,312219,312225,312229,312232,312238,356954,356955,356961,356965,356968,356974) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: