(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` = 82899 WHERE `RP`.`player` = 82899 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107415,107417,122199,123065,122200,123540,123905,124424,123059,212722,214356,212723,214357,214958,218287,235859,235908,235953,237464,247086,247579,248918,257333,257384,259644,259670,261988,262044,264569,265159,277068,277108,281429,281761,283287,283328,299201,299545,300882,300943,301803,301856,301857,302975,303392,303398,337197,337546,342049,342194,345630,346101,371888,371911,373342,373364,10369033,10369459,10370176,10370405,10370669,10370690,10387032,10387240,10400092,10401928,10403895,10404141,10406407,10406628,10437266,10440340,10441319,10441316,10441317,10442130,10442275,10443664,10465273,10465733,10465272,10465838,10481067,10482754,10483537,10510446,10510703,10512455,10513542,10513545,10513612,10513544,10513614,10514169,10514484,10514524,10514953,10540899,10541089,10542716,10544144,10567991,10568041,10569785,10569794,10570093,10570107,10570190,10570317,10570618,10570769,10570861,10570863,10583679,10583712,10605123,10605717,10608162,10608191,10637753,10639357,10639627,10639678,10639618,10639680,10639619,10639914,10640861,10640866,10640978,10640979,10641053,10647733,10661278,10661291,10664887,10665430,10690395,10690612,10692445,10692452,10692710,10692743,10693221,10693242,10709063,10708340,10710376,10710914,10727539,10728573,10729730,10730329,10757445,10758576,10758648,10758574,10758649,10758578,10758651,10760413,10760449,10760906,10760917,10762165,10762499,10770409,10771288,10772420,10773679,10778267,10778749,10779958,10780559,10795742,10795097,10798665,10799894,10825305,10825762,10826367,10826370,10826424,10826590,10826672,10826752,10827339,10827344,10839351,10839641,10840887,10841070,10842982,10843385,10892891,10893092,10893824,10893897,10893830,10893894,10893821,10893895,10894020,10894197,10894532,10894632,10895395,10895495,10904787,10905171,10906587,10906606,10920262,10920628,10937012,10937395,10938040,10938079,10938041,10938088,10938044,10938071,10939502,10939525,10940811,10941092,10941682,10941692,10948293,10948569,10963429,10963988,10981505,10984078,10984118,10985657,10985678,10998709,10999587,11015482,11015958,11036357,11038831,11038885,11038925,11039160,11039332,11055535,11055642,11067253,11068659,11070799,11071281,11085072,11085946,11085973,11085948,11087267,11087555,11088458,11107113,11107697,11109057,11109630,11121101,11121660,11139748,11140131,11141619,11141959,11142025,11157653,11158051,11186313,11188294,11188292,11188379,11188427,11188628,11188999,11195270,11195884,11198700,11198718,11213372,11213545,11229238,11229854,11229856,11232970,11238166,11238948,11241742,11242016,11243413,11243943,11246835,11247764,11253505,11254175,11267227,11267299,11284071,11284083,11286198,11286407,11286199,11286410,11286205,11286535,11286680,11286633,11287155,11287401,11287820,11287913,11302953,11303223,11305527,11305757,11320248,11320736,11337871,11338942,11340068,11340151,11340086,11340373,11341437,11342003,11342039,11342766,11343905,11359775,11360026,11361668,11361678,11374405,11374504,11392041,11392640,11393036,11393215,11393059,11393219,11393053,11393203,11394310,11394335,11394719,11394729,11394862,11394928,11395066,11395660,11396824,11397527,11416084,11417741,11433622,11433628,11435999,11436236,11436297,11441096,11441067,11449501,11451555,11449503,11451502,11479216,11481702,11481788,11481812,11481884,11481920,11494021,11494045,11500750,11500752,11500754,11514090,11514239,11530216,11531297,11532747,11532872,11538389,11538439,11544531,11544737,11557158,11557725,11573309,11573320,11574844,11574854,11574839,11574851,11574841,11574859,11575632,11575755,11575882,11575901,11576035,11576066,11577090,11576988,11579744,11579851,11587326,11587767,11601228,11601265,11602495,11602595,11616979,11616987,11618565,11618562,11618575,11619562,11619826,11620230,11620281,11620377,11620399,11625074,11626393,11634964,11635761,11637114,11637574,11649973,11650538,11666290,11666644,11667649,11668041,11668130,11668178,11668211,11678336,11678340,11679062,11680893,11683613,11711161,11712053,11712171,11712055,11712215,11712057,11712217,11713299,11713649,11713819,11737909,11739958,11737911,11739960,11756968,11757009,11767674,11767810,11769786,11770351,11805477,11805589,11805475,11805548,11805470,11805551,11807000,11807018,11807334,11807600,11807884,11807917,11816765,11817550,11822852,11823042,11822801,11823041,11854434,11854789,11855023,11855247,11855295,11865451,11865484,11895899,11895945,11896796,11896799,11896800,11896962,11897012,11897074,11897112,11905506,11905722,11907521,11908095,11940085,11940096,11941440,11941558,11941476,11942521,11942712,11942787,11942818,11949878,11951282,11965076,11965930,11980338,11980360,11980576,11980714,11980618,11980751,11980689,11980717,11981408,11981416,11981997,11982036,11982837,11982994,11983039,12006809,12006806,12021384,12021392,12021526,12021604,12021530,12021588,12021529,12021551,12022106,12022258,12022430,12022487,12022550,12022580,12024161,12024316,12031392,12031870,12034180,12034413,12046109,12046674,12061227,12061233,12062011,12062001,12062002,12062635,12062736,12062962,12063007,12063060,12063114,12065174,12065208,12071146,12071142,12085202,12085804,12101169,12103100,12103144,12103639,12103668,12103747,12103774,4189,4394,4180,4391,20591,21571,46546,47090,47403,47410,48392,48927,49078,49105,49153,49446,49461,57500,57517,59718,59833,85747,86177,86561,86589,86563,86596,86559,86594,87368,87419,87445,87460,87536,87555,88347,88569,94133,94147,97668,97673,98724,99459,126636,127204,127196,127197,128706,128824,128891,128909,134581,136831,139159,156650,172869,172883,173794,173801,173800,174644,174884,175434,178737,178772,193405,194307,210155,211158,211160,211236,212146,211228,212143,212536,212552,212711,212741,212803,212812,212866,215263,215181,215403,215150,215568,220263,220635,247399,248403,248402,249141,249605,250026,257443,260476,261969,272689,288475,288486,289301,289303,289305,289843,289847,290123,290135,290634,299063,316472,316630,333114,333482,333506,333550,333508,333551,333628,334403,334675,334820,335029,335065,337391,338426,340329,341643,340328,341412,344330,358153,358372,372075,372582,373074,373041,373021,373807,374425,374642) ) 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` = 82899 WHERE `RP`.`player` = 82899 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107415,107417,122199,123065,122200,123540,123905,124424,123059,212722,214356,212723,214357,214958,218287,235859,235908,235953,237464,247086,247579,248918,257333,257384,259644,259670,261988,262044,264569,265159,277068,277108,281429,281761,283287,283328,299201,299545,300882,300943,301803,301856,301857,302975,303392,303398,337197,337546,342049,342194,345630,346101,371888,371911,373342,373364,10369033,10369459,10370176,10370405,10370669,10370690,10387032,10387240,10400092,10401928,10403895,10404141,10406407,10406628,10437266,10440340,10441319,10441316,10441317,10442130,10442275,10443664,10465273,10465733,10465272,10465838,10481067,10482754,10483537,10510446,10510703,10512455,10513542,10513545,10513612,10513544,10513614,10514169,10514484,10514524,10514953,10540899,10541089,10542716,10544144,10567991,10568041,10569785,10569794,10570093,10570107,10570190,10570317,10570618,10570769,10570861,10570863,10583679,10583712,10605123,10605717,10608162,10608191,10637753,10639357,10639627,10639678,10639618,10639680,10639619,10639914,10640861,10640866,10640978,10640979,10641053,10647733,10661278,10661291,10664887,10665430,10690395,10690612,10692445,10692452,10692710,10692743,10693221,10693242,10709063,10708340,10710376,10710914,10727539,10728573,10729730,10730329,10757445,10758576,10758648,10758574,10758649,10758578,10758651,10760413,10760449,10760906,10760917,10762165,10762499,10770409,10771288,10772420,10773679,10778267,10778749,10779958,10780559,10795742,10795097,10798665,10799894,10825305,10825762,10826367,10826370,10826424,10826590,10826672,10826752,10827339,10827344,10839351,10839641,10840887,10841070,10842982,10843385,10892891,10893092,10893824,10893897,10893830,10893894,10893821,10893895,10894020,10894197,10894532,10894632,10895395,10895495,10904787,10905171,10906587,10906606,10920262,10920628,10937012,10937395,10938040,10938079,10938041,10938088,10938044,10938071,10939502,10939525,10940811,10941092,10941682,10941692,10948293,10948569,10963429,10963988,10981505,10984078,10984118,10985657,10985678,10998709,10999587,11015482,11015958,11036357,11038831,11038885,11038925,11039160,11039332,11055535,11055642,11067253,11068659,11070799,11071281,11085072,11085946,11085973,11085948,11087267,11087555,11088458,11107113,11107697,11109057,11109630,11121101,11121660,11139748,11140131,11141619,11141959,11142025,11157653,11158051,11186313,11188294,11188292,11188379,11188427,11188628,11188999,11195270,11195884,11198700,11198718,11213372,11213545,11229238,11229854,11229856,11232970,11238166,11238948,11241742,11242016,11243413,11243943,11246835,11247764,11253505,11254175,11267227,11267299,11284071,11284083,11286198,11286407,11286199,11286410,11286205,11286535,11286680,11286633,11287155,11287401,11287820,11287913,11302953,11303223,11305527,11305757,11320248,11320736,11337871,11338942,11340068,11340151,11340086,11340373,11341437,11342003,11342039,11342766,11343905,11359775,11360026,11361668,11361678,11374405,11374504,11392041,11392640,11393036,11393215,11393059,11393219,11393053,11393203,11394310,11394335,11394719,11394729,11394862,11394928,11395066,11395660,11396824,11397527,11416084,11417741,11433622,11433628,11435999,11436236,11436297,11441096,11441067,11449501,11451555,11449503,11451502,11479216,11481702,11481788,11481812,11481884,11481920,11494021,11494045,11500750,11500752,11500754,11514090,11514239,11530216,11531297,11532747,11532872,11538389,11538439,11544531,11544737,11557158,11557725,11573309,11573320,11574844,11574854,11574839,11574851,11574841,11574859,11575632,11575755,11575882,11575901,11576035,11576066,11577090,11576988,11579744,11579851,11587326,11587767,11601228,11601265,11602495,11602595,11616979,11616987,11618565,11618562,11618575,11619562,11619826,11620230,11620281,11620377,11620399,11625074,11626393,11634964,11635761,11637114,11637574,11649973,11650538,11666290,11666644,11667649,11668041,11668130,11668178,11668211,11678336,11678340,11679062,11680893,11683613,11711161,11712053,11712171,11712055,11712215,11712057,11712217,11713299,11713649,11713819,11737909,11739958,11737911,11739960,11756968,11757009,11767674,11767810,11769786,11770351,11805477,11805589,11805475,11805548,11805470,11805551,11807000,11807018,11807334,11807600,11807884,11807917,11816765,11817550,11822852,11823042,11822801,11823041,11854434,11854789,11855023,11855247,11855295,11865451,11865484,11895899,11895945,11896796,11896799,11896800,11896962,11897012,11897074,11897112,11905506,11905722,11907521,11908095,11940085,11940096,11941440,11941558,11941476,11942521,11942712,11942787,11942818,11949878,11951282,11965076,11965930,11980338,11980360,11980576,11980714,11980618,11980751,11980689,11980717,11981408,11981416,11981997,11982036,11982837,11982994,11983039,12006809,12006806,12021384,12021392,12021526,12021604,12021530,12021588,12021529,12021551,12022106,12022258,12022430,12022487,12022550,12022580,12024161,12024316,12031392,12031870,12034180,12034413,12046109,12046674,12061227,12061233,12062011,12062001,12062002,12062635,12062736,12062962,12063007,12063060,12063114,12065174,12065208,12071146,12071142,12085202,12085804,12101169,12103100,12103144,12103639,12103668,12103747,12103774,4189,4394,4180,4391,20591,21571,46546,47090,47403,47410,48392,48927,49078,49105,49153,49446,49461,57500,57517,59718,59833,85747,86177,86561,86589,86563,86596,86559,86594,87368,87419,87445,87460,87536,87555,88347,88569,94133,94147,97668,97673,98724,99459,126636,127204,127196,127197,128706,128824,128891,128909,134581,136831,139159,156650,172869,172883,173794,173801,173800,174644,174884,175434,178737,178772,193405,194307,210155,211158,211160,211236,212146,211228,212143,212536,212552,212711,212741,212803,212812,212866,215263,215181,215403,215150,215568,220263,220635,247399,248403,248402,249141,249605,250026,257443,260476,261969,272689,288475,288486,289301,289303,289305,289843,289847,290123,290135,290634,299063,316472,316630,333114,333482,333506,333550,333508,333551,333628,334403,334675,334820,335029,335065,337391,338426,340329,341643,340328,341412,344330,358153,358372,372075,372582,373074,373041,373021,373807,374425,374642) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: