I recently wrote a post that explains how to create library database subject guides by utilizing WordPress with a loop inside of a loop. It turns the static pages into static/dynamic mixed pages. I hope it helps someone.
Using WordPress as a CMS: How to Create a Dynamically-Generated Subject Guide