(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` = 84948 WHERE `RP`.`player` = 84948 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107566,107804,122171,122715,122671,124169,124127,124129,214037,214040,214803,235787,235790,249107,257396,257445,259843,260097,262027,262040,264583,265544,277094,278636,281041,281592,283378,283871,299589,299624,300954,300966,301830,301842,301835,301843,303418,303424,317090,326402,342050,342185,345950,346677,372023,372140,373307,373383,10368844,10368886,10369934,10370041,10385841,10387260,10399945,10400759,10402901,10403627,10406191,10406619,10436953,10437055,10440663,10441440,10441306,10441485,10442131,10442201,10442267,10442331,10443334,10443472,10464395,10465597,10464264,10466068,10481034,10481524,10482753,10483521,10510358,10510822,10512489,10513566,10513567,10514132,10514160,10514418,10514462,10514511,10514521,10540766,10540767,10543266,10544183,10568092,10568140,10570111,10570164,10570208,10570586,10570662,10570884,10570909,10602764,10602905,10604950,10605399,10608148,10608152,10637768,10638229,10639590,10639609,10639659,10640838,10641101,10647866,10647878,10661105,10661732,10664888,10665326,10690449,10690554,10691505,10692144,10691512,10692146,10691677,10692228,10692406,10692443,10692706,10692809,10693177,10693179,10708580,10709300,10710395,10710539,10727467,10727769,10730147,10730183,10757455,10757450,10758544,10758610,10758615,10759667,10758608,10759669,10760424,10760838,10760893,10760928,10762026,10762233,10770819,10771759,10772509,10774759,10777531,10778125,10779564,10780093,10794762,10796457,10798488,10798529,10825131,10826317,10826449,10826277,10826448,10826280,10826465,10826557,10826580,10826719,10826870,10827323,10827978,10839206,10839221,10840980,10841344,10842524,10842668,10892888,10892902,10893928,10893947,10893925,10893932,10893920,10893934,10894175,10894326,10894560,10894740,10895547,10895550,10904363,10905063,10906566,10906715,10920157,10920785,10937007,10939512,10939573,10940494,10941088,10941609,10948359,10948455,10962209,10962488,10981503,10981540,10983001,10983073,10983010,10983103,10983008,10983075,10983401,10983481,10984065,10984069,10985564,10985668,10998999,10999105,11015475,11016723,11036726,11038389,11038609,11038388,11038570,11038385,11038615,11038769,11038799,11038899,11038941,11039437,11039516,11055718,11056196,11067180,11067434,11070852,11071585,11084944,11085134,11086182,11086282,11086155,11086290,11086086,11086514,11087201,11087315,11087564,11087579,11088925,11106784,11107190,11108869,11109428,11121132,11121241,11139753,11139996,11140661,11140664,11140641,11141354,11141380,11141885,11141916,11141991,11142001,11157942,11158088,11186344,11186387,11186716,11186795,11186800,11187278,11186757,11187400,11188269,11188316,11188389,11188400,11188947,11189014,11195527,11195863,11198692,11198751,11213394,11229211,11229370,11229784,11230237,11229947,11230275,11229950,11230351,11230862,11231067,11232030,11232091,11232769,11233089,11238104,11238259,11240860,11241891,11243261,11243920,11246812,11246880,11253679,11254143,11267333,11267606,11284063,11284092,11286338,11286437,11286343,11286430,11286340,11286475,11286611,11286683,11286814,11286837,11287785,11287935,11303138,11306641,11320481,11322403,11337907,11338790,11339974,11340159,11339999,11340161,11339976,11340195,11340425,11340439,11342036,11342840,11343931,11359634,11359755,11361694,11362576,11374509,11376427,11391988,11393263,11393286,11393086,11393266,11393056,11393279,11394343,11394355,11394774,11394793,11394873,11394914,11395385,11395950,11396948,11397043,11416294,11417261,11433540,11434301,11434354,11434338,11434369,11434340,11434367,11435988,11436038,11436226,11436261,11439987,11440165,11450345,11450190,11450343,11450185,11479175,11481330,11481336,11481332,11481337,11481343,11481334,11481654,11481691,11481784,11481839,11481875,11494207,11494215,11500362,11500612,11500546,11500609,11514282,11514867,11530226,11530234,11531664,11531671,11531695,11532028,11532363,11532594,11532608,11532804,11532864,11538391,11538425,11543461,11543523,11557221,11558062,11573295,11574801,11574814,11574799,11574804,11574806,11574816,11575602,11575667,11575886,11575902,11576027,11576044,11577213,11578265,11579717,11579882,11587386,11587672,11601297,11601290,11601898,11601923,11616945,11618579,11618587,11618576,11619527,11619738,11620244,11620250,11620385,11620438,11624826,11625497,11635110,11635398,11637231,11637787,11649900,11650117,11666296,11666643,11667230,11667234,11667232,11667539,11668108,11668228,11678239,11678368,11679047,11679334,11682428,11683592,11711159,11711163,11712117,11712110,11712115,11713331,11713551,11713652,11713687,11713791,11713838,11738031,11738519,11737942,11738564,11756987,11756988,11757888,11757891,11757904,11758758,11758793,11758889,11758908,11758953,11758979,11767262,11767467,11769538,11769787,11806010,11806013,11805975,11806999,11807045,11807289,11807391,11807869,11807872,11816908,11816947,11823332,11823406,11823405,11823469,11852604,11853810,11853815,11853813,11854432,11854728,11854916,11855246,11865442,11867578,11896187,11896249,11896871,11896827,11896778,11896934,11896976,11897009,11897016,11897062,11897102,11904907,11904783,11908091,11940097,11940268,11941132,11941244,11941134,11942562,11942681,11942713,11942764,11942778,11949690,11949716,11963441,11965106,11980345,11980369,11980614,11980786,11980750,11980880,11980620,11980783,11981370,11981390,11981834,11982013,11982884,11982922,11983008,11983061,12006106,12006788,12021366,12021625,12021628,12021627,12022222,12022429,12022471,12022528,12022581,12024454,12024720,12031306,12031358,12033475,12034351,12046672,12047570,12061228,12061250,12062078,12062150,12062072,12062124,12062109,12062127,12062614,12062748,12062953,12063000,12063077,12063090,12065152,12065232,12071112,12071157,12085826,12085933,12101126,12102040,12102038,12102036,12102777,12102959,12103538,12103570,12103736,12103758,4268,4355,4270,4357,20701,20737,46545,47133,47391,48193,48225,48184,48251,48186,48253,48387,48391,48895,48942,49135,49188,49225,49253,57319,57522,59722,70889,85615,86597,86600,86602,87324,87465,87540,88482,88645,94145,94163,97505,97778,99266,99317,126223,126635,128653,128697,128821,128845,128887,128927,133789,133952,136735,136821,138457,138469,145325,156567,173134,173775,173761,173778,173781,173784,173779,174583,174616,174934,174997,175381,175387,177355,177865,193464,194245,210129,210150,210998,210999,211001,212550,212571,212735,212752,212784,212830,213015,213198,213591,213694,213619,213701,220241,220277,247365,247368,248248,248253,248270,249123,249184,249217,249251,249834,249867,256931,257095,260223,260256,261973,272677,288237,289156,289116,289157,289114,289160,289137,289832,289820,290136,290305,290607,290648,299039,313254,313625,315858,316522,331817,331836,333359,333433,333365,333436,333352,333437,333609,333615,334794,334839,335033,337401,337407,340471,341485,339856,340468,344297,358157,358356,372040,372909,372968,372911,373776,374329,374382,374579,374588) ) 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` = 84948 WHERE `RP`.`player` = 84948 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107566,107804,122171,122715,122671,124169,124127,124129,214037,214040,214803,235787,235790,249107,257396,257445,259843,260097,262027,262040,264583,265544,277094,278636,281041,281592,283378,283871,299589,299624,300954,300966,301830,301842,301835,301843,303418,303424,317090,326402,342050,342185,345950,346677,372023,372140,373307,373383,10368844,10368886,10369934,10370041,10385841,10387260,10399945,10400759,10402901,10403627,10406191,10406619,10436953,10437055,10440663,10441440,10441306,10441485,10442131,10442201,10442267,10442331,10443334,10443472,10464395,10465597,10464264,10466068,10481034,10481524,10482753,10483521,10510358,10510822,10512489,10513566,10513567,10514132,10514160,10514418,10514462,10514511,10514521,10540766,10540767,10543266,10544183,10568092,10568140,10570111,10570164,10570208,10570586,10570662,10570884,10570909,10602764,10602905,10604950,10605399,10608148,10608152,10637768,10638229,10639590,10639609,10639659,10640838,10641101,10647866,10647878,10661105,10661732,10664888,10665326,10690449,10690554,10691505,10692144,10691512,10692146,10691677,10692228,10692406,10692443,10692706,10692809,10693177,10693179,10708580,10709300,10710395,10710539,10727467,10727769,10730147,10730183,10757455,10757450,10758544,10758610,10758615,10759667,10758608,10759669,10760424,10760838,10760893,10760928,10762026,10762233,10770819,10771759,10772509,10774759,10777531,10778125,10779564,10780093,10794762,10796457,10798488,10798529,10825131,10826317,10826449,10826277,10826448,10826280,10826465,10826557,10826580,10826719,10826870,10827323,10827978,10839206,10839221,10840980,10841344,10842524,10842668,10892888,10892902,10893928,10893947,10893925,10893932,10893920,10893934,10894175,10894326,10894560,10894740,10895547,10895550,10904363,10905063,10906566,10906715,10920157,10920785,10937007,10939512,10939573,10940494,10941088,10941609,10948359,10948455,10962209,10962488,10981503,10981540,10983001,10983073,10983010,10983103,10983008,10983075,10983401,10983481,10984065,10984069,10985564,10985668,10998999,10999105,11015475,11016723,11036726,11038389,11038609,11038388,11038570,11038385,11038615,11038769,11038799,11038899,11038941,11039437,11039516,11055718,11056196,11067180,11067434,11070852,11071585,11084944,11085134,11086182,11086282,11086155,11086290,11086086,11086514,11087201,11087315,11087564,11087579,11088925,11106784,11107190,11108869,11109428,11121132,11121241,11139753,11139996,11140661,11140664,11140641,11141354,11141380,11141885,11141916,11141991,11142001,11157942,11158088,11186344,11186387,11186716,11186795,11186800,11187278,11186757,11187400,11188269,11188316,11188389,11188400,11188947,11189014,11195527,11195863,11198692,11198751,11213394,11229211,11229370,11229784,11230237,11229947,11230275,11229950,11230351,11230862,11231067,11232030,11232091,11232769,11233089,11238104,11238259,11240860,11241891,11243261,11243920,11246812,11246880,11253679,11254143,11267333,11267606,11284063,11284092,11286338,11286437,11286343,11286430,11286340,11286475,11286611,11286683,11286814,11286837,11287785,11287935,11303138,11306641,11320481,11322403,11337907,11338790,11339974,11340159,11339999,11340161,11339976,11340195,11340425,11340439,11342036,11342840,11343931,11359634,11359755,11361694,11362576,11374509,11376427,11391988,11393263,11393286,11393086,11393266,11393056,11393279,11394343,11394355,11394774,11394793,11394873,11394914,11395385,11395950,11396948,11397043,11416294,11417261,11433540,11434301,11434354,11434338,11434369,11434340,11434367,11435988,11436038,11436226,11436261,11439987,11440165,11450345,11450190,11450343,11450185,11479175,11481330,11481336,11481332,11481337,11481343,11481334,11481654,11481691,11481784,11481839,11481875,11494207,11494215,11500362,11500612,11500546,11500609,11514282,11514867,11530226,11530234,11531664,11531671,11531695,11532028,11532363,11532594,11532608,11532804,11532864,11538391,11538425,11543461,11543523,11557221,11558062,11573295,11574801,11574814,11574799,11574804,11574806,11574816,11575602,11575667,11575886,11575902,11576027,11576044,11577213,11578265,11579717,11579882,11587386,11587672,11601297,11601290,11601898,11601923,11616945,11618579,11618587,11618576,11619527,11619738,11620244,11620250,11620385,11620438,11624826,11625497,11635110,11635398,11637231,11637787,11649900,11650117,11666296,11666643,11667230,11667234,11667232,11667539,11668108,11668228,11678239,11678368,11679047,11679334,11682428,11683592,11711159,11711163,11712117,11712110,11712115,11713331,11713551,11713652,11713687,11713791,11713838,11738031,11738519,11737942,11738564,11756987,11756988,11757888,11757891,11757904,11758758,11758793,11758889,11758908,11758953,11758979,11767262,11767467,11769538,11769787,11806010,11806013,11805975,11806999,11807045,11807289,11807391,11807869,11807872,11816908,11816947,11823332,11823406,11823405,11823469,11852604,11853810,11853815,11853813,11854432,11854728,11854916,11855246,11865442,11867578,11896187,11896249,11896871,11896827,11896778,11896934,11896976,11897009,11897016,11897062,11897102,11904907,11904783,11908091,11940097,11940268,11941132,11941244,11941134,11942562,11942681,11942713,11942764,11942778,11949690,11949716,11963441,11965106,11980345,11980369,11980614,11980786,11980750,11980880,11980620,11980783,11981370,11981390,11981834,11982013,11982884,11982922,11983008,11983061,12006106,12006788,12021366,12021625,12021628,12021627,12022222,12022429,12022471,12022528,12022581,12024454,12024720,12031306,12031358,12033475,12034351,12046672,12047570,12061228,12061250,12062078,12062150,12062072,12062124,12062109,12062127,12062614,12062748,12062953,12063000,12063077,12063090,12065152,12065232,12071112,12071157,12085826,12085933,12101126,12102040,12102038,12102036,12102777,12102959,12103538,12103570,12103736,12103758,4268,4355,4270,4357,20701,20737,46545,47133,47391,48193,48225,48184,48251,48186,48253,48387,48391,48895,48942,49135,49188,49225,49253,57319,57522,59722,70889,85615,86597,86600,86602,87324,87465,87540,88482,88645,94145,94163,97505,97778,99266,99317,126223,126635,128653,128697,128821,128845,128887,128927,133789,133952,136735,136821,138457,138469,145325,156567,173134,173775,173761,173778,173781,173784,173779,174583,174616,174934,174997,175381,175387,177355,177865,193464,194245,210129,210150,210998,210999,211001,212550,212571,212735,212752,212784,212830,213015,213198,213591,213694,213619,213701,220241,220277,247365,247368,248248,248253,248270,249123,249184,249217,249251,249834,249867,256931,257095,260223,260256,261973,272677,288237,289156,289116,289157,289114,289160,289137,289832,289820,290136,290305,290607,290648,299039,313254,313625,315858,316522,331817,331836,333359,333433,333365,333436,333352,333437,333609,333615,334794,334839,335033,337401,337407,340471,341485,339856,340468,344297,358157,358356,372040,372909,372968,372911,373776,374329,374382,374579,374588) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: