How to get Lab results by result_text?

Hi,

I’m trying to get the results for labs but for some reason I’m not getting the correct results. Can someone please take a look at this query and tell me what I’m missing.
SELECT
po.patient_id,
p2.procedure_report_id,
p2.procedure_order_id,
pr.result_text,
pr.abnormal,
pr.result,
pr.range,
pr.procedure_result_id AS procid,
po.date_collected,
p2.date_report AS r,
po.encounter_id,
p2.report_status
FROM
procedure_order po
INNER JOIN procedure_report p2 ON
p2.procedure_order_id = po.procedure_order_id
INNER JOIN procedure_result pr ON
p2.procedure_report_id = pr.procedure_result_id
WHERE
(pr.result_text) IN (‘Creatinine’,
‘Potassium’,
‘WBC’,
‘HGB’,
‘NT PRO BNP’)
ORDER BY
p2.date_report DESC

So it seems like I only get Potassium and Creatinine but patients have more than just those two.