Originally Posted by sarettah

Put this together real quick so don't know if it is 100% correct or not:

select c.term_id, c.name as term_name, c.slug as term_slug from wp_posts a
inner join wp_term_relationships b on a.id=b.object_id
inner join wp_term_taxonomy c on b.term_taxonomy_id=c.term_taxonomy_id
inner join wp_terms d on c.term_id=d.term_id
inner join wp_post_meta e on a.id=e.post_id
where e.meta_key='wpb_post_views_count'
order by cast(e.meta_value as signed) desc