I'm trying to create a mysql view inside WP database that selects and then show some custom post fields.

E.g.: with custom post types Movies and Reviews create an SQL view with movies name, ID and it's Reviews average rating (based on related field which confronts the Movie ID, sum the ratings and divide by the ratings count).

I can do it with two custom tables, but was curious if it's possible to do the same with normal WP post and meta tables.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.