QUERY = SELECT DISTINCT man, CubeCart_inventory.cat_id, CubeCart_cats_idx.productId, productCode, quantity, description, image, price, dia, name, popularity, sale_price, stock_level, useStockLevel FROM CubeCart_cats_idx INNER JOIN CubeCart_inventory ON CubeCart_cats_idx.productId = CubeCart_inventory.productId WHERE CubeCart_cats_idx.cat_id IN () AND active='1' AND isPhotos='0' AND isNews='0' ORDER BY CubeCart_inventory.productId ASC, productId DESC