select r.id resident_id,r.road,r.house,r.flat,r.status,r.created_at,m.id person_id,m.name,m.nid,m.mobile,m.profession,m.email,m.dob,m.facebook_id,m.blood_group,m.gender,t.id person_type,t.name type_name from resident_registration r inner join resident_family_members m on r.id=m.resident_id inner join person_type t on t.id=m.type_id  where r.inactive=0       order by r.id desc limit 0,102
select r.id resident_id,r.road,r.house,r.flat,r.status,r.created_at,m.id person_id,m.name,m.nid,m.mobile,m.profession,m.email,m.dob,m.facebook_id,m.blood_group,m.gender,t.id person_type,t.name type_name from resident_registration r inner join resident_family_members m on r.id=m.resident_id inner join person_type t on t.id=m.type_id  where r.inactive=0       order by r.id desc limit 0,102
select r.id resident_id,r.road,r.house,r.flat,r.status,r.created_at,m.id person_id,m.name,m.nid,m.mobile,m.profession,m.email,m.dob,m.facebook_id,m.blood_group,m.gender,t.id person_type,t.name type_name from resident_registration r inner join resident_family_members m on r.id=m.resident_id inner join person_type t on t.id=m.type_id  where r.inactive=0       order by r.id desc limit 0,102