(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` = 44597 WHERE `RP`.`player` = 44597 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107435,107574,122122,122731,122732,123338,122739,122740,124023,213653,214229,213997,214182,214360,214593,235513,235645,235516,235648,246674,246465,247389,247422,257493,257505,259652,259808,261937,261945,264473,264549,277221,277455,281182,281248,283309,283392,299275,299306,300909,300911,301802,301834,301888,301832,303442,303460,317104,317111,342098,342267,345641,345720,360728,371994,373488,373504,10368428,10368484,10369969,10370628,10387273,10398747,10400145,10400252,10403169,10403734,10406192,10406206,10436703,10436777,10440356,10442094,10442254,10442316,10443750,10443754,10464507,10464632,10464510,10464711,10481220,10481229,10482491,10482580,10510508,10510628,10512424,10514449,10514560,10514566,10540980,10541013,10543009,10545527,10569946,10570106,10570429,10570714,10570927,10603071,10605718,10605968,10608226,10608611,10638166,10639358,10639754,10639755,10639763,10640893,10641097,10647797,10662420,10665059,10690396,10691959,10691946,10691947,10692431,10692455,10692499,10692994,10693250,10693252,10710594,10710798,10727631,10727968,10730412,10730424,10757499,10760552,10760900,10762028,10771376,10772864,10773538,10777792,10779120,10779322,10780022,10796279,10796068,10797914,10798805,10825284,10826624,10827714,10839435,10840978,10841358,10842438,10842570,10892914,10893488,10893872,10893882,10893869,10894108,10894670,10894682,10896110,10896114,10905182,10905172,10906597,10906726,10922130,10921984,10937665,10938283,10938286,10938420,10940100,10940820,10940824,10941688,10941689,10948388,10949042,10962785,10963264,10981535,10981558,10983063,10983042,10983057,10983351,10984129,10998736,11000211,11017118,11017301,11036693,11036986,11038372,11038374,11038376,11038904,11039156,11055986,11067733,11067319,11068890,11070824,11071282,11084961,11085654,11086257,11086135,11086549,11086138,11086552,11087209,11087234,11087515,11087580,11087620,11087639,11106948,11108438,11109157,11120938,11121580,11121675,11139877,11139962,11140576,11140917,11140573,11140878,11140578,11140915,11141262,11141385,11141816,11141927,11142004,11142053,11157930,11158258,11186444,11188346,11188417,11188432,11188894,11189330,11195269,11196575,11198659,11213389,11213450,11229213,11229276,11229975,11230344,11229989,11230381,11230005,11230400,11231000,11231113,11232213,11232542,11238886,11240030,11241684,11241836,11244117,11244338,11246912,11248128,11253910,11253926,11267364,11269130,11286502,11286504,11286510,11286667,11302962,11302985,11306103,11306518,11320996,11323662,11338164,11339942,11340166,11339982,11340170,11339944,11340168,11341723,11344332,11344806,11360429,11361104,11362575,11374242,11376766,11392015,11392224,11393194,11393282,11393292,11394366,11394736,11394887,11394921,11395640,11396748,11397476,11398536,11416121,11416139,11433563,11434335,11434307,11434314,11436287,11440937,11441484,11450616,11452117,11450612,11452489,11479187,11479234,11481262,11481506,11481295,11481510,11481297,11481508,11481731,11481726,11481785,11481888,11494444,11496006,11501704,11501820,11501705,11501818,11514320,11515548,11530274,11531680,11531683,11531906,11531678,11531886,11532365,11532504,11532624,11532786,11532819,11532870,11538541,11539455,11545059,11545189,11557328,11558702,11573335,11573346,11574955,11574960,11574938,11575013,11574940,11574996,11575598,11575611,11575916,11575933,11576094,11577141,11577836,11579881,11580247,11586849,11587671,11601231,11601777,11602357,11602445,11616972,11618566,11618561,11618583,11619635,11620090,11620249,11620321,11620383,11620413,11624992,11626080,11636219,11636444,11637048,11637788,11650083,11650560,11666482,11666881,11667198,11667192,11667189,11667374,11667520,11668069,11668138,11668252,11678359,11678371,11679328,11680455,11682673,11711196,11712076,11712084,11712059,11713356,11713691,11713739,11713813,11713821,11739794,11739812,11739697,11739814,11756998,11757877,11757994,11757886,11757997,11757885,11757998,11758771,11758779,11758925,11758929,11759017,11759020,11768040,11769165,11770742,11771055,11805823,11805547,11805824,11806071,11807035,11807073,11807301,11807335,11807857,11817093,11818651,11823083,11823909,11825549,11852890,11852921,11853548,11853706,11853546,11853709,11853527,11853685,11854448,11854467,11854744,11854824,11855222,11855243,11865396,11865742,11896305,11896361,11896905,11896933,11896967,11897001,11897038,11904375,11904660,11907294,11907767,11940144,11940460,11940941,11940988,11940938,11940976,11940937,11941006,11942563,11942577,11942672,11942684,11942785,11942789,11949096,11951173,11963453,11965203,11980340,11980354,11980641,11980637,11980639,11981371,11981799,11981924,11982835,11982956,11982983,11983056,12006708,12006795,12021357,12021399,12021582,12021584,12021602,12022008,12022463,12022461,12022567,12022569,12024461,12024497,12031304,12031619,12033467,12046202,12062021,12062023,12062017,12062574,12062951,12063130,12065194,12071178,12087486,12101132,4486,5014,21120,46541,46588,48338,48340,48342,48486,48832,49155,49422,57281,59705,70700,87470,87526,88414,94968,97678,98532,126876,126896,127178,127179,127182,128672,128790,128871,133168,136158,138461,155984,174675,175380,179110,193416,210123,213329,214163,214166,231884,248292,248296,248294,249088,249238,249780,256932,260028,273677,288106,289031,289035,288987,290298,290636,299075,313281,315780,331849,333349,333347,333401,333613,334793,335116,337314,339835,339869,344093,358362,372267,373656,373657,373804) ) 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` = 44597 WHERE `RP`.`player` = 44597 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107435,107574,122122,122731,122732,123338,122739,122740,124023,213653,214229,213997,214182,214360,214593,235513,235645,235516,235648,246674,246465,247389,247422,257493,257505,259652,259808,261937,261945,264473,264549,277221,277455,281182,281248,283309,283392,299275,299306,300909,300911,301802,301834,301888,301832,303442,303460,317104,317111,342098,342267,345641,345720,360728,371994,373488,373504,10368428,10368484,10369969,10370628,10387273,10398747,10400145,10400252,10403169,10403734,10406192,10406206,10436703,10436777,10440356,10442094,10442254,10442316,10443750,10443754,10464507,10464632,10464510,10464711,10481220,10481229,10482491,10482580,10510508,10510628,10512424,10514449,10514560,10514566,10540980,10541013,10543009,10545527,10569946,10570106,10570429,10570714,10570927,10603071,10605718,10605968,10608226,10608611,10638166,10639358,10639754,10639755,10639763,10640893,10641097,10647797,10662420,10665059,10690396,10691959,10691946,10691947,10692431,10692455,10692499,10692994,10693250,10693252,10710594,10710798,10727631,10727968,10730412,10730424,10757499,10760552,10760900,10762028,10771376,10772864,10773538,10777792,10779120,10779322,10780022,10796279,10796068,10797914,10798805,10825284,10826624,10827714,10839435,10840978,10841358,10842438,10842570,10892914,10893488,10893872,10893882,10893869,10894108,10894670,10894682,10896110,10896114,10905182,10905172,10906597,10906726,10922130,10921984,10937665,10938283,10938286,10938420,10940100,10940820,10940824,10941688,10941689,10948388,10949042,10962785,10963264,10981535,10981558,10983063,10983042,10983057,10983351,10984129,10998736,11000211,11017118,11017301,11036693,11036986,11038372,11038374,11038376,11038904,11039156,11055986,11067733,11067319,11068890,11070824,11071282,11084961,11085654,11086257,11086135,11086549,11086138,11086552,11087209,11087234,11087515,11087580,11087620,11087639,11106948,11108438,11109157,11120938,11121580,11121675,11139877,11139962,11140576,11140917,11140573,11140878,11140578,11140915,11141262,11141385,11141816,11141927,11142004,11142053,11157930,11158258,11186444,11188346,11188417,11188432,11188894,11189330,11195269,11196575,11198659,11213389,11213450,11229213,11229276,11229975,11230344,11229989,11230381,11230005,11230400,11231000,11231113,11232213,11232542,11238886,11240030,11241684,11241836,11244117,11244338,11246912,11248128,11253910,11253926,11267364,11269130,11286502,11286504,11286510,11286667,11302962,11302985,11306103,11306518,11320996,11323662,11338164,11339942,11340166,11339982,11340170,11339944,11340168,11341723,11344332,11344806,11360429,11361104,11362575,11374242,11376766,11392015,11392224,11393194,11393282,11393292,11394366,11394736,11394887,11394921,11395640,11396748,11397476,11398536,11416121,11416139,11433563,11434335,11434307,11434314,11436287,11440937,11441484,11450616,11452117,11450612,11452489,11479187,11479234,11481262,11481506,11481295,11481510,11481297,11481508,11481731,11481726,11481785,11481888,11494444,11496006,11501704,11501820,11501705,11501818,11514320,11515548,11530274,11531680,11531683,11531906,11531678,11531886,11532365,11532504,11532624,11532786,11532819,11532870,11538541,11539455,11545059,11545189,11557328,11558702,11573335,11573346,11574955,11574960,11574938,11575013,11574940,11574996,11575598,11575611,11575916,11575933,11576094,11577141,11577836,11579881,11580247,11586849,11587671,11601231,11601777,11602357,11602445,11616972,11618566,11618561,11618583,11619635,11620090,11620249,11620321,11620383,11620413,11624992,11626080,11636219,11636444,11637048,11637788,11650083,11650560,11666482,11666881,11667198,11667192,11667189,11667374,11667520,11668069,11668138,11668252,11678359,11678371,11679328,11680455,11682673,11711196,11712076,11712084,11712059,11713356,11713691,11713739,11713813,11713821,11739794,11739812,11739697,11739814,11756998,11757877,11757994,11757886,11757997,11757885,11757998,11758771,11758779,11758925,11758929,11759017,11759020,11768040,11769165,11770742,11771055,11805823,11805547,11805824,11806071,11807035,11807073,11807301,11807335,11807857,11817093,11818651,11823083,11823909,11825549,11852890,11852921,11853548,11853706,11853546,11853709,11853527,11853685,11854448,11854467,11854744,11854824,11855222,11855243,11865396,11865742,11896305,11896361,11896905,11896933,11896967,11897001,11897038,11904375,11904660,11907294,11907767,11940144,11940460,11940941,11940988,11940938,11940976,11940937,11941006,11942563,11942577,11942672,11942684,11942785,11942789,11949096,11951173,11963453,11965203,11980340,11980354,11980641,11980637,11980639,11981371,11981799,11981924,11982835,11982956,11982983,11983056,12006708,12006795,12021357,12021399,12021582,12021584,12021602,12022008,12022463,12022461,12022567,12022569,12024461,12024497,12031304,12031619,12033467,12046202,12062021,12062023,12062017,12062574,12062951,12063130,12065194,12071178,12087486,12101132,4486,5014,21120,46541,46588,48338,48340,48342,48486,48832,49155,49422,57281,59705,70700,87470,87526,88414,94968,97678,98532,126876,126896,127178,127179,127182,128672,128790,128871,133168,136158,138461,155984,174675,175380,179110,193416,210123,213329,214163,214166,231884,248292,248296,248294,249088,249238,249780,256932,260028,273677,288106,289031,289035,288987,290298,290636,299075,313281,315780,331849,333349,333347,333401,333613,334793,335116,337314,339835,339869,344093,358362,372267,373656,373657,373804) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: