Laravel paginate raw sql

$items = DB::table('team')   
    ->selectRaw('SELECT *,earth_distance(ll_to_earth(team.lat, team.lng), ll_to_earth(23.1215939329,113.3096030895)) AS distance')
    ->whereRaw('earth_box(ll_to_earth(23.1215939329,113.3096030895),1000) @> ll_to_earth(team.lat, team.lng)')
    ->paginate(10);

foreach($items as $item) {
    echo $item->distance;
}

Source: stackoverflow.com

Similar codes

2 votes378 views1 answer
Tcl in sql
SQL
0 vote352 views1 answer
Add new column in sql with foreign key
SQL
0 vote301 views1 answer
Mysql delete from where like
SQL
0 vote302 views1 answer
How to return only the Date from a SQL Server DateTime datatype
SQL
0 vote308 views2 answers
Sql server set default value equal to auto increment
SQL
10 votes273 views1 answer
Oracle view dependencies
SQL
0 vote313 views1 answer
Mysql count with two joins
SQL
0 vote337 views1 answer
Update sql sintax
SQL
0 vote315 views1 answer
Convert int to varchar sql
SQL
1 vote319 views1 answer
Join to find results not in another table
SQL