i dont know how to achieve this in query arg. This is because it cannot be done using just arguments. No option for role is listed in the order/orderby parameter docs. There is no option to sort by user role in WordPress. Instead, you’re going to have to query for all gold role users, grab … Read more
I found my answer, I added ‘orderby’ => ‘post__in’
How to duplicate 5 posts out of WP_Query results?
Thank you to Tom J Nowell for pointing me to using WP_Query instead of get_posts. With WP_Query you have the entire WP_Query object to reference. So something like the following gives the actual mysql query of the args I was using. // these same args also worked with get_posts() $args = array( ‘post_type’ => ‘post’, … Read more
Disable stored tags queries in admin page when posting a new post
I had a quick grep for SQL_CALC_FOUND_ROWS and found a few instances. I’m not sure which one is being called in your case, but here’s an interesting one from wp-includes/class-wp-query.php line 2904 onwards: $found_rows=””; if ( ! $q[‘no_found_rows’] && ! empty( $limits ) ) { $found_rows=”SQL_CALC_FOUND_ROWS”; } $old_request = “SELECT $found_rows $distinct $fields FROM {$wpdb->posts} … Read more
Modify the query method when adding category filtering function to the custom post list
Iterating through $wpdb query without using get_results for large query results
You could adapt get_post_acestors(), and write a similar function for comments. Here is an example that returns the top comment’s id or false. Not tested! function get_root_comment( $comment_id ) { $comment = get_comment( $comment_id ); if ( ! $comment || empty( $comment->comment_parent ) || $comment->comment_parent == $comment_id ) { return false; } $ancestors = []; … Read more
Protect sequence of pages with same password for each of two groups of users