MySQL Query Error: SELECT FM.ID, FM.FORUM_ID, FM.TOPIC_ID, FM.USE_SMILES, FM.NEW_TOPIC, FM.APPROVED, FM.SOURCE_ID, DATE_FORMAT(FM.POST_DATE, '%d.%m.%Y %H:%i:%s') as POST_DATE, FM.POST_MESSAGE, FM.POST_MESSAGE_HTML, FM.POST_MESSAGE_FILTER, FM.ATTACH_IMG, FM.XML_ID, FM.PARAM1, FM.PARAM2, FM.AUTHOR_ID, FM.AUTHOR_NAME, FM.AUTHOR_EMAIL, FM.AUTHOR_IP, FM.AUTHOR_REAL_IP, FM.GUEST_ID, FM.EDITOR_ID, FM.EDITOR_NAME, FM.EDITOR_EMAIL, FM.EDIT_REASON, DATE_FORMAT(FM.EDIT_DATE, '%d.%m.%Y %H:%i:%s') as EDIT_DATE, FM.HTML, FM.MAIL_HEADER, FU.SHOW_NAME, FU.DESCRIPTION, FU.NUM_POSTS, FU.POINTS as NUM_POINTS, FU.SIGNATURE, FU.AVATAR, DATE_FORMAT(FU.DATE_REG, '%d.%m.%Y') as DATE_REG, U.LOGIN, U.NAME, U.SECOND_NAME, U.LAST_NAME, U.PERSONAL_PHOTO, FU.RANK_ID, U.PERSONAL_WWW, U.PERSONAL_GENDER, U.EMAIL, U.PERSONAL_ICQ, U.PERSONAL_CITY, U.PERSONAL_COUNTRY FROM b_forum_message FM LEFT JOIN b_forum_user FU ON (FM.AUTHOR_ID = FU.USER_ID) LEFT JOIN b_user U ON (FM.AUTHOR_ID = U.ID) WHERE 1 = 1 AND ((FM.AUTHOR_ID = 1 )) AND ((FM.APPROVED = 'Y' )) AND ((FM.FORUM_ID IN (2, 4, 6, 1, 3) )) ORDER BY FM.POST_DATE DESC LIMIT 100, 10[Out of sort memory, consider increasing server sort buffer size]
|