(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` = 76687 WHERE `RP`.`player` = 76687 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107458,107593,122007,122232,122656,123191,122237,124042,122245,124606,212857,215067,216729,234845,235254,234848,235255,246673,247236,257318,259692,259780,261997,262005,264550,264753,277636,278172,281002,281615,283369,283412,299104,299689,300895,300987,301793,303416,303422,326378,342213,342288,345757,346073,371937,372061,373384,373701,10368596,10368927,10370290,10370650,10387170,10387384,10400245,10400264,10403165,10403178,10406414,10407304,10436664,10437360,10440365,10440541,10441320,10441335,10441322,10442202,10442249,10442951,10443751,10464396,10477531,10464517,10477797,10481402,10481596,10482486,10483755,10510341,10510313,10512619,10512660,10513627,10513636,10513652,10514157,10514247,10514467,10514486,10514548,10541283,10541638,10543820,10544085,10568120,10568555,10569864,10569942,10569865,10570006,10570092,10570101,10570158,10570353,10570557,10570770,10583735,10602899,10605140,10605322,10608145,10608197,10637695,10638164,10639596,10640378,10639611,10640379,10639599,10640831,10640995,10641074,10641685,10648146,10648201,10662029,10662589,10664991,10665205,10690389,10690650,10691727,10691568,10691599,10692355,10692437,10692487,10692500,10692797,10693214,10694402,10708380,10708446,10710505,10710947,10727540,10730699,10731074,10757705,10758008,10758662,10759091,10758601,10758890,10758607,10759152,10760457,10760474,10760963,10760966,10762343,10762398,10770778,10771525,10773211,10773884,10778750,10779607,10780219,10797382,10796345,10799611,10800166,10825203,10826392,10826393,10826444,10826396,10826457,10826617,10826912,10827869,10827900,10839207,10839535,10841343,10841357,10843526,10843530,10892897,10893354,10893901,10893904,10893888,10894023,10894586,10894669,10895463,10904323,10904729,10906591,10906595,10921070,10921113,10937239,10937800,10938197,10939061,10938192,10938852,10938611,10938854,10939561,10939589,10940823,10941405,10941606,10941624,10948999,10949191,10963375,10964819,10981553,10981559,10983013,10983039,10983029,10983555,10983731,10984062,10984085,10985666,10985949,10998749,10999655,11015618,11016345,11036431,11036985,11038469,11038610,11038480,11038618,11038488,11038489,11038816,11038817,11038908,11038928,11039377,11039515,11055821,11056112,11067593,11068320,11070812,11071532,11085379,11085620,11086181,11086215,11086184,11087264,11087258,11087561,11087937,11088072,11107551,11107571,11108943,11109367,11121504,11121676,11139749,11139809,11140585,11140709,11140588,11140640,11140642,11140678,11141199,11141348,11141811,11141920,11141982,11142040,11158257,11158502,11186318,11186349,11186740,11186750,11186741,11187133,11186758,11187116,11188275,11188422,11188433,11188548,11188996,11195679,11196212,11198662,11198789,11213425,11213448,11229198,11230106,11230108,11230110,11231925,11232796,11232996,11239251,11239880,11241031,11241412,11243458,11244326,11246771,11246916,11253616,11253918,11268317,11269156,11284081,11286248,11286257,11286569,11286253,11286536,11286636,11286643,11287119,11287297,11287833,11287885,11303119,11303153,11305655,11306211,11320448,11321995,11337891,11337893,11339998,11340119,11340000,11340114,11339995,11340115,11340406,11340415,11341479,11341563,11341878,11342062,11342731,11343890,11360025,11360259,11361648,11361661,11374482,11374521,11391989,11392063,11393073,11393146,11393099,11393148,11393101,11393159,11394403,11394702,11394711,11394861,11394925,11395211,11395239,11397047,11397501,11416455,11416914,11433646,11433655,11434363,11434408,11434365,11434473,11434362,11434435,11435987,11435995,11436217,11436325,11440075,11441386,11449738,11452577,11449739,11452490,11479204,11479230,11481347,11481405,11481367,11481431,11481402,11481366,11481701,11481740,11481819,11481841,11481914,11481930,11494272,11495153,11500365,11501782,11500351,11501785,11514883,11515633,11530256,11531627,11531620,11531921,11531622,11531924,11532027,11532294,11532631,11532671,11533030,11533223,11538440,11538456,11544280,11544463,11557644,11557891,11573311,11574912,11574865,11574867,11574913,11574869,11574995,11575599,11575659,11575912,11575951,11576062,11576076,11576939,11577593,11579743,11580156,11586946,11587385,11601465,11601571,11601902,11602649,11616943,11616983,11618735,11618772,11618724,11618774,11618725,11619023,11619834,11619877,11620233,11620278,11620389,11627769,11635006,11635812,11637179,11637391,11650247,11650744,11666511,11666951,11667211,11667281,11667208,11667280,11667206,11667283,11667774,11667808,11668106,11668141,11668212,11678682,11678709,11680665,11683082,11683614,11711162,11712096,11712188,11712100,11712201,11712087,11712190,11713486,11713653,11713783,11713839,11739690,11739708,11739696,11739704,11757007,11757946,11758023,11757948,11758021,11757950,11758019,11758767,11758803,11758866,11758960,11758996,11768069,11769202,11769990,11771293,11805588,11806059,11805596,11806056,11805634,11806047,11807062,11807070,11807436,11807555,11807912,11807910,11816916,11818118,11823890,11824423,11823893,11824425,11852609,11852659,11853766,11854289,11853630,11854291,11853626,11854292,11854468,11854478,11854758,11854976,11855262,11855275,11866889,11896094,11896521,11896756,11896841,11896759,11896836,11896760,11896839,11896938,11896968,11896997,11897003,11897073,11897098,11904982,11905030,11907967,11909006,11940166,11940646,11942573,11942661,11942765,11949718,11951622,11964760,11965225,11980361,11980372,11980648,11980938,11980609,11980941,11980604,11980997,11981385,11981406,11981925,11982108,11982874,11982948,11983080,11983082,12006474,12006622,12021380,12021387,12021613,12021615,12021617,12022089,12022371,12022396,12022400,12022515,12022532,12024136,12024292,12031106,12031394,12033824,12034073,12046127,12046758,12061238,12062004,12062006,12062210,12062008,12062208,12062634,12062877,12062984,12063029,12063065,12063061,12065172,12065280,12071151,12071153,12085043,12085057,12101134,12101161,12102070,12102080,12102078,12103098,12103571,12103601,12103780,12103799,4327,4351,21149,46493,47172,47413,47434,48138,48202,48141,48198,48146,48199,48578,48537,48871,49012,49147,49194,49328,49681,57505,59706,70604,85636,85652,86504,86509,86501,86512,86500,86505,87334,87364,87435,87454,87524,87557,88545,88843,94180,94877,97498,97834,98619,99354,126644,126774,127089,127119,127095,127114,127104,127127,128633,128661,128814,128819,128885,128929,133875,133913,136156,136855,139022,139089,157393,172837,172867,173734,173869,173737,173872,173735,173874,174628,174943,174989,175383,175468,177657,178427,193406,193442,211132,211121,211133,212602,212679,212696,212777,212829,212872,213361,213371,213592,213620,216307,219743,220418,247360,248362,248357,248404,248356,248401,249079,249105,249277,249880,250009,257217,257307,260475,272690,274344,288518,289353,289443,289358,289446,289356,289423,289831,289867,290165,290195,290591,290613,299064,299100,313388,316070,316317,331827,331834,333353,333327,333534,333387,333535,333621,334662,334775,335026,335113,337399,337875,339652,341755,339894,341657,344416,345189,358127,358347,372497,373039,373123,372980,373126,373013,373127,373817,373820,374348,374477,374537,374633) ) 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` = 76687 WHERE `RP`.`player` = 76687 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107458,107593,122007,122232,122656,123191,122237,124042,122245,124606,212857,215067,216729,234845,235254,234848,235255,246673,247236,257318,259692,259780,261997,262005,264550,264753,277636,278172,281002,281615,283369,283412,299104,299689,300895,300987,301793,303416,303422,326378,342213,342288,345757,346073,371937,372061,373384,373701,10368596,10368927,10370290,10370650,10387170,10387384,10400245,10400264,10403165,10403178,10406414,10407304,10436664,10437360,10440365,10440541,10441320,10441335,10441322,10442202,10442249,10442951,10443751,10464396,10477531,10464517,10477797,10481402,10481596,10482486,10483755,10510341,10510313,10512619,10512660,10513627,10513636,10513652,10514157,10514247,10514467,10514486,10514548,10541283,10541638,10543820,10544085,10568120,10568555,10569864,10569942,10569865,10570006,10570092,10570101,10570158,10570353,10570557,10570770,10583735,10602899,10605140,10605322,10608145,10608197,10637695,10638164,10639596,10640378,10639611,10640379,10639599,10640831,10640995,10641074,10641685,10648146,10648201,10662029,10662589,10664991,10665205,10690389,10690650,10691727,10691568,10691599,10692355,10692437,10692487,10692500,10692797,10693214,10694402,10708380,10708446,10710505,10710947,10727540,10730699,10731074,10757705,10758008,10758662,10759091,10758601,10758890,10758607,10759152,10760457,10760474,10760963,10760966,10762343,10762398,10770778,10771525,10773211,10773884,10778750,10779607,10780219,10797382,10796345,10799611,10800166,10825203,10826392,10826393,10826444,10826396,10826457,10826617,10826912,10827869,10827900,10839207,10839535,10841343,10841357,10843526,10843530,10892897,10893354,10893901,10893904,10893888,10894023,10894586,10894669,10895463,10904323,10904729,10906591,10906595,10921070,10921113,10937239,10937800,10938197,10939061,10938192,10938852,10938611,10938854,10939561,10939589,10940823,10941405,10941606,10941624,10948999,10949191,10963375,10964819,10981553,10981559,10983013,10983039,10983029,10983555,10983731,10984062,10984085,10985666,10985949,10998749,10999655,11015618,11016345,11036431,11036985,11038469,11038610,11038480,11038618,11038488,11038489,11038816,11038817,11038908,11038928,11039377,11039515,11055821,11056112,11067593,11068320,11070812,11071532,11085379,11085620,11086181,11086215,11086184,11087264,11087258,11087561,11087937,11088072,11107551,11107571,11108943,11109367,11121504,11121676,11139749,11139809,11140585,11140709,11140588,11140640,11140642,11140678,11141199,11141348,11141811,11141920,11141982,11142040,11158257,11158502,11186318,11186349,11186740,11186750,11186741,11187133,11186758,11187116,11188275,11188422,11188433,11188548,11188996,11195679,11196212,11198662,11198789,11213425,11213448,11229198,11230106,11230108,11230110,11231925,11232796,11232996,11239251,11239880,11241031,11241412,11243458,11244326,11246771,11246916,11253616,11253918,11268317,11269156,11284081,11286248,11286257,11286569,11286253,11286536,11286636,11286643,11287119,11287297,11287833,11287885,11303119,11303153,11305655,11306211,11320448,11321995,11337891,11337893,11339998,11340119,11340000,11340114,11339995,11340115,11340406,11340415,11341479,11341563,11341878,11342062,11342731,11343890,11360025,11360259,11361648,11361661,11374482,11374521,11391989,11392063,11393073,11393146,11393099,11393148,11393101,11393159,11394403,11394702,11394711,11394861,11394925,11395211,11395239,11397047,11397501,11416455,11416914,11433646,11433655,11434363,11434408,11434365,11434473,11434362,11434435,11435987,11435995,11436217,11436325,11440075,11441386,11449738,11452577,11449739,11452490,11479204,11479230,11481347,11481405,11481367,11481431,11481402,11481366,11481701,11481740,11481819,11481841,11481914,11481930,11494272,11495153,11500365,11501782,11500351,11501785,11514883,11515633,11530256,11531627,11531620,11531921,11531622,11531924,11532027,11532294,11532631,11532671,11533030,11533223,11538440,11538456,11544280,11544463,11557644,11557891,11573311,11574912,11574865,11574867,11574913,11574869,11574995,11575599,11575659,11575912,11575951,11576062,11576076,11576939,11577593,11579743,11580156,11586946,11587385,11601465,11601571,11601902,11602649,11616943,11616983,11618735,11618772,11618724,11618774,11618725,11619023,11619834,11619877,11620233,11620278,11620389,11627769,11635006,11635812,11637179,11637391,11650247,11650744,11666511,11666951,11667211,11667281,11667208,11667280,11667206,11667283,11667774,11667808,11668106,11668141,11668212,11678682,11678709,11680665,11683082,11683614,11711162,11712096,11712188,11712100,11712201,11712087,11712190,11713486,11713653,11713783,11713839,11739690,11739708,11739696,11739704,11757007,11757946,11758023,11757948,11758021,11757950,11758019,11758767,11758803,11758866,11758960,11758996,11768069,11769202,11769990,11771293,11805588,11806059,11805596,11806056,11805634,11806047,11807062,11807070,11807436,11807555,11807912,11807910,11816916,11818118,11823890,11824423,11823893,11824425,11852609,11852659,11853766,11854289,11853630,11854291,11853626,11854292,11854468,11854478,11854758,11854976,11855262,11855275,11866889,11896094,11896521,11896756,11896841,11896759,11896836,11896760,11896839,11896938,11896968,11896997,11897003,11897073,11897098,11904982,11905030,11907967,11909006,11940166,11940646,11942573,11942661,11942765,11949718,11951622,11964760,11965225,11980361,11980372,11980648,11980938,11980609,11980941,11980604,11980997,11981385,11981406,11981925,11982108,11982874,11982948,11983080,11983082,12006474,12006622,12021380,12021387,12021613,12021615,12021617,12022089,12022371,12022396,12022400,12022515,12022532,12024136,12024292,12031106,12031394,12033824,12034073,12046127,12046758,12061238,12062004,12062006,12062210,12062008,12062208,12062634,12062877,12062984,12063029,12063065,12063061,12065172,12065280,12071151,12071153,12085043,12085057,12101134,12101161,12102070,12102080,12102078,12103098,12103571,12103601,12103780,12103799,4327,4351,21149,46493,47172,47413,47434,48138,48202,48141,48198,48146,48199,48578,48537,48871,49012,49147,49194,49328,49681,57505,59706,70604,85636,85652,86504,86509,86501,86512,86500,86505,87334,87364,87435,87454,87524,87557,88545,88843,94180,94877,97498,97834,98619,99354,126644,126774,127089,127119,127095,127114,127104,127127,128633,128661,128814,128819,128885,128929,133875,133913,136156,136855,139022,139089,157393,172837,172867,173734,173869,173737,173872,173735,173874,174628,174943,174989,175383,175468,177657,178427,193406,193442,211132,211121,211133,212602,212679,212696,212777,212829,212872,213361,213371,213592,213620,216307,219743,220418,247360,248362,248357,248404,248356,248401,249079,249105,249277,249880,250009,257217,257307,260475,272690,274344,288518,289353,289443,289358,289446,289356,289423,289831,289867,290165,290195,290591,290613,299064,299100,313388,316070,316317,331827,331834,333353,333327,333534,333387,333535,333621,334662,334775,335026,335113,337399,337875,339652,341755,339894,341657,344416,345189,358127,358347,372497,373039,373123,372980,373126,373013,373127,373817,373820,374348,374477,374537,374633) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: