SELECT ts, ref, ref_type
FROM counters
ORDER BY ref