WP_User_Query Object ( [query_vars] => Array ( [blog_id] => 1 [role] => [role__in] => Array ( ) [role__not_in] => Array ( ) [capability] => [capability__in] => Array ( ) [capability__not_in] => Array ( ) [meta_key] => last_name [meta_value] => [meta_compare] => [include] => Array ( ) [exclude] => Array ( ) [search] => [search_columns] => Array ( ) [orderby] => meta_value [order] => ASC [offset] => [number] => 20 [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 ( ) [cache_results] => 1 [meta_query] => Array ( [relation] => AND [0] => Array ( [key] => subsdue [compare] => >= [value] => 2024-04-23 [type] => DATETIME ) [1] => Array ( [key] => memcat [value] => Array ( [0] => Professional [1] => New Professional [2] => Professional Plus [3] => Graduate [4] => International Associate [5] => Organisation [6] => Honorary [7] => Retired [8] => Complimentary ) [compare] => IN ) [2] => Array ( [key] => last_name [value] => ^Y.* [compare] => REGEXP ) ) ) [results:WP_User_Query:private] => Array ( [0] => WP_User Object ( [data] => stdClass Object ( [ID] => 22 [user_login] => amyyardley [user_pass] => $P$B8Z3V/byWKriox.krU3T6is466SXZo. [user_nicename] => amyyardley [user_email] => amyyardley@gmail.com [user_url] => http://www.amyyardley.co.uk [user_registered] => 2009-10-20 18:06:27 [user_activation_key] => [user_status] => 0 [display_name] => Amy Yardley ) [ID] => 22 [caps] => Array ( [contributor] => 1 ) [cap_key] => wp_capabilities [roles] => Array ( [0] => contributor ) [allcaps] => Array ( [edit_posts] => 1 [read] => 1 [level_1] => 1 [level_0] => 1 [delete_posts] => 1 [edit_tribe_event] => 1 [read_tribe_event] => 1 [delete_tribe_event] => 1 [edit_aggregator-records] => 1 [delete_aggregator-records] => 1 [contributor] => 1 ) [filter] => [site_id:WP_User:private] => 1 ) [1] => WP_User Object ( [data] => stdClass Object ( [ID] => 1993 [user_login] => jodieyates [user_pass] => $P$BHS5/vZio0x/JhIBULLhULu9WlWrMB0 [user_nicename] => jodieyates [user_email] => jodiejewyates@outlook.com [user_url] => [user_registered] => 2023-12-06 17:43:01 [user_activation_key] => 1707300901:$P$Bu7EmIERP0LDs.jXSooIhniL9ahtJh/ [user_status] => 0 [display_name] => Jodie Yates ) [ID] => 1993 [caps] => Array ( [subscriber] => 1 ) [cap_key] => wp_capabilities [roles] => Array ( [0] => subscriber ) [allcaps] => Array ( [level_0] => 1 [read] => 1 [read_tribe_event] => 1 [subscriber] => 1 ) [filter] => [site_id:WP_User:private] => 1 ) [2] => WP_User Object ( [data] => stdClass Object ( [ID] => 1886 [user_login] => agnesyeung [user_pass] => $P$BAk04IjnghY3t0RigwgOUMbAdxP915. [user_nicename] => agnesyeung [user_email] => agnesyeung01@gmail.com [user_url] => [user_registered] => 2023-04-13 00:34:55 [user_activation_key] => [user_status] => 0 [display_name] => Agnes Yeung ) [ID] => 1886 [caps] => Array ( [subscriber] => 1 ) [cap_key] => wp_capabilities [roles] => Array ( [0] => subscriber ) [allcaps] => Array ( [level_0] => 1 [read] => 1 [read_tribe_event] => 1 [subscriber] => 1 ) [filter] => [site_id:WP_User:private] => 1 ) [3] => WP_User Object ( [data] => stdClass Object ( [ID] => 1502 [user_login] => Haibo Yu [user_pass] => $P$BfXOlF0SRa2EaaN5iI74kHwd7xxe1q. [user_nicename] => haibo-yu [user_email] => haiboyu555@yahoo.com [user_url] => http://www.haiboyudesign.com [user_registered] => 2016-11-26 19:39:28 [user_activation_key] => [user_status] => 0 [display_name] => Haibo Yu ) [ID] => 1502 [caps] => Array ( [subscriber] => 1 ) [cap_key] => wp_capabilities [roles] => Array ( [0] => subscriber ) [allcaps] => Array ( [level_0] => 1 [read] => 1 [read_tribe_event] => 1 [subscriber] => 1 ) [filter] => [site_id:WP_User:private] => 1 ) ) [total_users:WP_User_Query:private] => 4 [meta_query] => WP_Meta_Query Object ( [queries] => Array ( [0] => Array ( [key] => last_name ) [1] => Array ( [0] => Array ( [key] => subsdue [compare] => >= [value] => 2024-04-23 [type] => DATETIME ) [1] => Array ( [key] => memcat [value] => Array ( [0] => Professional [1] => New Professional [2] => Professional Plus [3] => Graduate [4] => International Associate [5] => Organisation [6] => Honorary [7] => Retired [8] => Complimentary ) [compare] => IN ) [2] => Array ( [key] => last_name [value] => ^Y.* [compare] => REGEXP ) [relation] => AND ) [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 [2] => mt2 [3] => mt3 ) [clauses:protected] => Array ( [wp_usermeta] => Array ( [key] => last_name [compare] => = [compare_key] => = [alias] => wp_usermeta [cast] => CHAR ) [mt1] => Array ( [key] => subsdue [compare] => >= [value] => 2024-04-23 [type] => DATETIME [compare_key] => = [alias] => mt1 [cast] => DATETIME ) [mt2] => Array ( [key] => memcat [value] => Array ( [0] => Professional [1] => New Professional [2] => Professional Plus [3] => Graduate [4] => International Associate [5] => Organisation [6] => Honorary [7] => Retired [8] => Complimentary ) [compare] => IN [compare_key] => = [alias] => mt2 [cast] => CHAR ) [mt3] => Array ( [key] => last_name [value] => ^Y.* [compare] => REGEXP [compare_key] => = [alias] => mt3 [cast] => CHAR ) ) [has_or_relation:protected] => ) [request] => SELECT SQL_CALC_FOUND_ROWS wp_users.ID 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 ) INNER JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id ) INNER JOIN wp_usermeta AS mt3 ON ( wp_users.ID = mt3.user_id ) WHERE 1=1 AND ( wp_usermeta.meta_key = 'last_name' AND ( ( mt1.meta_key = 'subsdue' AND CAST(mt1.meta_value AS DATETIME) >= '2024-04-23' ) AND ( mt2.meta_key = 'memcat' AND mt2.meta_value IN ('Professional','New Professional','Professional Plus','Graduate','International Associate','Organisation','Honorary','Retired','Complimentary') ) AND ( mt3.meta_key = 'last_name' AND mt3.meta_value REGEXP '^Y.*' ) ) ) ORDER BY wp_usermeta.meta_value ASC LIMIT 0, 20 [compat_fields:WP_User_Query:private] => Array ( [0] => results [1] => total_users ) [query_fields] => SQL_CALC_FOUND_ROWS wp_users.ID [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 ) INNER JOIN wp_usermeta AS mt2 ON ( wp_users.ID = mt2.user_id ) INNER JOIN wp_usermeta AS mt3 ON ( wp_users.ID = mt3.user_id ) [query_where] => WHERE 1=1 AND ( wp_usermeta.meta_key = 'last_name' AND ( ( mt1.meta_key = 'subsdue' AND CAST(mt1.meta_value AS DATETIME) >= '2024-04-23' ) AND ( mt2.meta_key = 'memcat' AND mt2.meta_value IN ('Professional','New Professional','Professional Plus','Graduate','International Associate','Organisation','Honorary','Retired','Complimentary') ) AND ( mt3.meta_key = 'last_name' AND mt3.meta_value REGEXP '^Y.*' ) ) ) [query_orderby] => ORDER BY wp_usermeta.meta_value ASC [query_limit] => LIMIT 0, 20 )