SELECT * FROM wp_cp_ad_pop_total a INNER JOIN wp_posts p ON p.ID = a.postnum WHERE postcount > 0 AND post_status = 'publish' ORDER BY postcount DESC LIMIT 10