updated index/show query