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 add images to taxonomies?
  3. Can you add the visual editor to the description field for custom taxonomies?
  4. custom post type taxonomy “tag” archive : no post found
  5. Get taxonomy names by post id
  6. Return only the custom sub-term for custom post type, do not echo term-parent
  7. Get total number of comments from posts in a specific custom taxonomy
  8. Check if current term is a child of another term
  9. Custom hierarchal taxonomy loses interface hierarchy when selecting parent & children
  10. get_terms() doesn’t return empty terms even though hide_empty is false
  11. Formating the_terms() function output
  12. Custom taxonomy on users with UI
  13. Post tags saving as both tag name & tag ID on post update when tags are displayed as checkboxes
  14. Taxonomy Relationships
  15. How to get the top most term (top ancestor) of a custom taxonomy child term?
  16. Combine multiple custom user taxonomy in single url
  17. Add custom taxonomy to default category taxonomy?
  18. Display sub-taxonomies based on SELECTED parent-taxonomy
  19. Checking if a Page has an Associated Term?
  20. What are terms and taxonomy, how they related to post and how these three are stored in database?
  21. Taxonomy , subtaxonomy,child taxonomy of a product woocommerce
  22. Get terms ordered by post date
  23. How to display custom taxonomy in multiple columns?
  24. Custom taxonomies making WP very slow – Way to fix?
  25. Removing the “Popular Terms” area from the Taxonomy Edit Screen in the Admin Area
  26. Sorting taxonomy columns by meta value numeric
  27. Programatically added attribute, set to ‘show on product page’ automatically. Woocommerce [closed]
  28. ACF vs Taxonomies
  29. Reverse traversing taxonomy based on term_id
  30. How to filter terms from a custom taxonomy by a usermeta value on all screens and templates
  31. Get Current Custom Taxonomy ID by Post ID
  32. Taxonomy archive showing no results
  33. Use get_the_terms to list subcategories of custom taxonomy
  34. I used the Tax-meta-class by bainternet but i still can’t get it to display any of the results.
  35. Autogenerate Front End Form Field With jQuery
  36. Custom taxonomy [year] is directing to yearly archive
  37. Display Taxonomy Terms in an option tag with value being the slug
  38. Changing taxonomy term by slug (wp_update_term)
  39. Modify “View” in admin panel for custom taxonomy
  40. Taxonomies on custom taxonomies
  41. How to join result of different taxonomies?
  42. Hide product categories and taxonomy terms in menu if empty
  43. Custom taxonomy forms for user profile
  44. How to add Post Format Taxonomy Archive page in the menu?
  45. How to Rewrite Taxonomy URL to Include the Post Type as the Second Segment of the URL?
  46. How to get all taxonomies which can be added in menu?
  47. get the taxonomies terms associated with users
  48. Add Taxonomy Subcategory To Permalink
  49. Replace taxonomy permalinks
  50. Custom Taxonomy Term Archive Page Template that Filters 2 or more Taxonomies
  51. Create custom taxonomy and Display in metabox dropdown
  52. Custom Taxonomy with tax_query
  53. Override Taxonomy Template
  54. Get posts in certain Taxonomy terms for the current page url
  55. Trying to add taxonomy to get_categories() but it’s not working. How to fix this?
  56. Edit custom taxonomy description programatically
  57. Get taxonomy name for the current post
  58. View the complete list of a taxonomy in the navigation menu
  59. Get name of taxonomies of current page
  60. Filter through custom taxonomy with an array of taxonomy IDs
  61. Add custom taxonomy as a css class
  62. Taxonomy archive template that shows posts from more than one taxonomy
  63. Taxonomy page shows category in title
  64. Query custom taxonomy for category including children
  65. Taxonomy Overview Page?
  66. Order taxonomy terms wordpress
  67. Only display latest custom taxonomy post
  68. Unable to get the Parent Custom Taxonomy Terms
  69. How to get the term description in a taxonomy term archive query?
  70. Unsetting post_tag taxonomy breaks term description for other taxonomies
  71. Taxonomies on Pages with Custom Formatting
  72. How to combine taxonomies into URL?
  73. Why do my quick edits for custom taxonomies not show on the post frontend?
  74. Prioritise Pages over Taxonomy Term Root Archive, but not Taxonomy Term Child Archives
  75. Tracking the name of a custom taxonomy
  76. Add terms to a taxonomy archive from within the same taxonomy
  77. Show recent posts from a custom taxonomy in wordpress
  78. new custom filed not showing in taxonomy
  79. Fill New Taxonomies
  80. how do you pull data from two taxonomies?
  81. problem : Custom taxonomy template not showing
  82. Filter “get_terms” query
  83. How To Create Dynamic Permalink To Custom Taxonomy List of Current Posts?
  84. Dropdown (with onChange) with custom taxonomies
  85. generate random slug when adding taxonomy
  86. ACF Custom field not showing in Timber Taxonomy page
  87. How to get a terms and posts associated with another term?
  88. Displaying subcategories and then posts in taxonomy template
  89. How to use two same taxonomy in same post differently?
  90. Sort Taxonomy List by Custom Values
  91. Can I use multi (sub) levels of relation (AND | OR) on custom query?
  92. How to display custom taxonomy
  93. Taxonomy term breadcrumb; how?
  94. Advanced AND tax_query in sidebar with 2 taxonomies
  95. Using wp_query is it possible to orderby taxonomy?
  96. Alternative for is_taxonomy() to workaround theme’s default sidebar
  97. Custom Taxonomy Template Variables Available?
  98. Adding new terms to custom taxonomy
  99. Group custom taxonomies based on tags contained in their posts
  100. Taxonomies starting with a hyphen (minus) to assign B.C. dates to a post