Array
(
[0] => 2286
[PRODUCT_CATEGORY_ID] => 2286
[1] => New Famous Ships
[CATEGORY_NAME] => New Famous Ships
[2] =>
[CATEGORY_HEADER] =>
[3] => famous ships,from movies and television,historically significant ships,pirate ships,blackbeards queen annes revenge,captain kidds pirate ships,pirates of the caribbean,privateers,calico jacks the william ,black barts royal fortune,henry averys the fancy,john halseys charles,edward englands the pearl,ed lows rose pink ,new pirate ships,john gows revenge,thomas tews amity,united states warships,new famous ships,New Famous Ships,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats,
[PRODUCT_META_TAG] => famous ships,from movies and television,historically significant ships,pirate ships,blackbeards queen annes revenge,captain kidds pirate ships,pirates of the caribbean,privateers,calico jacks the william ,black barts royal fortune,henry averys the fancy,john halseys charles,edward englands the pearl,ed lows rose pink ,new pirate ships,john gows revenge,thomas tews amity,united states warships,new famous ships,New Famous Ships,model ship,replica model boat, ship model,ship,model,models,ships,boat,boats,
[4] => New Famous Ships model ships are fully assembled and in stock. New Famous Ships model ships at discounted prices. No assembly required. Lots of models to choose from.
[PRODUCT_META_DESCRIPTION] => New Famous Ships model ships are fully assembled and in stock. New Famous Ships model ships at discounted prices. No assembly required. Lots of models to choose from.
[5] => Buy New Famous Ships Models Assembled - Famous Ships Replica - Model Ship Model Boat
[PRODUCT_PAGE_TITLE] => Buy New Famous Ships Models Assembled - Famous Ships Replica - Model Ship Model Boat
[6] =>
[PRODUCT_SEO] =>
[7] => new-famous-ships.php
[FILENAME] => new-famous-ships.php
[8] =>
[CATEGORY_FOOTER] =>
[9] =>
[AMAZON] =>
[10] =>
[IMAGE] =>
[11] =>
[H1] => New Famous Ship
[12] =>
[H2] =>
[13] =>
[POINTS] =>
[14] =>
[CATEGORY_SPLASH] =>
[15] => 2834
[CATEGORY_PICTURE] => 2834
[16] => product
[CATEGORY_TYPE] => product
[17] => 3
[FEATURED] => 3
[18] =>
[EBAY] =>
[19] =>
[BREADCRUMB] =>
[20] => 0
[SHOW_ALL] => 0
[21] =>
[HOME_IMAGE] =>
[22] =>
[CATEGORY_SITE] =>
[SUPER_NAME] =>
)
2::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2286' 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 PRODUCTS.PRODUCT_ID DESC, PRODUCT_ACTIVE DESC LIMIT 48,48