Live Queries

SELECT ltrd.id as detail_id,lab_test_results.id as result_id,lab_test_results.service_unit_id,s.id as service_id, s.name as service_name,sp.name as specimen_name,sp.id as specimen_id,ltr.patient_id as patientid,ltr.id as ltrid,ltr.*,ltrd.*,lab_test_results.status as bbtr_status,lts.extid as lextid, ltrd.status as ltrd_status,s.report_type,ltr.location_id as location_id FROM "lab_test_results" inner join lab_test_request_details as ltrd on ltrd.id = lab_test_results.lab_test_request_detail_id
        inner join lab_test_requests as ltr on ltr.id = ltrd.lab_test_request_id
        inner join lab_test_specimens as lts on lts.lab_test_request_detail_id = ltrd.id
        inner join services as s on s.id = ltrd.service_id
        inner join specimens as sp on sp.id = ltrd.specimen_id
        inner join service_units as su on su.id = lab_test_results.service_unit_id WHERE (su.apk_code != '' and ltrd.specimen_recieved = 'Received' and lab_test_results.apk_status is null and ltr.location_id=5 and ltr.id = '727702' an