streamlined backend queries for lms index page