(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` = 66498 WHERE `RP`.`player` = 66498 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107403,107451,122088,122192,122086,122657,122678,124043,122834,124025,212765,212858,212736,212768,212770,213309,235402,235801,235181,235800,244154,246469,248570,248052,257325,257632,259712,259718,261983,262043,264400,265160,277222,277456,281181,281247,283334,284489,299243,299509,300900,300964,301861,301896,301860,301894,303452,303471,337226,337683,342025,342274,345808,345986,372010,372134,373178,373412,10368602,10368800,10369996,10370607,10370689,10386208,10386292,10399652,10400296,10403026,10403403,10406343,10406553,10436886,10437373,10440294,10440348,10441290,10441459,10441301,10441442,10441291,10441453,10442161,10442221,10442292,10442317,10443866,10464091,10464273,10464095,10464325,10481024,10481317,10482660,10483329,10510393,10510937,10512491,10513593,10513591,10514223,10514367,10514475,10514507,10514551,10540799,10541070,10542624,10543265,10568250,10568661,10570086,10570105,10570155,10570197,10570754,10570766,10570922,10602798,10603060,10605910,10606074,10608235,10608653,10637756,10640894,10640920,10640951,10641095,10648009,10648012,10662552,10665102,10690412,10692003,10692244,10691920,10692157,10692005,10692126,10692433,10692476,10692498,10693053,10693233,10693290,10708481,10708692,10710163,10727744,10728788,10729886,10730732,10757906,10760569,10760974,10762494,10770662,10771111,10772762,10774648,10777290,10778405,10780043,10783300,10797381,10795615,10798561,10799745,10825158,10825994,10826391,10826394,10826382,10826629,10826723,10827206,10827823,10839282,10839334,10840976,10842601,10893884,10893890,10893881,10893892,10893887,10893977,10894042,10894710,10896113,10896460,10904581,10905292,10906748,10906752,10921226,10921718,10937539,10938470,10938545,10938633,10948459,10948685,10962767,10963824,10981552,10981560,10983021,10983251,10983023,10983230,10983019,10983241,10983474,10983839,10984056,10984079,10985630,10985821,10999134,11000381,11015617,11017025,11036255,11036667,11038415,11038418,11038419,11038722,11038790,11038955,11039300,11056253,11067734,11067736,11068525,11070783,11070802,11084931,11084999,11086256,11085974,11086251,11087203,11087281,11087566,11087631,11089527,11106647,11109181,11109392,11121465,11140074,11140412,11140414,11140372,11141246,11141825,11157461,11158225,11186326,11186386,11187339,11187310,11187483,11188290,11188401,11188418,11188568,11188905,11195119,11195691,11198910,11199726,11213571,11213588,11229257,11230904,11231147,11232157,11232199,11232764,11232758,11237933,11238273,11240918,11241207,11243230,11243944,11246768,11246861,11253516,11253635,11267065,11268940,11284084,11284096,11286348,11286365,11286350,11286638,11287298,11288009,11303065,11303260,11305503,11306447,11320687,11320987,11337875,11337922,11340394,11340403,11341901,11342063,11342711,11343027,11359609,11360467,11361624,11361639,11374503,11374513,11392044,11393204,11394384,11394707,11394859,11395457,11397048,11416057,11417044,11433580,11433630,11434610,11434709,11434612,11435989,11436072,11436310,11439969,11440294,11449183,11449737,11449180,11449740,11479210,11479233,11481400,11481415,11481411,11481738,11481824,11481889,11494176,11494276,11500870,11501613,11501610,11513345,11514530,11514558,11530252,11531730,11531783,11531731,11531776,11531727,11531824,11532022,11532460,11532629,11532706,11532869,11532912,11538480,11538516,11545190,11556041,11557788,11558726,11573349,11574829,11575008,11574891,11575009,11574896,11575120,11575641,11575643,11575940,11575971,11576054,11576067,11577142,11577541,11579753,11580971,11586874,11588142,11601543,11601834,11602625,11602711,11617305,11618703,11618948,11618691,11618946,11618694,11618949,11619523,11619986,11620240,11620287,11620393,11620440,11625707,11626394,11635131,11635502,11649831,11651412,11666397,11666993,11667170,11667167,11667345,11667172,11667343,11667906,11667959,11668065,11668181,11668201,11678273,11678409,11681665,11682474,11682669,11711158,11711188,11712064,11712119,11712045,11712123,11712043,11712130,11713268,11713270,11713718,11713748,11713788,11713787,11737985,11738373,11737964,11738367,11756972,11757935,11757938,11757937,11758026,11758760,11758807,11758870,11758961,11767466,11767483,11770220,11771292,11805858,11805894,11805884,11805860,11805832,11805974,11807022,11807034,11807290,11807664,11807862,11807918,11816764,11817605,11822853,11824056,11822976,11823813,11852628,11853158,11853576,11854079,11854081,11854184,11853586,11853789,11854463,11854488,11854729,11855110,11855223,11855241,11865351,11865504,11895946,11896222,11896852,11896864,11896822,11896830,11896824,11896867,11896937,11896943,11897002,11897037,11897068,11897095,11904431,11905507,11907710,11908556,11940171,11940554,11941023,11941061,11941113,11941263,11941094,11941323,11942526,11942584,11942664,11942679,11942768,11942797,11949876,11951400,11964856,11964935,11980337,11980364,11980615,11981106,11980560,11981044,11980562,11981046,11981373,11981415,11981762,11982379,11982844,11982872,11982960,11983054,12006094,12006104,12021349,12021370,12021559,12021570,12021564,12021576,12021561,12021574,12022084,12022195,12022391,12022406,12022529,12022544,12024280,12024273,12031126,12031871,12034042,12034332,12046112,12046130,12061216,12061220,12062071,12062080,12062060,12062095,12062062,12062096,12062601,12062721,12062956,12062978,12063071,12063074,12065212,12065234,12071124,12071165,12085058,12086034,12101142,12102002,12102004,12102009,12102574,12102712,12103537,12103541,12103712,12103729,4173,4404,4172,4429,20561,20569,46497,46539,47392,48133,48136,48132,48385,48381,48854,48892,49128,49130,49307,49421,57282,57491,59750,70681,85673,86544,86545,86548,87316,87443,87531,88296,88335,94137,94144,97557,97616,98723,99318,126568,126810,127115,127118,127131,128638,128806,128812,128869,128873,133726,133783,136162,136755,138427,138440,145324,145331,172839,173462,173721,173729,173732,174595,174732,175393,177792,178051,193418,193425,210146,210426,211103,211096,211093,212559,212705,212722,212767,212789,212944,212961,215004,215227,214043,215230,220636,231346,247382,248266,248267,248269,249091,249242,249246,249792,249854,257353,258472,260497,261053,261993,262019,288101,288547,289177,289180,289213,289799,289807,290280,290268,290629,290637,299068,299069,313401,313403,316075,316325,331829,331843,333381,333472,333380,333449,333377,333452,333607,333614,334650,334652,335013,335020,337306,337308,339800,340535,339855,340544,344092,344499,358147,358145,372217,372353,372964,373452,372967,373576,372965,373573,373757,373793,374356,374426,374547,374564) ) 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` = 66498 WHERE `RP`.`player` = 66498 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107403,107451,122088,122192,122086,122657,122678,124043,122834,124025,212765,212858,212736,212768,212770,213309,235402,235801,235181,235800,244154,246469,248570,248052,257325,257632,259712,259718,261983,262043,264400,265160,277222,277456,281181,281247,283334,284489,299243,299509,300900,300964,301861,301896,301860,301894,303452,303471,337226,337683,342025,342274,345808,345986,372010,372134,373178,373412,10368602,10368800,10369996,10370607,10370689,10386208,10386292,10399652,10400296,10403026,10403403,10406343,10406553,10436886,10437373,10440294,10440348,10441290,10441459,10441301,10441442,10441291,10441453,10442161,10442221,10442292,10442317,10443866,10464091,10464273,10464095,10464325,10481024,10481317,10482660,10483329,10510393,10510937,10512491,10513593,10513591,10514223,10514367,10514475,10514507,10514551,10540799,10541070,10542624,10543265,10568250,10568661,10570086,10570105,10570155,10570197,10570754,10570766,10570922,10602798,10603060,10605910,10606074,10608235,10608653,10637756,10640894,10640920,10640951,10641095,10648009,10648012,10662552,10665102,10690412,10692003,10692244,10691920,10692157,10692005,10692126,10692433,10692476,10692498,10693053,10693233,10693290,10708481,10708692,10710163,10727744,10728788,10729886,10730732,10757906,10760569,10760974,10762494,10770662,10771111,10772762,10774648,10777290,10778405,10780043,10783300,10797381,10795615,10798561,10799745,10825158,10825994,10826391,10826394,10826382,10826629,10826723,10827206,10827823,10839282,10839334,10840976,10842601,10893884,10893890,10893881,10893892,10893887,10893977,10894042,10894710,10896113,10896460,10904581,10905292,10906748,10906752,10921226,10921718,10937539,10938470,10938545,10938633,10948459,10948685,10962767,10963824,10981552,10981560,10983021,10983251,10983023,10983230,10983019,10983241,10983474,10983839,10984056,10984079,10985630,10985821,10999134,11000381,11015617,11017025,11036255,11036667,11038415,11038418,11038419,11038722,11038790,11038955,11039300,11056253,11067734,11067736,11068525,11070783,11070802,11084931,11084999,11086256,11085974,11086251,11087203,11087281,11087566,11087631,11089527,11106647,11109181,11109392,11121465,11140074,11140412,11140414,11140372,11141246,11141825,11157461,11158225,11186326,11186386,11187339,11187310,11187483,11188290,11188401,11188418,11188568,11188905,11195119,11195691,11198910,11199726,11213571,11213588,11229257,11230904,11231147,11232157,11232199,11232764,11232758,11237933,11238273,11240918,11241207,11243230,11243944,11246768,11246861,11253516,11253635,11267065,11268940,11284084,11284096,11286348,11286365,11286350,11286638,11287298,11288009,11303065,11303260,11305503,11306447,11320687,11320987,11337875,11337922,11340394,11340403,11341901,11342063,11342711,11343027,11359609,11360467,11361624,11361639,11374503,11374513,11392044,11393204,11394384,11394707,11394859,11395457,11397048,11416057,11417044,11433580,11433630,11434610,11434709,11434612,11435989,11436072,11436310,11439969,11440294,11449183,11449737,11449180,11449740,11479210,11479233,11481400,11481415,11481411,11481738,11481824,11481889,11494176,11494276,11500870,11501613,11501610,11513345,11514530,11514558,11530252,11531730,11531783,11531731,11531776,11531727,11531824,11532022,11532460,11532629,11532706,11532869,11532912,11538480,11538516,11545190,11556041,11557788,11558726,11573349,11574829,11575008,11574891,11575009,11574896,11575120,11575641,11575643,11575940,11575971,11576054,11576067,11577142,11577541,11579753,11580971,11586874,11588142,11601543,11601834,11602625,11602711,11617305,11618703,11618948,11618691,11618946,11618694,11618949,11619523,11619986,11620240,11620287,11620393,11620440,11625707,11626394,11635131,11635502,11649831,11651412,11666397,11666993,11667170,11667167,11667345,11667172,11667343,11667906,11667959,11668065,11668181,11668201,11678273,11678409,11681665,11682474,11682669,11711158,11711188,11712064,11712119,11712045,11712123,11712043,11712130,11713268,11713270,11713718,11713748,11713788,11713787,11737985,11738373,11737964,11738367,11756972,11757935,11757938,11757937,11758026,11758760,11758807,11758870,11758961,11767466,11767483,11770220,11771292,11805858,11805894,11805884,11805860,11805832,11805974,11807022,11807034,11807290,11807664,11807862,11807918,11816764,11817605,11822853,11824056,11822976,11823813,11852628,11853158,11853576,11854079,11854081,11854184,11853586,11853789,11854463,11854488,11854729,11855110,11855223,11855241,11865351,11865504,11895946,11896222,11896852,11896864,11896822,11896830,11896824,11896867,11896937,11896943,11897002,11897037,11897068,11897095,11904431,11905507,11907710,11908556,11940171,11940554,11941023,11941061,11941113,11941263,11941094,11941323,11942526,11942584,11942664,11942679,11942768,11942797,11949876,11951400,11964856,11964935,11980337,11980364,11980615,11981106,11980560,11981044,11980562,11981046,11981373,11981415,11981762,11982379,11982844,11982872,11982960,11983054,12006094,12006104,12021349,12021370,12021559,12021570,12021564,12021576,12021561,12021574,12022084,12022195,12022391,12022406,12022529,12022544,12024280,12024273,12031126,12031871,12034042,12034332,12046112,12046130,12061216,12061220,12062071,12062080,12062060,12062095,12062062,12062096,12062601,12062721,12062956,12062978,12063071,12063074,12065212,12065234,12071124,12071165,12085058,12086034,12101142,12102002,12102004,12102009,12102574,12102712,12103537,12103541,12103712,12103729,4173,4404,4172,4429,20561,20569,46497,46539,47392,48133,48136,48132,48385,48381,48854,48892,49128,49130,49307,49421,57282,57491,59750,70681,85673,86544,86545,86548,87316,87443,87531,88296,88335,94137,94144,97557,97616,98723,99318,126568,126810,127115,127118,127131,128638,128806,128812,128869,128873,133726,133783,136162,136755,138427,138440,145324,145331,172839,173462,173721,173729,173732,174595,174732,175393,177792,178051,193418,193425,210146,210426,211103,211096,211093,212559,212705,212722,212767,212789,212944,212961,215004,215227,214043,215230,220636,231346,247382,248266,248267,248269,249091,249242,249246,249792,249854,257353,258472,260497,261053,261993,262019,288101,288547,289177,289180,289213,289799,289807,290280,290268,290629,290637,299068,299069,313401,313403,316075,316325,331829,331843,333381,333472,333380,333449,333377,333452,333607,333614,334650,334652,335013,335020,337306,337308,339800,340535,339855,340544,344092,344499,358147,358145,372217,372353,372964,373452,372967,373576,372965,373573,373757,373793,374356,374426,374547,374564) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: