/*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 TM050 = new Array (0.80, 242, "1/2 inch", "Sched. 80 Spigot (pipe)", "1 - 10", "3.8 - 37.9", "3", "/TM/models/TM_S.jpg");var TM050_N = new Array (0.80, 260, "1/2 inch", "NPT (female)  ", "1 - 10", "3.8 - 37.9", "3", "/TM/models/TM_N.jpg");var TM075 = new Array (0.88, 266, "3/4 inch", "Sched. 80 Spigot (pipe)", "2 - 20", "7.6 - 75.7", "3", "/TM/models/TM_S.jpg");var TM075_N = new Array (0.88, 285, "3/4 inch", "NPT (female)  ", "2 - 20", "7.6 - 75.7", "3", "/TM/models/TM_N.jpg");var TM100 = new Array (1.00, 311, "1 inch", "Sched. 80 Spigot (pipe)", "5 - 50", "18.9 - 190", "3", "/TM/models/TM_S.jpg");var TM100_N = new Array (1.00, 330, "1 inch", "NPT (female)  ", "5 - 50", "18.9 - 190", "3", "/TM/models/TM_N.jpg");var TM150 = new Array (1.40, 349, "1-1/2 inch", "Sched. 80 Spigot (pipe)", "10 - 100", "39 - 380", "3", "/TM/models/TM_S.jpg");var TM150_N = new Array (1.40, 377, "1-1/2 inch", "NPT (female)  ", "10 - 100", "39 - 380", "3", "/TM/models/TM_N.jpg");var TM200 = new Array (1.68, 377, "2 inch", "Sched. 80 Spigot (pipe)", "20 - 200", "76 - 760", "3", "/TM/models/TM_S.jpg");var TM200_N = new Array (1.68, 405, "2 inch", "NPT (female)  ", "20 - 200", "76 - 760", "3", "/TM/models/TM_N.jpg");