posts as p"; $bfa_pic_request .= " INNER JOIN $wpdb->term_relationships AS tr ON"; $bfa_pic_request .= " (p.ID = tr.object_id AND"; $bfa_pic_request .= " tr.term_taxonomy_id = $cat_id )"; $bfa_pic_request .= " INNER JOIN $wpdb->term_taxonomy AS tt ON"; $bfa_pic_request .= " (tr.term_taxonomy_id = tt.term_taxonomy_id AND"; $bfa_pic_request .= " taxonomy = 'category')"; $bfa_pic_request .= " WHERE post_status = 'publish' AND comment_count >= $bfa_pic_min_amount_comments"; $bfa_pic_request .= " AND post_password =''"; if ($bfa_pic_duration !="") $bfa_pic_request .= " AND DATE_SUB(CURDATE(),INTERVAL ".$bfa_pic_duration." DAY) < post_date "; $bfa_pic_request .= " ORDER BY comment_count DESC LIMIT $bfa_pic_no_posts"; $bfa_pic_posts = $wpdb->get_results($bfa_pic_request); if ($bfa_pic_posts) { foreach ($bfa_pic_posts as $bfa_pic_post) { $bfa_pic_post_title = stripslashes($bfa_pic_post->post_title); $bfa_pic_comment_count = $bfa_pic_post->comment_count; $bfa_pic_permalink = get_permalink($bfa_pic_post->ID); $widget_mdv_most_commented_per_cat .= '
/>Prepend
/> Append Category Name to Title
Show posts not older than days and with at least comments