擅长:python、mysql、java
<p>正确的方法是使用聚合。</p>
<pre><code>articles = ArticleTracking.objects.filter(date__range=(start_date, end_date))
articles = articles.values('story_id', 'url', 'headline').annotate(count = Count('story_id')).order_by('-count')[:20]
</code></pre>
<p>还要查看Django中的聚合文档。</p>
<p><a href="https://docs.djangoproject.com/en/dev/topics/db/aggregation/" rel="noreferrer">https://docs.djangoproject.com/en/dev/topics/db/aggregation/</a></p>