Styjun

Can I lend a small amount of my own money to a bank at the federal funds rate?

Count the number of triangles

Defending Castle from Zombies

Fantasy Macro Economics: What would Merfolk trade for?

Journal published a paper, ignoring my objections as a referee

Term used to describe a person who predicts future outcomes

In Endgame, wouldn't Stark have remembered Hulk busting out of the stairwell?

What is Soda Fountain Etiquette?

Why does Sauron not permit his followers to use his name?

Why can't I identify major and minor chords?

Why is 3/4 a simple meter while 6/8 is a compound meter?

Is this position a forced win for Black after move 14?

Find feasible point in polynomial time in linear programming

Is there an in-universe explanation given to the senior Imperial Navy Officers as to why Darth Vader serves Emperor Palpatine?

Why is the Grievance Studies affair considered to be research requiring IRB approval?

web scraping images

What should be done with the carbon when using magic to get oxygen from carbon dioxide?

Magnesium's Role in Photosynthesis

Stolen MacBook should I worry about my data?

How do I portray irrational anger in first person?

How did medieval manors handle population growth? Were there room for more fields to be ploughed?

Why did Lucius make a deal out of Buckbeak hurting Draco but not about Draco being turned into a ferret?

Which polygons can be turned inside out by a smooth deformation?

How to prevent a hosting company from accessing a VM's encryption keys?

Unexpected behaviour when using groupby in eloquent query for latest records

Get most recent row with group by and LaravelLaravel 4 Eloquent Query Using WHERE with OR AND OR?How to Create Multiple Where Clause Query Using Laravel Eloquent?Converting a MariaDB-Statement into a Laravel4 Eloquent-QueryOrderBy in Laravel 5How To GroupBy the latest record on the groupLaravel error in query that has “as having”Laravel : Select and GroupBy SQL Query Error. Multiple Selects with groupBy? Is it Possible?Laravel Eloquent group by most recent recordIs there any function to get the last entry in groupby in query builder or eloquent?Raw Query TO Laravel Eloquent

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

0

I'm trying to get the latest records in a group by query using eloquent in laravel.

My current query is:

 $clubs = ClubsLooking::select('a.*')
 ->from(DB::raw('(SELECT *, (3959 * acos( cos( radians('.Auth::user()->latitude.') ) *
 cos( radians( latitude ) )
 * cos( radians( longitude ) - radians('.Auth::user()->longitude.')
 ) + sin( radians('.Auth::user()->latitude.') ) *
 sin( radians( latitude ) ) )
 ) AS distance FROM clubs_looking ORDER BY created_at DESC) a'))
 ->groupBy('a.club_id')
 ->limit(4)
 ->get();

The query looks complex but is just using the haversine method of calculating distance between two coordinates and returning the result as a column named distance.

I was under the impression that by using this nested query I would be able to group by using the latest created_at date after reading this answer - Get most recent row with group by and Laravel

However when I run this query I always get the oldest record first, I've tried playing around in multiple ways with it but to no avail.

Does anyone with a larger brain than me know what I'm doing wrong?

laravel eloquent

share|improve this question

asked Mar 27 at 21:03

RockhopperRockhopper

9811 silver badge1010 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you screenshot your table structure? :)
  
  – Benjamin Beganović
  Mar 27 at 21:46
  

  
  
  
  

add a comment | 

0

0

I'm trying to get the latest records in a group by query using eloquent in laravel.

My current query is:

 $clubs = ClubsLooking::select('a.*')
 ->from(DB::raw('(SELECT *, (3959 * acos( cos( radians('.Auth::user()->latitude.') ) *
 cos( radians( latitude ) )
 * cos( radians( longitude ) - radians('.Auth::user()->longitude.')
 ) + sin( radians('.Auth::user()->latitude.') ) *
 sin( radians( latitude ) ) )
 ) AS distance FROM clubs_looking ORDER BY created_at DESC) a'))
 ->groupBy('a.club_id')
 ->limit(4)
 ->get();

The query looks complex but is just using the haversine method of calculating distance between two coordinates and returning the result as a column named distance.

I was under the impression that by using this nested query I would be able to group by using the latest created_at date after reading this answer - Get most recent row with group by and Laravel

However when I run this query I always get the oldest record first, I've tried playing around in multiple ways with it but to no avail.

Does anyone with a larger brain than me know what I'm doing wrong?

laravel eloquent

share|improve this question

asked Mar 27 at 21:03

RockhopperRockhopper

9811 silver badge1010 bronze badges

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you screenshot your table structure? :)
  
  – Benjamin Beganović
  Mar 27 at 21:46
  

  
  
  
  

add a comment | 

I'm trying to get the latest records in a group by query using eloquent in laravel.

My current query is:

 $clubs = ClubsLooking::select('a.*')
 ->from(DB::raw('(SELECT *, (3959 * acos( cos( radians('.Auth::user()->latitude.') ) *
 cos( radians( latitude ) )
 * cos( radians( longitude ) - radians('.Auth::user()->longitude.')
 ) + sin( radians('.Auth::user()->latitude.') ) *
 sin( radians( latitude ) ) )
 ) AS distance FROM clubs_looking ORDER BY created_at DESC) a'))
 ->groupBy('a.club_id')
 ->limit(4)
 ->get();

The query looks complex but is just using the haversine method of calculating distance between two coordinates and returning the result as a column named distance.

I was under the impression that by using this nested query I would be able to group by using the latest created_at date after reading this answer - Get most recent row with group by and Laravel

However when I run this query I always get the oldest record first, I've tried playing around in multiple ways with it but to no avail.

Does anyone with a larger brain than me know what I'm doing wrong?

laravel eloquent

share|improve this question

asked Mar 27 at 21:03

RockhopperRockhopper

9811 silver badge1010 bronze badges

 $clubs = ClubsLooking::select('a.*')
 ->from(DB::raw('(SELECT *, (3959 * acos( cos( radians('.Auth::user()->latitude.') ) *
 cos( radians( latitude ) )
 * cos( radians( longitude ) - radians('.Auth::user()->longitude.')
 ) + sin( radians('.Auth::user()->latitude.') ) *
 sin( radians( latitude ) ) )
 ) AS distance FROM clubs_looking ORDER BY created_at DESC) a'))
 ->groupBy('a.club_id')
 ->limit(4)
 ->get();

share|improve this question

asked Mar 27 at 21:03

RockhopperRockhopper

9811 silver badge1010 bronze badges

share|improve this question

asked Mar 27 at 21:03

RockhopperRockhopper

9811 silver badge1010 bronze badges

asked Mar 27 at 21:03

RockhopperRockhopper

9811 silver badge1010 bronze badges

asked Mar 27 at 21:03

RockhopperRockhopper

9811 silver badge1010 bronze badges