Array
(
[0] => 2580
[PRODUCT_CATEGORY_ID] => 2580
[1] => Black Pearl
[CATEGORY_NAME] => Black Pearl
[2] =>
[CATEGORY_HEADER] =>
[3] => top sellers,nautical decor top sellers,model ship top sellers,beach & sealife decor top sellers,cast iron decor top sellers,clearance sale,model ship clearance sale,nautical decor clearance sale,beach & sealife decor clearance sale,wholesale famous ships,new famous ships,from movies and television,historically significant ships,rms titanic,uss constitution,cutty sark,united states warships,pirate ships,blackbeards queen annes revenge,captain kidds pirate ships,pirates of the caribbean,privateers,calico jacks the william ,black barts royal fortune,flying dutchman,black pearl,Wholesale Black Pearl, model ship,replica model boat, ship model,ship,model,models,ships,boat,boats,
[PRODUCT_META_TAG] => top sellers,nautical decor top sellers,model ship top sellers,beach & sealife decor top sellers,cast iron decor top sellers,clearance sale,model ship clearance sale,nautical decor clearance sale,beach & sealife decor clearance sale,wholesale famous ships,new famous ships,from movies and television,historically significant ships,rms titanic,uss constitution,cutty sark,united states warships,pirate ships,blackbeards queen annes revenge,captain kidds pirate ships,pirates of the caribbean,privateers,calico jacks the william ,black barts royal fortune,flying dutchman,black pearl,Wholesale Black Pearl, model ship,replica model boat, ship model,ship,model,models,ships,boat,boats,
[4] => Wholesale Black Pearl model ships are fully assembled and in stock. Black Pearl model ships at discounted prices. No assembly required. Lots of models to choose from.
[PRODUCT_META_DESCRIPTION] => Wholesale Black Pearl model ships are fully assembled and in stock. Black Pearl model ships at discounted prices. No assembly required. Lots of models to choose from.
[5] => Wholesale Black Pearl Models Assembled - Wholesale Replica - Wholesale Model Ship Model Boat
[PRODUCT_PAGE_TITLE] => Wholesale Black Pearl Models Assembled - Wholesale Replica - Wholesale Model Ship Model Boat
[6] =>
[PRODUCT_SEO] =>
[7] => black-pearl-pirates-of-the-caribbean-model-ships.php
[FILENAME] => black-pearl-pirates-of-the-caribbean-model-ships.php
[8] =>
[CATEGORY_FOOTER] =>
[9] =>
[AMAZON] =>
[10] =>
[IMAGE] =>
[11] =>
[H1] => Black Pearl
[12] =>
[H2] =>
[13] =>
[POINTS] =>
[14] =>
[CATEGORY_SPLASH] =>
[15] => 12124
[CATEGORY_PICTURE] => 12124
[16] => product
[CATEGORY_TYPE] => product
[17] => 3
[FEATURED] => 3
[18] =>
[EBAY] =>
[19] =>
[BREADCRUMB] =>
[20] => 0
[SHOW_ALL] => 0
[21] =>
[HOME_IMAGE] =>
[22] => HMS
[CATEGORY_SITE] => HMS
[SUPER_NAME] =>
)
(19 Items) Sort:
Items: 1 to 19
::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2580' 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 LIMIT 0,48