Показать все похожие в группе - еще 15
Query: SELECT SQL_CALC_FOUND_ROWS a.`Message_ID`, a.`User_ID`, a.`IP`, a.`UserAgent`, a.`LastUser_ID`, a.`LastIP`, a.`LastUserAgent`, a.`Priority`, a.`Parent_Message_ID`, a.`ncTitle`, a.`ncKeywords`, a.`ncDescription`, sub.`Subdivision_ID`, CONCAT('', sub.`Hidden_URL`) AS `Hidden_URL`, cc.`Sub_Class_ID`, cc.`EnglishName`, a.`Checked`, a.`Created`, a.`Keyword`, a.`LastUpdated` + 0 AS LastUpdated, a.Name, tbl2551.Tip_Name AS Tip, tbl2551.Tip_ID AS Tip_id, tbl2551.`Value` AS Tip_value , a.Price, a.Pl, a.Comn, a.Cokol, a.Garage, a.Mans, a.Kirp, a.Gaz, a.Opalub, a.Derevo, a.Karkas, a.Otdelka, a.Deskr, a.Vid1, a.Vid2, a.Vid3, a.Vid4, a.Fasad1, a.Fasad2, a.Fasad3, a.Fasad4, a.Plan1, a.Plan2, a.Plan3, a.Plan4, a.Vid1small, a.Vid2small, a.Vid3small, a.Vid4small, a.Fasad1small, a.Fasad2small, a.Fasad3small, a.Fasad4small, a.Plan1small, a.Plan2small, a.Plan3small, a.Plan4small, a.Vidcat, a.Nomer, a.Vidp, a.Smeta, a.Uzki, a.gabA, a.gabB, a.Grupa, a.RabotnikNomer, a.ProektRabotnikID, a.PlLive, a.PriceAll, a.OpisKom, a.PriceAR, a.Top, a.PriceIR, a.PriceSmeta, a.IRPodrazdel, a.Archi, a.Articl, tbl2609.Etagnost_Name AS Etagnost, tbl2609.Etagnost_ID AS Etagnost_id, tbl2609.`Value` AS Etagnost_value , a.block, a.NomerNew, a.NomerOld, a.Podarok, a.recom, a.variant, a.region, a.zakazchik, a.style, a.pokaz, a.Price_Home, a.PriceARKRIR, a.PricePasport, a.PriceGenplan, a.PriceSI, a.PriceZI, a.TTR, a.monolit, a.Skidka, a.bestDay, a.bestWeek, a.bestMounth, a.sklon, a.Spalen, a.Keram, a.Dop, a.Prochie, a.Drugoe, a.Model, a.Video, a.Vid1Mob, a.Vid2Mob, a.Vid3Mob, a.Vid4Mob, a.Fasad1Mob, a.Fasad2Mob, a.Fasad3Mob, a.Fasad4Mob, a.Plan1Mob, a.Plan2Mob, a.Plan3Mob, a.Plan4Mob, a.Video_url, a.TipGarage, tbl2891.TipKrisha_Name AS TipKrisha, tbl2891.TipKrisha_ID AS TipKrisha_id, tbl2891.`Value` AS TipKrisha_value , a.ViewImage, a.Updated, DATE_FORMAT(a.`Updated`,'%Y') as Updated_year, DATE_FORMAT(a.`Updated`,'%m') as Updated_month, DATE_FORMAT(a.`Updated`,'%d') as Updated_day, DATE_FORMAT(a.`Updated`,'%H') as Updated_hours, DATE_FORMAT(a.`Updated`,'%i') as Updated_minutes, DATE_FORMAT(a.`Updated`,'%s') as Updated_seconds, a.Peredelal, a.Fundament, a.Perekritiya, a.FundamentText, a.PerekritiyaText, a.DataOffOn, DATE_FORMAT(a.`DataOffOn`,'%Y') as DataOffOn_year, DATE_FORMAT(a.`DataOffOn`,'%m') as DataOffOn_month, DATE_FORMAT(a.`DataOffOn`,'%d') as DataOffOn_day, DATE_FORMAT(a.`DataOffOn`,'%H') as DataOffOn_hours, DATE_FORMAT(a.`DataOffOn`,'%i') as DataOffOn_minutes, DATE_FORMAT(a.`DataOffOn`,'%s') as DataOffOn_seconds, a.PrichinaOff, tbl2919.TipProekta_Name AS TipProekta, tbl2919.TipProekta_ID AS TipProekta_id, tbl2919.`Value` AS TipProekta_value , a.KakieIzmeneniaStimbox, a.IDProektRoditel, a.PriceDizain, a.GrupaDiz, a.PodGrupa, a.PapkaArh, a.Virt_ingenerka, a.Virt_smeta, a.dizVid, a.VariantName, a.Vendor, a.ItemID, tbl3038.ShopCurrency_Name AS Currency, tbl3038.ShopCurrency_ID AS Currency_id, tbl3038.`Value` AS Currency_value , a.VAT, a.StockUnits, tbl3041.ShopUnits_Name AS Units, tbl3041.ShopUnits_ID AS Units_id, tbl3041.`Value` AS Units_value , a.ImportSourceID, a.kolSanUzlov, tbl3044.formaZdania_Name AS formaZdania, tbl3044.formaZdania_ID AS formaZdania_id, tbl3044.`Value` AS formaZdania_value , a.TipGaragePoisk, a.zerkaloOtID, a.visota, a.elVersion, a.PriceMarket, a.SpecMarket, a.Stock
FROM (`Message2001` AS a ) LEFT JOIN `Subdivision` AS sub ON sub.`Subdivision_ID` = a.`Subdivision_ID`
LEFT JOIN `Sub_Class` AS cc ON cc.`Sub_Class_ID` = a.`Sub_Class_ID` LEFT JOIN `Classificator_Tip` AS tbl2551 ON a.`Tip` = tbl2551.Tip_ID LEFT JOIN `Classificator_Etagnost` AS tbl2609 ON a.`Etagnost` = tbl2609.Etagnost_ID LEFT JOIN `Classificator_TipKrisha` AS tbl2891 ON a.`TipKrisha` = tbl2891.TipKrisha_ID LEFT JOIN `Classificator_TipProekta` AS tbl2919 ON a.`TipProekta` = tbl2919.TipProekta_ID LEFT JOIN `Classificator_ShopCurrency` AS tbl3038 ON a.`Currency` = tbl3038.ShopCurrency_ID LEFT JOIN `Classificator_ShopUnits` AS tbl3041 ON a.`Units` = tbl3041.ShopUnits_ID LEFT JOIN `Classificator_formaZdania` AS tbl3044 ON a.`formaZdania` = tbl3044.formaZdania_ID
WHERE 1 AND a.`Parent_Message_ID` = '0' AND (a.`Grupa` = 49 and a.`Message_ID` !=6283 and a.`User_ID` = 62 and a.`Model`!= '1') AND sub.`Catalogue_ID` = '11' AND a.`Subdivision_ID` = '98' AND a.`Sub_Class_ID` = '184' AND a.`Checked` = 1 ORDER BY a.`Priority` DESC, a.`LastUpdated` DESC LIMIT 0,12
Error: Sort aborted: Server shutdown in progress
Ошибка в функции вывода объектов.
