ok so I got a lovely query from @tgxworld some time ago.
posts = Post.where('user_id IN (?) OR topic_id IN (?) OR raw LIKE (?)', uid, tid, '%@everyone%' ) .order(created_at: :desc) .limit(params["total"]) .offset(params["start"])
and it is quite useful, but I ain’t sure how to go adding more data to this.
What I’m really looking for is a request like above that returns:
pretty much what you would find in: