SELECT* from service_top10place top10 JOIN service_place place ON top10.place_id = place.id WHERE place.is_open = TRUE ORDER BY top10.created_date DESC, top10.ranking asc; SELECT * from … limit 50 When I do the sql statement, the two results are different I’m curious why the results are different if there’s a limit or not sql limit