# Tag Info

SELECT COUNT(DISTINCT comment_post_ID) FROM ".$wpdb->prefix."comments USE INDEX (left_frame_index) WHERE comment_approved = 1 AND comment_type = 'comment' LIMIT$count_limit Needs a better index; see the below. Do NOT compare a VARCHAR (such as comment_approved) with a numeric literal (such as 1), the index cannot be used....