I want to run one sql query like this in wordpress. Just wanted to know if there is an easy way to do this in wp. Thanks.

Is this query possible with the use of query_posts anyhow?

select p1.meta_value as avg,p2.meta_value as total,p1.meta_value*p2.meta_value as product from wp_postmeta as p1, wp_postmeta as p2 where p1.meta_key = 'crfp-average-rating' and p2.meta_key = 'crfp-total-ratings' and p1.post_id = p2.post_id;

Read more here: Easy way to write complex queries in wordpress


If you know the solution of this issue, please leave us a reply in Comment section, to update the question.

Related Wordpress search:

, , , ,

Wordpress related questions and answers: