Updated item stock details to fetch with a subselect rather than individual selects.