Page Comparison

  "declarations": select area, count(id) from
(select d.id,d.division_id, da.area from  declarations d
left join division_addresses da on da.division.addreses['RESIDENCE'].region_ID and _id=d.division_id
where d.status in('active', 'pending_verification') ) a
group by area

  "msps": legal_entities.[type='MSP' and status='ACTIVE'].addreses['REGISTRATION'].region_ID
  "doctors": 15 --> employees.[employee_type='DOCTOR' & is_active=true and status='APPROVED'].division_id-->divisions.addreses['RESIDENCE'].region_ID
  "pharmacies": 2, --> legal_entities.[type='PHARMACY' and status='ACTIVE'].addreses['REGISTRATION'].region_ID
  "pharmacists": 15 --> employees.[employee_type='PHARMACIST' & is_active=true and status='APPROVED'].division_id-->divisions.addreses['RESIDENCE'].region_ID
  "medication_requests": 30 -->medication_requests.employee_id-->division_id-->divisions.addreses['REGISTRATION'].region_ID
  "active medication requests":
      select area, count(id) from
      (select  mr.id,mr.division_id, da.area from medication_requests mrleft join division_addresses da on da.division_id=mr.division_id and type = 'RESIDENCE'where status = 'ACTIVE') a
      group by area;
  "completed medication requests":
      select area, count(id) from
      (select  mr.id,mr.division_id, da.area from medication_requests mrleft join division_addresses da on da.division_id=mr.division_id and type = 'RESIDENCE'where status = 'COMPLETED') a
      group by area;