The parent field in wp_term_taxonomy links a category with its parent category. Get the id of this “Location” parent category and update the wp_term_taxonomy for every location to link them with its parent one.
Related Posts:
- Deleting All tags except categories Wp database
- Modify WordPress SQL Query to pull from within a category
- batch adding posts to a category based on matching regex for title with SQL
- SQL to migrate post types to taxonomy
- Custom SQL Query: Get all posts with category id and a concated list of tags on each post
- Get posts under a category with SQL
- Get a count of how many times a term or a category is used in posts
- SQL query to return categories and category parents
- Overriding default calendar to show posts from a category
- SQL query to get posts from multiple categories but not in a category
- Get category from slug list
- Bulk Change WordPress category Slug
- Help with SQL query, how to add taxonomie terms with value stored in options?
- finding out the top 5 source ( source is a custom taxonomy ), in a given category
- How to create an automatic MultiColoumn MegaMenu with Categories WordPress
- Is There a Difference Between Taxonomies and Categories?
- List all subcategories from category
- How To Find Out WordPress Category Table in MYSQL?
- Add custom field to Category
- Get Category ID inside Category template
- Only one category per post
- WordPress Multisite – global categories
- Get the children of the parent category
- Get posts from sites in Multisite?
- WP REST API: filter by category 1 AND category 2
- How To Get Parent Category Slug of Current Post
- Display All Products by Category with WooCommerce
- What is the difference between a “tag” and a “category”?
- Is there an easy way to make a meta box have the tabs like the Categories meta box has?
- How to check if I’m on the last page of posts?
- Display posts from the same category using next/previous post link
- How would I get a taxonomy/category list inside a Gutenberg block?
- Can I set a default featured image for a category?
- Check if a post is in any child category of a parent category
- How to export and import taxonomies (category, tag and/or custom taxonomy) and their terms
- Force category choice before creating new post?
- Gutenberg editor add a custom category as wrapper for custom blocks
- WooCommerce: List All Categories
- How to get category and archive title?
- Get category ID from category slug (not working)
- How do I remove “Uncategorized” from posts with more than 1 category?
- Get rid of WordPress category, tag and author archives?
- Individual rss feed entry length for categories?
- How can I create a category landing page followed by pages of posts?
- Remove parent category from permalink? Basically only have the child category?
- Custom permalink structure leads to be 404 on pagination
- Retrieve Product category ‘NAME’ by product category ID – WooCommerce?
- Posts URL structure like site.com/category/the-post-title
- Can’t custom taxonomies have same terms (slugs) as categories?
- How to get permalinks with category base working with sub-categories
- How to remove the term “category” from category pagination?
- Using wp_category_checklist in a widget
- WP 3.9 TinyMCE no longer loads on category description editor
- On the category page, get the category object
- Get only the top level categories using get_categories() without foreach loop
- Get all categories and posts in those categories
- How to add featured image for category (without a plugin)?
- How to create a custom sort for WordPress categories
- How to display non-hierarchical taxonomy as terms with checkboxes?
- Category archive by year with permalink support /category/YYYY
- Best Way to Redirect Category to Page and Hide Category
- get_terms vs. get_categories: does it matter?
- What is a good robots.txt?
- Allow users to create their own feed from selected categories?
- Hook when category is added to post
- get_categories for custom post type with a specific custom taxonomy attached
- Add a URL prefix to permalinks of one category of posts only
- How do you add categories to custom post types in WordPress?
- Create a category list page
- Catch 404 after changing permalink structure from /%postname%/ to /%category%/%postname%/
- Woocommerce get category image full size
- exclude category from get_posts?
- How To Modify The Loop in archives.php To Have 11 Posts Per Page and CSS Styling
- How can I hide a category from Contributors in the edit/add new post screen?
- Order get_terms() By Custom Field
- WordPress Multiple Category Search
- Should category.php and The Loop be used if the query needs to be customizable?
- How do the ‘tag’ and ‘category’ (default) taxonomies do ‘save_post’ action?
- How to Change the Categories Order in the Admin Dashboard?
- Control term order on a per-post basis
- How to remove categories filter from wordpress admin?
- get all tags from category
- Could not insert term into the database
- How can I add the featured image functionality to a custom taxonomy?
- Activate Gutenberg in category-descriptions
- Filter by post category in Media Library
- Filtering categories in the permalink structure
- Share one taxonomy across multiple blogs in 3.0 [duplicate]
- 404 Error On Category and Tags Pages
- How to show subcategories in categories else show posts
- Allow duplicate permalink slugs for posts in different categories
- Exclude the category from the WordPress loop
- get_categories hierarchical order like wp_list_categories – with name, slug & link to edit cat
- How to make child categories recognize parent’s template displays
- Force WordPress to Show Pages Instead of Category
- Completely disable categories
- How do I get the category URL from get_the_category?
- Display Image for a category using get_categories, or show an image from any child post
- Remove / Rename Uncategorized Category In WordPress
- Fixing category count