(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` = 35804 WHERE `RP`.`player` = 35804 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107424,107434,122197,122681,123150,123523,123376,123904,123362,123416,214035,218288,235518,235519,246562,246775,248902,247346,257539,257643,259757,259871,261971,262083,265037,277173,277375,281529,281759,283310,283380,299288,299295,300887,301866,301889,301892,301903,303393,317089,337548,342037,342227,345642,345962,371936,371960,373388,373917,10368427,10368483,10369881,10370357,10370596,10370615,10385851,10386765,10399754,10400322,10402969,10403025,10406344,10406389,10436995,10437125,10440309,10440337,10441351,10441354,10441370,10442185,10442235,10442328,10442336,10443391,10443758,10465536,10477532,10465647,10477657,10481175,10481561,10483461,10483547,10510478,10510490,10512450,10512546,10513559,10513563,10514203,10514224,10514448,10514492,10514515,10514544,10540900,10541774,10545592,10545701,10568143,10568183,10570120,10570159,10570558,10570916,10570941,10583838,10602763,10605217,10605411,10608147,10608609,10637767,10638053,10639787,10639791,10639784,10640843,10641743,10647798,10647892,10661373,10661377,10664839,10664983,10690509,10691645,10691653,10691642,10692422,10692525,10693206,10708445,10710179,10710232,10727953,10728373,10729885,10730700,10757436,10757484,10758521,10758633,10758518,10758630,10758519,10758631,10760527,10760587,10760905,10760923,10762027,10762261,10770742,10771587,10773101,10773212,10777372,10780039,10782318,10794841,10797220,10798395,10799013,10825133,10825157,10826431,10826422,10826420,10826552,10826797,10826925,10827324,10827625,10839145,10839219,10840899,10841017,10842721,10843361,10892883,10893909,10893915,10893906,10894043,10894225,10894527,10894567,10895382,10895497,10904883,10905468,10906576,10906644,10920572,10920975,10937056,10937478,10938673,10938625,10938587,10939513,10939579,10940812,10941091,10941614,10941623,10948512,10949465,10962461,10963584,10981521,10983196,10983253,10983236,10983621,10983750,10984043,10984060,10985677,10985951,10999681,10999984,11015957,11015922,11036281,11036787,11038521,11038550,11038531,11038562,11038783,11038836,11038920,11038923,11039327,11039438,11056032,11056123,11067499,11067624,11070853,11071586,11085014,11085900,11085909,11085908,11087282,11087534,11087638,11106783,11108115,11108802,11109658,11121268,11121570,11141515,11141835,11141881,11141994,11142058,11157748,11159097,11186325,11186358,11186749,11187046,11186726,11187213,11186724,11187081,11188265,11188299,11188420,11188429,11188540,11188794,11195102,11195176,11198645,11198769,11213445,11214590,11229174,11229306,11229664,11229666,11229661,11230861,11232042,11232324,11232803,11233027,11238162,11238207,11240824,11243526,11246836,11246895,11253649,11253721,11267315,11267403,11284078,11286247,11286332,11286251,11286335,11286244,11286339,11286614,11286644,11286716,11287176,11287790,11287871,11302960,11303083,11305691,11305981,11320301,11320855,11337889,11337902,11340165,11340152,11340167,11340388,11341490,11341842,11342691,11343542,11359610,11360824,11361650,11361687,11374472,11375483,11392010,11392145,11393062,11393137,11393060,11393134,11393064,11393136,11394350,11394391,11394701,11394731,11394867,11394869,11395297,11395973,11396823,11397502,11417005,11418071,11433549,11433621,11434296,11434326,11434538,11434493,11434541,11435991,11436043,11436289,11436326,11440660,11441046,11448986,11450899,11449012,11450925,11479178,11479221,11481429,11481416,11481427,11481725,11481739,11481778,11481820,11481892,11481913,11494083,11494117,11501161,11501762,11501039,11501763,11514175,11514334,11530224,11530255,11531777,11531784,11531787,11531780,11531766,11531823,11532117,11532227,11532597,11532729,11533293,11533399,11538479,11538650,11543482,11545197,11557609,11558930,11573337,11574861,11574883,11574831,11574880,11574873,11574881,11575600,11575765,11575887,11575970,11576030,11576060,11577741,11577871,11579754,11579859,11586924,11587765,11601505,11602447,11602337,11602406,11616953,11618597,11618833,11618599,11618807,11618572,11618811,11619605,11619965,11620260,11620273,11620414,11620416,11625272,11625711,11634941,11636059,11637017,11637969,11650453,11650623,11666484,11666618,11667229,11667312,11667227,11667314,11667222,11667317,11667411,11667986,11668067,11668137,11668221,11678211,11678267,11678734,11680287,11682624,11682788,11711149,11711168,11712077,11712078,11712080,11713269,11713443,11713651,11713713,11713818,11713835,11738038,11739605,11738040,11740035,11756978,11756991,11757871,11757876,11757872,11757890,11757874,11757892,11758768,11758827,11758930,11758927,11758973,11759007,11767188,11767296,11769991,11770204,11805476,11806246,11805474,11805516,11805471,11805544,11807043,11807069,11807293,11807320,11807868,11807878,11816920,11817410,11823082,11823679,11822977,11823690,11852618,11852726,11853599,11853581,11853587,11854421,11854480,11854712,11854987,11855258,11865446,11866888,11895898,11896105,11896870,11896894,11896886,11896949,11897036,11897104,11904240,11904377,11908090,11908370,11940126,11940488,11941209,11941393,11941210,11941394,11941213,11941397,11942568,11942640,11942674,11942771,11942783,11949202,11951744,11963452,11965022,11980349,11980787,11980789,11980782,11981363,11981365,11981853,11982530,11982936,12006083,12006310,12022189,12022465,12022490,12024682,12031395,12046116,12046862,12061224,12061246,12062162,12062181,12062166,12062600,12062979,12063370,12065175,12065206,12071150,12071155,12085074,12086084,12101168,12101180,12102020,12102090,12102022,12102084,12102024,12102097,12102662,12102724,12103636,12103662,12103788,5099,5169,5013,5171,20556,21277,46495,46579,47405,47431,48161,48194,48163,48221,48173,48219,48395,48657,48880,48899,49195,49207,49273,49308,57312,57493,59717,70725,85637,85646,86590,86626,86628,87433,87459,87516,87545,88275,88371,94231,95000,97555,98600,98604,126221,127159,127150,127152,127162,127154,127158,128631,128698,128778,128834,128867,128903,133167,133760,136159,136870,139055,139090,145330,156014,172846,173707,173750,173710,173758,173713,173759,174629,174617,174674,174689,175371,175433,177356,177455,193427,193441,210114,210141,210996,211019,211022,212543,212693,212746,212774,212799,212865,212953,213842,213746,213794,213883,219820,220357,247366,247405,248329,248263,248245,249083,249235,249874,257081,257378,260224,260668,272681,272683,288379,288462,289008,289010,289030,289836,290092,290261,290596,290664,299062,299067,313232,313905,315825,316562,331819,333434,333459,333435,333450,333438,333451,333600,333624,334685,334855,335070,335117,337318,337340,339668,341301,339666,341303,344345,358166,358368,372229,372498,372981,373475,372986,373478,373026,373490,373766,373785,374321,374343,374607) ) 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` = 35804 WHERE `RP`.`player` = 35804 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107424,107434,122197,122681,123150,123523,123376,123904,123362,123416,214035,218288,235518,235519,246562,246775,248902,247346,257539,257643,259757,259871,261971,262083,265037,277173,277375,281529,281759,283310,283380,299288,299295,300887,301866,301889,301892,301903,303393,317089,337548,342037,342227,345642,345962,371936,371960,373388,373917,10368427,10368483,10369881,10370357,10370596,10370615,10385851,10386765,10399754,10400322,10402969,10403025,10406344,10406389,10436995,10437125,10440309,10440337,10441351,10441354,10441370,10442185,10442235,10442328,10442336,10443391,10443758,10465536,10477532,10465647,10477657,10481175,10481561,10483461,10483547,10510478,10510490,10512450,10512546,10513559,10513563,10514203,10514224,10514448,10514492,10514515,10514544,10540900,10541774,10545592,10545701,10568143,10568183,10570120,10570159,10570558,10570916,10570941,10583838,10602763,10605217,10605411,10608147,10608609,10637767,10638053,10639787,10639791,10639784,10640843,10641743,10647798,10647892,10661373,10661377,10664839,10664983,10690509,10691645,10691653,10691642,10692422,10692525,10693206,10708445,10710179,10710232,10727953,10728373,10729885,10730700,10757436,10757484,10758521,10758633,10758518,10758630,10758519,10758631,10760527,10760587,10760905,10760923,10762027,10762261,10770742,10771587,10773101,10773212,10777372,10780039,10782318,10794841,10797220,10798395,10799013,10825133,10825157,10826431,10826422,10826420,10826552,10826797,10826925,10827324,10827625,10839145,10839219,10840899,10841017,10842721,10843361,10892883,10893909,10893915,10893906,10894043,10894225,10894527,10894567,10895382,10895497,10904883,10905468,10906576,10906644,10920572,10920975,10937056,10937478,10938673,10938625,10938587,10939513,10939579,10940812,10941091,10941614,10941623,10948512,10949465,10962461,10963584,10981521,10983196,10983253,10983236,10983621,10983750,10984043,10984060,10985677,10985951,10999681,10999984,11015957,11015922,11036281,11036787,11038521,11038550,11038531,11038562,11038783,11038836,11038920,11038923,11039327,11039438,11056032,11056123,11067499,11067624,11070853,11071586,11085014,11085900,11085909,11085908,11087282,11087534,11087638,11106783,11108115,11108802,11109658,11121268,11121570,11141515,11141835,11141881,11141994,11142058,11157748,11159097,11186325,11186358,11186749,11187046,11186726,11187213,11186724,11187081,11188265,11188299,11188420,11188429,11188540,11188794,11195102,11195176,11198645,11198769,11213445,11214590,11229174,11229306,11229664,11229666,11229661,11230861,11232042,11232324,11232803,11233027,11238162,11238207,11240824,11243526,11246836,11246895,11253649,11253721,11267315,11267403,11284078,11286247,11286332,11286251,11286335,11286244,11286339,11286614,11286644,11286716,11287176,11287790,11287871,11302960,11303083,11305691,11305981,11320301,11320855,11337889,11337902,11340165,11340152,11340167,11340388,11341490,11341842,11342691,11343542,11359610,11360824,11361650,11361687,11374472,11375483,11392010,11392145,11393062,11393137,11393060,11393134,11393064,11393136,11394350,11394391,11394701,11394731,11394867,11394869,11395297,11395973,11396823,11397502,11417005,11418071,11433549,11433621,11434296,11434326,11434538,11434493,11434541,11435991,11436043,11436289,11436326,11440660,11441046,11448986,11450899,11449012,11450925,11479178,11479221,11481429,11481416,11481427,11481725,11481739,11481778,11481820,11481892,11481913,11494083,11494117,11501161,11501762,11501039,11501763,11514175,11514334,11530224,11530255,11531777,11531784,11531787,11531780,11531766,11531823,11532117,11532227,11532597,11532729,11533293,11533399,11538479,11538650,11543482,11545197,11557609,11558930,11573337,11574861,11574883,11574831,11574880,11574873,11574881,11575600,11575765,11575887,11575970,11576030,11576060,11577741,11577871,11579754,11579859,11586924,11587765,11601505,11602447,11602337,11602406,11616953,11618597,11618833,11618599,11618807,11618572,11618811,11619605,11619965,11620260,11620273,11620414,11620416,11625272,11625711,11634941,11636059,11637017,11637969,11650453,11650623,11666484,11666618,11667229,11667312,11667227,11667314,11667222,11667317,11667411,11667986,11668067,11668137,11668221,11678211,11678267,11678734,11680287,11682624,11682788,11711149,11711168,11712077,11712078,11712080,11713269,11713443,11713651,11713713,11713818,11713835,11738038,11739605,11738040,11740035,11756978,11756991,11757871,11757876,11757872,11757890,11757874,11757892,11758768,11758827,11758930,11758927,11758973,11759007,11767188,11767296,11769991,11770204,11805476,11806246,11805474,11805516,11805471,11805544,11807043,11807069,11807293,11807320,11807868,11807878,11816920,11817410,11823082,11823679,11822977,11823690,11852618,11852726,11853599,11853581,11853587,11854421,11854480,11854712,11854987,11855258,11865446,11866888,11895898,11896105,11896870,11896894,11896886,11896949,11897036,11897104,11904240,11904377,11908090,11908370,11940126,11940488,11941209,11941393,11941210,11941394,11941213,11941397,11942568,11942640,11942674,11942771,11942783,11949202,11951744,11963452,11965022,11980349,11980787,11980789,11980782,11981363,11981365,11981853,11982530,11982936,12006083,12006310,12022189,12022465,12022490,12024682,12031395,12046116,12046862,12061224,12061246,12062162,12062181,12062166,12062600,12062979,12063370,12065175,12065206,12071150,12071155,12085074,12086084,12101168,12101180,12102020,12102090,12102022,12102084,12102024,12102097,12102662,12102724,12103636,12103662,12103788,5099,5169,5013,5171,20556,21277,46495,46579,47405,47431,48161,48194,48163,48221,48173,48219,48395,48657,48880,48899,49195,49207,49273,49308,57312,57493,59717,70725,85637,85646,86590,86626,86628,87433,87459,87516,87545,88275,88371,94231,95000,97555,98600,98604,126221,127159,127150,127152,127162,127154,127158,128631,128698,128778,128834,128867,128903,133167,133760,136159,136870,139055,139090,145330,156014,172846,173707,173750,173710,173758,173713,173759,174629,174617,174674,174689,175371,175433,177356,177455,193427,193441,210114,210141,210996,211019,211022,212543,212693,212746,212774,212799,212865,212953,213842,213746,213794,213883,219820,220357,247366,247405,248329,248263,248245,249083,249235,249874,257081,257378,260224,260668,272681,272683,288379,288462,289008,289010,289030,289836,290092,290261,290596,290664,299062,299067,313232,313905,315825,316562,331819,333434,333459,333435,333450,333438,333451,333600,333624,334685,334855,335070,335117,337318,337340,339668,341301,339666,341303,344345,358166,358368,372229,372498,372981,373475,372986,373478,373026,373490,373766,373785,374321,374343,374607) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: