QUERY = SELECT DISTINCT man, CubeCart_cats_idx.productId, productCode, quantity, description, showBack, image, price, dia, name, popularity, sale_price, stock_level, useStockLevel, second_hand, orderCopy 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.list_no DESC, productId DESC