My Cart 0 Item(s), $0.00

Product Search

Search
Advanced Search

Narrow Beam Reflector-26 Inch Arm

Model #: 12818
Narrow Beam Reflector-26 Inch Arm
List Price: $115.00
Price: $57.50
You Save: $57.50 (50%)
Save to my Wish List Tell a friend
Narrow Beam Reflector-26 Inch Arm
Narrow Beam Reflector-26 Inch Arm
Previous Item   Next Item
SELECT ProductsOrdered.idProduct, products.pcProd_parentPrd, COUNT(idOrder) AS NumOrders FROM ProductsOrdered INNER JOIN products ON ProductsOrdered.idProduct=products.idProduct WHERE (idOrder IN (SELECT idOrder FROM ProductsOrdered WHERE (idProduct = 6863))) AND (ProductsOrdered.idProduct <> 6863) GROUP BY ProductsOrdered.idProduct, products.pcProd_parentPrd ORDER BY NumOrders DESC;

Product Reviews

Write your own review

 

Rate this product: 1 2 3 4 5 


 

Flexbar Machine Corporation
250 Gibbs Road Islandia, NY 11749
Toll Free: 800.879.7575
Tel: 631.582.8440 Fax: 631.582.8487
e-mail: sales@flexbar.com

 
Live chat by BoldChat