File: /var/www/html/bitrix/modules/blog/mysql/blog_post.php<br>Line: 628<br><font color=#ff0000>MySQL Query Error: SELECT DISTINCT P.ID as ID, P.TITLE as TITLE, P.DETAIL_TEXT as DETAIL_TEXT, DATE_FORMAT(P.DATE_PUBLISH, '%d.%m.%Y %H:%i:%s') as DATE_PUBLISH, P.AUTHOR_ID as AUTHOR_ID, UN.NAME as AUTHOR_NAME, ULN.LAST_NAME as AUTHOR_LAST_NAME, BU.ALIAS as BLOG_USER_ALIAS, P.DETAIL_TEXT_TYPE as DETAIL_TEXT_TYPE  FROM b_blog_post P 	LEFT JOIN b_user UN ON (P.AUTHOR_ID = UN.ID) LEFT JOIN b_user ULN ON (P.AUTHOR_ID = ULN.ID) LEFT JOIN b_blog_user BU ON (P.AUTHOR_ID = BU.USER_ID)  WHERE ((((P.BLOG_ID = 3 )))) AND ((((P.DATE_PUBLISH &lt;= '2026-05-10 07:26:08')))) AND ((((P.PUBLISH_STATUS = 'P' )))) ORDER BY P.DATE_PUBLISH DESC LIMIT 10</font>[Expression #1 of ORDER BY clause is not in SELECT list, references column 'olditida.P.DATE_PUBLISH' which is not in SELECT list; this is incompatible with DISTINCT]<br><br>
<table cellpadding="1" cellspacing="0" width="35%" bgcolor="#9C9A9C">
	<tr>
		<td><table cellpadding="5" cellspacing="0" width="100%">
			<tr>
				<td bgcolor="#FFFFFF" align="center"><FONT face="Verdana, Arial, Helvetica, sans-serif" size="-1">
				<font color="#FF0000"><b>DB query error.</b></font><br>Please try later.</font></td>
			</tr>
		</table></td>
	</tr>
</table>	
<br><br><br>	
