DataBase error - Table 'iay.tblsettingvalue' doesn't exist
select tblsettingvalue.settingvalue from tblsettingvalue
left join tblsetting on tblsettingvalue.settingid = tblsetting.settingid
where tblsetting.parameter = 'frontend_pagelength' DataBase error - Table 'iay.tblfamily' doesn't exist
Select count(*) from tblfamily where verificationstatus='Yes' DataBase error - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 5
select familyid, familycode, tblfamily.villagecode, fathername, headname, tblfamilyhindi.headinhindi,tblfamilyhindi.fatherinhindi, amountsan, date_format(amountsandate, '%d-%m-%Y') as amountsandate, amtsanfirst, date_format(amtsanfirstdate, '%d-%m-%Y') as amtsanfirstdate, amtsansecond, date_format(amtsanseconddate, '%d-%m-%Y') as amtsanseconddate, constructionstatus, verificationstatus, gps,photo from tblfamily
left join tblvillages on tblvillages.villagecode = tblfamily.villagecode
left join tblfamilyhindi on tblfamilyhindi.familyhindiid = tblfamily.familyhindiid where verificationstatus='Yes' Limit 0,