Public feed #892583

Someone

public text v1 · immutable
Raw Edit
·published 2008-02-05 15:35 UTC
rendered paste body
		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