(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` = 83074 WHERE `RP`.`player` = 83074 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125234,126332,128185,128998,130033,204167,206070,209445,209598,209689,280852,280855,280858,280861,280868,280871,338306,338309,338312,338315,338322,338325,10398262,10398265,10398268,10398271,10398278,10398281,10479224,10479227,10479230,10479233,10479240,10479243,10542422,10542425,10542428,10542431,10542438,10542441,10604438,10604441,10604444,10604447,10604454,10604457,10662784,10662787,10662790,10662793,10662800,10662803,10690380,10691358,10691363,10691368,10692380,10726582,10726585,10726588,10726591,10726598,10726601,10796800,10796803,10796806,10796809,10796816,10796819,10876318,10876321,10876324,10876327,10876334,10876337,10919953,10919955,10919962,10919965,10919968,10919974,10937957,10937962,10937965,10939495,10940491,10941589,10964385,10964390,10964393,10964398,10964401,10964406,10982953,10982958,10982961,11014725,11014730,11014733,11014738,11014741,11014746,11069533,11069538,11069541,11069546,11069549,11069554,11084882,11122205,11122210,11122212,11122218,11122221,11122223,11139737,11140300,11140301,11140307,11170504,11170505,11170511,11170515,11170518,11170524,11186649,11186654,11186656,11188252,11213893,11213898,11213900,11213906,11213909,11213911,11266524,11266529,11266534,11266535,11266542,11266545,11323332,11323337,11323342,11323343,11323350,11323353,11374836,11374841,11374846,11374847,11374854,11374857,11418762,11418763,11418769,11418773,11418776,11418782,11434216,11434217,11434223,11464783,11464788,11464790,11464796,11464799,11464801,11513777,11513782,11513784,11513790,11513793,11513795,11556952,11556953,11556959,11556963,11556966,11556972,11600584,11600585,11600591,11600595,11600598,11600604,11618510,11618511,11618517,11649435,11649440,11649442,11649448,11649451,11649453,11666272,11667156,11667161,11667166,11667368,11668035,11668171,11671675,11671680,11671683,11671688,11671691,11671696,11739314,11739319,11739321,11739327,11739330,11739332,11787053,11787054,11787060,11787064,11787067,11787073,11805218,11837194,11837199,11837201,11837207,11837210,11837212,11853467,11853468,11853474,11869040,11869045,11869047,11869053,11869056,11869058,11895844,11896699,11896704,11896709,11924040,11924045,11924047,11924053,11924056,11924058,11964242,11964247,11964249,11964255,11964258,11964260,12004413,12004418,12004423,12004424,12004431,12004434,12045545,12045550,12045555,12045556,12045563,12045566,12084619,12084624,12084629,12084630,12084637,12084640,20234,20239,20244,20245,20252,20255,47386,71826,71831,71836,71837,71844,71847,111866,111871,111876,111877,111884,111887,127056,127057,127063,158576,158577,158583,158587,158590,158596,192942,192947,192952,192953,192960,192963,210108,232208,232209,232215,232219,232222,232228,273452,273453,273459,273463,273466,273472,312528,312533,312538,312539,312546,312549,333268,333269,333275,333582,357338,357339,357345,357349,357352,357358,371998) ) 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` = 83074 WHERE `RP`.`player` = 83074 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125234,126332,128185,128998,130033,204167,206070,209445,209598,209689,280852,280855,280858,280861,280868,280871,338306,338309,338312,338315,338322,338325,10398262,10398265,10398268,10398271,10398278,10398281,10479224,10479227,10479230,10479233,10479240,10479243,10542422,10542425,10542428,10542431,10542438,10542441,10604438,10604441,10604444,10604447,10604454,10604457,10662784,10662787,10662790,10662793,10662800,10662803,10690380,10691358,10691363,10691368,10692380,10726582,10726585,10726588,10726591,10726598,10726601,10796800,10796803,10796806,10796809,10796816,10796819,10876318,10876321,10876324,10876327,10876334,10876337,10919953,10919955,10919962,10919965,10919968,10919974,10937957,10937962,10937965,10939495,10940491,10941589,10964385,10964390,10964393,10964398,10964401,10964406,10982953,10982958,10982961,11014725,11014730,11014733,11014738,11014741,11014746,11069533,11069538,11069541,11069546,11069549,11069554,11084882,11122205,11122210,11122212,11122218,11122221,11122223,11139737,11140300,11140301,11140307,11170504,11170505,11170511,11170515,11170518,11170524,11186649,11186654,11186656,11188252,11213893,11213898,11213900,11213906,11213909,11213911,11266524,11266529,11266534,11266535,11266542,11266545,11323332,11323337,11323342,11323343,11323350,11323353,11374836,11374841,11374846,11374847,11374854,11374857,11418762,11418763,11418769,11418773,11418776,11418782,11434216,11434217,11434223,11464783,11464788,11464790,11464796,11464799,11464801,11513777,11513782,11513784,11513790,11513793,11513795,11556952,11556953,11556959,11556963,11556966,11556972,11600584,11600585,11600591,11600595,11600598,11600604,11618510,11618511,11618517,11649435,11649440,11649442,11649448,11649451,11649453,11666272,11667156,11667161,11667166,11667368,11668035,11668171,11671675,11671680,11671683,11671688,11671691,11671696,11739314,11739319,11739321,11739327,11739330,11739332,11787053,11787054,11787060,11787064,11787067,11787073,11805218,11837194,11837199,11837201,11837207,11837210,11837212,11853467,11853468,11853474,11869040,11869045,11869047,11869053,11869056,11869058,11895844,11896699,11896704,11896709,11924040,11924045,11924047,11924053,11924056,11924058,11964242,11964247,11964249,11964255,11964258,11964260,12004413,12004418,12004423,12004424,12004431,12004434,12045545,12045550,12045555,12045556,12045563,12045566,12084619,12084624,12084629,12084630,12084637,12084640,20234,20239,20244,20245,20252,20255,47386,71826,71831,71836,71837,71844,71847,111866,111871,111876,111877,111884,111887,127056,127057,127063,158576,158577,158583,158587,158590,158596,192942,192947,192952,192953,192960,192963,210108,232208,232209,232215,232219,232222,232228,273452,273453,273459,273463,273466,273472,312528,312533,312538,312539,312546,312549,333268,333269,333275,333582,357338,357339,357345,357349,357352,357358,371998) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: