(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` = 27424 WHERE `RP`.`player` = 27424 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125226,126329,128178,128994,130025,204159,206065,209440,209594,209681,280732,280735,280738,280741,280748,280751,338137,338139,338146,338149,338152,338158,10398166,10398169,10398172,10398175,10398182,10398185,10479078,10479084,10479087,10479092,10479095,10479097,10542420,10542426,10542429,10542434,10542437,10542439,10604436,10604442,10604445,10604450,10604453,10604455,10662950,10662956,10662959,10662964,10662967,10662969,10726485,10726487,10726494,10726497,10726500,10726506,10796680,10796683,10796686,10796689,10796696,10796699,10876414,10876417,10876420,10876423,10876430,10876433,10919857,10919859,10919866,10919869,10919872,10919878,10964196,10964199,10964202,10964205,10964212,10964215,11014894,11014899,11014904,11014905,11014912,11014915,11069534,11069539,11069544,11069545,11069552,11069555,11122012,11122017,11122022,11122023,11122030,11122033,11170622,11170627,11170632,11170633,11170640,11170643,11213940,11213945,11213950,11213951,11213958,11213961,11266644,11266649,11266654,11266655,11266662,11266665,11323236,11323241,11323246,11323247,11323254,11323257,11374980,11374985,11374990,11374991,11374998,11375001,11418592,11418597,11418602,11418603,11418610,11418613,11464614,11464619,11464624,11464625,11464632,11464635,11513968,11513973,11513978,11513979,11513986,11513989,11556878,11556883,11556888,11556889,11556896,11556899,11600774,11600779,11600784,11600785,11600792,11600795,11649602,11649607,11649612,11649613,11649620,11649623,11671508,11671513,11671518,11671519,11671526,11671529,11711140,11739241,11739246,11739251,11739252,11739259,11739262,11787099,11787104,11787109,11787110,11787117,11787120,11837121,11837126,11837131,11837132,11837139,11837142,11868967,11868972,11868977,11868978,11868985,11868988,11924015,11924020,11924025,11924026,11924033,11924036,11964195,11964196,11964202,11964206,11964209,11964215,12004367,12004368,12004374,12004378,12004381,12004387,12045499,12045500,12045506,12045510,12045513,12045519,12061188,12084596,12084601,12084603,12084609,12084612,12084614,20137,20142,20145,20150,20153,20158,71708,71709,71715,71719,71722,71728,111770,111775,111780,111781,111788,111791,158526,158531,158536,158537,158544,158547,192894,192899,192904,192905,192912,192915,210101,232422,232427,232432,232433,232440,232443,273404,273405,273411,273415,273418,273424,312504,312509,312514,312515,312522,312525,357384,357389,357394,357395,357402,357405) ) 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` = 27424 WHERE `RP`.`player` = 27424 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125226,126329,128178,128994,130025,204159,206065,209440,209594,209681,280732,280735,280738,280741,280748,280751,338137,338139,338146,338149,338152,338158,10398166,10398169,10398172,10398175,10398182,10398185,10479078,10479084,10479087,10479092,10479095,10479097,10542420,10542426,10542429,10542434,10542437,10542439,10604436,10604442,10604445,10604450,10604453,10604455,10662950,10662956,10662959,10662964,10662967,10662969,10726485,10726487,10726494,10726497,10726500,10726506,10796680,10796683,10796686,10796689,10796696,10796699,10876414,10876417,10876420,10876423,10876430,10876433,10919857,10919859,10919866,10919869,10919872,10919878,10964196,10964199,10964202,10964205,10964212,10964215,11014894,11014899,11014904,11014905,11014912,11014915,11069534,11069539,11069544,11069545,11069552,11069555,11122012,11122017,11122022,11122023,11122030,11122033,11170622,11170627,11170632,11170633,11170640,11170643,11213940,11213945,11213950,11213951,11213958,11213961,11266644,11266649,11266654,11266655,11266662,11266665,11323236,11323241,11323246,11323247,11323254,11323257,11374980,11374985,11374990,11374991,11374998,11375001,11418592,11418597,11418602,11418603,11418610,11418613,11464614,11464619,11464624,11464625,11464632,11464635,11513968,11513973,11513978,11513979,11513986,11513989,11556878,11556883,11556888,11556889,11556896,11556899,11600774,11600779,11600784,11600785,11600792,11600795,11649602,11649607,11649612,11649613,11649620,11649623,11671508,11671513,11671518,11671519,11671526,11671529,11711140,11739241,11739246,11739251,11739252,11739259,11739262,11787099,11787104,11787109,11787110,11787117,11787120,11837121,11837126,11837131,11837132,11837139,11837142,11868967,11868972,11868977,11868978,11868985,11868988,11924015,11924020,11924025,11924026,11924033,11924036,11964195,11964196,11964202,11964206,11964209,11964215,12004367,12004368,12004374,12004378,12004381,12004387,12045499,12045500,12045506,12045510,12045513,12045519,12061188,12084596,12084601,12084603,12084609,12084612,12084614,20137,20142,20145,20150,20153,20158,71708,71709,71715,71719,71722,71728,111770,111775,111780,111781,111788,111791,158526,158531,158536,158537,158544,158547,192894,192899,192904,192905,192912,192915,210101,232422,232427,232432,232433,232440,232443,273404,273405,273411,273415,273418,273424,312504,312509,312514,312515,312522,312525,357384,357389,357394,357395,357402,357405) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: