/*SELECT selectedproducts.discount FROM (assuredautomation_com_1.distributors INNER JOIN assuredautomation_com_1.selectedproducts ON assuredautomation_com_1.distributors.distributorid = assuredautomation_com_1.selectedproducts.distributorid) INNER JOIN assuredautomation_com_1.products ON assuredautomation_com_1.selectedproducts.productid = assuredautomation_com_1.products.productID  WHERE assuredautomation_com_1.distributors.Subdomain Like 'sysspec' and assuredautomation_com_1.products.shortname='WaterMeter';*/var ECON_01N31GM = new Array (1.10, 157, "1 inch", "NPT (female)", "3 to 30", "Nylon", "2.5", "/water/models/water.jpg", "GPM");var ECON_01N31LM = new Array (1.10, 157, "1 inch", "NPT (female)", "10 to 100", "Nylon", "2.5", "/water/models/water.jpg", "LPM");var ECON_01A31GM = new Array (2.00, 157, "1 inch", "NPT (female)", "3 to 30", "Aluminum", "2.5", "/water/models/fuel.jpg", "GPM");var ECON_01A31LM = new Array (2.00, 157, "1 inch", "NPT (female)", "10 to 100", "Aluminum", "2.5", "/water/models/fuel.jpg", "LPM");