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 votes145 views1 answer
Sql find not in list
SQL
2 votes155 views1 answer
Query to find table size in oracle 12c
SQL
1 vote140 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
0 vote147 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
2 votes152 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote142 views1 answer
Like and not like together in sql
SQL
0 vote170 views2 answers
Getting customers with no orders sql
SQL
0 vote139 views1 answer
Mariadb cast to int
SQL
10 votes140 views2 answers
Tsql merge example
SQL
2 votes148 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL