QUERY = SELECT DISTINCT CubeCart_inventory.cat_id, CubeCart_cats_idx.productId, productCode, image, price, dia, name, available, sale_price, tampelaki, useStockLevel, stock_level 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