(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` = 71032 WHERE `RP`.`player` = 71032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107567,107609,122677,123862,123860,124607,212727,214341,212729,216526,212731,214344,234869,235401,234872,235850,247047,247956,249108,257338,259894,260378,262009,262432,264778,265139,277051,281521,283275,283394,299148,299469,300910,300970,301801,302495,301824,303437,303441,337701,337737,342014,342054,345766,345839,371938,372743,373403,373750,10368591,10369715,10369909,10370579,10386366,10399759,10401716,10403502,10404055,10406244,10406588,10436768,10436927,10440355,10442206,10442333,10442566,10443557,10465464,10465494,10465513,10466051,10481043,10481558,10482527,10482559,10510342,10511661,10512438,10512606,10513585,10513640,10513588,10513641,10514145,10514235,10514382,10514501,10540841,10542705,10543463,10543961,10568644,10568737,10602843,10602925,10605415,10605967,10608151,10608612,10637713,10637895,10640825,10640841,10640973,10641540,10648112,10648202,10662646,10665146,10665406,10690462,10690510,10691728,10691945,10691948,10692411,10692642,10693231,10708661,10710429,10728518,10730003,10731007,10757393,10757519,10758524,10758628,10758525,10758619,10758528,10758625,10760489,10760920,10760931,10761975,10762493,10770609,10771024,10773336,10773680,10777764,10777954,10779291,10780238,10795653,10795385,10797941,10798534,10825147,10825204,10826320,10826341,10826329,10826346,10826324,10826344,10826563,10826603,10826644,10826658,10827316,10827984,10839208,10839234,10840858,10841069,10842437,10843386,10892872,10892875,10893889,10893893,10893896,10894243,10894544,10895458,10904998,10905250,10906665,10906714,10920646,10920890,10937014,10937063,10938316,10938314,10938318,10939597,10940495,10941612,10948294,10948456,10962959,10963807,10981523,10983152,10983149,10983154,10983362,10984041,10984100,10985665,10985733,10999133,10999854,11015720,11016404,11036327,11036475,11038425,11038470,11038396,11038454,11038398,11038482,11038772,11038828,11038924,11038943,11039473,11039526,11055605,11055625,11067355,11067577,11070819,11070822,11085012,11086005,11086000,11086020,11087263,11087520,11087562,11087629,11088617,11106967,11108215,11108803,11108833,11121124,11121342,11139750,11139787,11140627,11140993,11140592,11140995,11140593,11140970,11141225,11141370,11141817,11141889,11141980,11142034,11157611,11158226,11186319,11186403,11186862,11186817,11186820,11186864,11186821,11186945,11188261,11188280,11188388,11188442,11188529,11189226,11195623,11195646,11198737,11198816,11213343,11213467,11229151,11229305,11229826,11230238,11229827,11230131,11229813,11230273,11230866,11230892,11231908,11232197,11232772,11232831,11238580,11239359,11241446,11241450,11243367,11243498,11246833,11253480,11254746,11268092,11284060,11284103,11286284,11286285,11286555,11286625,11287863,11303011,11303070,11305754,11305856,11320175,11323661,11337898,11340336,11340367,11340420,11341412,11341875,11343340,11344787,11359756,11360589,11361620,11361707,11374452,11374473,11393105,11393085,11393090,11394361,11394694,11394718,11394870,11394920,11395070,11395379,11396648,11396947,11416259,11416652,11433542,11433595,11434240,11434242,11434261,11436008,11436123,11436221,11436244,11440138,11440460,11450086,11450575,11450088,11450629,11479231,11481382,11481465,11481384,11481458,11481380,11481446,11481649,11481669,11481780,11481885,11481919,11495154,11501162,11501197,11513342,11514839,11515097,11530716,11531693,11531809,11531672,11531817,11531674,11531786,11532113,11532149,11532636,11532700,11532954,11533366,11538426,11538510,11543777,11544464,11558138,11558838,11573331,11574843,11575077,11574846,11575068,11574849,11575090,11575620,11575766,11575908,11575972,11576025,11576108,11577335,11577562,11579774,11580500,11587028,11587065,11601496,11601544,11602547,11602596,11616970,11617018,11618834,11618855,11618857,11619614,11620323,11620419,11625303,11626237,11635005,11636141,11637037,11637938,11650084,11650537,11666549,11667212,11667282,11667214,11667313,11667216,11667284,11667491,11667757,11668076,11668205,11678181,11678449,11679048,11680456,11683391,11683779,11711173,11711186,11712138,11712142,11712150,11713262,11713336,11713686,11713701,11713792,11713812,11738468,11739431,11738470,11739464,11756990,11756996,11757894,11757899,11757896,11758814,11758837,11758892,11758916,11758957,11759009,11767737,11767942,11769539,11771601,11805612,11805597,11805636,11807041,11807757,11816733,11816938,11823689,11825467,11823718,11824655,11852619,11854255,11854185,11854252,11854462,11855047,11865324,11865443,11895969,11896138,11896804,11896766,11896802,11896996,11897066,11904213,11904444,11907974,11908919,11940321,11940457,11941261,11941262,11941321,11942523,11942566,11942694,11942705,11942773,11949201,11949692,11965058,11965241,11980373,11980375,11981029,11981011,11980998,11981045,11980996,11981047,11981389,11981419,11982012,11982060,11982832,11982875,11983003,11983017,12006296,12006805,12021372,12021390,12021517,12021527,12021520,12021531,12021518,12021528,12022105,12022193,12022416,12022437,12022510,12022522,12024281,12024293,12031123,12031207,12034012,12034003,12046149,12046675,12061203,12061221,12062950,12063091,12065171,12065209,12071073,12071074,12085042,12085077,12101151,12101153,12102047,12102062,12102061,12103017,12103277,12103530,12103605,12103745,12103742,4356,5170,4358,5152,20636,47059,47179,47430,47435,48149,48148,48145,48398,48406,48987,49037,49136,49187,49292,49765,57519,57507,70634,70822,85649,85852,86635,86633,86619,87382,87444,87514,88602,88646,94146,94210,97501,98632,99265,126667,127243,127227,127247,128662,128676,128779,128785,128863,128877,133884,136860,136168,139120,139145,156591,156764,174662,174676,174690,175378,175388,177436,177791,193434,193454,210140,210153,211073,211063,211066,212555,212726,212785,212912,213264,214318,214410,214407,214361,220050,220358,247374,247410,256919,257021,260016,260520,262025,273684,288037,288965,289496,288967,289512,288970,289509,289838,289850,290232,290434,290595,290638,299046,299152,313322,313927,316190,316815,331837,331854,333421,333424,333425,333623,333631,334638,334947,335019,335172,337366,337396,341262,341297,341263,341338,344539,358143,358345,372032,372330,372982,372985,372933,373773,373784,374314,374514,374565,374603) ) 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` = 71032 WHERE `RP`.`player` = 71032 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107567,107609,122677,123862,123860,124607,212727,214341,212729,216526,212731,214344,234869,235401,234872,235850,247047,247956,249108,257338,259894,260378,262009,262432,264778,265139,277051,281521,283275,283394,299148,299469,300910,300970,301801,302495,301824,303437,303441,337701,337737,342014,342054,345766,345839,371938,372743,373403,373750,10368591,10369715,10369909,10370579,10386366,10399759,10401716,10403502,10404055,10406244,10406588,10436768,10436927,10440355,10442206,10442333,10442566,10443557,10465464,10465494,10465513,10466051,10481043,10481558,10482527,10482559,10510342,10511661,10512438,10512606,10513585,10513640,10513588,10513641,10514145,10514235,10514382,10514501,10540841,10542705,10543463,10543961,10568644,10568737,10602843,10602925,10605415,10605967,10608151,10608612,10637713,10637895,10640825,10640841,10640973,10641540,10648112,10648202,10662646,10665146,10665406,10690462,10690510,10691728,10691945,10691948,10692411,10692642,10693231,10708661,10710429,10728518,10730003,10731007,10757393,10757519,10758524,10758628,10758525,10758619,10758528,10758625,10760489,10760920,10760931,10761975,10762493,10770609,10771024,10773336,10773680,10777764,10777954,10779291,10780238,10795653,10795385,10797941,10798534,10825147,10825204,10826320,10826341,10826329,10826346,10826324,10826344,10826563,10826603,10826644,10826658,10827316,10827984,10839208,10839234,10840858,10841069,10842437,10843386,10892872,10892875,10893889,10893893,10893896,10894243,10894544,10895458,10904998,10905250,10906665,10906714,10920646,10920890,10937014,10937063,10938316,10938314,10938318,10939597,10940495,10941612,10948294,10948456,10962959,10963807,10981523,10983152,10983149,10983154,10983362,10984041,10984100,10985665,10985733,10999133,10999854,11015720,11016404,11036327,11036475,11038425,11038470,11038396,11038454,11038398,11038482,11038772,11038828,11038924,11038943,11039473,11039526,11055605,11055625,11067355,11067577,11070819,11070822,11085012,11086005,11086000,11086020,11087263,11087520,11087562,11087629,11088617,11106967,11108215,11108803,11108833,11121124,11121342,11139750,11139787,11140627,11140993,11140592,11140995,11140593,11140970,11141225,11141370,11141817,11141889,11141980,11142034,11157611,11158226,11186319,11186403,11186862,11186817,11186820,11186864,11186821,11186945,11188261,11188280,11188388,11188442,11188529,11189226,11195623,11195646,11198737,11198816,11213343,11213467,11229151,11229305,11229826,11230238,11229827,11230131,11229813,11230273,11230866,11230892,11231908,11232197,11232772,11232831,11238580,11239359,11241446,11241450,11243367,11243498,11246833,11253480,11254746,11268092,11284060,11284103,11286284,11286285,11286555,11286625,11287863,11303011,11303070,11305754,11305856,11320175,11323661,11337898,11340336,11340367,11340420,11341412,11341875,11343340,11344787,11359756,11360589,11361620,11361707,11374452,11374473,11393105,11393085,11393090,11394361,11394694,11394718,11394870,11394920,11395070,11395379,11396648,11396947,11416259,11416652,11433542,11433595,11434240,11434242,11434261,11436008,11436123,11436221,11436244,11440138,11440460,11450086,11450575,11450088,11450629,11479231,11481382,11481465,11481384,11481458,11481380,11481446,11481649,11481669,11481780,11481885,11481919,11495154,11501162,11501197,11513342,11514839,11515097,11530716,11531693,11531809,11531672,11531817,11531674,11531786,11532113,11532149,11532636,11532700,11532954,11533366,11538426,11538510,11543777,11544464,11558138,11558838,11573331,11574843,11575077,11574846,11575068,11574849,11575090,11575620,11575766,11575908,11575972,11576025,11576108,11577335,11577562,11579774,11580500,11587028,11587065,11601496,11601544,11602547,11602596,11616970,11617018,11618834,11618855,11618857,11619614,11620323,11620419,11625303,11626237,11635005,11636141,11637037,11637938,11650084,11650537,11666549,11667212,11667282,11667214,11667313,11667216,11667284,11667491,11667757,11668076,11668205,11678181,11678449,11679048,11680456,11683391,11683779,11711173,11711186,11712138,11712142,11712150,11713262,11713336,11713686,11713701,11713792,11713812,11738468,11739431,11738470,11739464,11756990,11756996,11757894,11757899,11757896,11758814,11758837,11758892,11758916,11758957,11759009,11767737,11767942,11769539,11771601,11805612,11805597,11805636,11807041,11807757,11816733,11816938,11823689,11825467,11823718,11824655,11852619,11854255,11854185,11854252,11854462,11855047,11865324,11865443,11895969,11896138,11896804,11896766,11896802,11896996,11897066,11904213,11904444,11907974,11908919,11940321,11940457,11941261,11941262,11941321,11942523,11942566,11942694,11942705,11942773,11949201,11949692,11965058,11965241,11980373,11980375,11981029,11981011,11980998,11981045,11980996,11981047,11981389,11981419,11982012,11982060,11982832,11982875,11983003,11983017,12006296,12006805,12021372,12021390,12021517,12021527,12021520,12021531,12021518,12021528,12022105,12022193,12022416,12022437,12022510,12022522,12024281,12024293,12031123,12031207,12034012,12034003,12046149,12046675,12061203,12061221,12062950,12063091,12065171,12065209,12071073,12071074,12085042,12085077,12101151,12101153,12102047,12102062,12102061,12103017,12103277,12103530,12103605,12103745,12103742,4356,5170,4358,5152,20636,47059,47179,47430,47435,48149,48148,48145,48398,48406,48987,49037,49136,49187,49292,49765,57519,57507,70634,70822,85649,85852,86635,86633,86619,87382,87444,87514,88602,88646,94146,94210,97501,98632,99265,126667,127243,127227,127247,128662,128676,128779,128785,128863,128877,133884,136860,136168,139120,139145,156591,156764,174662,174676,174690,175378,175388,177436,177791,193434,193454,210140,210153,211073,211063,211066,212555,212726,212785,212912,213264,214318,214410,214407,214361,220050,220358,247374,247410,256919,257021,260016,260520,262025,273684,288037,288965,289496,288967,289512,288970,289509,289838,289850,290232,290434,290595,290638,299046,299152,313322,313927,316190,316815,331837,331854,333421,333424,333425,333623,333631,334638,334947,335019,335172,337366,337396,341262,341297,341263,341338,344539,358143,358345,372032,372330,372982,372985,372933,373773,373784,374314,374514,374565,374603) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: