(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, 207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 56076 WHERE `RP`.`player` = 56076 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125203,126390,128149,129058,130303,204132,206128,209409,209658,209741,246877,246882,246885,250355,250960,251093,280681,280686,280689,280694,280697,280702,303503,303508,303510,303659,338351,338356,338359,338364,338367,338372,10398553,10398555,10398562,10398565,10398568,10398574,10479391,10479393,10479400,10479403,10479406,10479412,10542061,10542063,10542070,10542073,10542076,10542082,10604918,10604921,10604924,10604927,10604934,10604937,10639502,10639503,10639509,10663095,10663097,10663104,10663107,10663110,10663116,10726318,10726321,10726324,10726327,10726334,10726337,10758420,10758421,10758427,10760385,10797063,10797065,10797072,10797075,10797078,10797084,10826220,10826221,10826227,10826536,10826635,10827312,10876532,10876538,10876541,10876546,10876549,10876551,10893699,10893704,10893706,10919759,10919764,10919767,10919772,10919775,10919780,10964460,10964466,10964469,10964474,10964477,10964479,11015160,11015161,11015167,11015171,11015174,11015180,11069294,11069299,11069304,11069305,11069312,11069315,11122350,11122351,11122357,11122361,11122364,11122370,11170310,11170315,11170320,11170321,11170328,11170331,11214206,11214207,11214213,11214217,11214220,11214226,11266933,11266938,11266940,11266946,11266949,11266951,11323093,11323098,11323100,11323106,11323109,11323111,11337867,11339740,11339741,11339747,11374765,11374770,11374772,11374778,11374781,11374783,11391965,11418497,11418502,11418504,11418510,11418513,11418515,11434129,11434134,11434137,11435323,11464349,11464354,11464357,11464362,11464365,11464370,11481161,11481166,11481169,11513511,11513516,11513519,11513524,11513527,11513532,11531529,11531534,11531536,11556613,11556618,11556621,11556626,11556629,11556634,11574717,11574722,11574724,11600365,11600370,11600373,11600378,11600381,11600386,11618474,11618475,11618481,11619492,11649387,11649392,11649394,11649400,11649403,11649405,11666268,11671341,11671346,11671348,11671354,11671357,11671359,11738906,11738911,11738913,11738919,11738922,11738924,11786692,11786697,11786699,11786705,11786708,11786710,11837001,11837006,11837011,11837012,11837019,11837022,11868559,11868564,11868569,11868570,11868577,11868580,11923919,11923924,11923929,11923930,11923937,11923940,11963809,11963814,11963819,11963820,11963827,11963830,12004077,12004082,12004087,12004088,12004095,12004098,12021446,12021451,12021453,12045306,12045311,12045313,12045319,12045322,12045324,12061178,12084476,12084481,12084483,12084489,12084492,12084494,19899,19904,19906,19912,19915,19917,47374,48110,48115,48120,71491,71496,71498,71504,71507,71509,111459,111464,111466,111472,111475,111477,158096,158097,158103,158107,158110,158116,173626,173627,173633,174564,174668,175361,192533,192538,192541,192546,192549,192554,210094,232495,232500,232502,232508,232511,232513,247340,248116,248121,248126,273017,273022,273025,273030,273033,273038,288813,288818,288821,289787,290018,290578,312383,312388,312391,312396,312399,312404,331801,333230,333235,333240,333568,334620,334997,356975,356980,356983,356988,356991,356996,371993,372786,372787,372793,373739) ) 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, 207) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 56076 WHERE `RP`.`player` = 56076 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125203,126390,128149,129058,130303,204132,206128,209409,209658,209741,246877,246882,246885,250355,250960,251093,280681,280686,280689,280694,280697,280702,303503,303508,303510,303659,338351,338356,338359,338364,338367,338372,10398553,10398555,10398562,10398565,10398568,10398574,10479391,10479393,10479400,10479403,10479406,10479412,10542061,10542063,10542070,10542073,10542076,10542082,10604918,10604921,10604924,10604927,10604934,10604937,10639502,10639503,10639509,10663095,10663097,10663104,10663107,10663110,10663116,10726318,10726321,10726324,10726327,10726334,10726337,10758420,10758421,10758427,10760385,10797063,10797065,10797072,10797075,10797078,10797084,10826220,10826221,10826227,10826536,10826635,10827312,10876532,10876538,10876541,10876546,10876549,10876551,10893699,10893704,10893706,10919759,10919764,10919767,10919772,10919775,10919780,10964460,10964466,10964469,10964474,10964477,10964479,11015160,11015161,11015167,11015171,11015174,11015180,11069294,11069299,11069304,11069305,11069312,11069315,11122350,11122351,11122357,11122361,11122364,11122370,11170310,11170315,11170320,11170321,11170328,11170331,11214206,11214207,11214213,11214217,11214220,11214226,11266933,11266938,11266940,11266946,11266949,11266951,11323093,11323098,11323100,11323106,11323109,11323111,11337867,11339740,11339741,11339747,11374765,11374770,11374772,11374778,11374781,11374783,11391965,11418497,11418502,11418504,11418510,11418513,11418515,11434129,11434134,11434137,11435323,11464349,11464354,11464357,11464362,11464365,11464370,11481161,11481166,11481169,11513511,11513516,11513519,11513524,11513527,11513532,11531529,11531534,11531536,11556613,11556618,11556621,11556626,11556629,11556634,11574717,11574722,11574724,11600365,11600370,11600373,11600378,11600381,11600386,11618474,11618475,11618481,11619492,11649387,11649392,11649394,11649400,11649403,11649405,11666268,11671341,11671346,11671348,11671354,11671357,11671359,11738906,11738911,11738913,11738919,11738922,11738924,11786692,11786697,11786699,11786705,11786708,11786710,11837001,11837006,11837011,11837012,11837019,11837022,11868559,11868564,11868569,11868570,11868577,11868580,11923919,11923924,11923929,11923930,11923937,11923940,11963809,11963814,11963819,11963820,11963827,11963830,12004077,12004082,12004087,12004088,12004095,12004098,12021446,12021451,12021453,12045306,12045311,12045313,12045319,12045322,12045324,12061178,12084476,12084481,12084483,12084489,12084492,12084494,19899,19904,19906,19912,19915,19917,47374,48110,48115,48120,71491,71496,71498,71504,71507,71509,111459,111464,111466,111472,111475,111477,158096,158097,158103,158107,158110,158116,173626,173627,173633,174564,174668,175361,192533,192538,192541,192546,192549,192554,210094,232495,232500,232502,232508,232511,232513,247340,248116,248121,248126,273017,273022,273025,273030,273033,273038,288813,288818,288821,289787,290018,290578,312383,312388,312391,312396,312399,312404,331801,333230,333235,333240,333568,334620,334997,356975,356980,356983,356988,356991,356996,371993,372786,372787,372793,373739) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: