MySQL 選取特定主鍵跟其下一筆之外的資料

這是來自ptt上的問題，最後將結論摘錄如下：

 SELECT A.id FROM news AS A LEFT JOIN
     (SELECT id FROM news WHERE id >=
        (select IFNULL(max(id),10) from news where id <10 )
      ORDER BY id LIMIT 3) AS B
   ON A.id = B.id WHERE B.id IS NULL