fix bad-query: payment_processor_type is not a char-field. add join to get ID.