SELECT * FROM product ORDER BY id LIMIT 10000, 2 SELECT * FROM product as i JOIN (SELECT id FROM product ORDER BY id LIMIT 10000, 2) as temp on temp.id = i.id select name from member where age = 20;