Mysql子查询用limit

执行带有Limit子查询是有问题的：

  SELECT * FROM task_and_device  WHERE  job_id IN   (SELECT id FROM wx_device_task_job WHERE user_id=79269 AND STATUS=1 ORDER BY last_updated DESC LIMIT  20  OFFSET 0)

报了如下的错误：

错误码: 1235
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

需要再加上一层select才能成功：

  SELECT * FROM task_and_device  WHERE  job_id IN  (  SELECT A.id FROM  (  SELECT id FROM wx_device_task_job WHERE user_id=79269 AND STATUS=1 ORDER BY last_updated DESC  LIMIT  20  OFFSET 0  ) AS A  )