Les organisation avec le plus de recurring_export
1
2
3
4
5
6
7
8
9
10
11
12
13 | SELECT slug,
organization_id,
count(*) AS total_active_recurring_export
FROM organization_reporting
JOIN organization ON organization.id = organization_id
WHERE (
expired_at IS NULL OR
expired_at > now()
)
AND organization_reporting.deleted_at IS NULL
GROUP BY organization_id
ORDER BY total_active_recurring_export DESC
LIMIT 20;
|
Keywords
organization_reporting count organization