updated index get route logic to limit select to 9 results