数据库语句,统计点赞量

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();
            }