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