::SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE (PRODUCT_BRIDGE.CATEGORY_ID='2535' OR PRODUCT_BRIDGE.CATEGORY_ID='2600' OR PRODUCT_BRIDGE.CATEGORY_ID='2634' OR PRODUCT_BRIDGE.CATEGORY_ID='2635' OR PRODUCT_BRIDGE.CATEGORY_ID='2636' OR PRODUCT_BRIDGE.CATEGORY_ID='2651' OR PRODUCT_BRIDGE.CATEGORY_ID='2653' OR PRODUCT_BRIDGE.CATEGORY_ID='2601' OR PRODUCT_BRIDGE.CATEGORY_ID='2637' OR PRODUCT_BRIDGE.CATEGORY_ID='2639' OR PRODUCT_BRIDGE.CATEGORY_ID='2642' OR PRODUCT_BRIDGE.CATEGORY_ID='2649' OR PRODUCT_BRIDGE.CATEGORY_ID='2650' OR PRODUCT_BRIDGE.CATEGORY_ID='2651' OR PRODUCT_BRIDGE.CATEGORY_ID='2652' OR PRODUCT_BRIDGE.CATEGORY_ID='2653' OR PRODUCT_BRIDGE.CATEGORY_ID='2602' OR PRODUCT_BRIDGE.CATEGORY_ID='2637' OR PRODUCT_BRIDGE.CATEGORY_ID='2638' OR PRODUCT_BRIDGE.CATEGORY_ID='2639' OR PRODUCT_BRIDGE.CATEGORY_ID='2640' OR PRODUCT_BRIDGE.CATEGORY_ID='2641' OR PRODUCT_BRIDGE.CATEGORY_ID='2642' OR PRODUCT_BRIDGE.CATEGORY_ID='2644' OR PRODUCT_BRIDGE.CATEGORY_ID='2645' OR PRODUCT_BRIDGE.CATEGORY_ID='2646' OR PRODUCT_BRIDGE.CATEGORY_ID='2648' OR PRODUCT_BRIDGE.CATEGORY_ID='2653') 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