(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` = 82891 WHERE `RP`.`player` = 82891 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107421,107441,122873,123064,122687,122734,122701,122869,123714,124752,246611,247667,249143,257536,258681,259777,262053,264826,265046,277074,277688,281314,283354,283899,299433,299522,300916,301812,301895,301814,301893,303466,337545,337615,342076,342240,345939,346054,371998,372116,373809,373982,10368593,10369462,10370340,10370604,10386384,10386874,10400191,10401545,10403685,10403779,10406620,10406664,10436814,10437071,10440329,10440335,10441378,10441400,10441357,10441394,10441374,10441391,10442136,10442159,10442269,10442952,10443816,10464163,10465379,10464168,10465382,10481073,10481207,10483330,10483559,10510378,10510387,10512427,10512501,10513595,10513598,10514110,10514477,10514550,10540997,10541726,10542527,10542715,10568119,10569863,10569792,10570123,10570207,10570430,10603250,10605143,10605959,10608241,10608610,10640871,10641009,10641098,10648088,10661411,10665038,10665339,10690387,10708167,10708185,10710336,10710489,10727672,10728097,10730184,10730330,10757427,10757500,10758533,10758523,10758526,10758541,10758540,10758527,10760509,10760882,10762099,10762412,10770375,10770396,10772419,10772889,10777103,10778065,10779339,10780387,10795722,10795504,10798050,10798098,10825127,10826327,10826336,10826323,10826560,10826689,10827318,10839143,10839251,10840866,10841238,10843222,10875826,10892890,10892907,10893944,10893941,10893940,10894476,10894534,10894708,10895459,10895498,10904902,10905487,10906596,10921553,10920967,10921265,10937175,10937357,10938049,10938221,10938052,10938216,10938072,10938264,10939504,10940810,10941122,10941628,10948668,10949255,10962267,10962462,10981525,10981600,10983014,10983082,10983017,10983083,10983016,10983117,10983482,10983622,10984035,10985322,10985607,10985680,10998764,10999868,11016403,11016472,11036256,11036467,11038774,11038811,11038889,11038931,11039326,11039374,11055530,11055933,11067460,11067530,11070804,11070842,11084953,11085228,11086250,11086253,11086252,11087223,11087521,11088247,11107268,11107572,11109087,11109101,11121569,11121856,11140352,11140359,11140338,11140354,11140418,11140426,11141212,11141245,11141818,11141831,11141985,11142019,11157929,11159138,11187936,11187938,11188297,11188421,11188457,11188530,11188673,11196097,11196211,11198695,11198904,11213342,11213446,11229202,11229663,11229665,11229662,11230979,11231953,11232139,11232852,11232918,11237881,11237934,11242025,11243275,11244116,11246801,11246887,11253479,11253595,11267467,11268094,11284053,11284064,11286268,11286287,11286266,11286294,11286259,11286301,11286632,11286642,11286783,11287046,11287825,11287834,11302961,11303294,11305692,11307311,11320161,11322666,11337901,11339846,11339841,11339844,11340397,11340422,11341942,11343533,11343738,11360995,11360590,11361636,11361660,11374456,11374510,11391982,11392003,11393067,11393066,11393063,11394417,11394502,11394714,11394795,11394897,11394936,11395570,11395600,11397224,11397323,11416085,11416210,11433556,11433571,11434343,11434325,11434327,11436026,11436039,11436254,11436270,11440495,11440688,11450189,11451438,11450186,11451440,11479177,11479192,11481315,11481318,11481333,11481651,11481800,11481872,11494197,11496099,11500840,11501621,11501291,11501624,11514548,11530272,11531736,11531738,11531749,11532253,11532364,11532640,11532718,11533450,11533626,11538649,11539271,11544364,11545060,11558014,11573351,11574821,11574916,11574818,11575107,11574819,11575076,11575613,11575705,11575919,11575922,11576061,11576088,11576940,11578125,11580938,11581085,11587115,11587565,11601506,11601796,11601972,11602118,11616939,11616969,11618771,11618773,11618646,11620146,11620198,11620245,11620257,11620379,11624824,11634942,11636032,11637909,11651275,11651811,11666491,11666617,11667220,11667292,11667228,11667303,11667231,11667302,11667412,11667519,11668070,11668083,11668248,11678372,11678696,11681201,11682427,11685211,11711157,11713744,11713778,11713809,11738108,11738237,11738149,11738239,11757330,11757947,11757949,11757951,11758765,11758813,11758915,11758963,11767241,11767336,11770038,11805728,11806247,11805730,11806188,11805732,11806190,11807026,11807023,11807329,11807467,11807874,11807924,11816917,11816921,11822870,11825466,11822928,11825548,11852608,11852690,11853642,11853896,11853645,11853895,11853898,11854348,11854487,11854490,11854818,11855218,11865264,11867579,11895944,11896214,11896861,11896874,11896877,11896951,11897006,11897080,11904544,11907711,11940774,11941092,11941681,11941089,11941162,11941058,11942594,11942723,11942727,11942759,11949514,11951627,11963424,11965107,11980353,11981368,11981763,11982465,11982855,11983068,12006091,12021345,12022188,12022264,12022402,12022409,12022518,12022540,12024137,12024268,12031134,12031133,12034330,12046865,12046904,12061212,12061223,12065151,12065192,12071152,12071168,12085056,12085126,12101125,12101136,12102027,12102028,12102030,12103337,12103545,12103787,4255,4309,4257,4439,21172,46557,47232,47411,48162,48171,48140,48378,49121,49274,49327,57291,57305,70838,71877,85621,86557,86555,86566,87344,87462,87512,88481,89037,94915,99584,126581,127140,127145,127142,128678,128797,128882,133803,134666,136186,138423,172873,173796,173787,173780,174607,175071,175372,177975,193460,193465,210156,211044,211045,211051,212558,212736,212775,213182,213315,214002,214949,213884,215959,220459,247361,248330,248328,248334,249106,249232,249782,257409,260255,260533,272687,288441,290124,290621,299094,332247,333119,333350,333348,333351,333632,335060,337347,337892,339932,341292,339944,341289,345253,373584,373575,373574,373731,373801,374430,374619) ) 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` = 82891 WHERE `RP`.`player` = 82891 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107421,107441,122873,123064,122687,122734,122701,122869,123714,124752,246611,247667,249143,257536,258681,259777,262053,264826,265046,277074,277688,281314,283354,283899,299433,299522,300916,301812,301895,301814,301893,303466,337545,337615,342076,342240,345939,346054,371998,372116,373809,373982,10368593,10369462,10370340,10370604,10386384,10386874,10400191,10401545,10403685,10403779,10406620,10406664,10436814,10437071,10440329,10440335,10441378,10441400,10441357,10441394,10441374,10441391,10442136,10442159,10442269,10442952,10443816,10464163,10465379,10464168,10465382,10481073,10481207,10483330,10483559,10510378,10510387,10512427,10512501,10513595,10513598,10514110,10514477,10514550,10540997,10541726,10542527,10542715,10568119,10569863,10569792,10570123,10570207,10570430,10603250,10605143,10605959,10608241,10608610,10640871,10641009,10641098,10648088,10661411,10665038,10665339,10690387,10708167,10708185,10710336,10710489,10727672,10728097,10730184,10730330,10757427,10757500,10758533,10758523,10758526,10758541,10758540,10758527,10760509,10760882,10762099,10762412,10770375,10770396,10772419,10772889,10777103,10778065,10779339,10780387,10795722,10795504,10798050,10798098,10825127,10826327,10826336,10826323,10826560,10826689,10827318,10839143,10839251,10840866,10841238,10843222,10875826,10892890,10892907,10893944,10893941,10893940,10894476,10894534,10894708,10895459,10895498,10904902,10905487,10906596,10921553,10920967,10921265,10937175,10937357,10938049,10938221,10938052,10938216,10938072,10938264,10939504,10940810,10941122,10941628,10948668,10949255,10962267,10962462,10981525,10981600,10983014,10983082,10983017,10983083,10983016,10983117,10983482,10983622,10984035,10985322,10985607,10985680,10998764,10999868,11016403,11016472,11036256,11036467,11038774,11038811,11038889,11038931,11039326,11039374,11055530,11055933,11067460,11067530,11070804,11070842,11084953,11085228,11086250,11086253,11086252,11087223,11087521,11088247,11107268,11107572,11109087,11109101,11121569,11121856,11140352,11140359,11140338,11140354,11140418,11140426,11141212,11141245,11141818,11141831,11141985,11142019,11157929,11159138,11187936,11187938,11188297,11188421,11188457,11188530,11188673,11196097,11196211,11198695,11198904,11213342,11213446,11229202,11229663,11229665,11229662,11230979,11231953,11232139,11232852,11232918,11237881,11237934,11242025,11243275,11244116,11246801,11246887,11253479,11253595,11267467,11268094,11284053,11284064,11286268,11286287,11286266,11286294,11286259,11286301,11286632,11286642,11286783,11287046,11287825,11287834,11302961,11303294,11305692,11307311,11320161,11322666,11337901,11339846,11339841,11339844,11340397,11340422,11341942,11343533,11343738,11360995,11360590,11361636,11361660,11374456,11374510,11391982,11392003,11393067,11393066,11393063,11394417,11394502,11394714,11394795,11394897,11394936,11395570,11395600,11397224,11397323,11416085,11416210,11433556,11433571,11434343,11434325,11434327,11436026,11436039,11436254,11436270,11440495,11440688,11450189,11451438,11450186,11451440,11479177,11479192,11481315,11481318,11481333,11481651,11481800,11481872,11494197,11496099,11500840,11501621,11501291,11501624,11514548,11530272,11531736,11531738,11531749,11532253,11532364,11532640,11532718,11533450,11533626,11538649,11539271,11544364,11545060,11558014,11573351,11574821,11574916,11574818,11575107,11574819,11575076,11575613,11575705,11575919,11575922,11576061,11576088,11576940,11578125,11580938,11581085,11587115,11587565,11601506,11601796,11601972,11602118,11616939,11616969,11618771,11618773,11618646,11620146,11620198,11620245,11620257,11620379,11624824,11634942,11636032,11637909,11651275,11651811,11666491,11666617,11667220,11667292,11667228,11667303,11667231,11667302,11667412,11667519,11668070,11668083,11668248,11678372,11678696,11681201,11682427,11685211,11711157,11713744,11713778,11713809,11738108,11738237,11738149,11738239,11757330,11757947,11757949,11757951,11758765,11758813,11758915,11758963,11767241,11767336,11770038,11805728,11806247,11805730,11806188,11805732,11806190,11807026,11807023,11807329,11807467,11807874,11807924,11816917,11816921,11822870,11825466,11822928,11825548,11852608,11852690,11853642,11853896,11853645,11853895,11853898,11854348,11854487,11854490,11854818,11855218,11865264,11867579,11895944,11896214,11896861,11896874,11896877,11896951,11897006,11897080,11904544,11907711,11940774,11941092,11941681,11941089,11941162,11941058,11942594,11942723,11942727,11942759,11949514,11951627,11963424,11965107,11980353,11981368,11981763,11982465,11982855,11983068,12006091,12021345,12022188,12022264,12022402,12022409,12022518,12022540,12024137,12024268,12031134,12031133,12034330,12046865,12046904,12061212,12061223,12065151,12065192,12071152,12071168,12085056,12085126,12101125,12101136,12102027,12102028,12102030,12103337,12103545,12103787,4255,4309,4257,4439,21172,46557,47232,47411,48162,48171,48140,48378,49121,49274,49327,57291,57305,70838,71877,85621,86557,86555,86566,87344,87462,87512,88481,89037,94915,99584,126581,127140,127145,127142,128678,128797,128882,133803,134666,136186,138423,172873,173796,173787,173780,174607,175071,175372,177975,193460,193465,210156,211044,211045,211051,212558,212736,212775,213182,213315,214002,214949,213884,215959,220459,247361,248330,248328,248334,249106,249232,249782,257409,260255,260533,272687,288441,290124,290621,299094,332247,333119,333350,333348,333351,333632,335060,337347,337892,339932,341292,339944,341289,345253,373584,373575,373574,373731,373801,374430,374619) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: