/*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='LMD';*/var LM50D = new Array (1.00, 279, "1/2 inch", "NPT (female)", "0.26 to 8", "1 to 30.2", "0.5", "/LM/models/LM50D.jpg");var LM50P = new Array (1.00, 220, "1/2 inch", "NPT (female)", "0.26 to 8", "1 to 30.2", "0.5", "/LM/models/LM50P.jpg");