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. Sort Order for a Custom Query in a Post Type Archive Not Working
  5. WP_Query orderby custom field then post_date in one query
  6. Select All in Parent Category, Group by Child Category?
  7. how to filter by last name for custom post
  8. Filtering a WP_Query meta_query by numeric values isn’t working
  9. Sorting a query by custom field date
  10. How can I generate a RSS feed based on a custom WP_Query?
  11. Filtering a WP Query result
  12. Display Custom Post Type Fields
  13. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  14. Search Custom Post Type with all meta attached?
  15. How to sort CPT by custom meta value (date), and return posts month by month
  16. Using new WP_Query in shortcode in a custom field causes the main post content to not display
  17. WordPress query by multiple Custom fields and order by date
  18. Comparing timestamps in meta query doesn’t work
  19. Display two post types ordered by two custom fields
  20. Get post info inside modal window?
  21. query order by date on custom type: wrong order
  22. Having trouble with custom date field for CPT query (WordPress)
  23. Display posts if a custom field value is equal to another custom field value
  24. Sort by two dates. Default entry date and custom field if present
  25. How to query different post types in specific order?
  26. Conditional to modify query results
  27. Filtering by Post Meta Custom Fields – Performance
  28. WP Query—Relationship between two custom post types and their fields
  29. How to dynamically attach pictures to a carousel
  30. Get all Posts If has same custom field values in Posts
  31. Custom Post type and Custom Field WP_Query
  32. WP_Query orderby modified to include custom meta changes
  33. Returning a list of custom post types excluding those without a specific meta_value
  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. Previous/Next Link by Meta Value in CPT
  38. Wp_query: sort by PHP variable
  39. How can I get the number of custom post type posts that have a specific attachment image set?
  40. WP_Query order by custom field, then randomly order some of results
  41. How to do WP_Query with two meta fields with orderby clause
  42. Including metaboxes from custom post types in global search — continued
  43. Get Posts by multiple custom fields is not working
  44. Query based on custom fields start and end date
  45. DIsplaying URL of custom field in last post of certain taxonomy && post type
  46. Add a custom meta box for client to order CPT posts how they want
  47. WP Query ‘posts_per_page’
  48. Display post from a date range from custom field
  49. How to get specific post meta by title or id
  50. Getting a custom post’s custom field based on another custom post’s custom field select
  51. WP_Query orderby not work with meta_key
  52. WP_Query of custom post type sorted by meta_key has unexpected results
  53. WP_Query not resetting after wp_reset_postdata
  54. Custom Post type loop with ACF not displaying properly
  55. Group by custom field value (start and end times)
  56. Filtered by a custom field, ordered by another
  57. Cache issue with WP_Query and custom field filtering
  58. Displaying Portfolio Filter by Category Order (alphabetically)
  59. How do I list a custom field and custom taxonomies for each result in a loop?
  60. Custom Form / Search with Custom Post Type Data
  61. Create if else for post types in WP_Query ‘post__in’ values
  62. Alike Shortcode using in Custom Shortcode
  63. Query custom post type that has a serialized relational advanced custom field value
  64. WP Admin Dropdown List Filter for custom (ACF) field on custom post type(s)
  65. How can I sort the results of a REST API response by the title of a connected custom post type?
  66. WP_Query get always custom post_type for first
  67. Sort custom post column by generated value?
  68. How can I query and sort custom-post type using WP_Query
  69. Filter posts by their related field’s custom field
  70. Query custom post type and custom field by URL parameters
  71. Custom meta fields not showing up in WP_Response Object via custom endpoint
  72. Query a Custom Post Type using SELECT that has ACF fields to compare dates
  73. meta query multiple values for the same key
  74. Custom post types – meta_query: search lesson which starts sooner
  75. Wp Query sort order from custom MetaBox
  76. Post Filtered by Custom Field Value
  77. Filter custom WP_Query by first letter of a custom field – hopefully using Search and Filter Pro?
  78. sorting in wp query based on custom field value
  79. Meta_Query refuses to return results
  80. WordPress query in which condition uses custom field
  81. WordPress loop add heading before first of type
  82. How to make a shortcode for my WP_Query Loop? [duplicate]
  83. Error in WP Query. If variable is empty it is displaying previous post value
  84. Query events post type after current date and timezone
  85. Show first posts with custom field not empty and order all by title
  86. Orderby modified only for specific post types
  87. Calling specific page with wp query
  88. How to stop wp_query searching pages as well as the specified CPT
  89. How to display custom post type ordered by a custom field date
  90. Order Custom Posts by Several Fields
  91. WP_Query and two custom fields returns no posts
  92. Storing/querying custom date data
  93. Show Posts in Vertical Tabs with Scrollbar
  94. How to show all posts of specific custom post type with their custom fields values?
  95. querying to custom field over ACF REST API
  96. Query order by meta value force specific tag first
  97. Order Wp Query by earliest of 3 dates meta query
  98. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?
  99. Query order by a numeric ACF field
  100. WP_Query not using relation key as expected and not producing any results