Closed amin101 closed 8 years ago
Because there are 2 orders, look at queries :
select count(*) as aggregate from `comments`
select * from `comments` order by `seen` asc, `created_at` desc limit 4 offset 0
select * from `posts` where `posts`.`id` in ('1', '2')
select * from `users` where `users`.`id` in ('2', '3')
select * from `users` where `users`.`id` = '1' limit 1
I'm a bit confused by using
latest
andoldest
methods in same query . would you please explain this :