create table foo (
  id bigserial primary key,
  name text,
  created date
);

insert into foo(name,created) values
  ('lol', '2018-01-09'),
  ('lol', '2018-01-08'),
  ('lol', '2018-01-08'),
  ('wow', '2018-01-07'),
  ('wow', '2018-01-09'),
  ('lol', '2018-01-09');


select * from foo order by name, id LIMIT 2;

select * from foo where id>2 OR name!='lol' order by name, id LIMIT 2;

select * from foo where id>6 OR name!='lol' order by name, id LIMIT 2;