DataBase error - Table 'iay.tblsubdivision' doesn't exist
select tblsubdivision.subdivision from tblsubdivision
where tblsubdivision.subdivisionid= '' and tblsubdivision.wardunique=''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.tblbbmpworkcode' doesn't exist
Select count(*) from tblbbmpworkcode
left join tblzone on tblzone.zoneid = tblbbmpworkcode.zoneid
left join tblward on tblward.wardid = tblbbmpworkcode.wardid
left join tbloptionvalue on tbloptionvalue.optionvalueid = tblbbmpworkcode.contractorid
where (tblbbmpworkcode.isactive = '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 tblzone.zone, tblward.wardname, tbloptionvalue.optcusfield01 as contractor, tblbbmpworkcode.statusofworkid, tblbbmpworkcode.workcodeid, tblbbmpworkcode.workcode, tblbbmpworkcode.wardid, tblbbmpworkcode.remarks, tblbbmpworkcode.createdon, tblbbmpworkcode.commissionerapprovalstatus, tblbbmpworkcode.approvedon from tblbbmpworkcode
left join tblzone on tblzone.zoneid = tblbbmpworkcode.zoneid
left join tblward on tblward.wardid = tblbbmpworkcode.wardid
left join tbloptionvalue on tbloptionvalue.optionvalueid = tblbbmpworkcode.contractorid
where (tblbbmpworkcode.isactive = 'Yes') order by tblbbmpworkcode.workcodeid asc Limit 0,