SELECT cats.id, cats.name, cats.born_at, (SELECT COUNT(*) FROM kittens WHERE mother_id = cats.id) AS num_offsprings FROM cats ORDER BY born_at DESC LIMIT 10 OFFSET 0