421 reputation
114
bio website thoughtspacedesigns.com
location Pittsburgh, PA
age
visits member for 1 year, 10 months
seen Apr 19 at 19:40

Mar
31
awarded  Popular Question
Feb
26
comment SQL query equivalent to WP User Query
Actually, it appears that my nested query is causing duplicate results. I believe at this point I'm going to try my hand at developing a raw SQL query for my purposes.
Feb
26
awarded  Curious
Feb
25
comment Searching user meta using WP_User_Query
Also, small world :)
Feb
25
comment Searching user meta using WP_User_Query
I have something similar to that currently, and I'm using a nested meta query. You cans my current query here: wordpress.stackexchange.com/questions/179274/… It's under the edit in the main question. Problem is that it leads to duplicates being returned so I decided maybe the default search parameter would be better. If I can avoid duplicates I might be able to use meta query.
Feb
25
asked Searching user meta using WP_User_Query
Feb
25
comment SQL query equivalent to WP User Query
I stuck a start time variable before the WP_User_Query and an end time variable right after it, calculated the difference and then spit it out and it came out to 5 ish seconds.
Feb
24
comment SQL query equivalent to WP User Query
So I tried nested queries, but they're taking a large amount of time to run (5+ seconds). Any idea how I can speed up execution some?
Feb
24
revised SQL query equivalent to WP User Query
Edit in reply to an answer
Feb
24
comment SQL query equivalent to WP User Query
Awesome sauce. I'm trying it now.
Feb
24
revised SQL query equivalent to WP User Query
More specific title
Feb
24
accepted WP_User_Query orderby meta_val_num
Feb
24
comment WP_User_Query orderby meta_val_num
Alright. I'm kind of debating doing this all with a SQL query anyway as my code isn't very efficient at this point. I'm having a hard time finding where to start with the SQL query and I put another question up. I'll mark this answer as correct. Do you mind taking a look over at this question: wordpress.stackexchange.com/questions/179274/…
Feb
24
asked SQL query equivalent to WP User Query
Feb
24
comment WP_User_Query orderby meta_val_num
Please see my edit above. It doesn't seem to work but I'm not sure if I'm doing anything wrong.
Feb
24
revised WP_User_Query orderby meta_val_num
added more details in reply to a answer
Feb
24
asked WP_User_Query orderby meta_val_num
Feb
24
accepted custom user table columns
Feb
24
comment custom user table columns
Awesome, thanks very much. I've got it all working now.
Feb
24
comment custom user table columns
Sounds good. How can I change column order to move my newly created column to the beginning of the table?