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

...et ID.