Array
(
[0] => 2554
[PRODUCT_CATEGORY_ID] => 2554
[1] => Cast Iron Decor Top Sellers
[CATEGORY_NAME] => Cast Iron Decor Top Sellers
[2] =>
[CATEGORY_HEADER] =>
[3] => top sellers,nautical decor top sellers,model ship top sellers,beach & sealife decor top sellers,cast iron decor top sellers,,beach decor,beach,coastal,living,decor,decorating,house,bedroom decor,gift,decor,ideas
[PRODUCT_META_TAG] => top sellers,nautical decor top sellers,model ship top sellers,beach & sealife decor top sellers,cast iron decor top sellers,,beach decor,beach,coastal,living,decor,decorating,house,bedroom decor,gift,decor,ideas
[4] => Cast Iron Decor Top Sellers Beach Decorating Gifts are in stock and ready to ship. Cast Iron Decor Top Sellers Nautical Decor and Gifts. Buy Cast Iron Decor Top Sellers nautical decor now.
[PRODUCT_META_DESCRIPTION] => Cast Iron Decor Top Sellers Beach Decorating Gifts are in stock and ready to ship. Cast Iron Decor Top Sellers Nautical Decor and Gifts. Buy Cast Iron Decor Top Sellers nautical decor now.
[5] => Cast Iron Decor Top Sellers - Beach Decor Living Ideas
[PRODUCT_PAGE_TITLE] => Cast Iron Decor Top Sellers - Beach Decor Living Ideas
[6] =>
[PRODUCT_SEO] =>
[7] => cast-iron-decor-top-sellers-clearance-sale.php
[FILENAME] => cast-iron-decor-top-sellers-clearance-sale.php
[8] =>
[CATEGORY_FOOTER] =>
[9] =>
[AMAZON] =>
[10] =>
[IMAGE] =>
[11] =>
[H1] => Cast Iron Decor Top Seller
[12] =>
[H2] =>
[13] =>
[POINTS] =>
[14] =>
[CATEGORY_SPLASH] =>
[15] => 8633
[CATEGORY_PICTURE] => 8633
[16] => product
[CATEGORY_TYPE] => product
[17] => 3
[FEATURED] => 3
[18] =>
[EBAY] =>
[19] =>
[BREADCRUMB] =>
[20] => 0
[SHOW_ALL] => 0
[21] =>
[HOME_IMAGE] =>
[22] => HCI
[CATEGORY_SITE] => HCI
[SUPER_NAME] =>
)
(25 Items) Sort:
Items: 1 to 24
::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='2554' 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