recNum 20
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.`img_prev`, a.`img`, a.`name`, a.`Mes_ID` FROM (`Message166` 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` WHERE (1 AND a.`Parent_Message_ID` = '0' AND sub.`Catalogue_ID` = '1' AND a.`Subdivision_ID` = '157' AND a.`Sub_Class_ID` = '299' AND a.`Checked` = 1 ) ORDER BY a.`Priority` DESC, a.`Message_ID` DESC LIMIT 0, 20