(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` = 71623 WHERE `RP`.`player` = 71623 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107398,107447,123069,121977,123686,121978,123863,122249,124590,212829,214834,212847,214840,212831,214844,235639,235716,247114,247479,249731,257364,257684,259669,259700,261979,264285,264816,277520,277752,281036,283382,285026,299521,300902,301819,302576,301817,302840,303482,317103,342256,342020,345748,346648,371944,372030,373749,10368838,10370120,10370651,10385953,10387383,10399946,10400866,10403628,10403841,10406381,10406554,10436782,10437263,10440359,10440361,10441469,10441495,10441437,10441441,10441447,10441457,10442100,10442177,10442262,10442332,10443659,10443755,10465598,10477603,10466195,10481022,10481647,10483522,10484778,10510394,10511366,10512473,10513201,10513589,10513573,10514184,10514460,10514508,10514563,10541129,10541189,10542844,10569846,10569848,10569972,10570139,10570180,10570778,10603092,10603072,10605347,10605451,10608195,10608554,10638165,10638286,10640868,10640926,10640981,10641014,10641055,10641081,10647773,10647901,10661237,10661412,10664833,10665244,10690441,10691701,10692243,10691723,10692209,10691707,10692191,10692421,10692481,10692810,10693135,10693200,10693248,10708244,10708339,10710195,10710201,10727552,10728139,10730951,10730224,10757424,10757520,10758522,10758517,10758520,10760630,10760956,10760959,10762169,10762171,10770327,10771287,10772742,10773902,10778151,10778280,10780707,10783299,10794893,10795187,10798083,10799143,10825186,10839256,10839492,10840941,10841018,10842778,10842976,10892918,10894424,10894559,10896129,10904291,10904901,10906548,10906751,10920270,10921983,10937240,10937547,10938631,10938813,10938323,10938546,10938544,10938853,10939558,10939580,10941109,10941123,10941644,10941690,10949081,10949909,10962196,10962382,10981589,10981901,10983322,10983761,10984036,10985641,10998735,10999396,11016911,11017499,11036515,11038406,11038411,11038404,11038919,11038966,11039368,11039496,11055872,11055880,11067959,11068033,11070784,11070829,11085150,11085653,11086370,11086539,11086542,11087453,11087519,11087598,11088930,11089083,11108102,11108473,11108857,11109077,11121415,11121624,11158399,11158424,11186295,11186291,11187340,11187806,11187338,11187813,11187413,11187815,11188283,11188339,11188384,11188458,11188547,11188856,11195177,11195245,11198779,11198819,11213335,11213340,11229237,11230030,11230406,11230031,11230433,11230055,11230487,11231125,11231130,11232158,11232187,11233020,11239548,11240073,11241317,11242092,11244251,11244325,11246782,11253650,11254006,11267438,11268917,11284618,11286570,11286556,11286640,11286684,11303120,11303293,11305656,11320877,11321042,11337897,11340120,11340280,11340330,11340392,11341346,11341748,11341929,11342068,11344117,11344035,11360394,11360680,11361621,11374112,11374413,11376652,11392043,11393091,11393078,11393080,11394313,11394344,11394697,11394846,11394860,11394872,11395212,11395906,11396779,11396810,11415988,11416339,11433594,11434239,11434241,11434227,11435997,11436037,11436231,11436273,11440526,11441235,11449217,11450085,11449179,11449971,11479191,11479211,11481351,11481457,11481355,11481645,11481695,11481811,11481848,11481882,11481897,11494043,11494175,11501463,11502096,11501517,11502094,11514666,11514719,11530257,11532099,11532515,11532652,11532785,11532868,11533060,11538392,11538571,11543840,11544876,11558192,11573326,11575827,11575884,11576006,11576036,11576113,11577820,11579115,11580053,11581254,11587445,11587728,11601413,11601838,11602405,11602651,11616944,11616984,11618614,11618618,11618615,11619561,11620234,11620239,11620430,11620461,11624917,11625254,11635567,11635841,11637018,11637385,11650738,11651212,11666320,11667173,11667264,11667218,11667262,11667260,11667301,11667606,11667801,11668042,11668209,11668255,11678196,11678403,11678733,11680176,11682952,11684279,11711153,11712106,11712105,11712108,11713351,11713659,11713709,11713777,11713843,11739813,11739815,11741757,11757011,11757015,11757919,11757981,11757945,11757991,11757917,11757993,11758764,11758789,11758931,11758933,11758969,11759018,11767283,11767407,11769909,11770555,11805819,11806248,11805816,11806251,11805535,11805833,11807145,11807380,11807936,11816587,11818658,11823407,11823511,11823404,11823516,11852691,11853984,11854288,11853987,11854290,11853988,11854293,11854483,11854820,11854819,11855240,11866378,11896394,11896588,11896790,11896787,11896788,11896903,11896927,11897022,11897094,11904782,11906056,11907966,11908094,11940358,11940746,11941680,11941732,11942066,11941586,11941602,11942532,11942542,11942658,11942710,11942814,11942820,11951625,11952139,11964863,11965275,11980397,11980724,11980985,11980727,11980962,11980731,11980961,11981409,11981420,11982284,11982854,11982946,11983046,11983075,12006097,12006804,12021391,12021541,12021534,12021536,12022063,12022481,12022583,12024160,12024394,12031305,12031704,12034199,12046902,12046905,12062093,12062094,12062097,12071141,12071133,12085640,12085908,12101594,12102064,12102063,12102153,12102060,12102151,12102607,12103262,12103637,4247,4393,4242,4392,20637,21464,47070,49919,49829,57307,57528,70640,71963,85625,85644,86494,86495,86647,86507,86646,87474,87491,87548,87553,88601,88733,95037,97728,97827,98701,112584,126391,126773,127120,127202,127200,127228,127209,127208,128691,128743,128808,128813,128875,128899,133759,133931,136176,136917,138468,139139,156697,156973,172859,173216,173870,173875,173878,174589,175031,175410,177509,178119,193459,193473,210164,211043,211112,211046,211114,211047,211115,212561,212567,212723,212729,212791,212804,213016,213033,213885,216299,213888,216634,220407,233051,247406,248261,248264,248333,249204,249199,249227,249255,249810,249952,256939,257096,261123,261227,273687,273686,288076,288600,289294,289297,289288,289871,290057,290592,299060,299443,313280,313989,315917,316438,331845,333342,333344,333346,333610,334812,335115,337390,337410,340358,340489,340163,340467,344557,344570,358360,372051,373124,373125,373128,373762,374355,374488,374601,374635) ) 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` = 71623 WHERE `RP`.`player` = 71623 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107398,107447,123069,121977,123686,121978,123863,122249,124590,212829,214834,212847,214840,212831,214844,235639,235716,247114,247479,249731,257364,257684,259669,259700,261979,264285,264816,277520,277752,281036,283382,285026,299521,300902,301819,302576,301817,302840,303482,317103,342256,342020,345748,346648,371944,372030,373749,10368838,10370120,10370651,10385953,10387383,10399946,10400866,10403628,10403841,10406381,10406554,10436782,10437263,10440359,10440361,10441469,10441495,10441437,10441441,10441447,10441457,10442100,10442177,10442262,10442332,10443659,10443755,10465598,10477603,10466195,10481022,10481647,10483522,10484778,10510394,10511366,10512473,10513201,10513589,10513573,10514184,10514460,10514508,10514563,10541129,10541189,10542844,10569846,10569848,10569972,10570139,10570180,10570778,10603092,10603072,10605347,10605451,10608195,10608554,10638165,10638286,10640868,10640926,10640981,10641014,10641055,10641081,10647773,10647901,10661237,10661412,10664833,10665244,10690441,10691701,10692243,10691723,10692209,10691707,10692191,10692421,10692481,10692810,10693135,10693200,10693248,10708244,10708339,10710195,10710201,10727552,10728139,10730951,10730224,10757424,10757520,10758522,10758517,10758520,10760630,10760956,10760959,10762169,10762171,10770327,10771287,10772742,10773902,10778151,10778280,10780707,10783299,10794893,10795187,10798083,10799143,10825186,10839256,10839492,10840941,10841018,10842778,10842976,10892918,10894424,10894559,10896129,10904291,10904901,10906548,10906751,10920270,10921983,10937240,10937547,10938631,10938813,10938323,10938546,10938544,10938853,10939558,10939580,10941109,10941123,10941644,10941690,10949081,10949909,10962196,10962382,10981589,10981901,10983322,10983761,10984036,10985641,10998735,10999396,11016911,11017499,11036515,11038406,11038411,11038404,11038919,11038966,11039368,11039496,11055872,11055880,11067959,11068033,11070784,11070829,11085150,11085653,11086370,11086539,11086542,11087453,11087519,11087598,11088930,11089083,11108102,11108473,11108857,11109077,11121415,11121624,11158399,11158424,11186295,11186291,11187340,11187806,11187338,11187813,11187413,11187815,11188283,11188339,11188384,11188458,11188547,11188856,11195177,11195245,11198779,11198819,11213335,11213340,11229237,11230030,11230406,11230031,11230433,11230055,11230487,11231125,11231130,11232158,11232187,11233020,11239548,11240073,11241317,11242092,11244251,11244325,11246782,11253650,11254006,11267438,11268917,11284618,11286570,11286556,11286640,11286684,11303120,11303293,11305656,11320877,11321042,11337897,11340120,11340280,11340330,11340392,11341346,11341748,11341929,11342068,11344117,11344035,11360394,11360680,11361621,11374112,11374413,11376652,11392043,11393091,11393078,11393080,11394313,11394344,11394697,11394846,11394860,11394872,11395212,11395906,11396779,11396810,11415988,11416339,11433594,11434239,11434241,11434227,11435997,11436037,11436231,11436273,11440526,11441235,11449217,11450085,11449179,11449971,11479191,11479211,11481351,11481457,11481355,11481645,11481695,11481811,11481848,11481882,11481897,11494043,11494175,11501463,11502096,11501517,11502094,11514666,11514719,11530257,11532099,11532515,11532652,11532785,11532868,11533060,11538392,11538571,11543840,11544876,11558192,11573326,11575827,11575884,11576006,11576036,11576113,11577820,11579115,11580053,11581254,11587445,11587728,11601413,11601838,11602405,11602651,11616944,11616984,11618614,11618618,11618615,11619561,11620234,11620239,11620430,11620461,11624917,11625254,11635567,11635841,11637018,11637385,11650738,11651212,11666320,11667173,11667264,11667218,11667262,11667260,11667301,11667606,11667801,11668042,11668209,11668255,11678196,11678403,11678733,11680176,11682952,11684279,11711153,11712106,11712105,11712108,11713351,11713659,11713709,11713777,11713843,11739813,11739815,11741757,11757011,11757015,11757919,11757981,11757945,11757991,11757917,11757993,11758764,11758789,11758931,11758933,11758969,11759018,11767283,11767407,11769909,11770555,11805819,11806248,11805816,11806251,11805535,11805833,11807145,11807380,11807936,11816587,11818658,11823407,11823511,11823404,11823516,11852691,11853984,11854288,11853987,11854290,11853988,11854293,11854483,11854820,11854819,11855240,11866378,11896394,11896588,11896790,11896787,11896788,11896903,11896927,11897022,11897094,11904782,11906056,11907966,11908094,11940358,11940746,11941680,11941732,11942066,11941586,11941602,11942532,11942542,11942658,11942710,11942814,11942820,11951625,11952139,11964863,11965275,11980397,11980724,11980985,11980727,11980962,11980731,11980961,11981409,11981420,11982284,11982854,11982946,11983046,11983075,12006097,12006804,12021391,12021541,12021534,12021536,12022063,12022481,12022583,12024160,12024394,12031305,12031704,12034199,12046902,12046905,12062093,12062094,12062097,12071141,12071133,12085640,12085908,12101594,12102064,12102063,12102153,12102060,12102151,12102607,12103262,12103637,4247,4393,4242,4392,20637,21464,47070,49919,49829,57307,57528,70640,71963,85625,85644,86494,86495,86647,86507,86646,87474,87491,87548,87553,88601,88733,95037,97728,97827,98701,112584,126391,126773,127120,127202,127200,127228,127209,127208,128691,128743,128808,128813,128875,128899,133759,133931,136176,136917,138468,139139,156697,156973,172859,173216,173870,173875,173878,174589,175031,175410,177509,178119,193459,193473,210164,211043,211112,211046,211114,211047,211115,212561,212567,212723,212729,212791,212804,213016,213033,213885,216299,213888,216634,220407,233051,247406,248261,248264,248333,249204,249199,249227,249255,249810,249952,256939,257096,261123,261227,273687,273686,288076,288600,289294,289297,289288,289871,290057,290592,299060,299443,313280,313989,315917,316438,331845,333342,333344,333346,333610,334812,335115,337390,337410,340358,340489,340163,340467,344557,344570,358360,372051,373124,373125,373128,373762,374355,374488,374601,374635) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: