edit ubuntu 14.04.5 source list

deb cdrom:[Ubuntu 14.04.5 LTS _Trusty Tahr_ - Release amd64 (20160803)]/ trusty main restricted
deb http://archive.ubuntu.com/ubuntu/ trusty main restricted
deb http://security.ubuntu.com/ubuntu/ trusty-security main restricted
deb http://archive.ubuntu.com/ubuntu/ trusty-updates main restricted

edit ubuntu 14.04 source

sudo sed -i -re 's/([a-z]{2}\.)?archive.ubuntu.com|security.ubuntu.com/old-releases.ubuntu.com/g' /etc/apt/sources.list

คนอยู่ที่เรา สิทธิ์อยู่ที่ใคร

SELECT
village.villno,
house.hno,
person.prename,
person.fname,
person.lname,
person.birth,
person.sex,
person.idcard,
person.typelive,
person.hosmain,
person.hossub
FROM
village
INNER JOIN house ON village.villcode = house.villcode
INNER JOIN person ON house.hcode = person.hcode
LEFT JOIN persondeath ON person.pid = persondeath.pid
WHERE
persondeath.pid IS NULL AND
village.villno <> 0 AND
person.typelive IN (0, 1, 3) AND
person.hossub = '03302'
ORDER BY
village.villno+100 ASC ,
length(if(instr(hno,'/')>0,substring(hno,1,instr(hno,'/')-1),hno)) ASC,
if(instr(hno,'/')>0,substring(hno,1,instr(hno,'/')-1),hno) asc,
hno asc