How to display companies by the number of comments?

Question

Laravel

$top_companies =Company::query()
            ->where(...)    // где коментариев больше както так
            ->paginate(8);

Answer 1

Company::has('comments', '>', 1)

Answer 2

->where('Comments', '>', 8)
My answer is given exactly as the question is asked. However, in reality the comments and their number will not be stored in the same table. Most likely, there is some kind of table with a foreign key to the companies table, you need to JOIN this table and in the condition rely on the number of records in it, and not in the main table.

Answer 3

1. Select companies along with comments using eager loading
   
2. You run through the elements of the collection and add a new attribute, for example, count, the value of which will be equal to the number of comments for this company
   
3. Sorting a collection by the count attribute
   
4. Cut out only the necessary elements from the collection
   
5. Returning a view with a collection