Title: Custom Select Query doubles posts
Last modified: August 21, 2016

---

# Custom Select Query doubles posts

 *  [SpidermanPuddin](https://wordpress.org/support/users/spidermanpuddin/)
 * (@spidermanpuddin)
 * [12 years, 6 months ago](https://wordpress.org/support/topic/custom-select-query-doubles-posts/)
 * Custom Select query will SOMETIMES double the post. Meaning it’ll display the
   same post twice, consecutively. It only does it on certain term ids. Here’s the
   query
 *     ```
       $querystr = "
       			SELECT COUNT(ID)
       			FROM $wpdb->posts
       			LEFT JOIN $wpdb->postmeta AS date_value
       				ON($wpdb->posts.ID = date_value.post_id
       				AND date_value.meta_key = 'date_value')
       	  		INNER JOIN  $wpdb->term_relationships
       	              ON (wp_posts.ID = $wpdb->term_relationships.object_id)
       	  		INNER JOIN  $wpdb->term_taxonomy
       	              ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
       	        INNER JOIN  $wpdb->terms
       	              ON ($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
       			WHERE $wpdb->posts.post_status = 'publish'
       				AND $wpdb->posts.post_type = 'custom_post'
       				AND date_value.meta_value >= '" . date('Ymd') . "'
       				AND $wpdb->terms.term_id IN ( $term->term_id )
       	";
       	$result = mysql_query($querystr) or die(mysql_error());
       	// Print out result
       	while($row = mysql_fetch_array($result)){
       		$gs_count = $row['COUNT(ID)'];
       	}
       	unset($querystr);
       ```
   
 * I’ve only been able to fix this by deleting the post(s) and republishing them.

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [SpidermanPuddin](https://wordpress.org/support/users/spidermanpuddin/)
 * (@spidermanpuddin)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/custom-select-query-doubles-posts/#post-4432354)
 * Still no luck on getting this to work right.
 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/custom-select-query-doubles-posts/#post-4432360)
 * `SELECT COUNT( DISTINCT ID )` ?
 *  Thread Starter [SpidermanPuddin](https://wordpress.org/support/users/spidermanpuddin/)
 * (@spidermanpuddin)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/custom-select-query-doubles-posts/#post-4432361)
 * Unfortunately, that breaks the MySQL.
 * Also that wouldn’t help the post query:
 *     ```
       $querystr = "
       			SELECT *
       			FROM $wpdb->posts
       			LEFT JOIN $wpdb->postmeta AS date_value
       				ON($wpdb->posts.ID = date_value.post_id
       				AND date_value.meta_key = 'date_value')
       	  		INNER JOIN  $wpdb->term_relationships
       	              ON (wp_posts.ID = $wpdb->term_relationships.object_id)
       	  		INNER JOIN  $wpdb->term_taxonomy
       	              ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)
       	        INNER JOIN  $wpdb->terms
       	              ON ($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id)
       			WHERE $wpdb->posts.post_status = 'publish'
       				AND $wpdb->posts.post_type = 'custom_post'
       				AND date_value.meta_value >= '" . date('Ymd') . "'
       				AND $wpdb->terms.term_id IN ( $term->term_id )
       			ORDER BY date_value.meta_value, $wpdb->posts.post_title
       	";
       ```
   
 *  Moderator [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * (@bcworkz)
 * [12 years, 5 months ago](https://wordpress.org/support/topic/custom-select-query-doubles-posts/#post-4432363)
 * Sorry, mySQL intricacies are foreign to me. Have you tried just using WP_Query?

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘Custom Select Query doubles posts’ is closed to new replies.

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 4 replies
 * 2 participants
 * Last reply from: [bcworkz](https://wordpress.org/support/users/bcworkz/)
 * Last activity: [12 years, 5 months ago](https://wordpress.org/support/topic/custom-select-query-doubles-posts/#post-4432363)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics