ID); if ($tags): $tag_ids = array(); foreach($tags as $individual_tag) $tag_ids[] = $individual_tag->term_id; $number_of_posts = 4; // number of posts to display $query = " SELECT ".$wpdb->posts.".*, COUNT(".$wpdb->posts.".ID) as q FROM ".$wpdb->posts." INNER JOIN ".$wpdb->term_relationships." ON (".$wpdb->posts.".ID = ".$wpdb->term_relationships.".object_id) WHERE ".$wpdb->posts.".ID NOT IN (".$post->ID.") AND ".$wpdb->term_relationships.".term_taxonomy_id IN (".implode(",",$tag_ids).") AND ".$wpdb->posts.".post_type = 'post' AND ".$wpdb->posts.".post_status = 'publish' GROUP BY ".$wpdb->posts.".ID ORDER BY q DESC LIMIT ".$number_of_posts.""; $related_posts = $wpdb->get_results($query, OBJECT); if($related_posts): ?>

Related posts