query.sql

SELECT COUNT(1) FROM (

  SELECT s_stats.id
  FROM s_stats
  LEFT JOIN s_organizations ON s_stats.organization_id = s_organizations.id
  WHERE stats_purged_sents IS NULL
  AND (
    (
      ( ( s_organizations.permissions -> 'quota_mode' ) is not distinct from 'no_limit' )
      OR
      ( ( s_organizations.permissions -> 'quota_limit' ) is distinct from '1' )
    )
    OR
    (
      s_organizations.deleted_at IS NULL
    )
  )

);