(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` = 12345 WHERE `RP`.`player` = 12345 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125183,126368,129041,130286,130659,131994,204112,206106,209564,209639,210917,209726,246903,246908,246910,250354,280561,280566,280569,280574,280577,280582,338400,338406,338409,338414,338417,338419,10369077,10398361,10398363,10398370,10398373,10398376,10398382,10479319,10479321,10479328,10479331,10479334,10479340,10513295,10513300,10513302,10514088,10542180,10542186,10542189,10542194,10542197,10542199,10567356,10569186,10569191,10569196,10570034,10604795,10604800,10604803,10604808,10604811,10604816,10663022,10663028,10663031,10663036,10663039,10663041,10690363,10691418,10691423,10691428,10692382,10692496,10693165,10726172,10726178,10726181,10726186,10726189,10726191,10796848,10796851,10796854,10796857,10796864,10796867,10876654,10876657,10876660,10876663,10876670,10876673,10919714,10919717,10919720,10919723,10919730,10919733,10964510,10964513,10964516,10964519,10964526,10964529,11015086,11015091,11015096,11015097,11015104,11015107,11038354,11038355,11038361,11069414,11069419,11069424,11069425,11069432,11069435,11084870,11085784,11085789,11085794,11122397,11122402,11122404,11122410,11122413,11122415,11170455,11170460,11170462,11170468,11170471,11170473,11214181,11214186,11214188,11214194,11214197,11214199,11266932,11266937,11266942,11266943,11266950,11266953,11323140,11323145,11323150,11323151,11323158,11323161,11374548,11374553,11374558,11374559,11374566,11374569,11418448,11418453,11418458,11418459,11418466,11418469,11433510,11464544,11464545,11464551,11464555,11464558,11464564,11513608,11513613,11513618,11513619,11513626,11513629,11531518,11531519,11531525,11556760,11556761,11556767,11556771,11556774,11556780,11600344,11600345,11600351,11600355,11600358,11600364,11616921,11649364,11649365,11649371,11649375,11649378,11649384,11667098,11667099,11667105,11667359,11671293,11671298,11671300,11671306,11671309,11671311,11711131,11711953,11711954,11711960,11713165,11713641,11713756,11738928,11738933,11738936,11738941,11738944,11738949,11757786,11757791,11757794,11786812,11786817,11786819,11786825,11786828,11786830,11836835,11836836,11836842,11836846,11836849,11836855,11852600,11853429,11853434,11853439,11868800,11868805,11868807,11868813,11868816,11868818,11895837,11923872,11923877,11923879,11923885,11923888,11923890,11963834,11963839,11963841,11963847,11963850,11963852,11980322,12003935,12003936,12003942,12003946,12003949,12003955,12021434,12021439,12021441,12045282,12045287,12045289,12045295,12045298,12045300,12061176,12084428,12084433,12084435,12084441,12084444,12084446,12101107,19996,19997,20003,20007,20010,20016,71420,71421,71427,71431,71434,71440,111508,111509,111515,111519,111522,111528,126195,127018,127023,127028,128615,128769,128857,158335,158340,158342,158348,158351,158353,192631,192636,192638,192644,192647,192649,210093,210924,210929,210934,232711,232716,232718,232724,232727,232729,273164,273165,273171,273175,273178,273184,312360,312365,312370,312371,312378,312381,357096,357101,357106,357107,357114,357117) ) 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` = 12345 WHERE `RP`.`player` = 12345 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125183,126368,129041,130286,130659,131994,204112,206106,209564,209639,210917,209726,246903,246908,246910,250354,280561,280566,280569,280574,280577,280582,338400,338406,338409,338414,338417,338419,10369077,10398361,10398363,10398370,10398373,10398376,10398382,10479319,10479321,10479328,10479331,10479334,10479340,10513295,10513300,10513302,10514088,10542180,10542186,10542189,10542194,10542197,10542199,10567356,10569186,10569191,10569196,10570034,10604795,10604800,10604803,10604808,10604811,10604816,10663022,10663028,10663031,10663036,10663039,10663041,10690363,10691418,10691423,10691428,10692382,10692496,10693165,10726172,10726178,10726181,10726186,10726189,10726191,10796848,10796851,10796854,10796857,10796864,10796867,10876654,10876657,10876660,10876663,10876670,10876673,10919714,10919717,10919720,10919723,10919730,10919733,10964510,10964513,10964516,10964519,10964526,10964529,11015086,11015091,11015096,11015097,11015104,11015107,11038354,11038355,11038361,11069414,11069419,11069424,11069425,11069432,11069435,11084870,11085784,11085789,11085794,11122397,11122402,11122404,11122410,11122413,11122415,11170455,11170460,11170462,11170468,11170471,11170473,11214181,11214186,11214188,11214194,11214197,11214199,11266932,11266937,11266942,11266943,11266950,11266953,11323140,11323145,11323150,11323151,11323158,11323161,11374548,11374553,11374558,11374559,11374566,11374569,11418448,11418453,11418458,11418459,11418466,11418469,11433510,11464544,11464545,11464551,11464555,11464558,11464564,11513608,11513613,11513618,11513619,11513626,11513629,11531518,11531519,11531525,11556760,11556761,11556767,11556771,11556774,11556780,11600344,11600345,11600351,11600355,11600358,11600364,11616921,11649364,11649365,11649371,11649375,11649378,11649384,11667098,11667099,11667105,11667359,11671293,11671298,11671300,11671306,11671309,11671311,11711131,11711953,11711954,11711960,11713165,11713641,11713756,11738928,11738933,11738936,11738941,11738944,11738949,11757786,11757791,11757794,11786812,11786817,11786819,11786825,11786828,11786830,11836835,11836836,11836842,11836846,11836849,11836855,11852600,11853429,11853434,11853439,11868800,11868805,11868807,11868813,11868816,11868818,11895837,11923872,11923877,11923879,11923885,11923888,11923890,11963834,11963839,11963841,11963847,11963850,11963852,11980322,12003935,12003936,12003942,12003946,12003949,12003955,12021434,12021439,12021441,12045282,12045287,12045289,12045295,12045298,12045300,12061176,12084428,12084433,12084435,12084441,12084444,12084446,12101107,19996,19997,20003,20007,20010,20016,71420,71421,71427,71431,71434,71440,111508,111509,111515,111519,111522,111528,126195,127018,127023,127028,128615,128769,128857,158335,158340,158342,158348,158351,158353,192631,192636,192638,192644,192647,192649,210093,210924,210929,210934,232711,232716,232718,232724,232727,232729,273164,273165,273171,273175,273178,273184,312360,312365,312370,312371,312378,312381,357096,357101,357106,357107,357114,357117) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: