Updated query of devices for top 100 based on visits