get_crp_posts_id ignores language

This will need to have a rewrite of the function. Alternatively, you can modify the results once they are retrieved similar to how it is implemented in get_crp

https://github.com/WebberZone/contextual-related-posts/blob/master/contextual-related-posts.php#L190-L196

I’ll need to experiment with the latter

For the moment I’ve changed the query to select only posts from the current language:
$sql = “SELECT DISTINCT $fields FROM $wpdb->posts inner join wp_icl_translations on wp_icl_translations.element_id = wp_posts.ID WHERE 1=1 AND wp_icl_translations.language_code='” . ICL_LANGUAGE_CODE . “‘ $where $groupby $having $orderby $limits”;

You could do this a bit cleaner in that case by using a function to

function same_language_crp( $where ) {

   $where .= " AND wp_icl_translations.language_code='" . ICL_LANGUAGE_CODE . "' ";
   return $where;

}
add__filter( 'crp_posts_where', 'same_language_crp' );

Yes I’ll do it and I’ll add a filter for the join as well ??

my 2cents on this:

function same_language_crp_join( $join ) {
  global $wpdb;

  $join .= " INNER JOIN " . $wpdb->prefix . "icl_translations";
  $join .= " ON " . $wpdb->prefix . "icl_translations.element_id = " . $wpdb->posts . ".ID";
  return $join;
}
add_filter( 'crp_posts_join', 'same_language_crp_join' );

function same_language_crp_where( $where ) {
  global $wpdb;

  $where .= " AND " . $wpdb->prefix . "icl_translations.language_code='" . ICL_LANGUAGE_CODE . "' ";
  return $where;
}
add_filter( 'crp_posts_where', 'same_language_crp_where' );

Thanks. This definitely looks complete.

@pixael does this work for you?

Sorry for not getting back to you @ajay!
Yes, this is almost exactly what I did to get the same query I posted with the correct filters.

That’s good to know.