Home»Oars & Paddles»New Oars & Paddles (184 Items)
3: SELECT PRODUCTS.PRODUCT_ID FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2300' AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' and PRODUCTS.DISCONTINUED='' GROUP BY PRODUCT_BRIDGE.PRODUCT_ID ORDER BY PRODUCT_BRIDGE.ORDER ASC