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