2: select PRODUCTS.PRODUCT_ID from PRODUCTS join PRODUCT_BRIDGE on PRODUCT_BRIDGE.PRODUCT_ID=PRODUCTS.PRODUCT_ID join CATEGORY_BRIDGE on CATEGORY_BRIDGE.CATEGORY_ID=PRODUCT_BRIDGE.CATEGORY_ID join PRODUCT_CATEGORIES on PRODUCT_CATEGORIES.PRODUCT_CATEGORY_ID=CATEGORY_BRIDGE.CATEGORY_ID where PRODUCTS.PRODUCT_ACTIVE='1' and PRODUCTS.DISCONTINUED='' and CATEGORY_BRIDGE.SUPER_ID='2444' order by PRODUCT_BRIDGE.ORDER ASC

SELECT *, IF(PRODUCTS.SPECIAL='1',PRODUCTS.PRODUCT_SALE_PRICE,PRODUCTS.PRODUCT_REG_PRICE) as price FROM `PRODUCT_BRIDGE`,`PRODUCTS` WHERE (PRODUCT_BRIDGE.CATEGORY_ID='2444' OR PRODUCT_BRIDGE.CATEGORY_ID='2155' OR PRODUCT_BRIDGE.CATEGORY_ID='2351' OR PRODUCT_BRIDGE.CATEGORY_ID='466' OR PRODUCT_BRIDGE.CATEGORY_ID='2445' OR PRODUCT_BRIDGE.CATEGORY_ID='2395' OR PRODUCT_BRIDGE.CATEGORY_ID='2442' OR PRODUCT_BRIDGE.CATEGORY_ID='2443' OR PRODUCT_BRIDGE.CATEGORY_ID='2512' OR PRODUCT_BRIDGE.CATEGORY_ID='2513' OR PRODUCT_BRIDGE.CATEGORY_ID='2514' OR PRODUCT_BRIDGE.CATEGORY_ID='2563') 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