myqsladdress|s:9:"10.0.0.17";fromFacebook|b:0;login_count_captcha|i:2;UserID|s:5:"david";UserName|s:5:"david";GroupID|s:0:"";AccessLevel|s:4:"User";OwnerID|N;MyUrlAccess|b:1;facilityinfo_search|i:0;facilityinfo_key|a:1:{i:0;i:1;}facilityinfo_orderFieldsList|s:109:"a:1:{i:0;O:10:"OrderField":3:{s:10:"fieldIndex";i:1;s:14:"orderDirection";s:3:"ASC";s:11:"userDefined";b:0;}}";facilityinfo_sql|s:423:"SELECT
`FacilityCode`, `SiteName`, `IPName`, `Funding_Source`, `Status`, `LGA`, `State`, `Physical_Address`, `Contact`, `Phone_Number`, `Reference_No`, `Received_Date`, `Departure_Date`, `UserName`, `EntryDate`,(SELECT count(*) FROM (SELECT FacilityCode 
 FROM `productdata` ) `subQuery_cnt` WHERE `subQuery_cnt`.`FacilityCode`=`facilityinfo`.`FacilityCode`) as `productdata_cnt`  
 FROM `facilityinfo`    ORDER BY 1 ASC";facilityinfo_where|s:0:"";facilityinfo_having|s:0:"";facilityinfo_criteria|s:3:"and";facilityinfo_order|s:15:" ORDER BY 1 ASC";facilityinfo_joinFromPart|s:0:"";productdata_mastertable|s:12:"facilityinfo";productdata_masterkey1|s:6:"B01/02";productdata_search|i:0;productdata_key|a:1:{i:0;i:1;}productdata_orderFieldsList|s:109:"a:1:{i:0;O:10:"OrderField":3:{s:10:"fieldIndex";i:1;s:14:"orderDirection";s:3:"ASC";s:11:"userDefined";b:0;}}";productdata_sql|s:208:"SELECT
`TransactionID`, `FacilityCode`, `ProductID`, `Quantity`, `Weight`, `Volume`, `BatchNo`, `ExpiryDate`, `UnitPrice`, `EntryDate` 
 FROM `productdata`  where ((FacilityCode='B01/02'))    ORDER BY 1 ASC";productdata_where|s:23:"(FacilityCode='B01/02')";productdata_having|s:0:"";productdata_criteria|s:3:"and";productdata_order|s:15:" ORDER BY 1 ASC";productdata_joinFromPart|s:0:"";MyURL|s:20:"/productdata_add.php";