Create a WP_Query where if the first value of the first row is equal to the second compare other value

You need to setup multiple meta_queries using an array. Since you didn’t have a value you were looking for I’m just making sure that thePrice and thePrice2 are not blank. I set each meta query to a variable and then used them in the main orderby statement with a space between them. I wasn’t able to do any testing on the code so if you have issues let me know.

<?php
$args = array(
    'post_type' => 'sn_dr_ia',
    'meta_query' => array(
        'relation' => 'OR',
        'thePriceValue' => array(
            'key'     => 'thePrice',
            'value'   => '',
            'compare' => '!='
        ),
        'thePrice2Value' => array(
            'key' => 'thePrice2',
            'value'   => '',
            'compare' => '!='
        )
    ),
    'orderby' => 'thePriceValue thePrice2Value',
    'order'   => 'ASC'
);

$query = new WP_Query($args);
?>

Here is a link to the codex for the syntax of the meta_query: https://codex.wordpress.org/Class_Reference/WP_Meta_Query

Related Posts:

  1. Mixing regular and custom post types (with meta_query) on home page
  2. WP_Query() show posts that end later than today
  3. WP_Query orderby custom field then post_date in one query
  4. Filtering a WP_Query meta_query by numeric values isn’t working
  5. Using Query Posts With Multiple Post Types And A Taxonomy
  6. Can’t sort order of wp_query with 2 meta keys
  7. Comparing timestamps in meta query doesn’t work
  8. Display two post types ordered by two custom fields
  9. Combine tax_query and meta_query in WP_Query
  10. query order by date on custom type: wrong order
  11. exclude custom post type by meta key in wp_query
  12. Filter posts with meta_query NOT IN where value has multiple values
  13. Filtering by Post Meta Custom Fields – Performance
  14. Is it possible to apply a meta_query to one specific post type in a query with multilple post types?
  15. Setting proper query for multiple custom admin filters
  16. WP_Query: include custom post type only with specific meta value
  17. Returning a list of custom post types excluding those without a specific meta_value
  18. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  19. wp_query check if integer exists in custom field’s array
  20. A method for ordering mixed dates in search result loop (theory only, no actual code)
  21. How to do WP_Query with two meta fields with orderby clause
  22. Stuck in Order by more then one
  23. Why is this query not working? (Standard posts + custom post type)
  24. Configuring a meta query with multiple post types that have the same relationship on a single page
  25. Possible to filter custom post type with multiple meta data?
  26. Query based on custom fields start and end date
  27. WP_query – Filter by tax_query and meta_query using multiple select
  28. Getting a custom post’s custom field based on another custom post’s custom field select
  29. find custom post type post by searching its custom field with my string
  30. WP_Query of custom post type sorted by meta_key has unexpected results
  31. Query Posts, order by meta value
  32. WP_Meta_Query object with conditionals
  33. Sorting by meta_key different to search criteria?
  34. Using WP meta query to show custom post types by a start and finish date
  35. Two queries – one with checkbox ticked, one without – comparing meta_query
  36. How to order query results based on if a custom field has been populated, then the order by the date of the post?
  37. build child and anchestor three from post parent
  38. meta query condition don’t work
  39. Custom query result empty on page 2
  40. Use WP_query to match post types based on custom field values
  41. meta query multiple values for the same key
  42. Sort custom post archives by a meta value from a different custom post type?
  43. Custom post types – meta_query: search lesson which starts sooner
  44. post type => ‘any’ not applied my custom queries
  45. How to get the posts that my following users are liked?
  46. Meta_Query refuses to return results
  47. Not able to get my custom search result using meta_query and tax_query together?
  48. Querying, storing, and using data from 2 separate custom post types
  49. Query events post type after current date and timezone
  50. Conditional posts in WP_query for search
  51. Selecting posts older than the current Unix epoch timestamp
  52. Custom Query With Multiple Meta Key Value
  53. Trying to combine multiple WordPress queries
  54. Querying meta values within an array
  55. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  56. Order Wp Query by earliest of 3 dates meta query
  57. WP_Query() displaying past post / event
  58. WP Query Conditionally query meta and taxonomy
  59. Exclude a category from WP_Query
  60. Single loop for wp_query and wp_user_query
  61. query multiple taxonomies
  62. Custom Post Type, WP_Query and ‘orderby’
  63. Include post id[s] into WP_Query()
  64. Grab 5 latest posts from custom post type ‘announcements’
  65. Pagination Doesn’t Work
  66. filter search result with custom post type meta key
  67. Numeric pagination custom post type
  68. Sort the main query in subcategories/terms?
  69. Get post info inside modal window?
  70. Pagination Issue: Custom Post Type In Index
  71. Having trouble with custom date field for CPT query (WordPress)
  72. Separate Posts and Custom Post Type in Custom Taxonomy archive template
  73. How to use WP_Query in a CPT achive page?
  74. Use get_post_types to query only custom posts types
  75. How can i skip same post from taxonomy term?
  76. Sorting Custom Post Type by Meta Value but wont display when set to 0
  77. WP_Query orderby modified to include custom meta changes
  78. Get posts between custom dates
  79. Several post types on WP Query by tag and taxonomy
  80. Filter Posts from the Main Query
  81. Display post from a date range from custom field
  82. WP_Query not resetting after wp_reset_postdata
  83. Custom post type to lead to single post type instead of shortcode modal
  84. List all Custom Post Type posts excluding certain Taxnomy term
  85. Custom post type pagination error
  86. WP Query from two Custom Post type fields as statement
  87. Display post count for a specific month
  88. Query to Exclude Child Pages from Custom Post Type Archive
  89. WP_query has incorrect wp_posts.post_name = ‘asc’ when I have custom post type called ‘order’
  90. Randomizing WordPress Custom Post Type Sorting Through Them Without Page Refresh
  91. Order posts alphabetically with numbers but some of the posts has numbers in the title
  92. How to output custom post type title on custom page with category next to it?
  93. ACF meta_key and meta_value break loop
  94. SQL LIKE in WP_Query
  95. WP Query with multiple post types ordered by custom meta date then published date
  96. WP_Query get posts where post_name is empty
  97. How do I sort post listing by child post count?
  98. Archive page – problem with pagination
  99. Assign a tag to custom post type using a query
  100. Query order by a numeric ACF field