I wish I were kidding when I say that the easiest way to interrogate the contents of a large Wordpress site’s post_meta data is to export the whole site, individually unserialize each meta record, put them into a document database, and use it to query them.