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

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