Custom Fields of Custom Post Type

Two reports ship with the plugin, one for Posts, one for Pages. Reporting custom fields in general can be difficult since there are variable amounts of custom fields and the database returns a big list of them instead of column-based like this plugin expects for it’s MySQL queries.

So you’d want to do a SELECT on your posts table, then do a JOIN for the postmeta table on the meta_key for each custom field, then alias each of those JOINed table meta_value columns in your SELECT for usage in the report.