public function getPosts()
{
global $wpdb, $post;
$taxonomies = new wpTaxonomies('');
$taxonomy_ids = $taxonomies->getTaxonomiesIds($post->ID, $this->taxonomies);
$subquery = 'SELECT COUNT(st.term_id) FROM wp_posts AS sp LEFT JOIN wp_term_relationships AS str ON (sp.ID = str.object_id)
LEFT JOIN wp_term_taxonomy AS stt ON (str.term_taxonomy_id = stt.term_taxonomy_id)
LEFT JOIN wp_terms AS st ON (st.term_id = stt.term_id)
WHERE st.term_id IN (' . $taxonomy_ids . ') AND sp.ID = p.ID';
$query = 'SELECT DISTINCT p.ID, p.post_title, p.post_date, image.meta_value AS image, t.term_id, t.name, t.slug';
$query .= ', (' . $subquery . ') as equals';
$query .= ' FROM wp_posts AS p';
$query .= ' LEFT JOIN wp_postmeta AS image ON (image.meta_key = "_thumbnail_id" and image.post_id = p.ID)';
$query .= ' LEFT JOIN wp_term_relationships AS tr ON (p.ID = tr.object_id)
LEFT JOIN wp_term_taxonomy AS tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id)
LEFT JOIN wp_terms AS t ON (t.term_id = tt.term_id)';
$query .= ' WHERE p.post_type="' . $post->post_type . '" AND p.post_status = "publish"';
$query .= ' AND t.term_id IN (' . $taxonomy_ids . ')';
$query .= ' AND p.ID != ' . $post->ID . '';
$query .= ' GROUP BY p.ID';
$query .= ' ORDER BY equals DESC, p.post_date DESC ';
$query .= ' LIMIT 0,' . $this->limit;
$postsQuery = $wpdb->get_results($query);
$posts = $postsQuery;
//print $query;
wp_reset_query();
$wpdb->flush();
unset($postsQuery);
return $posts;
}
