select topics.topic_id,subject,left(body,255),short_content,body,
	    1 as score,
	    topics.icon
	from topics ,favorites
	where access=1 and expires>=curdate() and since<=curdate() and intgroup_id in ('0',0)
	     and topics.intgroup_id in ('0',0) and topics.topic_id=favorites.article_id and ip=''
	group by topics.topic_id
	order by score desc,topics.subject asc
	limit 0,10