Results for: O
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-03-29
[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] => ^O.*
[compare] => REGEXP
)
)
)
[results:WP_User_Query:private] => Array
(
[0] => WP_User Object
(
[data] => stdClass Object
(
[ID] => 153
[user_login] => francisoconnor
[user_pass] => $P$BdIIcHZv0e.4v.niJCCI50DCoqIp/e.
[user_nicename] => francisoconnor
[user_email] => francisoconnor9@icloud.com
[user_url] =>
[user_registered] => 2009-11-01 14:03:40
[user_activation_key] =>
[user_status] => 0
[display_name] => francisoconnor
)
[ID] => 153
[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] => 1863
[user_login] => racheloneill
[user_pass] => $P$BYF.WVbodyWyrNkJ844ZlAYNLeFfFf.
[user_nicename] => racheloneill
[user_email] => rachoneill@hotmail.com
[user_url] =>
[user_registered] => 2022-09-27 13:19:25
[user_activation_key] =>
[user_status] => 0
[display_name] => Rachel O'Neill
)
[ID] => 1863
[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] => 1896
[user_login] => stellajaneodoemelam
[user_pass] => $P$BCNzzYXGC32ZgcrJXL6uDNPti7QH//0
[user_nicename] => stellajaneodoemelam
[user_email] => stella-j@hotmail.co.uk
[user_url] => http://www.thestellajanedesign.com
[user_registered] => 2023-07-28 06:52:58
[user_activation_key] =>
[user_status] => 0
[display_name] => Stella-Jane Odoemelam
)
[ID] => 1896
[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
)
[3] => WP_User Object
(
[data] => stdClass Object
(
[ID] => 1869
[user_login] => rachaelorr
[user_pass] => $P$B5DWQ54fCyFHfzdoNiQ7yhE0qOGMqO.
[user_nicename] => rachaelorr
[user_email] => Rachorrdesign@hotmail.co.uk
[user_url] =>
[user_registered] => 2022-10-27 16:04:56
[user_activation_key] => 1666886697:$P$BpFRg.WgcL4A7t/uTL/hQH6l/ZWl0Q0
[user_status] => 0
[display_name] => Rachel Louise Orr
)
[ID] => 1869
[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
)
[4] => WP_User Object
(
[data] => stdClass Object
(
[ID] => 1474
[user_login] => annaorton
[user_pass] => $P$B2z3sZ5hBnouYBcOpqgtwWShhwlCiS1
[user_nicename] => annaorton
[user_email] => annaorton@hotmail.co.uk
[user_url] => http://annaorton.com
[user_registered] => 2016-08-30 21:19:51
[user_activation_key] => 1526929731:$P$B/i/W8qbkrTmaQ2PDvyPK0.3oS1lli.
[user_status] => 0
[display_name] => Anna Orton
)
[ID] => 1474
[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
)
[5] => WP_User Object
(
[data] => stdClass Object
(
[ID] => 653
[user_login] => keithorton
[user_pass] => $P$BnNW9bq9g.JuYnI7VM9J6P3YzWGGz6.
[user_nicename] => keithorton
[user_email] => keith.orton@gmail.com
[user_url] =>
[user_registered] => 2011-11-15 12:19:29
[user_activation_key] =>
[user_status] => 0
[display_name] => Keith Orton
)
[ID] => 653
[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] => 6
[meta_query] => WP_Meta_Query Object
(
[queries] => Array
(
[0] => Array
(
[key] => last_name
)
[1] => Array
(
[0] => Array
(
[key] => subsdue
[compare] => >=
[value] => 2024-03-29
[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] => ^O.*
[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-03-29
[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] => ^O.*
[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-03-29' )
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 '^O.*' )
)
)
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-03-29' )
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 '^O.*' )
)
)
[query_orderby] => ORDER BY wp_usermeta.meta_value ASC
[query_limit] => LIMIT 0, 20
)