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. Issue with WordPress Automatically Assigning Terms to Multiple Posts
  83. SQL errors when querying for something with apostrophes
  84. Custom taxonomies not showing up in admin menu
  85. Search only custom taxonomies
  86. Custom taxonomies mixed into categories and tags in Post edit page
  87. Best way to redirect taxonomy terms to pages
  88. Optimizing function that automatically creates internal links based on post title string
  89. Using Advanced Custom Fields Relationship Field to select a taxonomy term
  90. Moving WordPress site to new domain – database import [duplicate]
  91. Create alphabetical Pagination for custom taxonomy?
  92. List Top 5 taxonomy terms based on number of post
  93. How to use AJAX in WordPress in MYSQL query?
  94. How to get attached image to taxonomy..?
  95. Loop through custom taxanomy in post and display custom fields from posts
  96. pagination not working on custom-taxonomy template
  97. Update multiple rows in one query
  98. delete term from taxonomy and assign in new one
  99. Understanding custom php that reads from WP MYSQL
  100. How to show post list based on taxonomy term?
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)