Relationship between post and category is not stored in the posts table. You must extend your query for additional tables. By category id: SELECT YEAR(p.post_date) FROM {$wpdb->posts} p JOIN {$wpdb->term_relationships} tr ON tr.object_id = p.id JOIN {$wpdb->term_taxonomy} tt ON tt.term_taxonomy_id = tr.term_taxonomy_id WHERE tt.term_id = 4 AND p.post_status=”publish” AND p.post_type=”post” GROUP BY YEAR(p.post_date) DESC Or … Read more
You want display posts of a given type ({post_type}) from category ({term}) and structure of link should looks like this: {post_type} / category / {term} To avoid collisions with links to pages and “blog” posts, expression can not start with ([^/]+), but should contain slug of post type entered explicitly. This means a separate rule … Read more
Probably you have to go to Permalinks > click “Save Permalinks” and refresh that archive page to see if it solved. If not, then maybe you are using some plugin that caused the problem? deactivate all plugins and re-save permalinks and check that archive page again.
You should only need one template. What you’re describing is how things should work, if your templates are written correctly. In your case you only need taxonomy-kernal_category.php. This template will be used for all terms automatically, and the correct posts will be displayed as long as you use the standard loop: <?php if ( have_posts() … Read more
Consider removing that extra the_post(); after $the_query->the_post();. That will solve the problem. You may just use that once on the Query object. You have a custom quesry, then just call it on that exact object is required.
With a custom Page (post type page) and a custom Page Template, you can do it like so: In the templates, make a new instance of WP_Query which is used for querying the posts in either the Romanian or English language. In the query/function args for WP_Query and wp_get_archives(), use a custom parameter named lang … Read more
I’ve taken the answer from here, where they are changing the order in a different way, but it should work for you. It uses the pre_get_posts hook to change the ordering for the archive page only. add_action( ‘pre_get_posts’, ‘my_change_sort_order’); function my_change_sort_order($query){ if(is_archive()): //If you wanted it for the archive of a custom post type use: … Read more
I’ve found the problem, and now I realise I had this exact same problem years ago on a different project: This: ‘exclude_from_search’ => true Needed changing to: ‘exclude_from_search’ => false ‘has_archive’ => true, I don’t get why excluding a post type from search should affect archive templates, but at least it’s fixed now.
Is there a way to make a “normal” archive for the terms of a taxonomy? No, there isn’t. All WordPress views are queries for a post or a collection of posts. There’s zero built in functionality for an archive of terms, so you would need to implement it yourself (including pagination).
Is there a trick to get for wwx.example.com/year/category/ The main query is open to public query variables like year and cat so without pretty permalinks you could try www.example.com/?year=2022&cat=5 where 5 is the category id as an example and with pretty permalinks it would be redirected to www.example.com/2022/?cat=5