DataBase error - Out of resources when opening file './bbmp/tblbbmpworkcode.MYD' (Errcode: 24 - Too many open files)
select tbladdproject.workcodeid,tbladdproject.projectid, tbladdproject.workcode,tbladdproject.projectname,wardid,localityid, tbladdproject.expenditureincurred, tbladdproject.approvedcost,actualdateofcompletion,completiondtpercontract from tblbbmpworkcode
left join tbladdproject on tbladdproject.workcodeid = tblbbmpworkcode.workcodeid
where wardid='133'DataBase error - Out of resources when opening file './bbmp/tblbbmpworkcode.MYD' (Errcode: 24 - Too many open files)
select count(*) from tblbbmpworkcode where wardid='133'DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count1 from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133' and workstatus='work in progress'
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count2 from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133' and workstatus='completed'
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count3 from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133' and workstatus='yet to start'
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count4 from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133' and workstatus='file in process'
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count5 from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133' and tbladdproject.workcode=' '
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) as count6 from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133' and tbladdproject.workstatus=' '
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select sum(estimatedcost) as sum1 from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133'
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select sum(approvedcost) as sum2 from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133'
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select sum(expenditureincurred) as sum3 from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133'
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133' and(expenditureincurred !=0) and (approvedcost != 0) and (expenditureincurred > approvedcost)
DataBase error - Out of resources when opening file './bbmp/tbladdproject.MYD' (Errcode: 24 - Too many open files)
select count(*) from tbladdproject
left join tblbbmpworkcode on tblbbmpworkcode.workcodeid = tbladdproject.workcodeid
where wardid='133' and (expenditureincurred < approvedcost) and (expenditureincurred !=0) and(approvedcost != 0)
DataBase error - Out of resources when opening file './bbmp/tblward.TRG' (Errcode: 24 - Too many open files)
select wardno from tblward where wardid='133'DataBase error - Out of resources when opening file './bbmp/tblward.TRG' (Errcode: 24 - Too many open files)
select wardname from tblward where wardid='133'