( If you know any of his / her Neibhour details please fill the below details.)
var fam_firstname=document.getElementById('family_firstname').value;
var fam_lastname=document.getElementById('family_lastname').value;
//var fam_firstname=document.getElementById('').value;
var fam_fromage=document.getElementById('family_age_from').value;
var fam_toage=document.getElementById('family_age_to').value;
var fam_maritalsts=document.getElementById('marital_status').value;
var fam_relation=document.getElementById('family_relation').value;
var fam_occpation=document.getElementById('family_occupation').value;
var edu_education=document.getElementById('edu_education').value;
var edu_scname=document.getElementById('edu_scname').value;
var edu_university=document.getElementById('edu_university').value;
var edu_location=document.getElementById('edu_location').value;
var edu_from_year=document.getElementById('edu_from_year').value;
var edu_to_year=document.getElementById('edu_to_year').value;
var neibh_village=document.getElementById('neigh_village').value;
var neibh_location=document.getElementById('neigh_location').value;
var neibh_district=document.getElementById('neibh_district').value;
var neibh_state=document.getElementById('neibh_state').value;
var neibh_from_year=document.getElementById('neibh_from_year').value;
var neibh_to_year=document.getElementById('neibh_to_year').value;
var prof_empid=document.getElementById('emp_employeeid').value;
var prof_designation=document.getElementById('emp_designation').value;
var prof_companyname=document.getElementById('emp_companyname').value;
var prof_category=document.getElementById('emp_category').value;
var prof_location=document.getElementById('emp_location').value;
var prof_from_year=document.getElementById('emp_from_year').value;
var prof_to_year=document.getElementById('emp_to_year').value;
"search_surname="+firstsurname_yes+"&search_firstname="+firstfirstname_yes+"&search_middlename="+firstmidlename_yes+"&search_location="+location+"&search_gender="+gender+"&search_age="+age+"&search_val="+search_val+"
$family_firstname=$this->family_firstname;
$family_lastname=$this->family_lastname;
$family_from_age=$this->family_from_age;
$family_to_age=$this->family_to_age;
$family_marital_status=$this->family_marital_status;
$family_relation=$this->family_relation;
$family_occupation=$this->family_occupation;
$edu_education=$this->edu_education;
$edu_scname=$this->edu_scname;
$edu_university=$this->edu_university;
$edu_location=$this->edu_location;
$edu_from_year=$this->edu_from_year;
$edu_to_year=$this->edu_to_year;
$neibh_village=$this->neibh_village;
$neibh_location=$this->neibh_location;
$neibh_district=$this->neibh_district;
$neibh_state=$this->neibh_state;
$neibh_from_year=$this->neibh_from_year;
$neibh_to_year=$this->neibh_to_year;
$prof_employeeid=$this->prof_employeeid;
$prof_designation=$this->prof_designation;
$prof_companyname=$this->prof_companyname;
$prof_category=$this->prof_category;
$prof_location=$this->prof_location;
$prof_from_year=$this->prof_from_year;
$prof_to_year=$this->prof_to_year;
regid: 1630135892
rollno: 3441009846
pwd: 50198863
select * from user u left join user_family uf on u.id=uf.user_id left join user_education ue on u.id=ue.user_id left join user_professional_info up on u.id=up.user_id left join user_neighourhood_data un on u.id=un.user_id where 1=1 and department_id='3' and u.last_name like '%batta%' and u.name like '%mad%' and u.middle_name like '%ma%' and uf.name like '%ven%' and uf.last_name like '%batta%' and uf.marital_status like '%married%' and uf.occupation like '%far%' and uf.age BETWEEN 15 AND 50 and u.status='Active' and u.verified='Yes' group by u.id order by u.id desc
select * from user u left join user_family uf on u.id=uf.user_id left join user_education ue on u.id=ue.user_id left join user_professional_info up on u.id=up.user_id left join user_neighourhood_data un on u.id=un.user_id where 1=1 and department_id='3' and u.last_name like '%batta%' and u.name like '%mad%' and u.middle_name like '%mad%' and u.location like '%hyd%' and u.gender='10' and u.age BETWEEN 10 AND 100 and uf.name like '%venk%' and uf.last_name like '%batta%' and u.status='Active' and u.verified='Yes' group by u.id order by u.id desc
select * from user u left join user_family uf on u.id=uf.user_id left join user_education ue on u.id=ue.user_id left join user_professional_info up on u.id=up.user_id left join user_neighourhood_data un on u.id=un.user_id where 1=1 and department_id='3' and uf.name like '%ven%' and uf.last_name like '%bat%' and u.status='Active' and u.verified='Yes' group by u.id order by u.id desc
select * from user u left join user_family uf on u.id=uf.user_id left join user_education ue on u.id=ue.user_id left join user_professional_info up on u.id=up.user_id left join user_neighourhood_data un on u.id=un.user_id where 1=1 and department_id='3' and u.last_name like '%bat%' and u.name like '%mad%' and u.middle_name like '%mad%' and uf.name like '%ven%' and uf.last_name like '%bat%' and uf.marital_status like '%married%' and uf.occupation like '%farm%' and uf.age BETWEEN 10 AND 55 and ue.education like '%tenth%' and ue.name like '%kudunuru%' and ue.university like '%kudunuru%' and ue.location like '%kudunuru%' and attend_from_year <= '1930' AND attend_to_year >= '2018' and un.village like '%kudunuru%' and un.location like '%bhad%' and un.district_id = '2' and un.state_id = '1' and attented_from_year <= '1931' AND attented_to_year >= '2018' and up.empid like '%123%' and up.designation like '%farm%' and up.company_name like '%home%' and up.category_id = '1' and up.location like '%kudunuru%' and worked_from_year <= '1936' AND worked_to_year >= '2018' and u.status='Active' and u.verified='Yes' group by u.id order by u.id desc
select * from user u left join user_family uf on u.id=uf.user_id left join user_education ue on u.id=ue.user_id left join user_professional_info up on u.id=up.user_id left join user_neighourhood_data un on u.id=un.user_id where 1=1 and department_id='3' and u.last_name like '%bat%' and u.name like '%mad%' and u.middle_name like '%ma%' and uf.name like '%ven%' and uf.last_name like '%bat%' and uf.marital_status like '%married%' and uf.occupation like '%farm%' and uf.age BETWEEN 10 AND 55 and ue.education like '%ssc%' and ue.name like '%ssc%' and ue.university like '%kudunuru%' and ue.location like '%kudunuru%' and un.village like '%kudunuru%' and un.location like '%bhad%' and un.district_id = '2' and un.state_id = '1' and up.empid like '%123%' and up.designation like '%farm%' and up.company_name like '%home%' and up.category_id = '1' and up.location like '%kudunuru%' and u.status='Active' and u.verified='Yes' group by u.id order by u.id desc
select * from user u left join user_family uf on u.id=uf.user_id left join user_education ue on u.id=ue.user_id left join user_professional_info up on u.id=up.user_id left join user_neighourhood_data un on u.id=un.user_id where 1=1 and department_id='3' and u.last_name like '%batta%' and u.name like '%mad%' and u.middle_name like '%ma%' and uf.name like '%ven%' and uf.last_name like '%bat%' and u.status='Active' and u.verified='Yes' group by u.id order by u.id desc 1
YesfNoeNonNoemp2cntselect * from user u left join user_family uf on u.id=uf.user_id left join user_education ue on u.id=ue.user_id left join user_professional_info up on u.id=up.user_id left join user_neighourhood_data un on u.id=un.user_id where 1=1 and department_id='3' and u.last_name like '%batta%' and u.name like '%mad%' and u.middle_name like '%ma%' and uf.name like '%ven%' and uf.last_name like '%bat%' and u.status='Active' and u.verified='Yes' group by u.id order by u.id desc 1
select u.id as userid,u.name as username, u.last_name as user_last_name,u.middle_name,u.nickname,u.gender as user_gender,u.age as user_age,u.is_nri,u.address as user_address,u.state_id as user_state,u.district_id as user_district,u.city as user_city,u.location as user_location,uf.id as family_id,uf.name as family_firstname,uf.last_name as family_lastname,uf.age as family_age,uf.occupation as family_occupation,uf.relation_id as family_relation,uf.marital_status as family_maritalstatus,ue.id as education_id,ue.education as user_education,ue.university as user_university,ue.name as scname,ue.state_id as education_state,ue.district_id as education_district,ue.location as education_location,ue.attend_from_year as edu_attend_fromyear,ue.attend_to_year as edu_attend_toyear,un.id as neigbour_id,un.village as neibh_village,un.state_id as neibh_state,un.district_id as neibh_district,un.location as neibh_location,un.attented_from_year as neibh_from_year,un.attented_to_year as neibh_to_year,up.id as professional_id,up.company_name as prof_companyname,up.designation as prof_designation,up.empid as employeeid,up.state_id as prof_state_id,up.district_id as prof_district_id,up.location as prof_location,up.worked_from_year as prof_from_year,up.worked_to_year as prof_to_year from user u left join user_family uf on u.id=uf.user_id left join user_education ue on u.id=ue.user_id left join user_professional_info up on u.id=up.user_id left join user_neighourhood_data un on u.id=un.user_id where 1=1 and department_id='3'
select u.id as userid,u.name as username, u.last_name as user_last_name,u.middle_name,u.nickname,u.gender as user_gender,u.age as user_age,u.is_nri,u.address as user_address,u.state_id as user_state,u.district_id as user_district,u.city as user_city,u.location as user_location,uf.id as family_id,uf.name as family_firstname,uf.last_name as family_lastname,uf.age as family_age,uf.occupation as family_occupation,uf.relation_id as family_relation,uf.marital_status as family_maritalstatus,ue.id as education_id,ue.education as user_education,ue.university as user_university,ue.name as scname,ue.state_id as education_state,ue.district_id as education_district,ue.location as education_location,ue.attend_from_year as edu_attend_fromyear,ue.attend_to_year as edu_attend_toyear,un.id as neigbour_id,un.village as neibh_village,un.state_id as neibh_state,un.district_id as neibh_district,un.location as neibh_location,un.attented_from_year as neibh_from_year,un.attented_to_year as neibh_to_year,up.id as professional_id,up.company_name as prof_companyname,up.designation as prof_designation,up.empid as employeeid,up.state_id as prof_state_id,up.district_id as prof_district_id,up.location as prof_location,up.worked_from_year as prof_from_year,up.worked_to_year as prof_to_year,up.category_id as prof_category_id from user u left join user_family uf on u.id=uf.user_id left join user_education ue on u.id=ue.user_id left join user_professional_info up on u.id=up.user_id left join user_neighourhood_data un on u.id=un.user_id where 1=1 and department_id='3' and u.last_name like '%batta%' and u.name like '%mad%' and u.middle_name like '%ma%' and uf.name like '%ven%' and uf.last_name like '%bat%' and u.status='Active' and u.verified='Yes' group by u.id order by u.id desc