(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` = 73983 WHERE `RP`.`player` = 73983 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107420,107559,122438,122667,122004,122676,122009,122679,122246,124079,212860,214042,212735,212767,213070,213588,235142,235143,236975,246684,246764,247715,249537,257376,257468,259698,260377,262046,262201,264306,264926,277208,277717,281155,281723,283276,283289,299140,299602,300886,300947,301825,301897,301828,302537,303399,337363,337547,342067,342197,346084,346995,371915,372744,373395,373746,10368684,10370010,10370479,10370589,10370611,10386387,10387426,10399750,10400020,10403842,10404057,10406245,10406361,10436786,10437354,10440293,10441429,10441493,10441438,10441492,10441432,10441503,10442216,10442253,10443720,10477810,10477818,10481037,10481346,10482644,10482793,10510569,10510690,10512478,10513549,10513551,10513554,10514137,10514476,10514559,10541575,10541552,10544030,10543992,10568162,10583779,10605711,10606073,10608207,10608566,10638221,10639908,10639796,10639915,10639894,10640953,10641480,10647732,10647999,10661106,10662030,10690413,10690607,10692278,10692307,10692310,10692424,10692497,10692699,10693192,10693234,10708676,10708742,10710224,10710583,10727634,10728178,10730054,10730731,10757405,10757426,10758530,10758658,10758616,10758663,10758618,10758660,10760434,10760629,10760899,10760937,10762025,10762035,10770434,10771303,10772668,10772890,10777977,10779006,10779545,10780237,10797392,10796314,10798410,10799406,10825230,10825290,10826356,10826436,10826371,10826406,10826381,10826423,10826556,10826606,10826647,10826724,10827348,10827989,10839167,10839461,10840882,10841294,10843362,10892877,10892882,10893921,10893916,10893914,10894725,10896108,10904446,10906660,10906664,10920197,10920344,10937198,10938080,10938087,10938077,10939505,10939535,10940959,10940957,10941603,10941621,10948220,10948749,10962954,10964820,10981536,10981590,10983087,10983219,10983097,10983207,10983139,10983210,10983402,10984114,10985887,10986175,10998770,11000675,11015481,11016346,11038142,11038371,11038463,11038373,11038449,11038375,11038444,11038764,11038765,11038905,11039365,11039375,11055627,11055656,11067357,11067529,11070821,11070832,11085393,11085803,11085805,11085802,11087247,11087525,11088189,11106700,11107861,11109158,11109169,11121117,11121131,11139770,11139795,11140495,11140521,11140489,11140559,11140482,11140577,11141232,11141392,11141833,11141962,11142014,11142050,11157442,11157654,11186288,11186300,11186991,11187101,11186993,11187094,11186946,11187096,11188276,11188278,11188430,11188463,11188677,11188893,11195259,11195702,11198691,11198713,11213358,11213522,11229172,11229185,11229686,11229757,11229749,11230887,11230931,11231933,11231970,11232765,11232795,11239349,11239736,11240841,11241269,11243588,11243988,11246849,11246905,11253531,11253676,11267263,11267533,11284067,11286292,11286293,11286295,11286615,11286937,11287410,11287837,11288003,11303084,11303136,11305409,11305504,11320162,11320581,11337888,11337923,11339882,11339884,11339897,11340376,11341409,11341841,11342712,11342692,11359590,11359954,11361676,11361971,11374461,11374484,11392023,11392054,11393145,11393118,11393135,11394557,11394750,11394958,11395151,11396047,11397051,11397340,11416514,11417006,11433526,11433645,11434243,11434260,11434496,11434643,11434234,11434262,11436180,11436192,11436243,11436336,11441236,11450435,11451895,11450433,11451677,11479193,11479896,11481505,11481509,11481507,11481646,11481714,11481792,11481851,11481868,11481927,11494097,11495577,11501033,11501543,11501012,11501292,11514456,11514482,11530222,11531694,11531697,11531696,11532114,11532740,11533469,11538379,11538431,11543481,11544508,11558280,11558408,11573340,11574932,11574934,11574951,11575053,11574939,11575034,11575651,11575784,11575909,11575955,11576038,11576107,11577288,11577819,11579731,11579860,11587311,11587748,11601236,11602474,11601901,11602472,11616949,11616954,11618549,11618689,11618552,11618707,11618571,11618705,11619625,11619686,11620231,11620251,11620390,11620396,11624873,11625271,11635501,11635769,11637095,11637962,11650338,11650984,11667322,11667323,11667326,11667391,11667576,11668046,11668157,11668243,11668272,11678179,11678275,11678653,11680102,11682299,11683591,11711145,11711156,11712041,11712051,11712060,11712066,11712042,11712056,11713222,11713515,11713661,11713663,11713772,11713820,11738109,11739843,11738126,11741147,11757003,11757021,11757934,11757939,11757936,11758787,11758909,11759023,11767187,11767629,11771064,11771118,11807012,11807027,11807291,11807300,11807873,11816586,11816999,11823061,11824650,11823080,11824652,11852621,11852639,11853569,11853897,11853570,11853894,11853573,11853899,11854485,11855111,11855248,11865505,11865507,11896128,11896593,11905417,11905697,11908691,11909346,11940269,11940731,11941208,11941211,11941227,11942631,11942808,11949812,11951743,11963425,11964280,11980365,11980377,11981360,11981821,11982853,11983053,12006075,12006111,12021355,12021607,12021608,12021603,12022021,12022419,12022556,12024398,12024777,12031620,12031655,12034333,12046400,12061249,12061999,12062012,12062016,12062709,12065285,12086816,12102101,12102103,12102105,12103276,12103623,20596,46580,47404,47439,48325,48329,48328,48339,48324,48333,48382,48836,49122,49552,57285,59805,71991,85631,85663,86554,86636,86551,86634,86550,86632,87345,87369,87440,87489,87507,87510,88420,88511,94198,94878,97502,97835,98864,110957,126334,126826,127192,127221,127205,127232,127198,127223,128642,128841,128874,133170,136185,139021,157220,157458,172834,172878,173821,173831,173829,174611,174883,178360,178905,193402,193408,210122,210132,211068,211123,211072,211113,211069,211110,212594,212688,212827,213263,213342,214420,215882,214421,216609,220095,220546,247364,248217,248216,248213,249080,249224,249269,249791,249837,256920,256996,260017,261008,261979,273689,288029,288565,289178,289179,289238,289810,290048,290594,299050,299175,313253,313408,315918,316176,331823,331855,333318,333510,333328,333511,333357,333513,333604,334127,334722,335014,335101,337345,337359,339667,340695,339654,340698,344329,358125,358349,372256,372636,372910,372908,372912,373790,374524,374543) ) 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` = 73983 WHERE `RP`.`player` = 73983 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107420,107559,122438,122667,122004,122676,122009,122679,122246,124079,212860,214042,212735,212767,213070,213588,235142,235143,236975,246684,246764,247715,249537,257376,257468,259698,260377,262046,262201,264306,264926,277208,277717,281155,281723,283276,283289,299140,299602,300886,300947,301825,301897,301828,302537,303399,337363,337547,342067,342197,346084,346995,371915,372744,373395,373746,10368684,10370010,10370479,10370589,10370611,10386387,10387426,10399750,10400020,10403842,10404057,10406245,10406361,10436786,10437354,10440293,10441429,10441493,10441438,10441492,10441432,10441503,10442216,10442253,10443720,10477810,10477818,10481037,10481346,10482644,10482793,10510569,10510690,10512478,10513549,10513551,10513554,10514137,10514476,10514559,10541575,10541552,10544030,10543992,10568162,10583779,10605711,10606073,10608207,10608566,10638221,10639908,10639796,10639915,10639894,10640953,10641480,10647732,10647999,10661106,10662030,10690413,10690607,10692278,10692307,10692310,10692424,10692497,10692699,10693192,10693234,10708676,10708742,10710224,10710583,10727634,10728178,10730054,10730731,10757405,10757426,10758530,10758658,10758616,10758663,10758618,10758660,10760434,10760629,10760899,10760937,10762025,10762035,10770434,10771303,10772668,10772890,10777977,10779006,10779545,10780237,10797392,10796314,10798410,10799406,10825230,10825290,10826356,10826436,10826371,10826406,10826381,10826423,10826556,10826606,10826647,10826724,10827348,10827989,10839167,10839461,10840882,10841294,10843362,10892877,10892882,10893921,10893916,10893914,10894725,10896108,10904446,10906660,10906664,10920197,10920344,10937198,10938080,10938087,10938077,10939505,10939535,10940959,10940957,10941603,10941621,10948220,10948749,10962954,10964820,10981536,10981590,10983087,10983219,10983097,10983207,10983139,10983210,10983402,10984114,10985887,10986175,10998770,11000675,11015481,11016346,11038142,11038371,11038463,11038373,11038449,11038375,11038444,11038764,11038765,11038905,11039365,11039375,11055627,11055656,11067357,11067529,11070821,11070832,11085393,11085803,11085805,11085802,11087247,11087525,11088189,11106700,11107861,11109158,11109169,11121117,11121131,11139770,11139795,11140495,11140521,11140489,11140559,11140482,11140577,11141232,11141392,11141833,11141962,11142014,11142050,11157442,11157654,11186288,11186300,11186991,11187101,11186993,11187094,11186946,11187096,11188276,11188278,11188430,11188463,11188677,11188893,11195259,11195702,11198691,11198713,11213358,11213522,11229172,11229185,11229686,11229757,11229749,11230887,11230931,11231933,11231970,11232765,11232795,11239349,11239736,11240841,11241269,11243588,11243988,11246849,11246905,11253531,11253676,11267263,11267533,11284067,11286292,11286293,11286295,11286615,11286937,11287410,11287837,11288003,11303084,11303136,11305409,11305504,11320162,11320581,11337888,11337923,11339882,11339884,11339897,11340376,11341409,11341841,11342712,11342692,11359590,11359954,11361676,11361971,11374461,11374484,11392023,11392054,11393145,11393118,11393135,11394557,11394750,11394958,11395151,11396047,11397051,11397340,11416514,11417006,11433526,11433645,11434243,11434260,11434496,11434643,11434234,11434262,11436180,11436192,11436243,11436336,11441236,11450435,11451895,11450433,11451677,11479193,11479896,11481505,11481509,11481507,11481646,11481714,11481792,11481851,11481868,11481927,11494097,11495577,11501033,11501543,11501012,11501292,11514456,11514482,11530222,11531694,11531697,11531696,11532114,11532740,11533469,11538379,11538431,11543481,11544508,11558280,11558408,11573340,11574932,11574934,11574951,11575053,11574939,11575034,11575651,11575784,11575909,11575955,11576038,11576107,11577288,11577819,11579731,11579860,11587311,11587748,11601236,11602474,11601901,11602472,11616949,11616954,11618549,11618689,11618552,11618707,11618571,11618705,11619625,11619686,11620231,11620251,11620390,11620396,11624873,11625271,11635501,11635769,11637095,11637962,11650338,11650984,11667322,11667323,11667326,11667391,11667576,11668046,11668157,11668243,11668272,11678179,11678275,11678653,11680102,11682299,11683591,11711145,11711156,11712041,11712051,11712060,11712066,11712042,11712056,11713222,11713515,11713661,11713663,11713772,11713820,11738109,11739843,11738126,11741147,11757003,11757021,11757934,11757939,11757936,11758787,11758909,11759023,11767187,11767629,11771064,11771118,11807012,11807027,11807291,11807300,11807873,11816586,11816999,11823061,11824650,11823080,11824652,11852621,11852639,11853569,11853897,11853570,11853894,11853573,11853899,11854485,11855111,11855248,11865505,11865507,11896128,11896593,11905417,11905697,11908691,11909346,11940269,11940731,11941208,11941211,11941227,11942631,11942808,11949812,11951743,11963425,11964280,11980365,11980377,11981360,11981821,11982853,11983053,12006075,12006111,12021355,12021607,12021608,12021603,12022021,12022419,12022556,12024398,12024777,12031620,12031655,12034333,12046400,12061249,12061999,12062012,12062016,12062709,12065285,12086816,12102101,12102103,12102105,12103276,12103623,20596,46580,47404,47439,48325,48329,48328,48339,48324,48333,48382,48836,49122,49552,57285,59805,71991,85631,85663,86554,86636,86551,86634,86550,86632,87345,87369,87440,87489,87507,87510,88420,88511,94198,94878,97502,97835,98864,110957,126334,126826,127192,127221,127205,127232,127198,127223,128642,128841,128874,133170,136185,139021,157220,157458,172834,172878,173821,173831,173829,174611,174883,178360,178905,193402,193408,210122,210132,211068,211123,211072,211113,211069,211110,212594,212688,212827,213263,213342,214420,215882,214421,216609,220095,220546,247364,248217,248216,248213,249080,249224,249269,249791,249837,256920,256996,260017,261008,261979,273689,288029,288565,289178,289179,289238,289810,290048,290594,299050,299175,313253,313408,315918,316176,331823,331855,333318,333510,333328,333511,333357,333513,333604,334127,334722,335014,335101,337345,337359,339667,340695,339654,340698,344329,358125,358349,372256,372636,372910,372908,372912,373790,374524,374543) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: