Query Posts by taxonomy/Taxonomy Child Custom order

Just answering bit by bit here and will add any optimisations I see as I go:

1) $termsreg = get_terms("region",array('orderby' => 'slug', 'order' => 'ASC')); can be run above the foreach loop. There is no need to run this however many times.

2) Are “all” your hotels that you have in your custom post type get listed somewhere in this page? If during this double loop all your hotels are at least shown once then it would be better to get all you hotels loaded first into an array along with the tax’s they belong to. then in the foreach check against the data you already received and then then show the hotel rather than grabbing it from the DB each time. What I’d do to get the hotel data in the first place would be to a custom SQL query to make sure I only pulled the data I needed and to pull both associated tax’s.

Thats all I come up with for now.

Related Posts:

  1. Using wp_query is it possible to orderby taxonomy?
  2. How to use taxonomies on attachments with the new Media Library?
  3. How to add images to taxonomies?
  4. Can you add the visual editor to the description field for custom taxonomies?
  5. Check if a post has any term in this custom taxonomy?
  6. custom post type taxonomy “tag” archive : no post found
  7. Add custom taxonomy fields when creating a new taxonomy
  8. Contact Form 7 – Populate Select List With Taxonomy [closed]
  9. How to display custom taxonomies in posts?
  10. Get taxonomy names by post id
  11. Creating Custom Taxonomy without mapping to any post type
  12. Why is my working Custom Taxonomy not in get_taxonomies array?
  13. Custom taxonomy hide meta box but show in menu
  14. display posts with same taxonomy term
  15. Exclude specific slug in ‘get_terms’
  16. wp_insert_term – parent & child problem
  17. Is there a way to disable a term rather than deleting it?
  18. Widget to display custom taxonomy tag cloud
  19. Modify Term Update Redirection
  20. Hook to process a new taxonomy tag before it is created?
  21. Return only the custom sub-term for custom post type, do not echo term-parent
  22. Get total number of comments from posts in a specific custom taxonomy
  23. Custom taxonomy on permalink
  24. Check if current term is a child of another term
  25. Custom hierarchal taxonomy loses interface hierarchy when selecting parent & children
  26. get_terms() doesn’t return empty terms even though hide_empty is false
  27. How do I filter posts by taxomony using AJAX
  28. SQL QUERY needed to get POST category (taxonomy) ? – MUST be SQL statement
  29. Remove Category description textarea
  30. Formating the_terms() function output
  31. Archive template for taxonomy terms
  32. Multiple users – only allow them to manage their own terms for custom taxonomy when logged in
  33. Custom taxonomy on users with UI
  34. How to return a list of custom taxonomy terms via the Gutenberg getEntityRecords method
  35. Create taxonomy with meta term using the WP Rest Api
  36. wp_options table value
  37. Custom Taxonomy Only Showing Top Level Terms in Admin?
  38. How can I set up a category “overview” page?
  39. Post tags saving as both tag name & tag ID on post update when tags are displayed as checkboxes
  40. Sort posts by number of matched terms
  41. Get current term’s ID
  42. Is it possible to get a Previous/Next Taxonomy term archive URL?
  43. Looping Through Custom Tax Terms and Displaying All Posts For Each
  44. Taxonomy Relationships
  45. Possible to register multiple custom taxonomies in one function?
  46. How to get the top most term (top ancestor) of a custom taxonomy child term?
  47. Taxonomies not appearing in columns on dashboard
  48. Combine multiple custom user taxonomy in single url
  49. How to modify default taxonomy field to a single text field?
  50. Add custom taxonomy to default category taxonomy?
  51. How to set hierarchical terms to a post using wp_set_object_terms
  52. Echo taxonomy term meta on author.php
  53. Hierarchical display of custom taxonomy
  54. How do I display a tag cloud with both post tags AND a custom taxonomy?
  55. Adding session variable and/or cookie based on user-selected input
  56. How to output the taxonomy term name in a widget
  57. How to link categories to custom taxonomy terms?
  58. List taxonomy / category count showing list published posts only
  59. Alternative for is_taxonomy() to workaround theme’s default sidebar
  60. What is the current page’s Taxonomy?
  61. Loop custom post type by taxonomy (Category)
  62. Any way to make custom taxonomy field searchable?
  63. Get custom taxonomy term url on archive page
  64. Custom Taxonomy Template Variables Available?
  65. query posts returns 10 records
  66. get_terms() – unexpected ‘=>’ (T_DOUBLE_ARROW) error
  67. Display woocommerce product_cat child terms with thumbnails
  68. get_term_children specific no id
  69. query grandchildren taxonomy terms
  70. Custom Search only for my Custom Taxonomy Page – data
  71. Insert taxonomy term to different table
  72. Getting taxonomies specific to categories
  73. Remove Tag Cloud Words from Custom Taxonomy
  74. How to add/enqueue Custom CSS for a custom taxonomy page?
  75. wp_get_object_terms count on taxonomies within an category archive
  76. Adding new terms to custom taxonomy
  77. Group custom taxonomies based on tags contained in their posts
  78. Make custom post type display with custom taxonomy in url
  79. Prevent random entries in hierarchical false taxonomies
  80. Exporting CSV of users with custom user taxonomies out of WordPress
  81. How do I create a term for every value of a post meta?
  82. Taxonomies starting with a hyphen (minus) to assign B.C. dates to a post
  83. is_tax not working for custom taxonomy
  84. Querying posts globally based on custom taxonomy with its own taxonomymeta table
  85. Add custom display condition to Elementor Theme Builder for custom taxonomy children, grandchildren, and great-grandchildren
  86. Save selected terms in order of custom taxonomy in post
  87. How to delete unused terms?
  88. Add text in custom taxonomy
  89. How do I check if a post has a term with a particular ancestor/parent?
  90. Child terms with improper parent in the url should redirect to 404
  91. Taxonomy entries are spawning copies of existing entries with the new title as the existing ID, since upgrade
  92. How to get parent and child name in taxonomy page
  93. How to enforce a requirement for custom taxonomy
  94. Issue with WordPress Automatically Assigning Terms to Multiple Posts
  95. Change taxonomy key of existing and future taxonomy posts
  96. Cannot set custom taxonomies when creating post
  97. How to call parent and child category name in separate div?
  98. Taxonomy archives based on Custom Post Types
  99. Creating a page that will dynamically get posts from 2 taxonomies
  100. Hiearchical terms structure and performance
Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)