WordPress query - markhowellsmead/helpers GitHub Wiki

Event start/end dates

• Complex start and end date comparison (slow). Possibly superseded by date_query.

Multiple meta keys

$users = get_users([
	'relation' => 'OR',
	[
		'meta_key'     => 'logo',
		'meta_compare' => 'EXISTS'
	],
	[
		'meta_key'     => 'logo_url',
		'meta_compare' => 'EXISTS'
	]
]);

Random sort users

add_action('pre_user_query', [$this, 'userRandomOrder'], 10, 1);

public function userRandomOrder($class)
{
	if ('random' == $class->query_vars['orderby']) {
		$class->query_orderby = str_replace('user_login', 'RAND()', $class->query_orderby);
	}
	return $class;
}