(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` = 7609 WHERE `RP`.`player` = 7609 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125175,126365,128126,129033,130276,204104,206101,209388,209631,209718,280587,280589,280596,280599,280602,280608,303502,303507,303512,303666,338592,338598,338601,338606,338609,338611,10370781,10370786,10370789,10398480,10398486,10398489,10398494,10398497,10398499,10440287,10441272,10441273,10441279,10479438,10479444,10479447,10479452,10479455,10479457,10542036,10542042,10542045,10542050,10542053,10542055,10567357,10569174,10569179,10569184,10570030,10604700,10604706,10604709,10604714,10604717,10604719,10637427,10663046,10663052,10663055,10663060,10663063,10663065,10726149,10726151,10726158,10726161,10726164,10726170,10797087,10797089,10797096,10797099,10797102,10797108,10826184,10826185,10826191,10826540,10826637,10827311,10876652,10876658,10876661,10876666,10876669,10876671,10892856,10893734,10893739,10893744,10919664,10919670,10919673,10919678,10919681,10919683,10936984,10964676,10964682,10964685,10964690,10964693,10964695,11014991,11014996,11014998,11015004,11015007,11015009,11069224,11069225,11069231,11069235,11069238,11069244,11122252,11122257,11122262,11122263,11122270,11122273,11170286,11170291,11170296,11170297,11170304,11170307,11214156,11214161,11214166,11214167,11214174,11214177,11229591,11229596,11229598,11230823,11231877,11232729,11266931,11266936,11266939,11266944,11266947,11266952,11284029,11322971,11322976,11322979,11322984,11322987,11322992,11339763,11339768,11339770,11340352,11374595,11374600,11374603,11374608,11374611,11374616,11392955,11392960,11392963,11394287,11418327,11418332,11418335,11418340,11418343,11418348,11434141,11434146,11434149,11464493,11464498,11464501,11464506,11464509,11464514,11479155,11481198,11481203,11481208,11513487,11513492,11513495,11513500,11513503,11513508,11531527,11531532,11531535,11531950,11556757,11556762,11556765,11556770,11556773,11556778,11600511,11600516,11600518,11600524,11600527,11600529,11616917,11649195,11649200,11649202,11649208,11649211,11649213,11671342,11671343,11671349,11671353,11671356,11671362,11711126,11711939,11711944,11711949,11738979,11738980,11738986,11738990,11738993,11738999,11756957,11786813,11786814,11786820,11786824,11786827,11786833,11805207,11805265,11805270,11805275,11836762,11836767,11836769,11836775,11836778,11836780,11853431,11853432,11853438,11868608,11868613,11868615,11868621,11868624,11868626,11895842,11923752,11923757,11923759,11923765,11923768,11923770,11963931,11963932,11963938,11963942,11963945,11963951,12004055,12004056,12004062,12004066,12004069,12004075,12021422,12021427,12021429,12021990,12022383,12022501,12045258,12045263,12045265,12045271,12045274,12045276,12061938,12061943,12061946,12062551,12062942,12063052,12084498,12084503,12084506,12084511,12084514,12084519,12101900,12101905,12101908,12102547,19873,19878,19881,19886,19889,19894,48109,48114,48117,48355,48813,49096,71513,71518,71521,71526,71529,71534,85602,86398,86399,86405,87273,111457,111462,111465,111470,111473,111478,126993,126998,127001,128620,128767,128856,158237,158242,158245,158250,158253,158258,173623,173628,173631,192557,192562,192565,192570,192573,192578,210937,210942,210944,212525,212671,212760,232661,232666,232669,232674,232677,232682,248115,248120,248123,249061,249222,249765,272969,272974,272977,272982,272985,272990,288002,312215,312220,312223,312228,312231,312236,357025,357030,357032,357038,357041,357043) ) 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` = 7609 WHERE `RP`.`player` = 7609 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (125175,126365,128126,129033,130276,204104,206101,209388,209631,209718,280587,280589,280596,280599,280602,280608,303502,303507,303512,303666,338592,338598,338601,338606,338609,338611,10370781,10370786,10370789,10398480,10398486,10398489,10398494,10398497,10398499,10440287,10441272,10441273,10441279,10479438,10479444,10479447,10479452,10479455,10479457,10542036,10542042,10542045,10542050,10542053,10542055,10567357,10569174,10569179,10569184,10570030,10604700,10604706,10604709,10604714,10604717,10604719,10637427,10663046,10663052,10663055,10663060,10663063,10663065,10726149,10726151,10726158,10726161,10726164,10726170,10797087,10797089,10797096,10797099,10797102,10797108,10826184,10826185,10826191,10826540,10826637,10827311,10876652,10876658,10876661,10876666,10876669,10876671,10892856,10893734,10893739,10893744,10919664,10919670,10919673,10919678,10919681,10919683,10936984,10964676,10964682,10964685,10964690,10964693,10964695,11014991,11014996,11014998,11015004,11015007,11015009,11069224,11069225,11069231,11069235,11069238,11069244,11122252,11122257,11122262,11122263,11122270,11122273,11170286,11170291,11170296,11170297,11170304,11170307,11214156,11214161,11214166,11214167,11214174,11214177,11229591,11229596,11229598,11230823,11231877,11232729,11266931,11266936,11266939,11266944,11266947,11266952,11284029,11322971,11322976,11322979,11322984,11322987,11322992,11339763,11339768,11339770,11340352,11374595,11374600,11374603,11374608,11374611,11374616,11392955,11392960,11392963,11394287,11418327,11418332,11418335,11418340,11418343,11418348,11434141,11434146,11434149,11464493,11464498,11464501,11464506,11464509,11464514,11479155,11481198,11481203,11481208,11513487,11513492,11513495,11513500,11513503,11513508,11531527,11531532,11531535,11531950,11556757,11556762,11556765,11556770,11556773,11556778,11600511,11600516,11600518,11600524,11600527,11600529,11616917,11649195,11649200,11649202,11649208,11649211,11649213,11671342,11671343,11671349,11671353,11671356,11671362,11711126,11711939,11711944,11711949,11738979,11738980,11738986,11738990,11738993,11738999,11756957,11786813,11786814,11786820,11786824,11786827,11786833,11805207,11805265,11805270,11805275,11836762,11836767,11836769,11836775,11836778,11836780,11853431,11853432,11853438,11868608,11868613,11868615,11868621,11868624,11868626,11895842,11923752,11923757,11923759,11923765,11923768,11923770,11963931,11963932,11963938,11963942,11963945,11963951,12004055,12004056,12004062,12004066,12004069,12004075,12021422,12021427,12021429,12021990,12022383,12022501,12045258,12045263,12045265,12045271,12045274,12045276,12061938,12061943,12061946,12062551,12062942,12063052,12084498,12084503,12084506,12084511,12084514,12084519,12101900,12101905,12101908,12102547,19873,19878,19881,19886,19889,19894,48109,48114,48117,48355,48813,49096,71513,71518,71521,71526,71529,71534,85602,86398,86399,86405,87273,111457,111462,111465,111470,111473,111478,126993,126998,127001,128620,128767,128856,158237,158242,158245,158250,158253,158258,173623,173628,173631,192557,192562,192565,192570,192573,192578,210937,210942,210944,212525,212671,212760,232661,232666,232669,232674,232677,232682,248115,248120,248123,249061,249222,249765,272969,272974,272977,272982,272985,272990,288002,312215,312220,312223,312228,312231,312236,357025,357030,357032,357038,357041,357043) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: