Виды ремонта

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`, a.`ncSMO_Title`, a.`ncSMO_Description`, a.`ncSMO_Image`, 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.`Link`, tbl942.`ServiceTab_Name` AS `ServiceTab`, tbl942.`ServiceTab_ID` AS `ServiceTab_id`, tbl942.`Value` AS `ServiceTab_value` , tbl942.`CustomSettings` AS `ServiceTab_settings` , a.`Name`, tbl943.`Icon_Name` AS `Icon`, tbl943.`Icon_ID` AS `Icon_id`, tbl943.`Value` AS `Icon_value` , tbl943.`CustomSettings` AS `Icon_settings` , a.`Price`, a.`Description`, tbl944.`Domain_Name` AS `Domain`, tbl944.`Domain_ID` AS `Domain_id`, tbl944.`Value` AS `Domain_value` , tbl944.`CustomSettings` AS `Domain_settings` FROM (`Message446` 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_ServiceTab` AS `tbl942` ON a.`ServiceTab` = tbl942.`ServiceTab_ID` LEFT JOIN `Classificator_Icon` AS `tbl943` ON a.`Icon` = tbl943.`Icon_ID` LEFT JOIN `Classificator_Domain` AS `tbl944` ON a.`Domain` = tbl944.`Domain_ID` WHERE (1 AND a.`Parent_Message_ID` = '0' AND a.`Domain` = '6' AND a.`ServiceTab` = '7' AND sub.`Catalogue_ID` = '1' AND a.`Checked` = 1 ) ORDER BY Priority ASC