Several things, Firstly you can add the following for pagination:
'paged' => ( get_query_var('paged') ? get_query_var('paged') : 1 )
This removes the need for the array_merge. Otherwise your existing code is fine except for some indentation. I would add the rest of the query though, e.g. defining the post type, the posts per page, etc
Related Posts:
- Speed optimization of $wpdb->get_results
- XOR functionality for meta_query
- Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
- How do I check for a duplicate record before inserting using wpdb
- $wpdb->insert not working in any way
- get_results on large datasets
- wpdb->insert not working
- Search multiple meta keys at once
- passing variables as parameters to stored procedures via wpdb from php-script
- How do I create a single.php for a specific category?
- How to count data records in wordpress which have same meta_value in wp_postmeta table?
- $wpdb->query() multiple query support
- Using $wpdb generates DB error
- How do you use prepare when asking for a list of id’s
- Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
- how to execute different sql query in non-sanitized $wpdb->get_results function
- How to get top 10 user is based on user meta value
- $wpdb Query Result not coming but in phpmyadmin it works [closed]
- $wpdb insert array
- How to update records using $wpdb?
- Join inside a wpdb query.. confused!
- Why doesn’t my insert query work?
- How to prevent $wpdb->prepare stripping a leading zero in variable value?
- Generate a unique hash/number for tracking on $wpdb insert
- show badge with count for pending items in custom post type
- wpdb->insert and stripslashes against sql injection
- create drop down menu in theme customizer from custom db
- Are there risks associated with using wp_options table using wpdb to update theme options
- $wpdb->insert is running multiple times on page load, but only called once
- $wpdb select query by month, post type, and taxonomy term
- Get an array of meta_values for a user meta_key
- WPDB – How to search a column in a table
- Confused by $wpdb->prepare
- WordPress (on AWS ubuntu) database Fails “Connection refused in .. /wp-includes/wp-db.php on line 1531”
- How to display user_nicename and usermeta values by custom query in WordPress?
- How can I combine one field using wpdb and group by?
- How to get entry by title by using wpdb
- how to use $wpdb->prepare to update a custom table
- $wpdb not being defined in function: Fatal error: Call to a member function query() on a non-object
- How to obtain a reference to $table_prefix in $wpdb object
- Trying to Connect to different database
- WordPress is trimming leading 0s
- Why does this WPDB code throw an empty WPDB error? [closed]
- wordpress $wpdb works only once
- get_results not returning anything
- WordPress core code contains things marked as deprecated by… WordPress?
- $wpdb – joining shows no result
- Compare transient data with a meta box value
- How to left join meta in queries [closed]
- wpdb->get_row is selecting the variable as a column name
- CREATE TABLE with dbDelta does not create table
- Save data from a checkbox to a wpdb array
- Display category names on edit user profile using $wpdb
- WP-PostRatings: list current user’s rated posts
- Get unique results from this function
- WPDB Join with custom table
- Getting values from wpdb
- Why is this $wpdb query looping 5 times?
- wpdb query not returning results containing single quotes
- duplicate entries in database while using save_post or wp_insert_post
- WPDB Table Does Not Exist
- Unknown column ‘siteurl’ in ‘where clause’ WPDB outside
- Inserting a MySQL record into a table with an array of field names and an array of values
- Incorrect Use of wpdb::prepare()
- Ascending order of yearly archives [closed]
- $wpdb->get_results(…) with $wpdb->prepare(…) returns empty array despite correct query
- wpdb insert formatting for date in array
- wpdb->insert with special chars failing with collation utf8mb4_unicode_520_ci
- Access to numerically indexed array in wpdb Class and undefined offset
- $wpbd->insert() does not insert user data
- Why $wpdb->insert and $wpdb->update not working server but it is working in localhost?
- wpdb prepare placeholders for MySQL keywords
- Sql query triggered twice
- Unable to insert data into using custom plugin
- Debugging db calls: $wpdb->insert works on test site, not on identical production site
- Fastest and most efficient SQL query to check if UID exists
- Creating an Angular factory from custom database table
- wpdb get_row database query inquiry
- Depreciated Call -> Function wpdb::escape()
- How do I update post based on meta_key in another table?
- Object Cache – Avoid db queries totally
- Inserting and updating rows with wpdb indreases integer fields by 1 point sometimes
- Creates only one table and not the other
- Retrieve a list of users based on some conditions
- adding a log row log table, when the draft post publish
- wp_commentdata: error in documentation?
- looking for a way to allow users to backup the plugin db data(save as)
- wp-postratings: list current user’s unrated posts
- Error inserting row into table
- Retriving array size from serialized data
- Out of Memory – Line 791 of WP-DB.php (mysql_real_escape_string)
- get only 1 wpdb and get taxonomy, post to next page [closed]
- Site going down due to slow queries
- Call to a member function get_results() on a non-object in wordpress plugin
- get_post_meta bringing back results, but $wpdb->postmeta doesn’t
- Get count of rows based if column exists in two different tables
- query_vars doesn’t return query string (trying to get data from $wpdb)
- Table wont load into WPDB
- WPDB prepare – like % – placeholders?
- $wpdb->prepare UPDATE process not work in functions.php