数据库语句,统计点赞量

select ArticleAuthor,count(*) AS count from usercreatearticleindex where CreateTime > '2020-10-14 00:00:00' group by ArticleAuthor order by count DESC; 

var connectionString = _configuration.GetSection("ConnectionString").Value; string cmdtxt2 = "select ArticleId,count(*) AS count from userlikearticleindex group by ArticleId order by count DESC LIMIT 10;"; var mysql = ""; ContentItem contentItem = new ContentItem(); List<ArticleOutputDto> articleOutputDtos = new List<ArticleOutputDto>(); MySqlConnection sqlCon = new MySqlConnection(connectionString);//"server=127.0.0.1;user id=root;password=sa123;database=ceshizd" List<ClickArticleModel> query = new List<ClickArticleModel>(); //设置查询命令 MySqlCommand cmd = new MySqlCommand(cmdtxt2, sqlCon); //查询结果读取器 MySqlDataReader reader = null; try { //打开连接 sqlCon.Open(); //执行查询，并将结果返回给读取器 reader = cmd.ExecuteReader(); while (reader.Read()) { mysql = reader[0].ToString(); //query = (List<ClickArticleModel>)await _session.Query<ClickArticleModel, ClickArticleIndex>(c => c.ArticleId == mysql).ListAsync(); contentItem = await _session.Query<ContentItem, ContentItemIndex>().Where(m => m.ContentItemId == mysql && m.ContentType == "Article").FirstOrDefaultAsync(); if (contentItem != null) { ArticleOutputDto articleOutputDto = new ArticleOutputDto(); articleOutputDto.ContentItemId = contentItem.ContentItemId; articleOutputDto.DisplayText = contentItem.DisplayText; if (contentItem.Content.Article.ImageHeadPicture != null) { if (contentItem.Content.Article.ImageHeadPicture.Paths != null) { articleOutputDto.ImageUrl = contentItem.Content.Article.ImageHeadPicture.Paths[0]; } else { articleOutputDto.ImageUrl = null; } } else { articleOutputDto.ImageUrl = null; } articleOutputDto.PublishedUtc = contentItem.PublishedUtc; articleOutputDtos.Add(articleOutputDto); } } } catch (Exception ex) { } finally { reader.Close(); sqlCon.Close(); }