QUERY = SELECT CubeCart_cats_idx.cat_id, CubeCart_cats_idx.productId, productCode, quantity, description, short_description, image, price, name, popularity, sale_price, stock_level, useStockLevel FROM CubeCart_cats_idx INNER JOIN CubeCart_inventory ON CubeCart_cats_idx.productId = CubeCart_inventory.productId WHERE showProd = 1 AND CubeCart_cats_idx.cat_id = '1021.html/miniature-bayonet/cat_1021' ORDER BY CubeCart_inventory.name DESC