$result = dbquery(
			"SELECT tn.*, tc.*, tu.user_id, tu.user_name, tu.user_status, (SELECT AVG(rating_vote)
																		   FROM ".DB_RATINGS." r
																		   WHERE r.rating_type='N'
																		   AND (r.rating_item_id = news_id)) as `ratcount`
			FROM ".DB_NEWS." tn
			LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id
			LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id
			WHERE ".groupaccess('news_visibility')." AND news_miasto='".$_SESSION&#91;'miasto'&#93;."' AND ".groupaccess('news_visibility')." AND (news_start='0'||news_start<=".time().")
				AND (news_end='0'||news_end>=".time().") AND news_draft='0'
			GROUP BY news_id
			ORDER BY news_sticky DESC, ratcount DESC, news_datestamp DESC LIMIT ".$_GET&#91;'rowstart'&#93;.",".$items_per_page
		);
 
Zinterpretowano w sekund: 0.013, wykorzystano GeSHi 1.0.8.10