Medication Orders

select
   mo.ID as "MED_ORDER_ID"
 , mo.PATIENT_ID
 , pt.first_name as "PATIENT_FIRST_NAME"
 , pt.last_name as "PATIENT_LAST_NAME"
 , pt.dob as "PATIENT_DOB"
 , mo.MED_ORDER_THREAD_ID
 , concat('(', PRESCRIBING_USER_ID , ')', ' ', p_user.first_name, ' ', p_user.last_name) as "PRESCRIBING_USER"
 , concat('(', mo.DOCUMENTING_PERSONNEL_ID , ')', ' ', doc_user.first_name, ' ', doc_user.last_name) as "DOCUMENTING_PERSONNEL"
 , mo.START_DATE
 , mo.MEDICATION_ID
 , controlled
 , dea_description
 , mo.DISPLAYED_MEDICATION_NAME
 , med.brand_name
 , med.generic_name
 , mo.TYPE
 , mo.ROUTE
 , mo.STRENGTH
 , mo.FORM
 , mo.NDC
 , mo.MEDICATION_TYPE
 , mo.DIRECTIONS
 , mo.INDICATION
 , mo.QTY
 , mo.QTY_UNITS
 , mo.AUTH_REFILLS
 , mo.AUTH_REFILLS_QUALIFIER
 , mo.PHARMACY_NCPDPID
 , pharm.store_name as "PHARMACY_STORE_NAME"
 , mo.PHARMACY_INSTRUCTIONS
 , mo.SUBSTITUTIONS
 , mo.ORIGIN
 , mo.NOTES
 , mo.FULFILLMENT_TYPE
 , concat('(', mo.signed_by_user_id, ')', ' ', s_user.first_name, ' ', s_user.last_name, ', ', s_user.credentials) as "SIGNED_BY"
 , mo.SIGNED_TIME
 , concat('(', mo.created_by_user_id, ')', ' ', c_user.first_name, ' ', c_user.last_name, ', ', c_user.credentials) as "CREATED_BY"
 , mo.CREATION_TIME
 , concat('(', mo.deleted_by_user_id, ')', ' ', d_user.first_name, ' ', d_user.last_name, ', ', d_user.credentials) as "DELETED_BY"
 , mo.DELETION_TIME
 , mo.LAST_MODIFIED
from med_order mo
  join patient pt on pt.id = mo.patient_id
  left join user p_user on mo.prescribing_user_id = p_user.id
  left join user c_user on mo.created_by_user_id = c_user.id
  left join user d_user on mo.deleted_by_user_id = d_user.id
  left join user s_user on mo.signed_by_user_id = s_user.id
  left join user doc_user on doc_user.physician_id = mo.documenting_personnel_id
  left join pharmacy pharm on mo.pharmacy_ncpdpid = pharm.ncpdpid
  left join medication med on med.id = mo.medication_id;