-- name: GetProviderRow :one
SELECT provider_id, display_name, notes, lifecycle, revision, created_at, updated_at, created_by, updated_by
FROM providers
WHERE provider_id = ?;

-- name: ListProviderRows :many
SELECT p.provider_id, p.display_name, p.notes, p.lifecycle, p.revision, p.created_at, p.updated_at, p.created_by, p.updated_by,
       COUNT(t.trunk_id) AS trunk_count
FROM providers p
LEFT JOIN trunks t ON t.provider_id = p.provider_id
GROUP BY p.provider_id, p.display_name, p.notes, p.lifecycle, p.revision, p.created_at, p.updated_at, p.created_by, p.updated_by
ORDER BY p.updated_at DESC, p.provider_id ASC;