Page Comparison

select distinct concat(pn.given_name," ", ifnull(pn.family_name,'')) as name, pi.identifier as identifier, concat("",p.uuid) as uuid,
           concat("",v.uuid) as activeVisitUuid,
           IF(va.value_reference = "Admitted", "true", "false") as hasBeenAdmitted
           from
           visit v join person_name pn on v.patient_id = pn.person_id and pn.voided = 0 and v.voided=0
           join patient_identifier pi on v.patient_id = pi.patient_id and pi.voided=0
           join person p on p.person_id = v.patient_id  and p.voided=0
           join encounter en on en.visit_id = v.visit_id and en.voided=0
           join encounter_provider ep on ep.encounter_id = en.encounter_id  and ep.voided=0
           join provider pr on ep.provider_id=pr.provider_id and pr.retired=0
           join person per on pr.person_id=per.person_id and per.voided=0
           left outer join visit_attribute va on va.visit_id = v.visit_id and va.voided = 0 and va.attribute_type_id = (
           select visit_attribute_type_id from visit_attribute_type where name="Admission Status"
           )
           where
           date(en.encounter_datetime)=curdate() and
           pr.uuid=${provider_uuid}
           order by en.encounter_datetime desc;