Handcrafted Model Ships
Coupon SAVE10 at for extra 10% off -  All models fully assembled

(45 Items) Sort:
::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE (PRODUCT_BRIDGE.CATEGORY_ID='2355' OR PRODUCT_BRIDGE.CATEGORY_ID='479' OR PRODUCT_BRIDGE.CATEGORY_ID='4' OR PRODUCT_BRIDGE.CATEGORY_ID='510' OR PRODUCT_BRIDGE.CATEGORY_ID='514' OR PRODUCT_BRIDGE.CATEGORY_ID='122' OR PRODUCT_BRIDGE.CATEGORY_ID='288') AND PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID AND PRODUCTS.PRODUCT_ACTIVE='1' AND PRODUCTS.DISCONTINUED='' and PRODUCTS.ISDELETED='0' GROUP BY PRODUCTS.PRODUCT_ID ORDER BY `price` ASC,PRODUCTS.PRODUCT_NAME, PRODUCT_ACTIVE DESC