3: SELECT PRODUCTS.PRODUCT_ID FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='82' 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

A pirate ship is a powerfully evocative image, but over the years those emotions have shifted from the negative emotions of terror and dread to the much more positive feelings of romance, adventure. and independence. This is no doubt because of the Hollywood depiction of pirates in movies ranging from Walt Disney's Pirates of the Caribbean to Renny Harlin's debacle Cutthroat Island.

A pirate ship is a powerfully evocative image, but over the years those emotions have shifted from the negative emotions of terror and dread to the much more positive feelings of romance, adventure. and independence. This is no doubt because of the Hollywood depiction of pirates in movies ranging from Walt Disney's Pirates of the Caribbean to Renny Harlin's debacle Cutthroat Island.

SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='82' 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

Similar to Legendary Pirate Ships

Legendary Pirate Ships

A pirate ship is a powerfully evocative image, but over the years those emotions have shifted from the negative emotions of terror and dread to the much more positive feelings of romance, adventure. and independence. This is no doubt because of the Hollywood depiction of pirates in movies ranging from Walt Disney's Pirates of the Caribbean to Renny Harlin's debacle Cutthroat Island.