WordPress get_terms replace INNER JOIN with STRAIGHT_JOIN using filters

wp-get-terms-straight-join.php

<?php
// Step 1. Add the filters surrounding the get_terms (which should be used in your code)
add_filter( 'terms_clauses', 'rs_replace_inner_with_straight_joins', 20 );
$terms = get_terms( $args );
remove_filter( 'terms_clauses', 'rs_replace_inner_with_straight_joins', 20 );

// Step 2. Add to functions.php or similar:
function rs_replace_inner_with_straight_joins( $pieces, $taxonomies = null, $args = null ) {
	global $wpdb;
	
	$s = 'INNER JOIN ' . $wpdb->prefix;
	$r = 'STRAIGHT_JOIN ' . $wpdb->prefix;
	$pieces['join'] = str_replace( $s, $r, $pieces['join'] );
	
	return $pieces;
}

thanks for this, btw the function name doesn't match the one used in the add/remove filter

@rtpHarry oops! Thanks for catching that