擅长:python、mysql、java
<p>正如<a href="https://stackoverflow.com/users/4429729/papooch">Papooch</a>所建议的,在模型上调用distinct似乎是可行的:</p>
<pre><code>distinct_visitors = (Pagevisits
.select(
Pagevisits.visitor_id.distinct().alias("visitor")
)
.where(Pagevisits.page_id == "Some specifc page")
.alias('distinct_visitors')
)
query = (Pagelikes
.select(fn.Count(Pagelikes.liked_item),
)
.join(distinct_visitors, on=(distinct_visitors.c.visitor = Pagelikes.user_id))
.group_by(Pagelikes.liked_item)
)
</code></pre>