404 on Pages for Custom Post Type & Query_Posts

I’ve battled with a similar problem and came to the conclusion that you can’t order by multiple meta values properly using pre_get_posts.

However in your case the solution might actually be very simple. All you need to do is combine the season number with the episode number into a single number.

I don’t know how the user enters these values, but if its done via a custom meta box, then this can be done easily on the function that saves the custom meta values to the database.

Once you’ve prepared the data this way, you only need to orderby by meta_value_num via pre_get_posts. Like this you won’t have to use query_posts() and the pagination and other functionalities will work as expected.

Related Posts:

  1. Order Custom Post Type by Custom Field Value
  2. Having Issue on Ordering CPT by Custom Field In Custom WP Query
  3. Multiple orderby values in WP_Query
  4. Search multiple custom fields by using meta_query
  5. Sort Order for a Custom Query in a Post Type Archive Not Working
  6. how to filter by last name for custom post
  7. Sorting a query by custom field date
  8. How can I generate a RSS feed based on a custom WP_Query?
  9. Filtering a WP Query result
  10. Display Custom Post Type Fields
  11. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  12. How to sort CPT by custom meta value (date), and return posts month by month
  13. List upcoming events, ordered by date in a custom field
  14. WP_Query on custom post type not displaying, multiple loops & get_template_part
  15. Using new WP_Query in shortcode in a custom field causes the main post content to not display
  16. WordPress query by multiple Custom fields and order by date
  17. WP_Query post at custom position
  18. Comparing timestamps in meta query doesn’t work
  19. Display two post types ordered by two custom fields
  20. WP Query group/order by category name
  21. query order by date on custom type: wrong order
  22. Re-order posts in query after
  23. Display custom post types with custom date field value (before today) & order by custom date field
  24. How to query different post types in specific order?
  25. Conditional to modify query results
  26. wp_query to find posts by year and month
  27. How to dynamically attach pictures to a carousel
  28. Get all Posts If has same custom field values in Posts
  29. Custom Post type and Custom Field WP_Query
  30. Including Custom Meta with posts_where query
  31. Combining sorted and random CPT
  32. WP_Query: include custom post type only with specific meta value
  33. WordPress custom loop filter by meta_key and value with serialize data
  34. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  35. Rewrite and custom post type: order by custom field not working
  36. wp_query check if integer exists in custom field’s array
  37. Wp_query: sort by PHP variable
  38. How can I get the number of custom post type posts that have a specific attachment image set?
  39. Problem querying Custom post type by custom fields
  40. Orderby CPT custom fields not working
  41. Query custom post type with ACF Date
  42. Including metaboxes from custom post types in global search — continued
  43. Query Multiple Custom Posts by Custom Fields
  44. First custom field value (out of several) displayed twice after query
  45. Change sort order when using ‘orderby’ => ‘type’
  46. Possible to filter custom post type with multiple meta data?
  47. Add a custom meta box for client to order CPT posts how they want
  48. WP Query ‘posts_per_page’
  49. How to get specific post meta by title or id
  50. WP_Query orderby not work with meta_key
  51. WP_Query of custom post type sorted by meta_key has unexpected results
  52. Group by custom field value (start and end times)
  53. Post ordering not working with custom field
  54. Filtered by a custom field, ordered by another
  55. Cache issue with WP_Query and custom field filtering
  56. Displaying Portfolio Filter by Category Order (alphabetically)
  57. How do I list a custom field and custom taxonomies for each result in a loop?
  58. Custom Form / Search with Custom Post Type Data
  59. Alike Shortcode using in Custom Shortcode
  60. Query custom post type that has a serialized relational advanced custom field value
  61. WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
  62. How can I sort the results of a REST API response by the title of a connected custom post type?
  63. WP_Query get always custom post_type for first
  64. Sort custom post column by generated value?
  65. How can I query and sort custom-post type using WP_Query
  66. Filter posts by their related field’s custom field
  67. Query custom post type and custom field by URL parameters
  68. Custom meta fields not showing up in WP_Response Object via custom endpoint
  69. Query a Custom Post Type using SELECT that has ACF fields to compare dates
  70. meta query multiple values for the same key
  71. Sort custom post archives by a meta value from a different custom post type?
  72. Custom post types – meta_query: search lesson which starts sooner
  73. Wp Query sort order from custom MetaBox
  74. Post Filtered by Custom Field Value
  75. Filter custom WP_Query by first letter of a custom field – hopefully using Search and Filter Pro?
  76. sorting in wp query based on custom field value
  77. Meta_Query refuses to return results
  78. What’s the most efficient way to get two queries based on an if statement?
  79. WordPress query in which condition uses custom field
  80. WordPress loop add heading before first of type
  81. How to make a shortcode for my WP_Query Loop? [duplicate]
  82. Error in WP Query. If variable is empty it is displaying previous post value
  83. Query events post type after current date and timezone
  84. Show first posts with custom field not empty and order all by title
  85. Orderby modified only for specific post types
  86. Custom post order when using OR relation
  87. How to stop wp_query searching pages as well as the specified CPT
  88. How to display custom post type ordered by a custom field date
  89. Selecting posts older than the current Unix epoch timestamp
  90. WP_Query and two custom fields returns no posts
  91. Storing/querying custom date data
  92. Query recent posts by author
  93. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  94. Show Posts in Vertical Tabs with Scrollbar
  95. How to show all posts of specific custom post type with their custom fields values?
  96. querying to custom field over ACF REST API
  97. Order Wp Query by earliest of 3 dates meta query
  98. Display ACF object field data using Elementor Custom Query
  99. WordPress custom field sorting, weird behavior: the latest post is at the end
  100. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?