从数据库获取趋势帖子

在给定的组中，(由 $groups 数组提供)

In the given groups,(provided by $groups array)

在给定日期之后，(由 $date 提供)

After a given date,(provided by $date)

按他们的颠簸数量排序

这是我正在构建的功能，它只会获取新帖子，但它可能有助于了解我所追求的内容.请注意，我拥有的代码的当前存储库是 post 存储库(对于那些不熟悉 symfony 查询构建器的人，它基本上意味着它会自动从 post 表中选择).

This is my function that I am building off of which only gets new posts but it may help provide an understanding of what I am after. Note that the current repository of the code I have is the post repository(for those not familiar with symfony query builder it basically means that it automatically selects from the post table).

这是我到目前为止所拥有的，我真正的问题在于按每个帖子的颠簸数量排序.我认为在某些时候必须使用连接.

This is what I have so far, My real issue lies in ordering by the amount of bumps each post has. I'm thinking that a join is going to have to be utilized at some point.

如果您不熟悉 querybuilder 语法，那么 SQL 中的答案就可以了.

If you aren't familiar with querybuilder syntax then an answer in SQL would be fine.

我不懂 symfony，所以我的答案是在 sql 中.您需要加入post 和postbump 表，按postid 分组并计算碰撞的数量并过滤分组和日期:

I do not know symfony, so my answer is in sql. You need to join the post and postbump tables, group by postid and count the number of bumps and filter on groups and the date:

还请注意，您不能简单地将 in 运算符中的参数数组绑定为单个值 - 除非 symfony 的查询构建器使用字符串操作进行参数设置而不是准备好的语句.

Pls also note that you cannot simply bind an array of parameters within the in operator as a single value - unless symfony's query builder uses string operations for parameter setting and not prepared statements.