(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` = 39997 WHERE `RP`.`player` = 39997 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125197,126384,128143,129052,130667,131996,204126,206122,209403,209566,209652,210925,280684,280687,280690,280693,280700,280703,301756,338401,338403,338410,338413,338416,338422,10398527,10398532,10398535,10398540,10398543,10398548,10479414,10479420,10479423,10479428,10479431,10479433,10512416,10542035,10542040,10542043,10542048,10542051,10542056,10604868,10604874,10604877,10604882,10604885,10604887,10663143,10663145,10663152,10663155,10663158,10663164,10726293,10726295,10726302,10726305,10726308,10726314,10796941,10796946,10796949,10796954,10796957,10796962,10876628,10876634,10876637,10876642,10876645,10876647,10892852,10919592,10919598,10919601,10919606,10919609,10919611,10964581,10964583,10964590,10964593,10964596,10964602,11015184,11015185,11015191,11015195,11015198,11015204,11036228,11069247,11069252,11069254,11069260,11069263,11069265,11084873,11122230,11122231,11122237,11122241,11122244,11122250,11170334,11170339,11170344,11170345,11170352,11170355,11214108,11214113,11214118,11214119,11214126,11214129,11229097,11266836,11266841,11266846,11266847,11266854,11266857,11323044,11323049,11323054,11323055,11323062,11323065,11374524,11374529,11374534,11374535,11374542,11374545,11418400,11418405,11418410,11418411,11418418,11418421,11464542,11464547,11464552,11464553,11464560,11464563,11513512,11513517,11513522,11513523,11513530,11513533,11556758,11556763,11556768,11556769,11556776,11556779,11573281,11600366,11600371,11600376,11600377,11600384,11600387,11616920,11649386,11649391,11649396,11649397,11649404,11649407,11671460,11671465,11671470,11671471,11671478,11671481,11738881,11738886,11738891,11738892,11738899,11738902,11786691,11786696,11786701,11786702,11786709,11786712,11805208,11836787,11836788,11836794,11836798,11836801,11836807,11852594,11868585,11868586,11868592,11868596,11868599,11868605,11923897,11923898,11923904,11923908,11923911,11923917,11963857,11963862,11963867,11963868,11963875,11963878,12003934,12003939,12003941,12003947,12003950,12003952,12045330,12045335,12045337,12045343,12045346,12045348,12061181,12084548,12084553,12084555,12084561,12084564,12084566,12101111,19923,19928,19930,19936,19939,19941,71371,71376,71378,71384,71387,71389,85599,111555,111560,111562,111568,111571,111573,158095,158100,158102,158108,158111,158113,192512,192513,192519,192523,192526,192532,210092,232687,232692,232694,232700,232703,232705,272971,272976,272978,272984,272987,272989,312361,312366,312368,312374,312377,312379,357121,357126,357128,357134,357137,357139) ) 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` = 39997 WHERE `RP`.`player` = 39997 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125197,126384,128143,129052,130667,131996,204126,206122,209403,209566,209652,210925,280684,280687,280690,280693,280700,280703,301756,338401,338403,338410,338413,338416,338422,10398527,10398532,10398535,10398540,10398543,10398548,10479414,10479420,10479423,10479428,10479431,10479433,10512416,10542035,10542040,10542043,10542048,10542051,10542056,10604868,10604874,10604877,10604882,10604885,10604887,10663143,10663145,10663152,10663155,10663158,10663164,10726293,10726295,10726302,10726305,10726308,10726314,10796941,10796946,10796949,10796954,10796957,10796962,10876628,10876634,10876637,10876642,10876645,10876647,10892852,10919592,10919598,10919601,10919606,10919609,10919611,10964581,10964583,10964590,10964593,10964596,10964602,11015184,11015185,11015191,11015195,11015198,11015204,11036228,11069247,11069252,11069254,11069260,11069263,11069265,11084873,11122230,11122231,11122237,11122241,11122244,11122250,11170334,11170339,11170344,11170345,11170352,11170355,11214108,11214113,11214118,11214119,11214126,11214129,11229097,11266836,11266841,11266846,11266847,11266854,11266857,11323044,11323049,11323054,11323055,11323062,11323065,11374524,11374529,11374534,11374535,11374542,11374545,11418400,11418405,11418410,11418411,11418418,11418421,11464542,11464547,11464552,11464553,11464560,11464563,11513512,11513517,11513522,11513523,11513530,11513533,11556758,11556763,11556768,11556769,11556776,11556779,11573281,11600366,11600371,11600376,11600377,11600384,11600387,11616920,11649386,11649391,11649396,11649397,11649404,11649407,11671460,11671465,11671470,11671471,11671478,11671481,11738881,11738886,11738891,11738892,11738899,11738902,11786691,11786696,11786701,11786702,11786709,11786712,11805208,11836787,11836788,11836794,11836798,11836801,11836807,11852594,11868585,11868586,11868592,11868596,11868599,11868605,11923897,11923898,11923904,11923908,11923911,11923917,11963857,11963862,11963867,11963868,11963875,11963878,12003934,12003939,12003941,12003947,12003950,12003952,12045330,12045335,12045337,12045343,12045346,12045348,12061181,12084548,12084553,12084555,12084561,12084564,12084566,12101111,19923,19928,19930,19936,19939,19941,71371,71376,71378,71384,71387,71389,85599,111555,111560,111562,111568,111571,111573,158095,158100,158102,158108,158111,158113,192512,192513,192519,192523,192526,192532,210092,232687,232692,232694,232700,232703,232705,272971,272976,272978,272984,272987,272989,312361,312366,312368,312374,312377,312379,357121,357126,357128,357134,357137,357139) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: