Convert SQL query into CakePHP pagination query

How can I use the following query:

SELEC开发者_开发问答T *
FROM `laps`
WHERE `id` = (
  SELECT `id`
  FROM `laps` AS `alt`
  WHERE `alt`.`user_id` = `laps`.`user_id`
  ORDER BY `lap_time` ASC
  LIMIT 1 )
ORDER BY `lap_time` ASC

in my CakePHP app and paginate the results?

what you actually want is how to do custom pagination query. there's some info about that here

convert your query to join way, then use cake custom pagination.