Warning

Error while accessing the database You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') nm_sel_esp' at line 1 select count(*), sum(WHT), sum(BILLAMT) from (SELECT ID, DIVISION, LoadingId, LifterId, LifterName, (SELECT DONO FROM loadorder WHERE ID=t.LoadingId GROUP BY ID ) AS DOId, ((SELECT Mines FROM mines WHERE ID =(SELECT Mines FROM domaster WHERE id = t.DOId) )) AS Colliery, (SELECT BillNO FROM billmast WHERE id=t.BillID) AS BillNo, (SELECT BDOCDT FROM billmast WHERE id=t.BillID) AS BillDate, LOCATION, LRDT, LRNO, DOCNO, VHNM, VHNO, VTRANS, LOADDOC, BILLTO, CONSIGNOR, CONSIGNEE, CONNAME, DESTINATION, ITEMNAME, UNIT, PACK, WHT, BILLID, BILLDOCNO, BILLDT, BILLWHT, BILLRATE, BILLX, BILLTP, BILLAMT FROM lrdata t WHERE BILLID= ) nm_sel_esp