Issues Stuck In Conversion

SELECT
 tenant_id,
 tenants.subdomain,
 tenants.final_domain,
 count(*) AS affected_issues
 --     id, conversion_status
FROM
 farfalla.issues
 JOIN tenants ON issues.tenant_id = tenants.id
WHERE
 issues.conversion_status != 'DEFERRED'
 AND issues.conversion_status != 'done'
 AND issues.file_type = 'pdf'
 AND tenant_id NOT IN(1, 2, 2859, 3112)
 AND issues.deleted_at IS NULL
GROUP BY
 tenant_id
ORDER BY
 affected_issues DESC;

Overview

---