/*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='G2';*/var G2S05N09GMA = new Array (2.00, 586, "1/2 inch", "NPT (female)", "1 - 10", "3.8 - 37.9", "2", "/G2/models/G2_N.jpg");var G2S05T09GMA = new Array (2.50, 690, "3/4 inch", "Tri-Clamp", "1 - 10", "3.8 - 37.9", "2", "/G2/models/G2_T.jpg");var G2B05N09GMA = new Array (2.00, 571, "1/2 inch", "NPT (female)", "1 - 10", "3.8 - 37.9", "2", "/G2/models/G2_N.jpg");var G2A05N09GMA = new Array (2.00, 498, "1/2 inch", "NPT (female)", "1 - 10", "3.8 - 37.9", "2", "/G2/models/G2_N.jpg");var G2P05N09GMA = new Array (2.00, 658, "1/2 inch", "NPT (female)", "1.2 - 12", "4.5 - 45.4", "2", "/G2/models/G2_PVDF.jpg");var G2S07N09GMA = new Array (2.30, 596, "3/4 inch", "NPT (female)", "2 - 20", "7.6 - 75.7", "1.5", "/G2/models/G2_N.jpg");var G2S07T09GMA = new Array (2.90, 700, "1 inch", "Tri-Clamp", "2 - 20", "7.6 - 75.7", "1.5", "/G2/models/G2_T.jpg");var G2B07N09GMA = new Array (2.30, 580, "3/4 inch", "NPT (female)", "2 - 20", "7.6 - 75.7", "1.5", "/G2/models/G2_N.jpg");var G2A07N09GMA = new Array (2.30, 508, "3/4 inch", "NPT (female)", "2 - 20", "7.6 - 75.7", "1.5", "/G2/models/G2_N.jpg");var G2S10N09GMA = new Array (2.60, 607, "1 inch", "NPT (female)", "5 - 50", "18.9 - 190", "1.5", "/G2/models/G2_N.jpg");var G2S10T09GMA = new Array (3.20, 711, "1-1/2 inch", "Tri-Clamp", "5 - 50", "18.9 - 190", "1.5", "/G2/models/G2_T.jpg");var G2B10N09GMA = new Array (2.60, 601, "1 inch", "NPT (female)", "5 - 50", "18.9 - 190", "1.5", "/G2/models/G2_N.jpg");var G2A10N09GMA = new Array (2.60, 514, "1 inch", "NPT (female)", "5 - 50", "18.9 - 190", "1.5", "/G2/models/G2_N.jpg");var G2S10F09GMD = new Array (2.60, 859, "1 inch", "150# Flange", "5 - 50", "18.9 - 190", "1.5", "/G2/models/G2_F.jpg");var G2P10N09GMA = new Array (2.60, 660, "1 inch", "NPT (female)", "5 - 50", "18.9 - 190", "1.5", "/G2/models/G2_PVDF.jpg");var G2S15N09GMB = new Array (4.20, 848, "1-1/2 inch", "NPT (female)", "10 - 100", "39 - 380", "1", "/G2/models/G2_N.jpg");var G2S15T09GMB = new Array (4.80, 951, "2 inch", "Tri-Clamp", "10 - 100", "39 - 380", "1", "/G2/models/G2_T.jpg");var G2B15N09GMB = new Array (4.20, 813, "1-1/2 inch", "NPT (female)", "10 - 100", "39 - 380", "1", "/G2/models/G2_N.jpg");var G2A15N09GMB = new Array (4.20, 714, "1-1/2 inch", "NPT (female)", "10 - 100", "39 - 380", "1", "/G2/models/G2_N.jpg");var G2S15F09GME = new Array (4.20, 1100, "1-1/2 inch", "150# Flange", "10 - 100", "39 - 380", "1", "/G2/models/G2_F.jpg");var G2S20N09GMB = new Array (6.60, 1105, "2 inch", "NPT (female)", "20 - 200", "76 - 760", "1", "/G2/models/G2_N.jpg");var G2S20T09GMB = new Array (7.20, 1208, "2-1/2 inch", "Tri-Clamp", "20 - 200", "76 - 760", "1", "/G2/models/G2_T.jpg");var G2B20N09GMB = new Array (6.60, 993, "2 inch", "NPT (female)", "20 - 200", "76 - 760", "1", "/G2/models/G2_N.jpg");var G2A20N09GMB = new Array (6.60, 895, "2 inch", "NPT (female)", "20 - 200", "76 - 760", "1", "/G2/models/G2_N.jpg");var G2S20F09GME = new Array (6.60, 1357, "2 inch", "150# Flange", "20 - 200", "76 - 760", "1", "/G2/models/G2_F.jpg");