added query in repository, maked it as service and used on index rote