memory-optimized query
more info on post dropdown