(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` = 60197 WHERE `RP`.`player` = 60197 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107406,107453,122660,122716,122081,123351,122082,124425,122106,124754,213064,213065,212734,235141,235144,236976,246739,247095,247864,248154,257662,257666,259779,259917,262080,262084,264777,264793,277073,277298,281380,281419,283288,283872,299276,299639,300981,301848,301794,301891,303448,337340,337470,342039,342019,345649,346005,371916,372813,373396,373487,10369025,10369650,10370092,10370601,10385942,10386207,10399839,10400251,10403194,10403477,10406272,10406413,10436685,10436746,10440306,10441077,10441294,10441405,10441296,10442182,10442229,10442318,10442330,10443560,10443561,10464126,10477459,10464263,10464326,10481081,10481256,10482659,10483422,10510584,10510709,10512486,10512494,10513594,10513620,10514172,10514240,10514473,10514522,10514562,10541130,10541444,10543054,10543464,10568176,10568628,10570191,10602979,10602997,10605125,10605309,10608211,10609269,10638001,10640901,10640984,10641059,10647961,10648054,10661643,10663551,10665327,10665349,10690386,10690390,10692100,10692158,10692125,10692467,10692689,10692922,10693181,10693269,10708232,10708717,10710913,10728028,10728374,10730286,10730871,10757479,10757457,10758548,10758550,10758563,10760688,10760877,10760960,10762232,10770491,10771306,10772584,10776895,10777106,10778497,10779981,10780220,10795654,10795178,10798049,10798619,10826599,10826613,10826706,10826718,10827320,10827870,10839333,10839596,10840929,10842886,10842907,10875783,10892893,10892917,10893826,10893856,10893841,10893858,10893833,10893905,10894106,10894078,10894535,10894597,10895494,10895919,10904429,10905017,10906588,10906705,10921298,10922385,10937013,10937199,10940779,10941605,10949318,10949576,10962406,10962953,10981545,10983055,10983127,10983048,10983808,10984123,10984125,10985914,10985950,11000907,11016087,11015575,11017549,11036358,11038574,11038617,11038721,11038791,11038793,11038932,11038958,11039519,11039673,11055705,11055686,11067824,11069760,11070826,11070854,11085099,11085538,11085886,11086316,11085884,11086524,11085895,11086318,11087268,11087316,11087516,11087582,11088363,11089227,11106773,11107336,11108879,11109058,11121250,11121434,11139780,11139878,11140886,11140893,11140895,11141334,11141829,11142060,11157872,11159038,11186359,11186456,11186828,11187102,11186830,11187107,11186839,11187115,11188313,11188353,11188405,11188434,11188779,11189463,11195175,11195701,11198638,11199170,11213449,11213555,11229167,11229195,11230061,11230063,11231072,11231126,11231945,11232261,11232737,11232900,11237951,11238947,11241318,11242638,11243265,11243299,11246906,11247171,11253671,11253751,11267745,11268591,11286238,11286313,11286311,11286645,11286938,11287843,11287865,11303259,11303415,11305634,11306517,11321623,11337896,11337908,11339851,11339901,11339850,11339903,11339848,11339898,11340409,11340414,11341653,11341785,11341963,11342067,11342969,11343737,11360339,11360996,11361666,11362286,11374462,11374463,11393049,11393051,11393055,11394443,11394459,11394708,11394845,11394880,11394967,11395982,11396689,11398535,11418014,11418203,11433664,11434720,11434722,11436103,11436124,11436227,11436311,11440026,11440076,11448989,11450943,11448992,11450941,11479208,11479232,11481301,11481485,11481300,11481468,11481258,11481470,11481670,11481696,11481781,11481837,11481893,11481904,11494265,11494460,11500639,11500863,11500608,11500862,11514148,11515122,11530212,11530217,11531735,11531752,11531732,11531763,11531754,11531734,11532254,11532310,11532739,11532763,11533156,11533224,11538437,11538535,11544953,11545198,11558391,11558628,11573312,11575927,11576045,11577205,11578329,11579721,11579870,11586941,11587451,11601424,11601893,11602017,11602706,11616971,11620098,11620276,11620415,11620443,11625824,11625970,11635369,11635448,11637728,11637877,11650051,11651198,11666456,11667291,11667194,11667196,11668018,11668043,11668218,11678291,11678450,11679473,11680886,11682303,11682591,11711195,11711200,11712128,11712122,11712120,11713212,11713675,11713717,11713767,11739576,11739795,11739601,11739797,11757758,11757954,11757962,11757968,11758766,11758782,11758900,11758913,11758974,11758980,11767282,11767860,11769417,11770276,11806058,11806057,11807036,11807258,11807859,11817761,11817787,11823107,11824102,11823081,11824143,11852634,11853323,11854358,11854356,11854457,11854813,11855267,11867039,11896144,11896846,11896848,11896851,11896960,11897019,11897089,11904430,11907379,11940191,11942538,11942611,11942668,11942683,11942807,11949525,11964326,11980394,11980398,11980582,11980652,11980654,11982272,11982889,11983038,12006752,12021507,12021504,12021512,12022009,12022390,12022521,12024580,12031107,12033440,12046132,12061232,12061248,12062036,12062101,12062033,12062105,12062028,12062103,12062615,12062855,12062952,12063044,12063081,12065213,12065279,12085075,12086063,12101150,12101166,12102129,12102130,12102126,12103217,12103336,12103534,12103612,12103708,4174,4286,4171,4282,20713,20738,46501,46575,47400,47442,48872,49150,49544,49718,57300,57506,70737,71878,85658,85665,88402,88927,94162,95268,97561,97588,98562,98596,126410,126524,127244,127246,127248,128730,128820,128822,128870,128938,133768,133785,136775,138458,156460,157402,172872,172876,173744,173828,173745,173840,173748,173823,174594,174663,174998,175072,175385,175426,177658,178496,193469,210135,210162,211017,211013,211016,212546,212586,212719,212744,212819,212826,212899,214071,214317,214950,214073,214706,220130,220242,247386,247414,248220,248302,248223,248313,248222,248304,249098,249145,249230,249260,249846,249909,257054,257444,260029,260649,261970,262028,288322,288442,288916,289293,288917,289639,288919,289549,289823,289829,290279,290363,290630,299071,299113,313467,313998,316146,316452,331830,331867,333460,333555,333558,333602,334753,335006,337313,340040,340745,340080,340748,344982,358160,358354,372031,372055,373016,373255,373017,373259,373014,373258,373774,374107,374439,374507,374548,374646) ) 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` = 60197 WHERE `RP`.`player` = 60197 AND `RP`.`mark` > 0 AND `RP`.`roster` IN (107406,107453,122660,122716,122081,123351,122082,124425,122106,124754,213064,213065,212734,235141,235144,236976,246739,247095,247864,248154,257662,257666,259779,259917,262080,262084,264777,264793,277073,277298,281380,281419,283288,283872,299276,299639,300981,301848,301794,301891,303448,337340,337470,342039,342019,345649,346005,371916,372813,373396,373487,10369025,10369650,10370092,10370601,10385942,10386207,10399839,10400251,10403194,10403477,10406272,10406413,10436685,10436746,10440306,10441077,10441294,10441405,10441296,10442182,10442229,10442318,10442330,10443560,10443561,10464126,10477459,10464263,10464326,10481081,10481256,10482659,10483422,10510584,10510709,10512486,10512494,10513594,10513620,10514172,10514240,10514473,10514522,10514562,10541130,10541444,10543054,10543464,10568176,10568628,10570191,10602979,10602997,10605125,10605309,10608211,10609269,10638001,10640901,10640984,10641059,10647961,10648054,10661643,10663551,10665327,10665349,10690386,10690390,10692100,10692158,10692125,10692467,10692689,10692922,10693181,10693269,10708232,10708717,10710913,10728028,10728374,10730286,10730871,10757479,10757457,10758548,10758550,10758563,10760688,10760877,10760960,10762232,10770491,10771306,10772584,10776895,10777106,10778497,10779981,10780220,10795654,10795178,10798049,10798619,10826599,10826613,10826706,10826718,10827320,10827870,10839333,10839596,10840929,10842886,10842907,10875783,10892893,10892917,10893826,10893856,10893841,10893858,10893833,10893905,10894106,10894078,10894535,10894597,10895494,10895919,10904429,10905017,10906588,10906705,10921298,10922385,10937013,10937199,10940779,10941605,10949318,10949576,10962406,10962953,10981545,10983055,10983127,10983048,10983808,10984123,10984125,10985914,10985950,11000907,11016087,11015575,11017549,11036358,11038574,11038617,11038721,11038791,11038793,11038932,11038958,11039519,11039673,11055705,11055686,11067824,11069760,11070826,11070854,11085099,11085538,11085886,11086316,11085884,11086524,11085895,11086318,11087268,11087316,11087516,11087582,11088363,11089227,11106773,11107336,11108879,11109058,11121250,11121434,11139780,11139878,11140886,11140893,11140895,11141334,11141829,11142060,11157872,11159038,11186359,11186456,11186828,11187102,11186830,11187107,11186839,11187115,11188313,11188353,11188405,11188434,11188779,11189463,11195175,11195701,11198638,11199170,11213449,11213555,11229167,11229195,11230061,11230063,11231072,11231126,11231945,11232261,11232737,11232900,11237951,11238947,11241318,11242638,11243265,11243299,11246906,11247171,11253671,11253751,11267745,11268591,11286238,11286313,11286311,11286645,11286938,11287843,11287865,11303259,11303415,11305634,11306517,11321623,11337896,11337908,11339851,11339901,11339850,11339903,11339848,11339898,11340409,11340414,11341653,11341785,11341963,11342067,11342969,11343737,11360339,11360996,11361666,11362286,11374462,11374463,11393049,11393051,11393055,11394443,11394459,11394708,11394845,11394880,11394967,11395982,11396689,11398535,11418014,11418203,11433664,11434720,11434722,11436103,11436124,11436227,11436311,11440026,11440076,11448989,11450943,11448992,11450941,11479208,11479232,11481301,11481485,11481300,11481468,11481258,11481470,11481670,11481696,11481781,11481837,11481893,11481904,11494265,11494460,11500639,11500863,11500608,11500862,11514148,11515122,11530212,11530217,11531735,11531752,11531732,11531763,11531754,11531734,11532254,11532310,11532739,11532763,11533156,11533224,11538437,11538535,11544953,11545198,11558391,11558628,11573312,11575927,11576045,11577205,11578329,11579721,11579870,11586941,11587451,11601424,11601893,11602017,11602706,11616971,11620098,11620276,11620415,11620443,11625824,11625970,11635369,11635448,11637728,11637877,11650051,11651198,11666456,11667291,11667194,11667196,11668018,11668043,11668218,11678291,11678450,11679473,11680886,11682303,11682591,11711195,11711200,11712128,11712122,11712120,11713212,11713675,11713717,11713767,11739576,11739795,11739601,11739797,11757758,11757954,11757962,11757968,11758766,11758782,11758900,11758913,11758974,11758980,11767282,11767860,11769417,11770276,11806058,11806057,11807036,11807258,11807859,11817761,11817787,11823107,11824102,11823081,11824143,11852634,11853323,11854358,11854356,11854457,11854813,11855267,11867039,11896144,11896846,11896848,11896851,11896960,11897019,11897089,11904430,11907379,11940191,11942538,11942611,11942668,11942683,11942807,11949525,11964326,11980394,11980398,11980582,11980652,11980654,11982272,11982889,11983038,12006752,12021507,12021504,12021512,12022009,12022390,12022521,12024580,12031107,12033440,12046132,12061232,12061248,12062036,12062101,12062033,12062105,12062028,12062103,12062615,12062855,12062952,12063044,12063081,12065213,12065279,12085075,12086063,12101150,12101166,12102129,12102130,12102126,12103217,12103336,12103534,12103612,12103708,4174,4286,4171,4282,20713,20738,46501,46575,47400,47442,48872,49150,49544,49718,57300,57506,70737,71878,85658,85665,88402,88927,94162,95268,97561,97588,98562,98596,126410,126524,127244,127246,127248,128730,128820,128822,128870,128938,133768,133785,136775,138458,156460,157402,172872,172876,173744,173828,173745,173840,173748,173823,174594,174663,174998,175072,175385,175426,177658,178496,193469,210135,210162,211017,211013,211016,212546,212586,212719,212744,212819,212826,212899,214071,214317,214950,214073,214706,220130,220242,247386,247414,248220,248302,248223,248313,248222,248304,249098,249145,249230,249260,249846,249909,257054,257444,260029,260649,261970,262028,288322,288442,288916,289293,288917,289639,288919,289549,289823,289829,290279,290363,290630,299071,299113,313467,313998,316146,316452,331830,331867,333460,333555,333558,333602,334753,335006,337313,340040,340745,340080,340748,344982,358160,358354,372031,372055,373016,373255,373017,373259,373014,373258,373774,374107,374439,374507,374548,374646) ) ORDER BY `sort` DESC === {Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist}: