Select ca_product_id, count(ca_product_id)
From card_subs_id left Join invoice ON card_subs_id.codes = invoice.card_subscriber_id
Where invoice.paid != 'Y' AND viewed_ind = 'Y' AND payment_override != 'Y' AND (invoice.Fix_existing_Viewed_invoice Is Null AND invoice.Fix_new_Viewed_invoice Is Null) AND substring(ca_product_id, 15 , 1) = '5'
Group By ca_product_id
Order By ca_product_id