查询30天内的内容

最新推荐文章于 2022-04-08 20:07:19 发布

mingruiren

最新推荐文章于 2022-04-08 20:07:19 发布

阅读量351

点赞数

本文链接：https://blog.csdn.net/mingruiren/article/details/49534193

版权

select searchcode as keywords, totalcount as count
      from (select t.searchcode, sum(b.countNum) as totalcount
              from (select contentid, count(contentid) as countNum
                      from T_US_VIEW_VIDEO_LOG a
                     where to_date(a.dateStr, 'yyyy-MM-dd') >= SYSDATE - 30
                       and a.identityid = 10053
                     group by contentid
                     order by countNum desc) b,
                   T_AUDITCONTENT_INFO t
             where b.contentid = t.contentid
               and t.searchcode is not null
             group by searchcode
             order by totalcount desc)
     WHERE ROWNUM <= 10