select ask.id "id",ask.createTime "createTime",ask.publisherID "publisherID",users.nickname "nickname",users.icon "icon",users.gender "gender",ask.reward "reward",ask.zan "zan",ask.commentID "commentID",ask.typee "type",ask.label "label",ask.content "content",ask.image "image",count(comment.id) "commentCount"from ask inner join users on ask.publisherID=users.id left outer join comment on comment.objectID = ask.id group by ask.id,users.nickname,users.icon,users.genderorder by "createTime" desclimit 10 offset 0;