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

0 vote218 views1 answer
Add mysql database to power bi web
SQL
0 vote200 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
1 vote203 views2 answers
Begin transaction in sql
SQL
0 vote233 views1 answer
Mysql error codeigniter
SQL
0 vote198 views1 answer
Oracle for loop on list
SQL
0 vote197 views1 answer
Mysql export and import
SQL
0 vote159 views1 answer
Postgresql subquery
SQL
5 votes228 views1 answer
Oracle get ddl
SQL
0 vote192 views1 answer
1 column values in to 1 single row in sql
SQL
0 vote195 views2 answers
Mysql disable foreign key checks
SQL