SET @hospitalcode = (SELECT hospitalcode FROM opdconfig);
SET @hospital_aid = (SELECT concat(chwpart,amppart) FROM hospcode WHERE hospcode = @hospitalcode);
SELECT v.hn,concat(p.pname,p.fname," ",p.lname) AS patient_name,v.age_y ,sx.name AS sex_name ,
s.bw AS body_weight,s.height,s.bmi
FROM vn_stat v
LEFT OUTER JOIN ovst o ON o.vn = v.vn
LEFT OUTER JOIN patient p ON p.hn = v.hn LEFT OUTER JOIN opdscreen s ON s.vn = v.vn
LEFT OUTER JOIN sex sx ON sx.code = v.sex
WHERE v.vstdate BETWEEN '2007-08-01' AND '2007-08-31' AND v.age_y >= 35
AND SUBSTRING(v.aid,1,4)=@hospital_aid