(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` = 56839 WHERE `RP`.`player` = 56839 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107407,107575,122233,122666,122234,122718,122236,122003,122238,213214,213586,213215,213898,213749,235646,235827,235647,235797,246979,247121,247708,248145,257473,257540,259711,261405,261980,262034,265233,265242,277250,277759,281173,281594,283294,283316,299287,299331,300907,300928,301774,301807,301867,303444,303402,337472,337666,342068,342075,345899,346740,372069,372133,373436,373790,10368424,10369302,10370085,10370119,10370622,10370643,10386658,10386766,10399879,10400727,10402957,10403046,10406226,10406285,10436686,10437460,10440318,10441340,10441336,10441342,10442132,10442135,10442265,10442288,10443558,10464125,10465408,10477155,10477257,10481148,10481568,10482557,10483334,10510500,10510938,10512425,10513603,10513602,10514154,10514385,10514520,10541212,10541513,10543411,10545710,10568438,10569878,10569879,10570103,10570204,10570758,10570935,10583632,10602953,10605286,10605992,10608154,10608707,10639741,10639794,10639740,10639795,10639744,10639808,10640887,10640902,10640972,10640982,10641051,10641859,10647845,10648000,10661490,10662218,10665033,10665496,10690402,10690534,10692468,10692786,10692919,10693186,10693218,10708304,10708637,10710210,10710240,10728062,10728406,10730633,10730790,10757408,10757418,10760938,10762074,10770376,10771790,10772538,10773700,10777791,10778052,10779463,10779470,10794990,10795200,10798218,10798621,10825248,10825296,10839380,10839390,10840950,10841554,10842424,10842862,10893984,10894726,10895418,10904447,10905104,10906706,10906766,10920158,10921865,10937048,10937102,10938104,10938112,10938130,10939602,10940748,10940856,10941636,10948686,10948778,10962356,10962980,10981524,10981927,10983107,10983104,10983242,10983919,10984038,10999106,10999941,11015444,11016912,11036282,11036396,11038379,11038498,11038616,11038906,11039149,11055456,11055788,11068056,11068526,11070794,11071160,11085080,11086249,11086216,11086218,11087202,11087494,11087526,11087636,11088182,11106774,11108150,11108848,11108880,11121197,11121486,11139754,11139772,11140398,11140522,11140390,11140574,11140388,11140562,11141436,11141860,11142013,11142012,11157924,11158076,11186348,11188286,11188392,11188447,11188514,11188861,11195555,11196033,11199147,11200704,11213368,11213409,11229171,11229233,11230980,11231068,11232355,11232372,11233019,11233028,11238764,11239127,11241270,11242851,11243431,11243919,11246886,11246907,11253680,11253930,11267794,11268795,11284070,11284094,11286208,11286209,11286206,11286661,11287786,11287962,11303086,11303121,11305876,11306444,11320880,11321624,11337877,11337924,11339905,11340054,11339904,11340052,11339900,11339909,11340404,11340419,11341664,11341876,11342004,11343339,11343989,11360468,11361457,11361794,11362596,11374455,11374501,11392067,11392146,11393295,11393281,11393280,11394500,11394789,11394841,11394896,11394978,11395974,11396348,11397016,11397460,11416293,11417863,11433629,11434609,11434606,11434611,11436013,11436232,11440137,11440639,11450986,11451394,11450630,11451391,11481833,11494002,11494003,11500432,11501227,11500429,11501223,11514455,11515070,11530220,11530261,11531829,11531827,11531831,11532503,11532650,11532761,11532849,11533601,11538432,11539202,11543524,11545079,11557186,11573296,11573334,11574807,11574811,11575116,11574805,11575118,11575742,11575969,11575999,11576098,11579191,11576987,11587132,11588141,11601472,11602387,11602793,11616959,11616975,11618814,11618810,11618808,11619095,11618812,11619141,11619613,11620184,11620286,11620301,11620388,11620436,11625175,11626844,11634740,11636754,11637386,11637961,11650595,11650604,11666286,11666708,11667266,11667268,11667271,11667650,11668045,11668190,11668208,11678210,11678410,11679061,11681364,11682321,11685000,11711167,11711201,11712036,11712038,11712034,11713553,11713662,11713707,11713771,11739842,11741434,11740070,11740955,11757017,11758666,11758094,11758815,11758917,11759008,11769203,11769404,11771241,11771652,11806371,11807021,11807837,11807825,11807937,11817873,11818917,11822927,11824499,11822929,11824654,11852727,11853549,11854266,11853547,11854269,11853550,11854349,11854444,11854825,11854878,11865281,11865485,11896015,11896215,11896865,11896862,11896866,11896935,11896977,11897013,11897061,11904545,11906451,11907585,11909157,11940104,11940959,11940960,11940963,11942280,11942524,11942616,11942659,11942667,11942758,11942770,11949879,11951724,11963445,11965132,11980343,11980555,11980830,11980556,11980824,11980559,11980827,11981395,11981382,11981764,11982117,11982867,11983042,11983063,12006073,12006078,12021365,12024234,12024321,12031206,12031617,12033825,12034408,12046113,12046108,12061196,12061208,12062201,12062187,12062189,12062678,12062977,12065276,12071125,12085888,12086812,12101133,12101811,12101985,12102140,12102114,12102139,12102116,12102136,12102575,12102776,12103572,12103599,12103715,4178,4322,4269,4323,20554,20662,46570,47440,48127,48126,48130,48667,49086,49168,49244,70705,70832,85626,86202,86648,86649,87336,87494,88884,88990,97838,98531,99594,126425,126825,128582,128690,128833,134571,136177,138453,145332,157329,173461,173541,173749,173746,173747,175295,175408,178331,179194,210425,210865,211139,211138,211148,212668,212749,215910,216216,216211,216300,216210,216610,233736,247397,248317,248314,248315,249207,249521,250010,257714,260027,261972,274345,288321,288751,299166,300384,313316,314100,316067,331868,333336,333337,333325,334948,337395,339061,340609,340902,340903,341487,344094,344482,358352,358371,372402,372672,373590,373701,373596) ) 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` = 56839 WHERE `RP`.`player` = 56839 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107407,107575,122233,122666,122234,122718,122236,122003,122238,213214,213586,213215,213898,213749,235646,235827,235647,235797,246979,247121,247708,248145,257473,257540,259711,261405,261980,262034,265233,265242,277250,277759,281173,281594,283294,283316,299287,299331,300907,300928,301774,301807,301867,303444,303402,337472,337666,342068,342075,345899,346740,372069,372133,373436,373790,10368424,10369302,10370085,10370119,10370622,10370643,10386658,10386766,10399879,10400727,10402957,10403046,10406226,10406285,10436686,10437460,10440318,10441340,10441336,10441342,10442132,10442135,10442265,10442288,10443558,10464125,10465408,10477155,10477257,10481148,10481568,10482557,10483334,10510500,10510938,10512425,10513603,10513602,10514154,10514385,10514520,10541212,10541513,10543411,10545710,10568438,10569878,10569879,10570103,10570204,10570758,10570935,10583632,10602953,10605286,10605992,10608154,10608707,10639741,10639794,10639740,10639795,10639744,10639808,10640887,10640902,10640972,10640982,10641051,10641859,10647845,10648000,10661490,10662218,10665033,10665496,10690402,10690534,10692468,10692786,10692919,10693186,10693218,10708304,10708637,10710210,10710240,10728062,10728406,10730633,10730790,10757408,10757418,10760938,10762074,10770376,10771790,10772538,10773700,10777791,10778052,10779463,10779470,10794990,10795200,10798218,10798621,10825248,10825296,10839380,10839390,10840950,10841554,10842424,10842862,10893984,10894726,10895418,10904447,10905104,10906706,10906766,10920158,10921865,10937048,10937102,10938104,10938112,10938130,10939602,10940748,10940856,10941636,10948686,10948778,10962356,10962980,10981524,10981927,10983107,10983104,10983242,10983919,10984038,10999106,10999941,11015444,11016912,11036282,11036396,11038379,11038498,11038616,11038906,11039149,11055456,11055788,11068056,11068526,11070794,11071160,11085080,11086249,11086216,11086218,11087202,11087494,11087526,11087636,11088182,11106774,11108150,11108848,11108880,11121197,11121486,11139754,11139772,11140398,11140522,11140390,11140574,11140388,11140562,11141436,11141860,11142013,11142012,11157924,11158076,11186348,11188286,11188392,11188447,11188514,11188861,11195555,11196033,11199147,11200704,11213368,11213409,11229171,11229233,11230980,11231068,11232355,11232372,11233019,11233028,11238764,11239127,11241270,11242851,11243431,11243919,11246886,11246907,11253680,11253930,11267794,11268795,11284070,11284094,11286208,11286209,11286206,11286661,11287786,11287962,11303086,11303121,11305876,11306444,11320880,11321624,11337877,11337924,11339905,11340054,11339904,11340052,11339900,11339909,11340404,11340419,11341664,11341876,11342004,11343339,11343989,11360468,11361457,11361794,11362596,11374455,11374501,11392067,11392146,11393295,11393281,11393280,11394500,11394789,11394841,11394896,11394978,11395974,11396348,11397016,11397460,11416293,11417863,11433629,11434609,11434606,11434611,11436013,11436232,11440137,11440639,11450986,11451394,11450630,11451391,11481833,11494002,11494003,11500432,11501227,11500429,11501223,11514455,11515070,11530220,11530261,11531829,11531827,11531831,11532503,11532650,11532761,11532849,11533601,11538432,11539202,11543524,11545079,11557186,11573296,11573334,11574807,11574811,11575116,11574805,11575118,11575742,11575969,11575999,11576098,11579191,11576987,11587132,11588141,11601472,11602387,11602793,11616959,11616975,11618814,11618810,11618808,11619095,11618812,11619141,11619613,11620184,11620286,11620301,11620388,11620436,11625175,11626844,11634740,11636754,11637386,11637961,11650595,11650604,11666286,11666708,11667266,11667268,11667271,11667650,11668045,11668190,11668208,11678210,11678410,11679061,11681364,11682321,11685000,11711167,11711201,11712036,11712038,11712034,11713553,11713662,11713707,11713771,11739842,11741434,11740070,11740955,11757017,11758666,11758094,11758815,11758917,11759008,11769203,11769404,11771241,11771652,11806371,11807021,11807837,11807825,11807937,11817873,11818917,11822927,11824499,11822929,11824654,11852727,11853549,11854266,11853547,11854269,11853550,11854349,11854444,11854825,11854878,11865281,11865485,11896015,11896215,11896865,11896862,11896866,11896935,11896977,11897013,11897061,11904545,11906451,11907585,11909157,11940104,11940959,11940960,11940963,11942280,11942524,11942616,11942659,11942667,11942758,11942770,11949879,11951724,11963445,11965132,11980343,11980555,11980830,11980556,11980824,11980559,11980827,11981395,11981382,11981764,11982117,11982867,11983042,11983063,12006073,12006078,12021365,12024234,12024321,12031206,12031617,12033825,12034408,12046113,12046108,12061196,12061208,12062201,12062187,12062189,12062678,12062977,12065276,12071125,12085888,12086812,12101133,12101811,12101985,12102140,12102114,12102139,12102116,12102136,12102575,12102776,12103572,12103599,12103715,4178,4322,4269,4323,20554,20662,46570,47440,48127,48126,48130,48667,49086,49168,49244,70705,70832,85626,86202,86648,86649,87336,87494,88884,88990,97838,98531,99594,126425,126825,128582,128690,128833,134571,136177,138453,145332,157329,173461,173541,173749,173746,173747,175295,175408,178331,179194,210425,210865,211139,211138,211148,212668,212749,215910,216216,216211,216300,216210,216610,233736,247397,248317,248314,248315,249207,249521,250010,257714,260027,261972,274345,288321,288751,299166,300384,313316,314100,316067,331868,333336,333337,333325,334948,337395,339061,340609,340902,340903,341487,344094,344482,358352,358371,372402,372672,373590,373701,373596) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: