Thought Space Designs
Reputation
451
Top tag
Next privilege 500 Rep.
Access review queues
Badges
3 15
Impact
~12k people reached

  • 0 posts edited
  • 0 helpful flags
  • 7 votes cast
Dec
30
awarded  Popular Question
Sep
22
awarded  Notable Question
Sep
5
awarded  Yearling
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