(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` = 56978 WHERE `RP`.`player` = 56978 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125228,126326,128179,128992,130027,204161,206064,209439,209592,209683,280874,280880,280883,280888,280891,280893,338210,338213,338216,338219,338226,338229,10369068,10398092,10398098,10398101,10398106,10398109,10398111,10479199,10479201,10479208,10479211,10479214,10479220,10542349,10542351,10542358,10542361,10542364,10542370,10567341,10604508,10604514,10604517,10604522,10604525,10604527,10662782,10662788,10662791,10662796,10662799,10662801,10726412,10726418,10726421,10726426,10726429,10726431,10796823,10796825,10796832,10796835,10796838,10796844,10876269,10876271,10876278,10876281,10876284,10876290,10919928,10919934,10919937,10919942,10919945,10919947,10964291,10964293,10964300,10964303,10964306,10964312,11014750,11014755,11014760,11014761,11014768,11014771,11036242,11069557,11069562,11069565,11069570,11069573,11069578,11122203,11122208,11122211,11122216,11122219,11122224,11170647,11170652,11170654,11170660,11170663,11170665,11186265,11213797,11213802,11213804,11213810,11213813,11213815,11266475,11266480,11266483,11266488,11266491,11266496,11323405,11323410,11323412,11323418,11323421,11323423,11374885,11374890,11374892,11374898,11374901,11374903,11391970,11418687,11418692,11418695,11418700,11418703,11418708,11464709,11464714,11464717,11464722,11464725,11464730,11513799,11513804,11513807,11513812,11513815,11513820,11557024,11557025,11557031,11557035,11557038,11557044,11600560,11600561,11600567,11600571,11600574,11600580,11649482,11649487,11649492,11649493,11649500,11649503,11671582,11671583,11671589,11671593,11671596,11671602,11739361,11739366,11739371,11739372,11739379,11739382,11786885,11786886,11786892,11786896,11786899,11786905,11837147,11837148,11837154,11837158,11837161,11837167,11869015,11869020,11869025,11869026,11869033,11869036,11923943,11923948,11923953,11923954,11923961,11923964,11964243,11964244,11964250,11964254,11964257,11964263,12004318,12004323,12004325,12004331,12004334,12004336,12045520,12045525,12045528,12045533,12045536,12045541,12084692,12084697,12084699,12084705,12084708,12084710,20258,20263,20268,20269,20276,20279,71802,71807,71812,71813,71820,71823,85606,111842,111847,111852,111853,111860,111863,158382,158387,158392,158393,158400,158403,192774,192779,192784,192785,192792,192795,232254,232259,232264,232265,232272,232275,273426,273431,273436,273437,273444,273447,312552,312557,312562,312563,312570,312573,357240,357245,357250,357251,357258,357261) ) 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` = 56978 WHERE `RP`.`player` = 56978 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125228,126326,128179,128992,130027,204161,206064,209439,209592,209683,280874,280880,280883,280888,280891,280893,338210,338213,338216,338219,338226,338229,10369068,10398092,10398098,10398101,10398106,10398109,10398111,10479199,10479201,10479208,10479211,10479214,10479220,10542349,10542351,10542358,10542361,10542364,10542370,10567341,10604508,10604514,10604517,10604522,10604525,10604527,10662782,10662788,10662791,10662796,10662799,10662801,10726412,10726418,10726421,10726426,10726429,10726431,10796823,10796825,10796832,10796835,10796838,10796844,10876269,10876271,10876278,10876281,10876284,10876290,10919928,10919934,10919937,10919942,10919945,10919947,10964291,10964293,10964300,10964303,10964306,10964312,11014750,11014755,11014760,11014761,11014768,11014771,11036242,11069557,11069562,11069565,11069570,11069573,11069578,11122203,11122208,11122211,11122216,11122219,11122224,11170647,11170652,11170654,11170660,11170663,11170665,11186265,11213797,11213802,11213804,11213810,11213813,11213815,11266475,11266480,11266483,11266488,11266491,11266496,11323405,11323410,11323412,11323418,11323421,11323423,11374885,11374890,11374892,11374898,11374901,11374903,11391970,11418687,11418692,11418695,11418700,11418703,11418708,11464709,11464714,11464717,11464722,11464725,11464730,11513799,11513804,11513807,11513812,11513815,11513820,11557024,11557025,11557031,11557035,11557038,11557044,11600560,11600561,11600567,11600571,11600574,11600580,11649482,11649487,11649492,11649493,11649500,11649503,11671582,11671583,11671589,11671593,11671596,11671602,11739361,11739366,11739371,11739372,11739379,11739382,11786885,11786886,11786892,11786896,11786899,11786905,11837147,11837148,11837154,11837158,11837161,11837167,11869015,11869020,11869025,11869026,11869033,11869036,11923943,11923948,11923953,11923954,11923961,11923964,11964243,11964244,11964250,11964254,11964257,11964263,12004318,12004323,12004325,12004331,12004334,12004336,12045520,12045525,12045528,12045533,12045536,12045541,12084692,12084697,12084699,12084705,12084708,12084710,20258,20263,20268,20269,20276,20279,71802,71807,71812,71813,71820,71823,85606,111842,111847,111852,111853,111860,111863,158382,158387,158392,158393,158400,158403,192774,192779,192784,192785,192792,192795,232254,232259,232264,232265,232272,232275,273426,273431,273436,273437,273444,273447,312552,312557,312562,312563,312570,312573,357240,357245,357250,357251,357258,357261) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: