How to get product order by two custom taxonomy in wordpress

WordPress is notoriously against ordering by terms. Of course it’s precisely what people need to accomplish in practice. And precisely a mess with a very clunky database representation of them (which is planned to be slowly improved over several releases to be fair).

In a nutshell the issues with your query are:

  • it’s preferable to work with WP_Query, even if you are considerably customizing SQL
  • you are missing the whole third wp_term_taxonomy table 🙂

While I don’t think there is any truly canonical way to do it, the most reliable approach I had seen and used is covered in Sortable Taxonomy Columns post.

Related Posts:

  1. Get terms of posts with category with sql
  2. How to Query Database for posts with certain Taxonomy Term
  3. Return terms from multiple taxonomies using $wpdb
  4. wordpress mysql / wpdb ajax load more for terms help
  5. Get child product categories from parent product category for CUSTOM TAXONOMY archive page
  6. How to make an sql query to exclude everything but custom taxonomy terms in table wp_terms?
  7. How to permanently delete a taxonomy
  8. Using wpdb to connect to a separate database
  9. How to return number of found rows from SELECT query
  10. How to fetch Data in WordPress using MySQLi or $wpdb
  11. wpdb->insert multiple record at once
  12. How to define composite keys with dbDelta()
  13. find a random blogid across my multisite network that has at least one post published
  14. $wpdb->delete column values IN ARRAY()?
  15. Get total number of comments from posts in a specific custom taxonomy
  16. Inserting Post Meta From SQL
  17. wp_options table value
  18. Why does dbDelta() not catch MysqlErrors?
  19. What causes the “max_user_connections” warning on WordPress frontend?
  20. What are terms and taxonomy, how they related to post and how these three are stored in database?
  21. How to execute mulitple statement SQL queries using $wpdb->query?
  22. Database slowdown after update to 3.4.1
  23. Activation hook not creating table
  24. Sorting taxonomy columns by meta value numeric
  25. wpdb_prepare with multiple or condition
  26. Order by custom table and multiplication
  27. wpdb custom post_type problem
  28. WordPress database error – Error in SQL syntax – I can’t identify any error?
  29. How to adjust code to refresh a dropdown box with tags that are active on filtered category listing
  30. $wpdb: Counting posts corresponding to 3 terms in 3 different taxonomies
  31. $wpdb query a post type within a specific taxonomy term while ordering posts by custom meta value?
  32. Advanced SELECT query with condtional statements
  33. Selecting all posts from the children of a particular parent taxonomy
  34. Help With MySQL to WPDB Query Conversion
  35. What is faster: custom taxonomy or serialized post-meta for db retrieval? (over 60,000 posts)
  36. Redirecting to old domain after migration website
  37. Update results, Before deleting the related category [closed]
  38. Create table from array with prepare
  39. Term and sub term from custom post type query [closed]
  40. WordPress running SQL query to update database from form
  41. Sorting main query by custom taxonomy slug
  42. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  43. Have working sql query… trying to adjust it to use $wpdb
  44. Custom WordPress Table wpdb
  45. Best practice to limit results in get_row()?
  46. I can’t update my data through $wpdb
  47. Trouble running $wpdb->query() with last_insert_id
  48. Different Taxonomy Values for Each Post
  49. Query Column of Specific ID from Database Table
  50. How to create more than one new wpdb object?
  51. How to connect and insert data in database of wordpress?
  52. Add row to custom database Table and delete all rows older than 1 day
  53. Query custom taxonomy for category including children
  54. WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version [closed]
  55. select a single val though a table in wordpress
  56. WordPress database error: [Query was empty] – using $wpdb->prepare()
  57. Trash Bin for Categories?
  58. How to get related taxonomies based on a category with mysql query?
  59. Pull data from MySQL and add it to terms
  60. Unknown column ‘wp_posts.ID’ in ‘field list
  61. How to escape percentage sign(%) in sql query with $wpdb->prepare?
  62. Fill New Taxonomies
  63. What is my error trying to create a new table in the database?
  64. Writing a function for WP Cron to run a SQL command daily
  65. “BS_” rows in postmeta table
  66. Custom post type and custom taxonomy key lenght & query performance
  67. Using wpdb to connect to a different database is not working
  68. Where is the HTML-handler part in the wpdb class?
  69. WordPress Database Query works in phpMyAdmin but not in the code
  70. insert data from a form:: Warning Empty query mysqli::query()
  71. How can I get $wpdb to show MySQL warnings?
  72. How To connect to the same WordPress database with different database user
  73. Write mysql credentials in plugin
  74. Looking for suggestions on creating simple database (Help!!)
  75. using same mysql user with many databases
  76. MySQL database migration to WordPress
  77. Altering term_id and name via $wpdb class
  78. Returning info from MYSQL table via custom taxonomy
  79. PHP Warning: Error while sending QUERY packet
  80. Uploading to WordPress Database
  81. Putting form result in my database
  82. Custom taxonomy terms not showing as list Gutenberg Editor
  83. Using pre_get_posts to rewrite search query to display posts from multiple taxonomies
  84. How to assign default taxonomy to pages on ‘save_post’?
  85. In a loop of custom post type, display first custom taxonomy term
  86. Recent comments from my blogs only
  87. All posts are still shown when adding category argument to query
  88. dbDelta not adding additional columns in plugin database update
  89. Get all terms, including unchecked, or get the terms outside loop
  90. Show template part if part of term
  91. Basic wpdb update question
  92. Display just the Post’s parent Category, not child
  93. How to get a taxonomy by a term slug?
  94. Get taxonomy link with post type slug prefix
  95. Populate custom post type/custom fields from an external database
  96. qtranslate-x problem with custom term description
  97. MySQL Select within WP Page template
  98. two wordpress sites, two themes, one database, same content
  99. Change taxonomy of posts
  100. Update fields with post object and custom tax with wp_insert_post
techhipbettruvabetnorabahisbahis forumutaraftarium24edusedueduedueduedueduseduseduedu