(SELECT pcr.request_status 
   FROM hdb_payment_change_request pcr 
   INNER JOIN hdb_registration_payment_detail rpd ON pcr.payment_id = rpd.id 
   WHERE rpd.registration_id = pr.id 
     AND rpd.deleted_at IS NULL 
     AND pcr.created_at IS NOT NULL
   ORDER BY pcr.updated_at DESC 
   LIMIT 1)