пїЅпїЅпїЅпїЅпїЅпїЅ MySQL!
1030 - Got error 28 from storage engine
DB Query (select mp.lat, mp.lng, ct.class, ct.h_type, mp.name, ct.tip, 'a' as infos, GROUP_CONCAT( concat('', ' ',cast(idrealty as char),'',cast(rooms as char),'',cast(cost_all as char),'$' ) SEPARATOR ' ') as info from chase__maps as mp left join chase__catalog ct on ct.id = mp.idrealty where mp.idrealty in (0,5110,5111,5112,5115,5121,5122,5123,5125,5127,5131,5144,5149,5156,5158,5159,5161,5162,5170,5179,5182,5183,5187,5190,5196,5199,5200,5206,5207,5209,5237,5245,5253,5263,5267,5272,5279,5282,5283,5287,5289,5290,5291,5292,5294,5304,5305,5307,5308,5309,5312,5315,5320,5324,5325,5328,5332,5337,5342,5343,5345,5366,5374,5375,5378,5384,5390,5391,5395,5396,5398,5399,5404,5405,5407,5409,5416,5419,5424,5427,5429,5431,5432,5436,5438,5440,5442,5443,5449,5466,5470,5472,5474,5477,5478,5480,5485,5486,5488,5498,5502,5508,5509,5518,5521,5525,5531,5532,5547,5552,5553,5554,5555,5561,5566,5567,5576,5579,5581,5582,5583,5584,5594,5598,5604,5606,5607,5608,5611,5616,5617,5621,5625,5630,5639,5641,5644,5646,5649,5652,5654,5656,5675,5678,5682,5683,5684,5690,5699,5705,5709,5715,5723,5728,5732,5733,5735,5738,5742,5743,5745,5755,5758,5760,5762,5764,5765,5769,5772,5776,5778,5779,5784,5785,5786,5787,5788,5802,5804,5813,5815,5819,5824,5828,5837,5841,5849,5853,5860,5863,5870,5872,5874,5875,5877,5879,5882,5885,5888,5894,5897,5901,5902,5914,5916,5918,5922,5926,5941,5944,5946,5947,5950,5951,5955,5956,5970,5972,5974,5975,5976,5977,5983,5986,5996,6000,6008,6016,6017,6022,6026,6030,6032,6035,6040,6041,6043,6044,6046,6049,6064,6076,6077,6080,6087,6088,6089,6099,6102,6104,6110,6113,6132,6135,6142,6146,6148,6162,6751,6752,6755,6756,6757,6759,6760,6762,6769,6771,6772,6773,6774,6775,6776,6892,6893,6894,6895,6896,6899,6904,6906,6910,7036,7046,7083,7086,7205,7207,7213,7216,7237,7239,7240,7241,7243,7245,7246,7271,7274,7371,7373,7374,7381,7577,7581,7587,7591,7627,7665,7680,7681,7683,7684,7715,7716,7748,7749,7771,7772,7773,7788,7791,7805,7806,7807,7829,7832,7833,7853,7854,7885,7909,7911,7937,7959,8008,8009,8010,8022,8061,8094,8095,8099,8149,8290,8291,8349,8390,8543,8545,8768,8769,8828,9193,9194,9365,9390,9417,9418,9501,9551,9644,9698,9740,9755,9758,9760,9774,9775,9788,9789,9840,9856,9857,9858,9863,9864,9865,9896,9936,9938,10041,10043,10050,10070,10120,10128,10168,10170,10174,10180,10704,10742,10750,10761,11023,11040,11160,11166,11170,11181,11203,11205,11211,11212,11223,11224,11225,11233,11234,11235,11245,11261,11265,11274,11295,11296,11298,11300,11301,11302,11304,11308,11338,11339,11342,11346,11347,11366,11377,11385,11406,11424,11481,11482,11483,11486,11487,11492,11497,11522,11528,11590,11634,11650,11768,11857,11920,11969,12015,12072,12080,12164,12376,12587,12589,12672,12675,12747,13139,13157,13159,13218,13289,13308,13324,13431,13496,13499,13613,13615,13625,13651,13664,13666,13668,13741,13742,13746,13774,13850,13858,13872,13901,13923,13924,13936,13977,13995,14087,14122,14180,14181,14193,14305,14429,14431,14436,14681,14690,14693,14897,14909,14913,14937,14980,14983,15072,15126,15128,15228,15292,15293,15466,15544,15555,15615,15841,15889,15891,15892,15894,15905,16049,16053,16070,16071,16108,16216,16427,16428,16439,16478,16578,16660,16927,16928,17103,17156,17157,17158,17164,17212,17237,17265,17297,17298,17308,17345,17349,17437,17453,17790,17827,17829,17831,17850,17855,17941,17975,17976,18086,18130,18386,18420,18421,18432,18433,18485,18508,18525,18622,21167,21296,21326,21327,21328,21533,21743,22397,23152,23155,23157,23161,23817,24087,24164,24459,25023,25266,25379,25653,25705,25772,25774,25829,25897,25943,25997,25998,25999,26227,26344,26359,26414,26632,26679,26708,26759,27353,27381,27432,27456,27890,27897,27966,28030,28053,28059,28101,28159,28219,28308,28329,28346,28853,29180,29237,29278,29515,29519,29552,29595,29601,29862,29890,29893,29895,29944,30011,30448,30468,30469,30593,30604,30682,30689,30826,30953,30980,31001,31023,31034,31097,31110,31168,31169,31171,31177,31179,31181,31182,31183,31211,31292,31293,31331,31335,31336,31337,31340,31351,31352,31432,31433,31516,31555,31580,31709,31742,31769,32269,32271,32373,32374,32375,32447,32704,32768,32902,33379,33383,33408,33411,33494,33506,33539,33591,33653,33661,34056,34395,34428,34764,35024,35650,36218,36395,36459,36460,36462,37005,37006,37007,37008,37009,37010,37272,37449,37679,37755,37823,37824,37902,37907,37944,38091,38434,38449,38632,39009,39013,39069,43398,44346,44545,44813,45527,45531,45549,45699,45707,45885,46468,46692,46786,47026,47092,47222,5195,5704,9755,9755,5260,9755,9755,33690,9755,47679,9755,9755,5740,9755,31520,48633,48659,48830,35131,47294,49298,49330,9755,48977,49452,9755,34617,50438,50543) group by lat,lng, class, h_type, name order by name )
пїЅ пїЅпїЅпїЅпїЅпїЅ /var/www/chase_cms/data/www/chaseestate.ru/kernel/db.mysql.php, пїЅпїЅпїЅпїЅпїЅпїЅ 625