Array
(
[0] => 1029
[PRODUCT_CATEGORY_ID] => 1029
[1] => Top Sellers
[CATEGORY_NAME] => Top Sellers
[2] =>
[CATEGORY_HEADER] =>
[3] => model ship sale, model ships for sale, model ship deals, model ship coupon, model ship savings
[PRODUCT_META_TAG] => model ship sale, model ships for sale, model ship deals, model ship coupon, model ship savings
[4] => Very limited availibility and when they are gone they are gone. Contact us about bulk discounts.
[PRODUCT_META_DESCRIPTION] => Very limited availibility and when they are gone they are gone. Contact us about bulk discounts.
[5] => Model Ship Deals - Coupons - Savings - Discount and Closeout Model Boats
[PRODUCT_PAGE_TITLE] => Model Ship Deals - Coupons - Savings - Discount and Closeout Model Boats
[6] =>
[PRODUCT_SEO] =>
[7] => nautical-decor-beach-decoration-top-sellers.php
[FILENAME] => nautical-decor-beach-decoration-top-sellers.php
[8] =>
[CATEGORY_FOOTER] =>
[9] =>
[AMAZON] =>
[10] => 1029.jpg
[IMAGE] => 1029.jpg
[11] =>
[H1] => Top Seller
[12] =>
[H2] =>
[13] =>
[POINTS] =>
[14] =>
[CATEGORY_SPLASH] =>
[15] => 1029
[CATEGORY_PICTURE] => 1029
[16] => product
[CATEGORY_TYPE] => product
[17] => 0
[FEATURED] => 0
[18] =>
[EBAY] =>
[19] =>
[BREADCRUMB] =>
[20] => 0
[SHOW_ALL] => 0
[21] =>
[HOME_IMAGE] =>
[22] => HND
[CATEGORY_SITE] => HND
[SUPER_NAME] =>
)
::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE PRODUCT_BRIDGE.CATEGORY_ID='1029' 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