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] => 2 [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] => ^M.* [compare] => REGEXP ) ) ) [results:WP_User_Query:private] => Array ( [0] => WP_User Object ( [data] => stdClass Object ( [ID] => 1905 [user_login] => emiliamendez [user_pass] => $P$BOT1BuE9SvuMia.W2nxi12zRPoAY1S. [user_nicename] => emiliamendez [user_email] => emendez@hotmail.co.uk [user_url] => [user_registered] => 2023-09-06 08:45:35 [user_activation_key] => 1693989935:$P$BoCMC1drVxNvTaq5FoOnTrLw6XmvRF1 [user_status] => 0 [display_name] => Emilia Mendez ) [ID] => 1905 [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 ) [1] => WP_User Object ( [data] => stdClass Object ( [ID] => 1533 [user_login] => florencemeredith [user_pass] => $P$BhzrcC/5U.bWfi0OgfXNxYk1vVucRw/ [user_nicename] => florencemeredith [user_email] => florencemeredith@live.co.uk [user_url] => [user_registered] => 2017-08-30 18:53:19 [user_activation_key] => 1703770678:$P$BvuuYagHSQ4Kt1RLXNdoTBB2zWat1C. [user_status] => 0 [display_name] => Florence Meredith ) [ID] => 1533 [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 ) [2] => WP_User Object ( [data] => stdClass Object ( [ID] => 1892 [user_login] => georginamiles [user_pass] => $P$BXvTkQq/fapA46DXXjJGR8wd3BdOkj1 [user_nicename] => georginamiles [user_email] => georgiemiles@hotmail.com [user_url] => [user_registered] => 2023-06-28 19:09:15 [user_activation_key] => 1687979355:$P$BjpeTfYwqut0uTgPXKxQIB6VPTm5Sk0 [user_status] => 0 [display_name] => Georgina Miles ) [ID] => 1892 [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] => 42 [user_login] => madeleinemillar [user_pass] => $P$BjocW8OjV4s2Nb7G0rdyRyJz7Gq5bl. [user_nicename] => madeleinemillar [user_email] => mmillar@freeuk.com [user_url] => http://www.mmillar.freeuk.com [user_registered] => 2009-10-22 10:01:46 [user_activation_key] => [user_status] => 0 [display_name] => Madeleine Millar ) [ID] => 42 [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 ) [4] => WP_User Object ( [data] => stdClass Object ( [ID] => 464 [user_login] => beckyminto [user_pass] => $P$BcxS5nTdWaaH4TmO.vf3j4713u/2sg/ [user_nicename] => beckyminto [user_email] => becky.minto@talktalk.net [user_url] => [user_registered] => 2010-04-30 12:31:25 [user_activation_key] => [user_status] => 0 [display_name] => Becky Minto ) [ID] => 464 [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 ) [5] => WP_User Object ( [data] => stdClass Object ( [ID] => 1974 [user_login] => valentinamiranda [user_pass] => $P$BmW2TeURF.itm8eZiU0v/kbyp6dwDL1 [user_nicename] => valentinamiranda [user_email] => valentinamirandauk@gmail.com [user_url] => [user_registered] => 2023-11-11 15:31:04 [user_activation_key] => [user_status] => 0 [display_name] => Valentina Miranda ) [ID] => 1974 [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 ) [6] => WP_User Object ( [data] => stdClass Object ( [ID] => 977 [user_login] => andreamoneta [user_pass] => $P$BItBqrTxFfhJWF1v77FZCzIXSLiAlO. [user_nicename] => andreamoneta [user_email] => andrea.moneta@ntu.ac.uk [user_url] => http://www.andreamoneta.it [user_registered] => 2015-09-16 16:05:59 [user_activation_key] => [user_status] => 0 [display_name] => Andrea Moneta ) [ID] => 977 [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 ) [7] => WP_User Object ( [data] => stdClass Object ( [ID] => 428 [user_login] => catherinemorgan [user_pass] => $P$BCHLg9emcJCB8HuGGfRhhFCgsJ0/li1 [user_nicename] => catherine-morgan [user_email] => catherinemorgan1@live.co.uk [user_url] => http://www.catherinemorgandesigns.co.uk [user_registered] => 2010-03-26 16:52:15 [user_activation_key] => [user_status] => 0 [display_name] => Catherine Morgan ) [ID] => 428 [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 ) [8] => WP_User Object ( [data] => stdClass Object ( [ID] => 861 [user_login] => charliemorganjones [user_pass] => $P$Bzbvgo1Tt6.zM1zrHp08cbMo0ZkYf50 [user_nicename] => charliemorganjones [user_email] => charliemjones@me.com [user_url] => http://www.charliemjones.co.uk [user_registered] => 2014-09-21 21:38:37 [user_activation_key] => [user_status] => 0 [display_name] => Charlie Morgan Jones ) [ID] => 861 [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 ) [9] => WP_User Object ( [data] => stdClass Object ( [ID] => 475 [user_login] => petermumford [user_pass] => $P$Bv5Ph6OwShWW7.dgd1G7whFjUoDK5V/ [user_nicename] => petermumford [user_email] => mumf1@mac.com [user_url] => http://www.petermumford.info [user_registered] => 2010-05-14 08:05:29 [user_activation_key] => [user_status] => 0 [display_name] => petermumford ) [ID] => 475 [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 ) [10] => WP_User Object ( [data] => stdClass Object ( [ID] => 1861 [user_login] => charlottemurphy [user_pass] => $P$B7vLnK7YmpQDGFnJZS7XeufB2KRrFq1 [user_nicename] => charlottemurphy [user_email] => murphydesign2000@gmail.com [user_url] => [user_registered] => 2022-09-13 09:14:07 [user_activation_key] => [user_status] => 0 [display_name] => Charlotte Murphy ) [ID] => 1861 [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 ) [11] => WP_User Object ( [data] => stdClass Object ( [ID] => 1819 [user_login] => charlottemurray [user_pass] => $P$BkOfpDDhI68QFHW2.dY8YX1UJ8ZkAm/ [user_nicename] => charlottemurray [user_email] => charlottejademurray@hotmail.co.uk [user_url] => [user_registered] => 2022-01-25 11:42:22 [user_activation_key] => [user_status] => 0 [display_name] => Charlotte Murray ) [ID] => 1819 [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 ) [12] => WP_User Object ( [data] => stdClass Object ( [ID] => 1884 [user_login] => charliemyers [user_pass] => $P$BEpMGVASvfaHpz1zrBrobtKzgPy1PX/ [user_nicename] => charliemyers [user_email] => charliemyers8@gmail.com [user_url] => https://charliemyers8.myportfolio.com/ [user_registered] => 2023-03-28 09:24:21 [user_activation_key] => [user_status] => 0 [display_name] => Charlie Myers ) [ID] => 1884 [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 ) ) [total_users:WP_User_Query:private] => 33 [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] => ^M.* [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] => ^M.* [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 '^M.*' ) ) ) ORDER BY wp_usermeta.meta_value ASC LIMIT 20, 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 '^M.*' ) ) ) [query_orderby] => ORDER BY wp_usermeta.meta_value ASC [query_limit] => LIMIT 20, 20 )