I have the same problem is outlined here: How to display multiple Post meta_key/meta_values by SQL query

The final comment does provide the correct result, but only ever displays one row because it is using MAX. I definitely have more than 1 post. Does anyone have any advice as to how to return the rows requested from all posts?