WP_User_Query Object
(
[query_vars] => Array
(
[blog_id] => 1
[role] =>
[role__in] => Array
(
)
[role__not_in] => Array
(
)
[meta_key] =>
[meta_value] =>
[meta_compare] =>
[include] => Array
(
)
[exclude] => Array
(
)
[search] =>
[search_columns] => Array
(
)
[orderby] => rand
[order] => ASC
[offset] =>
[number] =>
[paged] => 1
[count_total] => 1
[fields] => all
[who] =>
[has_published_posts] =>
[nicename] =>
[nicename__in] => Array
(
)
[nicename__not_in] => Array
(
)
[login] =>
[login__in] => Array
(
)
[login__not_in] => Array
(
)
[meta_query] => Array
(
[relation] => AND
[0] => Array
(
[key] => show_profile_in_find_a_celebrant_directory
[value] => 1
)
[1] =>
[2] =>
[3] => Array
(
[key] => celebrant_locations
[value] => Carnarvon
[compare] => LIKE
)
)
)
[results:WP_User_Query:private] => Array
(
[0] => WP_User Object
(
[data] => stdClass Object
(
[ID] => 169
[user_login] => MCM000252
[user_pass] => $P$BYgxN5KsqO8Ouq85BS/YhYqiSjJmUM0
[user_nicename] => mcm000252
[user_email] => pete@petebrown.com.au
[user_url] => https://www.bettercelebrants.com.au
[user_registered] => 2015-11-26 00:00:00
[user_activation_key] =>
[user_status] => 0
[display_name] => Peter Brown
)
[ID] => 169
[caps] => Array
(
[subscriber] => 1
[bbp_participant] => 1
)
[cap_key] => wp_capabilities
[roles] => Array
(
[0] => subscriber
[1] => bbp_participant
)
[allcaps] => Array
(
[level_0] => 1
[spectate] => 1
[participate] => 1
[read_private_forums] => 1
[publish_topics] => 1
[edit_topics] => 1
[publish_replies] => 1
[edit_replies] => 1
[assign_topic_tags] => 1
[subscriber] => 1
[bbp_participant] => 1
)
[filter] =>
[site_id:WP_User:private] => 1
)
)
[total_users:WP_User_Query:private] => 1
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => show_profile_in_find_a_celebrant_directory
[value] => 1
)
[3] => Array
(
[key] => celebrant_locations
[value] => Carnarvon
[compare] => LIKE
)
[relation] => AND
)
[relation] => AND
[meta_table] => wp_usermeta
[meta_id_column] => user_id
[primary_table] => wp_users
[primary_id_column] => ID
[table_aliases:protected] => Array
(
[0] => wp_usermeta
[1] => mt1
)
[clauses:protected] => Array
(
[wp_usermeta] => Array
(
[key] => show_profile_in_find_a_celebrant_directory
[value] => 1
[compare] => =
[compare_key] => =
[alias] => wp_usermeta
[cast] => CHAR
)
[mt1] => Array
(
[key] => celebrant_locations
[value] => Carnarvon
[compare] => LIKE
[compare_key] => =
[alias] => mt1
[cast] => CHAR
)
)
[has_or_relation:protected] =>
)
[request] => SELECT SQL_CALC_FOUND_ROWS wp_users.* FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id ) WHERE 1=1 AND (
( wp_usermeta.meta_key = 'show_profile_in_find_a_celebrant_directory' AND wp_usermeta.meta_value = '1' )
AND
( mt1.meta_key = 'celebrant_locations' AND mt1.meta_value LIKE '{58e5fd8452bb0c1827e27e2ebf99e1deab64a73a1c1ccac800dbe33949c87e3b}Carnarvon{58e5fd8452bb0c1827e27e2ebf99e1deab64a73a1c1ccac800dbe33949c87e3b}' )
) ORDER by RAND()
[compat_fields:WP_User_Query:private] => Array
(
[0] => results
[1] => total_users
)
[query_fields] => SQL_CALC_FOUND_ROWS wp_users.*
[query_from] => FROM wp_users INNER JOIN wp_usermeta ON ( wp_users.ID = wp_usermeta.user_id ) INNER JOIN wp_usermeta AS mt1 ON ( wp_users.ID = mt1.user_id )
[query_where] => WHERE 1=1 AND (
( wp_usermeta.meta_key = 'show_profile_in_find_a_celebrant_directory' AND wp_usermeta.meta_value = '1' )
AND
( mt1.meta_key = 'celebrant_locations' AND mt1.meta_value LIKE '{58e5fd8452bb0c1827e27e2ebf99e1deab64a73a1c1ccac800dbe33949c87e3b}Carnarvon{58e5fd8452bb0c1827e27e2ebf99e1deab64a73a1c1ccac800dbe33949c87e3b}' )
)
[query_orderby] => ORDER by RAND()
[query_limit] =>
)