$sqlSelect = " SELECT person.pcucodeperson AS pcucode,person.prename, person.fname, person.lname, person.birth,Year(Now())-Year(PERSON.birth) AS age, person.sex, person.hnomoi AS house, person.mumoi, person.idcard AS cid, personchronic.chroniccode AS chronic,
CONCAT(person.provcodemoi,person.distcodemoi,person.subdistcodemoi,person.mumoi) AS vhid
FROM person INNER JOIN personchronic ON person.pid = personchronic.pid
WHERE (((personchronic.chroniccode) Between 'e10' And 'e14.9')) AND
CONCAT(person.pid,person.pcucodeperson) not in (SELECT CONCAT(persondeath.pid,persondeath.pcucodeperson) FROM persondeath) and person.mumoi not like '00' AND person.hnomoi Not Like '0' ";
$querySelect = mysql_query($sqlSelect);
Load balance : Server 01
