Get the latest reviewed games

¡Hi, folks! ¿How are you?

I'm having some trouble trying to figure out how to get the latest reviewed games.

I'll give you a bit of context. I have two tables:

So:

Reviews belongs to Game and Game has many Reviews

I think that the logic of the query must be something like: Obtain the last review of each game and obtain its created_at date.

Then, use the date of the last review of each game to order the games.

But i can't transform that logic into a query :(

Best Answer

Level 11

1 like

Level 1

Im running Laravel 5.8.* and thats answer fits to 6^. I will try to upgrade to that version, but i will appreciate a solution for 5.8.*.

Thanks a lot buddy!

Level 1

$user = DB::table('users')->latest()->first();

Level 1

Thanks @imrodrigoalves. I solved it with your help. Best regards :)

1 like

Please or to participate in this conversation.