laravel query

@lav use groupBy.

@nakov Entry should not repeat with the same mobile number. Only a unique mobile number should be shown.

@lav so this does not work:

$tempUserData = TempCustomerBookTrip::select('temp_ggt_user_book_trip.order_date','temp_ggt_user_book_trip.order_time','temp_ggt_user_book_trip.intermediate_address','temp_ggt_user_book_trip.id','temp_ggt_user_book_trip.user_id','temp_ggt_user_book_trip.user_search_id','temp_ggt_user_book_trip.start_address_line_1','temp_ggt_user_book_trip.start_address_line_2','temp_ggt_user_book_trip.start_address_line_3','temp_ggt_user_book_trip.start_address_line_4','temp_ggt_user_book_trip.dest_address_line_1','temp_ggt_user_book_trip.dest_address_line_2','temp_ggt_user_book_trip.dest_address_line_3','temp_ggt_user_book_trip.dest_address_line_4','temp_ggt_user_book_trip.is_bid','ggt_user.user_first_name','ggt_user.user_middle_name','ggt_user.user_last_name','ggt_user.user_mobile_no','temp_ggt_user_book_trip.user_booked_location')
->join('ggt_user','temp_ggt_user_book_trip.user_id', '=','ggt_user.user_id')->orderBy('temp_ggt_user_book_trip.id','desc')
->groupBy('ggt_user.user_mobile_no')
->get()
->toArray();

?

@nakov By using findDistinct ggt_user.user_mobile_no and the recent entry for that mobile number. But how we wright the query for that.

@lav you will need a sub query to achieve that, take a look at this post

https://medium.com/@akaamitgupta/get-the-latest-record-on-the-group-in-the-most-eloquent-way-50597a588361

As your select is huge and I don't understand your database structure.

@nakov let me check. Thanks for the quick response.