SELECT
    count(*)
FROM
    "public"."reported_transactions" as "ReportedTransaction"
    inner join "public"."transactions" as "Transaction" on ("ReportedTransaction"."transaction_id" = "Transaction"."transaction_id")
    inner join "public"."receipts" as "Receipt" on ("Transaction"."receipt_id" = "Receipt"."receipt_id")
WHERE
    "ReportedTransaction"."is_closed" = false
    AND "ReportedTransaction"."creator_reason" not like '%Is: buyer%'
    AND "ReportedTransaction"."creation_tsz" <= now() + '12 hours ago'
    AND "Transaction"."seller_user_id" IS NOT NULL
    AND "Transaction"."buyer_user_id" IS NOT NULL;