Pin to Top Functionality using orderby custom field then event date

I had a similar aproach some days ago

//.....
'meta_query'      => array(
           'relation' => 'OR',
            array(
                'pin_clause' = array(
                'meta_key' => 'pin_to_top',
                'meta_type' => 'NUMERIC',
                'meta_value_num' => '1',
                'compare' => '='
                )
            ),
            array(
                'date_clause' => array(
                    'meta_key' => '_EventStartDate',
                    'meta_type' => 'DATETIME',
                    'meta_value' => '$today',
                    'compare' => '>='
                )
            )
        ),
        'orderby' => array(
            'pin_clause' => 'DESC',
            'date_clause' => 'ASC'
        )
 //....

I don’t know if I got your names right, but I think it will help to understand the trick.

Related Posts:

  1. WP REST API: Order posts by meta value (acf)?
  2. sort by date in Advanced Custom Field
  3. Display post in order of ACF checkbox?
  4. Order get_terms by multiple meta_values
  5. Multiple orderby date arguments
  6. WP Query with meta queries
  7. ACF order relationship by date
  8. Ignoring initial articles (like ‘a’, ‘an’ or ‘the’) when sorting queries?
  9. ORDER BY custom field value
  10. Sorting: custom query with orderby meta_value_num THEN by title
  11. Order get_terms using a Custom Field
  12. Custom Post type sort order not working in the admin area
  13. wordpress REST-API upload image to ACF
  14. Ascending sort order for monthly & category view, i.e. ?m=201204, ?cat=4
  15. How to add a custom field to quick edit
  16. Gutenberg First Block on Page Conditional?
  17. Comparing arrays with meta_query in pre_get_posts
  18. How to order by just the Time Field in Advanced Custom Fields
  19. Using Gutenberg parse_blocks Function With ACF Custom Blocks?
  20. Sorting posts by multiple values, combined
  21. How to update custom taxonomy meta using ACF update_field() function or any other wordpress function
  22. Thumbnails generated from PDF in the “Media” section – how to show them in theme template?
  23. How to count ACF Flexible Content Rows?
  24. Query between dates using date picker filter breaks in WordPress 4.2.1
  25. Get ACF value after update user using save_post
  26. random p tag in advanced custom fields?
  27. How to write PHP array to render JSON-LD Markup for Job Postings, with ACF
  28. Advanced Custom Fields: Conditional Statement with Select
  29. Add PDF to ACF image field from file url
  30. WP_Query: Group events by year, sorted DESC; then by date for each year group, sorted ASC
  31. Order RSS content by an advanced custom field value
  32. Understanding the orderby in WP_Query?
  33. Bulk-Update Custom Posts
  34. Group ACF repeater fields from differrent posts
  35. How to get custom fields in a post when published
  36. Get all custom fields with wp’s get_posts()
  37. How to populate a parent page with its child subpages and associated templates
  38. Find the first occurrence of a custom field
  39. Custom post type sorting: alphabetical order
  40. Sort a custom post with ACF: Date Picker & Display Featured!
  41. ACF Relationship – Limit to specific pages
  42. Website goes down while importing backup (Internal server 500)
  43. Display total unique custon field results
  44. Advanced custom fields – pulling data in from another page
  45. I would like my page editor to be sorted by date created, or updated, instead of in Alpha order, is this possible?
  46. ACF: If field contain a specific value, update value in another field programatically
  47. Custom Post Type page sorts differently on different environments
  48. how to load random related posts with specific custom fields?
  49. Displaying user data within ACF relational field (user type)
  50. ACF Image field not displaying in WordPress with Visual Composer [closed]
  51. get_previous_post() while accounting for sticky posts
  52. How to acquire an ACF image using get_previous_post and get_next_post
  53. ACF checkbox array is returning numbers, not labels [closed]
  54. Showing a post depending on the Custom Field value
  55. Advanced Custom Fields – category image
  56. Widget Code / Advanced Custom Fields / Elementor
  57. How can I apply an ACF field to a single custom post if it refers to the taxomy of that post type in the rules?
  58. ACF: Update field value based on value of another field
  59. Getting “Years Only ” from ACF Date Picker field to Hidden filed in the fields group
  60. Prevent other hooks from firing after wp_update_post() outside of editor
  61. Where to place CSS if add a new layout to FLexible Content Template
  62. Trying to update repeater field (ACF) dynamically with data from Contact Forms 7
  63. Get title color from category custom field
  64. WP Cron Working, but Function Not Working
  65. Explore custom posts (CPT UI & ACF) database from WP UI
  66. pre_get_posts hook not targeting search results page query
  67. ACF – get custom taxonomy term image field
  68. ACF group field disappeared after deployment using deployer script
  69. get the title of a relationship field
  70. ACF Dynamic select not showing data
  71. Modification of RSS feed is not consistent
  72. How to call ACF field in functions?
  73. Order by value of Custom Field using url string
  74. How to use WP Backery on Wysiwyg ACF
  75. wp query multiple values > display a specific value first
  76. Create Shortcode for php code in functions.php
  77. Wp Query sort order from custom MetaBox
  78. ACF: Updating gallery field doesn’t work in backend
  79. Multiple sorting criteries (order by)
  80. Using Orderby and meta_value to order natural/alphanumerical
  81. Pulling author name via $_GET parameter
  82. Srcset incorrect with Owl Carousel and ACF?
  83. Rearranging Content After Blog Post
  84. Advanced Custom Fields – Google Map Won’t Render Unless Variable Dumped
  85. Best way to sort posts with different types by distance
  86. ACF scheduled repeater fields
  87. Get the category fields even if there is no post
  88. Advanced Custom Fields Show After Password [closed]
  89. Custome column sort by date not title
  90. How to order posts by the user_login that corresponds to a meta_value (which is a user id)?
  91. query_posts with sorting on a custom datestamp
  92. Multiple loop issue – pull one featured and then continue the loop
  93. List CPT by menu_order with children right after parent
  94. Check if meta_key exists in wp_list_pages
  95. ACF + WPML: How to translate date fields?
  96. Using ACF custom field for custom post type to order categories
  97. PHP calls to custom fields not being made. Query seems to be blocking them
  98. Sort wordpress posts by facebook likes [closed]
  99. show only first element from a type with acf
  100. ACF – if field has value within Field Group conditional statement [closed]