select id,groups_id,label_id,title,content,cardNo,cardNo_nickname,lable_name,head_icon,gmt_create,is_lock,view_amount,comment_amount,flower_amount,is_hot,is_top,is_best,gmt_comment,is_first_page,sort
from b_subject
where is_hot = 1
order by gmt_create desc;