How can I change my meta_query to SQL wpdb query?

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:

  1. Speed optimization of $wpdb->get_results
  2. XOR functionality for meta_query
  3. $wpdb->get_row() only returns a single row?
  4. wpdb->insert: do I need to prepare against SQL injection?
  5. How to parse row results from $wpdb -> get_results
  6. Why $wpdb->show_errors() and print_error() is showing an output even if the query output is correct?
  7. what is the way to see the currently executing query in wordpress?
  8. Fetch array with $wpdb
  9. How do I check for a duplicate record before inserting using wpdb
  10. WordPress 4.8.1 uses mysql_connect which doesn’t work with PHP 7
  11. How to use $wpdb to delete in a custom table
  12. $wpdb->insert not working in any way
  13. WPDB prepare – like % – placeholders?
  14. $wpdb->update multiple rows, like IN in normal SQL
  15. Matching database content types to PHP types
  16. Does $wpdb->prepare not create a prepared statement that I can execute multiple times?
  17. get_results on large datasets
  18. $wpdb->insert() and Values for Datetime Columns?
  19. SELECT max(meta_value) FROM wp_postmeta WHERE meta_key=’price’… stops working when value is over 999
  20. $wpdb->last_error doesn’t show the query on error
  21. Avoiding “Usage of a direct database call is discouraged”
  22. dbDelta does not create Table, but returns success
  23. Theoretical Multi-Server WordPress Setup with Shared Users
  24. Change post status based on meta value
  25. wpdb->insert not working
  26. Saving custom form data into database
  27. Search multiple meta keys at once
  28. passing variables as parameters to stored procedures via wpdb from php-script
  29. Get data from database table by post_id to get data from second database table
  30. wp-content/db.php : where is this file?
  31. Quotes in table name
  32. Delete/replace img tags in post content for auto published posts [closed]
  33. $wpdb sql help. Select post id and post meta value based on 2 other post_meta values
  34. $wpdb->get_results() returns good result only in first foreach iteration
  35. $wpdb->insert – inserting multiple rows
  36. How do I create a single.php for a specific category?
  37. $wpdb prepared with search term
  38. WPDB->insert with special characters
  39. What does wp_update_post() do that the $wpdb class does not?
  40. How Can I Use $wpdb in PayPal IPN file?
  41. $wpdb is get_results escaped
  42. How to count data records in wordpress which have same meta_value in wp_postmeta table?
  43. $wpdb->query() multiple query support
  44. wpdb-> not adding prefix to custom table
  45. Is there a (better) way to access $wpdb results?
  46. Using $wpdb generates DB error
  47. WordPress insert NOW() in TIMESTAMP column returns all zeros
  48. How do you use prepare when asking for a list of id’s
  49. Set media metadata (i.e. “dimensions” field) on SVG file after extracting it with a filter
  50. $wpdb prepare issue with mysql DATE_FORMAT
  51. How-To: wpdb Insert Record With Date
  52. $wpdb->prepare not working with update table prefix
  53. How to use prepare to query with variables
  54. Use $wpdb in wordpress theme files
  55. How to pass NULL in where array for $wpdb->update
  56. how to execute different sql query in non-sanitized $wpdb->get_results function
  57. $wpdb not returning data
  58. Get random row from custom table
  59. How to get top 10 user is based on user meta value
  60. $wpdb Query Result not coming but in phpmyadmin it works [closed]
  61. WPDB update row with != in where clause
  62. store custom WP table names in a global variable
  63. wpdb prepare: passing varible number of fields as second argument
  64. $wpdb insert array
  65. I am not understandinhg $wpdb->prepare correctly
  66. Wpdb query for comment meta for current post
  67. How to update records using $wpdb?
  68. wpdb->get_row() / get_results – is it possible to return an object instances of my own class?
  69. Problem in creating table through plugin code
  70. I want to update my postcontent with $wpdb
  71. How to save html and text in the database?
  72. How to email user after inserting the username in database in WordPress
  73. $wpdb->replace / Replace or update primary key
  74. Join inside a wpdb query.. confused!
  75. Create an array with a string key from wpdb->get_results
  76. How to fetch an array in $wpdb?
  77. $wpdb – do you have to use foreach even if there will always only be one result?
  78. How to Modify this $wpdb query to accept an array of post statuses
  79. Replicating the WP_Query ‘s’ param with $wpdb
  80. Why doesn’t my insert query work?
  81. Need help writing a $wpdb query
  82. How to prevent $wpdb->prepare stripping a leading zero in variable value?
  83. Generate a unique hash/number for tracking on $wpdb insert
  84. get the number of queries made on a page(inside my plugin)
  85. Doing a loop with multiple DBs simultaneoulsy
  86. Using WPDB class
  87. show badge with count for pending items in custom post type
  88. WPDB Update using Conditional Arrays
  89. $wpdb->insert query changes to SHOW COLUMNS query Output
  90. How can I migrate mysql_fetch_array to $wbpdb?
  91. $wpdb->get_results returns empty but value exists
  92. Fixing wpdb->get_results and wpdb->prepare?
  93. How does the WXR file differ from the WPDB?
  94. WP Sql query multiple where clause
  95. Problem displaying inserted form
  96. What is _transient_random_seed for?
  97. WordPress SQL query – returning ‘true’ ‘false’ or ‘null’
  98. wpdb->insert and stripslashes against sql injection
  99. Get published posts and pages?
  100. Rolling Back from current WordPress version to previous one
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)