(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(207) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 79220 WHERE `RP`.`player` = 79220 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303540,303541,303547,303665,304763,305272,10441235,10441240,10441242,10442092,10513305,10513310,10513313,10514092,10569161,10569166,10569169,10691432,10691433,10691439,10692383,10692495,10693167,10826219,10826224,10826226,10893709,10893714,10893717,10893994,10894524,10895371,10937984,10937985,10937991,10939485,10940488,10941587,10982908,10982909,10982915,10983323,10984028,10985559,11038341,11038346,11038348,11038757,11038882,11038973,11140225,11140230,11140233,11229589,11229594,11229597,11230826,11231872,11232732,11286139,11286144,11286147,11286591,11286744,11287743,11339749,11339754,11339757,11340348,11434165,11434170,11434173,11435331,11435977,11436212,11481173,11481178,11481181,11481628,11481770,11481865,11531539,11531544,11531547,11531951,11574727,11574732,11574735,11575581,11575875,11576023,11618471,11618476,11618479,11667107,11667112,11667115,11667360,11668031,11668173,11711962,11711967,11711970,11713166,11713640,11713762,11805264,11805269,11805272,11806993,11807250,11807846,11853392,11853397,11853400,11896650,11896655,11896658,11980405,11980406,11980412,11981357,11981678,11982829,12021447,12021448,12021454,12021992,12022382,12022499,12061917,12061918,12061924,12101924,12101929,12101932,12102549,48088,48089,48095,48353,48814,49098,86431,86436,86439,87279,127029,127034,127037,128619,173611,173616,173619,174570,174665,175364,210914,210915,210921,248139,248144,248147,249066,288804,288805,288811,333231,333236,333238,333571,372796,372801,372806,373740,374296,374532) ) 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(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` = 79220 WHERE `RP`.`player` = 79220 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (303540,303541,303547,303665,304763,305272,10441235,10441240,10441242,10442092,10513305,10513310,10513313,10514092,10569161,10569166,10569169,10691432,10691433,10691439,10692383,10692495,10693167,10826219,10826224,10826226,10893709,10893714,10893717,10893994,10894524,10895371,10937984,10937985,10937991,10939485,10940488,10941587,10982908,10982909,10982915,10983323,10984028,10985559,11038341,11038346,11038348,11038757,11038882,11038973,11140225,11140230,11140233,11229589,11229594,11229597,11230826,11231872,11232732,11286139,11286144,11286147,11286591,11286744,11287743,11339749,11339754,11339757,11340348,11434165,11434170,11434173,11435331,11435977,11436212,11481173,11481178,11481181,11481628,11481770,11481865,11531539,11531544,11531547,11531951,11574727,11574732,11574735,11575581,11575875,11576023,11618471,11618476,11618479,11667107,11667112,11667115,11667360,11668031,11668173,11711962,11711967,11711970,11713166,11713640,11713762,11805264,11805269,11805272,11806993,11807250,11807846,11853392,11853397,11853400,11896650,11896655,11896658,11980405,11980406,11980412,11981357,11981678,11982829,12021447,12021448,12021454,12021992,12022382,12022499,12061917,12061918,12061924,12101924,12101929,12101932,12102549,48088,48089,48095,48353,48814,49098,86431,86436,86439,87279,127029,127034,127037,128619,173611,173616,173619,174570,174665,175364,210914,210915,210921,248139,248144,248147,249066,288804,288805,288811,333231,333236,333238,333571,372796,372801,372806,373740,374296,374532) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: