/*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='A1';*/var A109GMA025NA1 = new Array (1.35, 419, "1 inch", "NPT (female)", "0.3 to 3", "1 to 11", "1.5", "/A1/models/A1_A.jpg", "Aluminum");var A109GMA100NA1 = new Array (1.35, 408, "1 inch", "NPT (female)", "3 to 50", "11 to 190", "1.5", "/A1/models/A1_A.jpg", "Aluminum");var A109GMA200NA2 = new Array (3.00, 902, "2 inch", "NPT (female)", "30 to 300", "114 to 1136", "1.5", "/A1/models/A1_A.jpg", "Aluminum");var A109GMN025NA1 = new Array (1.00, 441, "1 inch", "NPT (female)", "0.3 to 3", "1 to 11", "1.5", "/A1/models/A1_N.jpg", "Nylon");var A109GMN100NA1 = new Array (1.00, 432, "1 inch", "NPT (female)", "3 to 50", "11 to 190", "1.5", "/A1/models/A1_N.jpg", "Nylon");