SELECT Replace(pm.Patient_ID,'LSHHI','')PID,pm.PName,pm.Age,pm.Gender,plo.Date,plo.LedgerTransactionNo LabNo,  im.Name Investigation,ploc.LabObservationName,ploc.Value,ploc.MinValue,ploc.MaxValue, IF(ploc.Value IN ('POSITIVE','REACTIVE','WEAKLY REACTIVE','WEAKLY POSITIVE'),'',ploc.DisplayReading)DisplayReading,  ploc.ReadingFormat FROM patient_labinvestigation_opd plo INNER JOIN patient_labobservation_opd ploc ON  plo.Test_ID = ploc.Test_ID AND DATE(plo.Date) >='2025-1-1'  AND DATE(plo.Date) <='2025-1-31' AND plo.Result_Flag=1  AND ploc.Value <>''  AND IF(ploc.Value IN ('POSITIVE','REACTIVE','WEAKLY REACTIVE','WEAKLY POSITIVE'),ploc.MinValue='',ploc.MinValue <> '')  AND IF(ploc.Value IN ('POSITIVE','REACTIVE','WEAKLY REACTIVE','WEAKLY POSITIVE'),ploc.MaxValue='',ploc.MaxValue <> '')  AND ((CAST(ploc.Value AS DECIMAL) NOT BETWEEN CAST(ploc.MinValue AS DECIMAL) AND CAST(ploc.MaxValue AS DECIMAL))  OR UCASE(ploc.VALUE) IN ('POSITIVE','REACTIVE','WEAKLY REACTIVE','WEAKLY POSITIVE')) INNER JOIN investigation_master im ON im.Investigation_Id = plo.Investigation_ID  INNER JOIN patient_master pm ON pm.Patient_ID = plo.Patient_ID  ORDER BY plo.ID,ploc.Priorty