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. WP_Query orderby custom field then post_date in one query
  7. Select All in Parent Category, Group by Child Category?
  8. how to filter by last name for custom post
  9. Filtering a WP_Query meta_query by numeric values isn’t working
  10. Sorting a query by custom field date
  11. How can I generate a RSS feed based on a custom WP_Query?
  12. Filtering a WP Query result
  13. Display Custom Post Type Fields
  14. WP_Query -> sort results by relevance (= most tags / taxonomy terms in common)
  15. Search Custom Post Type with all meta attached?
  16. How to sort CPT by custom meta value (date), and return posts month by month
  17. List upcoming events, ordered by date in a custom field
  18. WP_Query on custom post type not displaying, multiple loops & get_template_part
  19. Using new WP_Query in shortcode in a custom field causes the main post content to not display
  20. WordPress query by multiple Custom fields and order by date
  21. WP_Query post at custom position
  22. Comparing timestamps in meta query doesn’t work
  23. Display two post types ordered by two custom fields
  24. Get post info inside modal window?
  25. WP Query group/order by category name
  26. query order by date on custom type: wrong order
  27. Re-order posts in query after
  28. Having trouble with custom date field for CPT query (WordPress)
  29. Display posts if a custom field value is equal to another custom field value
  30. Sort by two dates. Default entry date and custom field if present
  31. Display custom post types with custom date field value (before today) & order by custom date field
  32. How to query different post types in specific order?
  33. Conditional to modify query results
  34. Filtering by Post Meta Custom Fields – Performance
  35. wp_query to find posts by year and month
  36. WP Query—Relationship between two custom post types and their fields
  37. How to dynamically attach pictures to a carousel
  38. Get all Posts If has same custom field values in Posts
  39. Custom Post type and Custom Field WP_Query
  40. Including Custom Meta with posts_where query
  41. Combining sorted and random CPT
  42. WP_Query: include custom post type only with specific meta value
  43. WP_Query orderby modified to include custom meta changes
  44. WordPress custom loop filter by meta_key and value with serialize data
  45. Returning a list of custom post types excluding those without a specific meta_value
  46. Two near-identical custom field types – one works, the other doesn’t . What can cause this?
  47. Rewrite and custom post type: order by custom field not working
  48. wp_query check if integer exists in custom field’s array
  49. Previous/Next Link by Meta Value in CPT
  50. Wp_query: sort by PHP variable
  51. How can I get the number of custom post type posts that have a specific attachment image set?
  52. Problem querying Custom post type by custom fields
  53. Orderby CPT custom fields not working
  54. WP_Query order by custom field, then randomly order some of results
  55. Query custom post type with ACF Date
  56. How to do WP_Query with two meta fields with orderby clause
  57. Including metaboxes from custom post types in global search — continued
  58. Query Multiple Custom Posts by Custom Fields
  59. Get Posts by multiple custom fields is not working
  60. First custom field value (out of several) displayed twice after query
  61. Change sort order when using ‘orderby’ => ‘type’
  62. Possible to filter custom post type with multiple meta data?
  63. Query based on custom fields start and end date
  64. DIsplaying URL of custom field in last post of certain taxonomy && post type
  65. Add a custom meta box for client to order CPT posts how they want
  66. WP Query ‘posts_per_page’
  67. Display post from a date range from custom field
  68. post_per_page ignored in WP_Query
  69. How to get specific post meta by title or id
  70. Getting a custom post’s custom field based on another custom post’s custom field select
  71. WP_Query orderby not work with meta_key
  72. WP_Query of custom post type sorted by meta_key has unexpected results
  73. WP_Query not resetting after wp_reset_postdata
  74. Display custom post type for specific user
  75. Custom Post type loop with ACF not displaying properly
  76. Group by custom field value (start and end times)
  77. Post ordering not working with custom field
  78. Filtered by a custom field, ordered by another
  79. Cache issue with WP_Query and custom field filtering
  80. Displaying Portfolio Filter by Category Order (alphabetically)
  81. How do I list a custom field and custom taxonomies for each result in a loop?
  82. WP query_posts group by meta field related
  83. Query recent posts by author
  84. Querying meta values within an array
  85. Custom Post Type + Custom Meta Query Not Showing 2012 Posts
  86. Filter Custom post type by another Custom post type
  87. Show Posts in Vertical Tabs with Scrollbar
  88. WP_query orderby not working after WP4.0 update [closed]
  89. How to show all posts of specific custom post type with their custom fields values?
  90. querying to custom field over ACF REST API
  91. Query order by meta value force specific tag first
  92. Order Wp Query by earliest of 3 dates meta query
  93. Display ACF object field data using Elementor Custom Query
  94. WordPress custom field sorting, weird behavior: the latest post is at the end
  95. Sort CPT by taxonomy AND THEN by custom field
  96. WP Query + custom fields: How to query event posts from the current date backwards 6 months and organize it month by month?
  97. Query order by a numeric ACF field
  98. WP_Query not using relation key as expected and not producing any results
  99. Use Custom Field to Display Post Loop
  100. Query multiple post types – Order by type and post title title
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)