(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(141, 1406) AND `PG`.`played` = 1 LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 6543 WHERE `RP`.`player` = 6543 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107560,122084,123068,122091,123522,122868,123076,122247,123079,213121,214041,213124,214044,213126,214045,234849,235829,234852,235902,246470,247073,247409,249732,257347,257631,259713,263165,264535,277719,277915,281127,281313,283333,283341,299485,299640,300862,300944,301840,302681,301846,303404,337302,338933,342040,342118,345758,346769,372009,372157,373771,10368928,10386192,10398748,10399684,10403698,10404142,10406594,10436745,10440442,10440497,10441311,10441376,10441323,10441382,10441300,10441380,10442222,10443046,10443864,10464092,10466197,10464096,10466067,10481230,10481552,10482573,10483497,10510583,10511662,10512462,10512524,10514400,10514561,10540952,10541773,10542690,10543591,10568249,10570185,10570723,10570933,10599876,10602940,10605317,10605384,10608208,10608223,10637714,10638145,10639848,10639634,10639913,10640925,10640968,10641039,10641107,10648076,10661535,10661872,10664897,10665084,10690598,10693022,10708547,10710385,10710430,10728140,10728574,10730004,10731073,10757828,10758383,10758634,10758632,10760512,10760671,10760980,10771406,10771514,10773140,10774760,10777371,10777750,10779883,10780040,10797391,10795454,10799283,10799432,10825167,10825306,10826348,10826398,10826349,10826405,10826351,10826401,10826566,10826596,10826762,10827119,10827815,10828070,10839252,10839484,10840948,10841207,10842523,10876083,10892899,10893220,10893823,10893820,10893822,10893978,10894019,10894100,10894536,10894709,10895391,10895455,10904493,10904594,10906575,10906605,10920749,10920645,10937477,10937631,10938204,10938215,10938206,10939506,10939576,10940821,10940839,10941643,10941678,10948348,10948555,10963345,10963583,10981527,10983002,10983059,10983012,10983053,10983020,10983061,10983373,10983574,10984067,10984089,10985670,10985736,10999867,11000212,11016068,11016580,11036694,11038805,11038820,11038952,11038954,11039373,11039382,11055496,11055749,11067140,11067804,11070788,11070838,11086550,11086551,11087374,11087454,11087571,11087578,11087826,11088367,11107189,11108149,11108944,11109600,11121183,11121272,11139840,11140575,11140803,11140443,11140560,11140561,11140731,11141364,11141788,11141867,11141871,11142103,11142281,11157713,11158531,11186388,11187562,11187564,11188255,11188306,11188406,11188464,11188674,11189051,11195645,11198829,11213385,11214605,11229118,11230405,11230276,11230274,11231963,11232766,11232988,11238165,11240814,11242030,11243328,11245512,11246865,11246888,11253675,11253851,11267439,11267829,11284055,11286196,11286255,11286193,11286252,11286201,11286254,11286613,11286637,11286707,11287758,11288211,11302954,11302956,11305329,11305755,11314029,11320229,11337870,11337881,11339854,11339874,11339857,11339885,11339839,11339869,11340381,11340407,11341338,11341714,11341865,11341877,11342748,11342958,11360430,11360645,11361699,11362782,11374411,11375669,11392002,11392016,11393075,11393140,11393133,11393149,11393079,11393185,11394404,11394521,11394703,11394842,11394868,11395771,11395903,11397110,11397528,11416757,11416913,11433525,11434373,11434370,11434368,11435996,11440187,11440054,11449621,11450649,11449623,11450660,11479180,11479205,11481399,11481385,11481403,11481368,11481401,11481365,11481653,11481684,11481801,11481843,11481886,11481910,11494304,11496005,11501008,11501228,11501107,11501263,11514112,11515547,11530241,11532004,11532644,11533189,11538375,11538429,11543893,11543815,11557244,11557327,11573319,11574959,11574946,11574944,11575695,11575893,11576084,11577143,11577594,11579718,11580788,11586889,11587276,11601493,11601572,11601897,11602346,11619280,11619419,11619389,11619870,11620303,11620464,11625304,11625511,11634782,11636237,11637251,11637425,11650167,11650337,11666282,11666287,11667376,11668038,11668107,11668197,11668256,11678356,11678367,11679204,11680593,11682487,11682670,11711181,11712052,11712049,11712047,11713213,11713648,11713766,11737967,11738518,11737980,11738449,11756973,11756995,11758762,11758914,11758928,11758971,11759002,11767297,11767406,11769534,11769821,11805805,11805776,11805779,11807044,11807259,11807270,11807858,11807863,11816678,11817381,11823094,11823352,11823091,11823375,11853643,11853644,11853648,11854440,11854455,11854719,11854743,11855227,11855236,11865444,11866035,11895912,11896757,11896885,11896758,11896875,11896761,11896876,11896954,11896958,11897020,11897091,11897101,11905886,11906252,11907785,11940456,11940747,11941000,11941618,11940977,11941620,11940990,11941617,11942606,11942643,11942687,11942728,11942793,11951146,11965223,11965437,11980363,11980539,11980831,11980524,11980825,11980523,11980826,11981361,11981411,11981899,11981926,11982861,11982920,11982971,11982982,12006110,12006672,12021374,12021394,12022097,12022285,12022407,12022541,12022546,12024399,12024776,12031430,12031654,12033441,12034280,12046097,12046151,12062047,12062049,12062051,12062844,12062986,12063087,12063121,12065230,12065242,12071149,12085203,12086085,12101172,12102091,12102124,12102095,12102123,12102093,12102127,12102656,12103297,12103648,12103689,12103762,4279,5123,4288,5120,20820,46527,47069,47455,48155,48330,48158,48327,48151,48335,48397,48499,49077,49174,49191,49404,49463,57315,57501,70773,70871,85624,86608,86609,86651,86612,86645,87380,87456,87511,88672,88969,94185,95023,99179,112583,126306,127236,127218,127234,128654,128837,128901,133169,133915,136155,136922,139061,139100,157031,158823,172842,172856,173743,173810,173742,173808,173739,173824,174601,174618,174673,174680,175373,175404,178027,178688,193404,193417,210136,212544,212604,212682,212739,212815,212823,213290,214466,213372,213377,213404,215826,220049,220446,247362,247375,248311,248310,248243,249092,249124,249236,249272,249873,249955,257157,257410,260018,272678,274264,288052,288197,288915,289007,288918,289009,288943,288988,289808,289809,290262,290267,290593,290635,299045,299101,313241,313906,315996,316175,331857,331860,333400,333411,333397,333407,333376,333410,333596,333633,334830,335032,337952,338625,340084,340088,344346,358150,372056,372505,373056,373052,373054,373732,373787,373802,374465,374513,374549) ) 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(141, 1406) AND `PG`.`played` = 1 AND `PG`.`sezon` = `RP`.`sezon` LEFT JOIN `pl_times` `PT` ON `PT`.`game_id` = `RP`.`game` AND `PT`.`pl_id` = 6543 WHERE `RP`.`player` = 6543 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107560,122084,123068,122091,123522,122868,123076,122247,123079,213121,214041,213124,214044,213126,214045,234849,235829,234852,235902,246470,247073,247409,249732,257347,257631,259713,263165,264535,277719,277915,281127,281313,283333,283341,299485,299640,300862,300944,301840,302681,301846,303404,337302,338933,342040,342118,345758,346769,372009,372157,373771,10368928,10386192,10398748,10399684,10403698,10404142,10406594,10436745,10440442,10440497,10441311,10441376,10441323,10441382,10441300,10441380,10442222,10443046,10443864,10464092,10466197,10464096,10466067,10481230,10481552,10482573,10483497,10510583,10511662,10512462,10512524,10514400,10514561,10540952,10541773,10542690,10543591,10568249,10570185,10570723,10570933,10599876,10602940,10605317,10605384,10608208,10608223,10637714,10638145,10639848,10639634,10639913,10640925,10640968,10641039,10641107,10648076,10661535,10661872,10664897,10665084,10690598,10693022,10708547,10710385,10710430,10728140,10728574,10730004,10731073,10757828,10758383,10758634,10758632,10760512,10760671,10760980,10771406,10771514,10773140,10774760,10777371,10777750,10779883,10780040,10797391,10795454,10799283,10799432,10825167,10825306,10826348,10826398,10826349,10826405,10826351,10826401,10826566,10826596,10826762,10827119,10827815,10828070,10839252,10839484,10840948,10841207,10842523,10876083,10892899,10893220,10893823,10893820,10893822,10893978,10894019,10894100,10894536,10894709,10895391,10895455,10904493,10904594,10906575,10906605,10920749,10920645,10937477,10937631,10938204,10938215,10938206,10939506,10939576,10940821,10940839,10941643,10941678,10948348,10948555,10963345,10963583,10981527,10983002,10983059,10983012,10983053,10983020,10983061,10983373,10983574,10984067,10984089,10985670,10985736,10999867,11000212,11016068,11016580,11036694,11038805,11038820,11038952,11038954,11039373,11039382,11055496,11055749,11067140,11067804,11070788,11070838,11086550,11086551,11087374,11087454,11087571,11087578,11087826,11088367,11107189,11108149,11108944,11109600,11121183,11121272,11139840,11140575,11140803,11140443,11140560,11140561,11140731,11141364,11141788,11141867,11141871,11142103,11142281,11157713,11158531,11186388,11187562,11187564,11188255,11188306,11188406,11188464,11188674,11189051,11195645,11198829,11213385,11214605,11229118,11230405,11230276,11230274,11231963,11232766,11232988,11238165,11240814,11242030,11243328,11245512,11246865,11246888,11253675,11253851,11267439,11267829,11284055,11286196,11286255,11286193,11286252,11286201,11286254,11286613,11286637,11286707,11287758,11288211,11302954,11302956,11305329,11305755,11314029,11320229,11337870,11337881,11339854,11339874,11339857,11339885,11339839,11339869,11340381,11340407,11341338,11341714,11341865,11341877,11342748,11342958,11360430,11360645,11361699,11362782,11374411,11375669,11392002,11392016,11393075,11393140,11393133,11393149,11393079,11393185,11394404,11394521,11394703,11394842,11394868,11395771,11395903,11397110,11397528,11416757,11416913,11433525,11434373,11434370,11434368,11435996,11440187,11440054,11449621,11450649,11449623,11450660,11479180,11479205,11481399,11481385,11481403,11481368,11481401,11481365,11481653,11481684,11481801,11481843,11481886,11481910,11494304,11496005,11501008,11501228,11501107,11501263,11514112,11515547,11530241,11532004,11532644,11533189,11538375,11538429,11543893,11543815,11557244,11557327,11573319,11574959,11574946,11574944,11575695,11575893,11576084,11577143,11577594,11579718,11580788,11586889,11587276,11601493,11601572,11601897,11602346,11619280,11619419,11619389,11619870,11620303,11620464,11625304,11625511,11634782,11636237,11637251,11637425,11650167,11650337,11666282,11666287,11667376,11668038,11668107,11668197,11668256,11678356,11678367,11679204,11680593,11682487,11682670,11711181,11712052,11712049,11712047,11713213,11713648,11713766,11737967,11738518,11737980,11738449,11756973,11756995,11758762,11758914,11758928,11758971,11759002,11767297,11767406,11769534,11769821,11805805,11805776,11805779,11807044,11807259,11807270,11807858,11807863,11816678,11817381,11823094,11823352,11823091,11823375,11853643,11853644,11853648,11854440,11854455,11854719,11854743,11855227,11855236,11865444,11866035,11895912,11896757,11896885,11896758,11896875,11896761,11896876,11896954,11896958,11897020,11897091,11897101,11905886,11906252,11907785,11940456,11940747,11941000,11941618,11940977,11941620,11940990,11941617,11942606,11942643,11942687,11942728,11942793,11951146,11965223,11965437,11980363,11980539,11980831,11980524,11980825,11980523,11980826,11981361,11981411,11981899,11981926,11982861,11982920,11982971,11982982,12006110,12006672,12021374,12021394,12022097,12022285,12022407,12022541,12022546,12024399,12024776,12031430,12031654,12033441,12034280,12046097,12046151,12062047,12062049,12062051,12062844,12062986,12063087,12063121,12065230,12065242,12071149,12085203,12086085,12101172,12102091,12102124,12102095,12102123,12102093,12102127,12102656,12103297,12103648,12103689,12103762,4279,5123,4288,5120,20820,46527,47069,47455,48155,48330,48158,48327,48151,48335,48397,48499,49077,49174,49191,49404,49463,57315,57501,70773,70871,85624,86608,86609,86651,86612,86645,87380,87456,87511,88672,88969,94185,95023,99179,112583,126306,127236,127218,127234,128654,128837,128901,133169,133915,136155,136922,139061,139100,157031,158823,172842,172856,173743,173810,173742,173808,173739,173824,174601,174618,174673,174680,175373,175404,178027,178688,193404,193417,210136,212544,212604,212682,212739,212815,212823,213290,214466,213372,213377,213404,215826,220049,220446,247362,247375,248311,248310,248243,249092,249124,249236,249272,249873,249955,257157,257410,260018,272678,274264,288052,288197,288915,289007,288918,289009,288943,288988,289808,289809,290262,290267,290593,290635,299045,299101,313241,313906,315996,316175,331857,331860,333400,333411,333397,333407,333376,333410,333596,333633,334830,335032,337952,338625,340084,340088,344346,358150,372056,372505,373056,373052,373054,373732,373787,373802,374465,374513,374549) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: