Title: SHORTCODE – include_cat_IDs works incorrect Last modified: August 23, 2020 --- # SHORTCODE – include_cat_IDs works incorrect * Resolved [JelStein](https://wordpress.org/support/users/jelstein/) * (@jelstein) * [5 years, 8 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/) * On my installation when using the shortcode ► include_cat_IDs ◄ works incorrect * I can only work with two categories : cat_ID 10 and 6 All other values like 36 or 4051 do not work… * this is the one that works: * [tptn_list heading=’0′ how_old=14 include_cat_ids=”10″ show_date = ‘1’ limit=’ 5′ disp_list_count = ‘0’] * please advise Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/page/2/?output_format=md) [→](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/page/2/?output_format=md) * Plugin Author [WebberZone](https://wordpress.org/support/users/webberzone/) * (@webberzone) * [5 years, 8 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13313822) * It should be in small so include_cat_ids * [https://webberzone.com/support/knowledgebase/top-10-shortcodes/](https://webberzone.com/support/knowledgebase/top-10-shortcodes/) * Thread Starter [JelStein](https://wordpress.org/support/users/jelstein/) * (@jelstein) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13887965) * I only wrote ID in capitals in my text NOT in the shortode parameters (see my example) * It really does not work! * Plugin Author [Ajay](https://wordpress.org/support/users/ajay/) * (@ajay) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13888883) * Can you please let me know what you’re expecting to see and what you see? * This should limit the posts to only the ones in those categories. Are you seeing posts from outside of the categories? * Are you in a position to install Query Monitor plugin and then see what query is being generated? * Thread Starter [JelStein](https://wordpress.org/support/users/jelstein/) * (@jelstein) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13889187) * I expect output based on the single cat_id which I supply. However nothing comes up * I only get results when I use cat id 6 or cat id 10 All other cat id’s result in nothing on screen. * I have several other cat id’s which dó have content records. * [I will look into the oossibility of installing the Query Monitor ] * Plugin Author [Ajay](https://wordpress.org/support/users/ajay/) * (@ajay) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13890940) * I just realised one thing as well. Can you also check that your cat ID is the same as the term_taxonomy_id and use that if needed? * I’m not sure how old your site is, but previously the term_id could have differed from the term_taxonomy_id – the latter is unique. * Query Monitor should help me see what the exact query is. * Thread Starter [JelStein](https://wordpress.org/support/users/jelstein/) * (@jelstein) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13893052) * I use the plugin * 1. the output of the query monitor for a WORKING QUERY : * Shortcode is: [tptn_list heading=’0′ how_old=35 include_cat_ids=”6″ show_date = ‘1’ limit=’14’ disp_list_count = ‘0’] * query = * SELECT DISTINCT wp_top_ten.postnumber, wp_top_ten.cntaccess as sum_count, wp_posts. ID FROM wp_top_ten INNER JOIN wp_posts ON wp_top_ten.postnumber=wp_posts.ID WHERE 1=1 AND wp_top_ten.blog_id = 1 AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘inherit’) AND wp_posts.post_type IN (‘post’, ‘page’, ‘ attachment’, ‘event’) AND wp_posts.post_date > ‘2020-12-06 17′ AND wp_posts.ID IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (6)) ORDER BY sum_count DESC LIMIT 0, 70 * 2. the output of the query monitor for a NON_ WORKING QUERY : (output is nothing) * Shortcode is: [tptn_list heading=’0’ how_old=35 include_cat_ids=”362″ show_date = ‘1’ limit=’14’ disp_list_count = ‘0’] * query = * SELECT DISTINCT wp_top_ten.postnumber, wp_top_ten.cntaccess as sum_count, wp_posts. ID FROM wp_top_ten INNER JOIN wp_posts ON wp_top_ten.postnumber=wp_posts.ID WHERE 1=1 AND wp_top_ten.blog_id = 1 AND (wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘inherit’) AND wp_posts.post_type IN (‘post’, ‘page’, ‘ attachment’, ‘event’) AND wp_posts.post_date > ‘2020-12-06 17’ AND wp_posts.ID IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (362)) ORDER BY sum_count DESC LIMIT 0, 70 - This reply was modified 5 years, 3 months ago by [JelStein](https://wordpress.org/support/users/jelstein/). * Plugin Author [Ajay](https://wordpress.org/support/users/ajay/) * (@ajay) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13893738) * Thanks for this – the query looks as I expected and I note the difference between the two is the 362 and the 6. My read is that the plugin cannot find any posts that are in taxonomy 362 that were published after 6th December 2020. * One option to see if the publish-date is the issue is removing the how_old parameter above and seeing if it gives results. * You might be able to double-check what is the output when you run the sub-query in phpMyAdmin. This would give the post IDs from this category. * ``` SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (362) ``` * And, then see if any of these IDs are posts that were published since 6th December 2020. These are also the IDs that should be the postnumber column of wp_top_ten_daily * [clsklvr](https://wordpress.org/support/users/clsklvr/) * (@clsklvr) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13918247) * Hey, it seems like my custom settings are ignored by CRP. This are the queries that are generared: * SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.term_taxonomy_id = 58 LIMIT 1 * ————– * SELECT wp_posts.*, MATCH (wp_posts.post_title) AGAINST (‘⸺ Outdoorknives Magazin⸺’) as score FROM wp_posts WHERE 1=1 AND ( ( wp_posts.post_date >= ‘1993-09-02 00: 00:00’ AND wp_posts.post_date <= ‘2021-01-17 13:01:03’ ) ) AND wp_posts.ID NOT IN (89,30,3248,303,20,541,542,539,3282,540,3281,3283,4801,4738,4917,3247,3248,540,3276,30) AND ( 0 = 1 ) AND wp_posts.post_type = ‘page’ AND ((wp_posts.post_status = ‘publish’ OR wp_posts.post_status = ‘inherit’)) AND MATCH (wp_posts.post_title) AGAINST(‘⸺ Outdoorknives Magazin ⸺’) GROUP BY wp_posts.ID ORDER BY score DESC LIMIT 0, 18 * I normaly match also against the content, that I excluded here to make the query a little bit shorter. * I added CRP as Gutenberg Blocks. In the Block Settings I added _include\_cat\ _ids=58_ for this Element. * All my taxonomies are tags related to pages. I have multiple CRP Elements on each page including the autogenerated CRP. * It works fine with CRP 2.9.4 and the “Related Posts by Categories and Tags” plugin. * With CRP 2.9.4 the query looks like this * SELECT DISTINCT wp_posts.ID, wp_posts.post_date FROM wp_posts WHERE 1=1 AND MATCH (post_title,post_content) AGAINST (‘⸺ Outdoorknives Magazin ⸺ Outdoorknives are knives ……………….…’) AND wp_posts.post_date < ‘2021-01-17 13:20:48’ AND wp_posts. post_date >= ‘1993-09-02 13:20:48’ AND wp_posts.post_status IN (‘publish’,’inherit’) AND wp_posts.ID != 30 AND wp_posts.ID NOT IN (89,30,3248,303,20,541,542,539,3282,540,3281,3283,4801,4738,4917,3247,3248,540,3276) AND wp_posts.post_type IN (‘page’) AND wp_posts.ID IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (58) ) LIMIT 0, 18 * Best Cls - This reply was modified 5 years, 3 months ago by [clsklvr](https://wordpress.org/support/users/clsklvr/). - This reply was modified 5 years, 3 months ago by [clsklvr](https://wordpress.org/support/users/clsklvr/). - This reply was modified 5 years, 3 months ago by [clsklvr](https://wordpress.org/support/users/clsklvr/). * Plugin Author [Ajay](https://wordpress.org/support/users/ajay/) * (@ajay) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13919340) * [@clsklvr](https://wordpress.org/support/users/clsklvr/) * There is a difference between 2.9.4 which constructed its own query and 3x which uses WP_Query’s for the include_cat_ids. * I ran some tests on my own install using the Gutenberg block and adding include_cat_ids =25 (in my case I had to use 25) and got this query – note there are a lot more extra conditions because of my tests. But the two main things to point that bring about the include_cat_ids is LEFT JOIN and then the `wp_term_relationships.term_taxonomy_id IN (25)` * You should be able to see this when you use 3x * ``` SELECT wp_posts.*, MATCH (wp_posts.post_title) AGAINST ('format') as score FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( ( wp_posts.post_date >= '1991-01-25 00:00:00' AND wp_posts.post_date <= '2021-01-17 21:33:31' ) ) AND wp_posts.ID NOT IN (562,903,1333) AND ( wp_term_relationships.term_taxonomy_id IN (25) AND wp_posts.ID NOT IN ( SELECT object_id FROM wp_term_relationships WHERE term_taxonomy_id IN (10) ) ) AND wp_posts.post_type IN ('post', 'page', 'attachment', 'wz_knowledgebase') AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'inherit')) AND MATCH (wp_posts.post_title) AGAINST ('format') GROUP BY wp_posts.ID ORDER BY score DESC LIMIT 1, 6 ``` * [clsklvr](https://wordpress.org/support/users/clsklvr/) * (@clsklvr) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13919380) * I was wondering if CRP may only be included once per page, because I was wondering why all the crp queries e.g. on my startpage looks the same although there is the standard CRP and some custom CRP with specific taxonomies embeded. * But also on a fresh new page with CRP deactivated for this page, the query of 3x looks like this: * ``` SELECT wp_posts.*, MATCH (wp_posts.post_title,wp_posts.post_content) AGAINST ('Casström ') as score FROM wp_posts WHERE 1=1 AND ( ( wp_posts.post_date >= '1993-09-02 00:00:00' AND wp_posts.post_date <= '2021-01-17 21:52:25' ) ) AND wp_posts.ID NOT IN (89,30,3248,303,20,541,542,539,3282,540,3281,3283,4801,4738,4917,3247,3248,540,3276,5005) AND ( 0 = 1 ) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'inherit')) AND MATCH (wp_posts.post_title,wp_posts.post_content) AGAINST ('Casström ') GROUP BY wp_posts.ID ORDER BY score DESC LIMIT 0, 6 ``` * There is no LEFT JOIN and no wp_term_relationships.term_taxonomy_id IN. * Do I have to deactivate the “Related Posts by Categories and Tags” plugin maybe?– No does not work either. * Best Cls - This reply was modified 5 years, 3 months ago by [clsklvr](https://wordpress.org/support/users/clsklvr/). * Plugin Author [Ajay](https://wordpress.org/support/users/ajay/) * (@ajay) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13919617) * Where exactly have you put the include_cat_ids=58? * Can you also try the shortcode (as a test) and check the query? Also, I assume that you have the caching disabled in the plugin settings page? * [clsklvr](https://wordpress.org/support/users/clsklvr/) * (@clsklvr) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13924602) * Yes, caching is disabled. * When the CRP Gutenberg Block is inserted, there is a field in the Block-Settings named “Other attributes”. Here I added “include_cat_ids=58”. * I also tested it with the shortcode now. It does not work with 3x, only with 2.9.4. The query with 3x is * ``` SELECT wp_posts.*, MATCH (wp_posts.post_title,wp_posts.post_content) AGAINST ('Casström ') as score FROM wp_posts WHERE 1=1 AND ( ( wp_posts.post_date >= '1993-09-03 00:00:00' AND wp_posts.post_date <= '2021-01-18 22:52:45' ) ) AND wp_posts.ID NOT IN (89,30,3248,303,20,541,542,539,3282,540,3281,3283,4801,4738,4917,3,3247,3248,540,3276,5005) AND ( 0 = 1 ) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'inherit')) AND MATCH (wp_posts.post_title,wp_posts.post_content) AGAINST ('Casström ') GROUP BY wp_posts.ID ORDER BY score DESC LIMIT 0, 6 ``` * Plugin Author [Ajay](https://wordpress.org/support/users/ajay/) * (@ajay) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13927849) * Thanks [@clsklvr](https://wordpress.org/support/users/clsklvr/) * I have to admit, that I am thoroughly confused as to why this is the case. You’ve definitely put it in the correct place as did I in my testing. I tried it on another install and it worked fine as expected. * Are you able to test this on other posts and see what happens? * On a very small point, just wanted to clarify that you just used `include_cat_ids =58` without any kind of quotes. * [clsklvr](https://wordpress.org/support/users/clsklvr/) * (@clsklvr) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13927934) * I tested it with quotes and without and also in a new post or page in my case. * Hm, this is strange. I will also start debugging at the weekend and I tell you, if I find something out. * Thanks you for your effort so or so! * Best, Cls * [clsklvr](https://wordpress.org/support/users/clsklvr/) * (@clsklvr) * [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/#post-13939089) * Hey [@ajay](https://wordpress.org/support/users/ajay/), * I printed in the `public function posts_where( $where, $query ) {...}` the array` $this->query_args` and the query string in `$where`: * `Array ( [include_cat_ids] => 58 [include_post_ids] => 0 [offset] => 0 [postid] => 30 [strict_limit] => [cache_posts] => 0 [cache] => 0 [add_to] => Array ( [ page] => page ) [content_filter_priority] => 999 [insert_after_paragraph] => - 1 [disable_on_mobile] => 0 [disable_on_amp] => 0 [uninstall_options] => 0 [uninstall_indices] => 0 [uninstall_indices_deactivate] => 0 [show_metabox] => 1 [show_metabox_admins] => 0 [show_credit] => 0 [limit] => 6 [daily_range] => 9999 [ordering] => random[ random_order] => [match_content] => 1 [match_content_words] => 0 [post_types] => page [same_post_type] => 0 [same_author] => 0 [exclude_post_ids] => 89,30,3248,303,20,541,542,539,3282,540,3281,3283,4801,4738,4917,3[ exclude_cat_slugs] => [exclude_categories] => [exclude_output_header] => 0 [exclude_on_post_ids] => [exclude_on_post_types] => [html_wrapper_header] => 0 [post_thumb_op] => inline[ thumb_size] => crp_thumbnail [thumb_width] => 325 [thumb_height] => 217 [thumb_crop] => 1 [thumb_create_sizes] => 1 [thumb_html] => html [thumb_meta] => post-image[ scan_images] => 1 [thumb_default_show] => 1 [thumb_default] => http://hostingkunde. de/wp-content/plugins/contextual-related-posts/default.png [crp_styles] => rounded_thumbs[ custom_css] => .related-posts-headline { margin-bottom: 10px !important; } [feed_options_desc] => 0 [limit_feed] => 5 [show_excerpt_feed] => 0 [post_thumb_op_feed] => text_only[ thumb_width_feed] => 250 [thumb_height_feed] => 250 [exclude_on_cat_slugs] =>[ exclude_on_categories] => [same_taxes] => post_tag [match_all] => 0 [no_of_common_terms] => 1 [disable_contextual] => 0 [disable_contextual_cpt] => 1 [crpt_same_taxes] => [crpt_match_all] => 0 [crpt_no_of_taxes] => 1 [crpt_disable_contextual] => 0 [crpt_disable_contextual_cpt] => 1 [is_widget] => [is_shortcode] => [is_manual] => [is_block] => 1 [echo] => 1 [heading] => [extra_class] => add-bottom-40 [more_link_text] => [other_attributes] => include_cat_ids=58 [className] => add-bottom-40 [crp_query] => 1 [suppress_filters] => [ignore_sticky_posts] => 1 [no_found_rows] => 1 [posts_per_page] => 18 [taxonomy_count] => 1 [tax_query] => Array ( [0] => Array ( [taxonomy] => category [field] => term_taxonomy_id [terms] => Array ( [0] => 58 ) ) ) [post_type] => Array ( [0] => page ) [date_query] => Array ( [0] => Array ( [after] => 1993- 09-06 [before] => 2021-01-21 17:47:27 [inclusive] => 1 ) ) [post_status] => Array([ 0] => publish [1] => inherit ) [post__not_in] => Array ( [0] => 89 [1] => 30 [ 2] => 3248 [3] => 303 [4] => 20 [5] => 541 [6] => 542 [7] => 539 [8] => 3282 [ 9] => 540 [10] => 3281 [11] => 3283 [12] => 4801 [13] => 4738 [14] => 4917 [15] => 3 [16] => 3247 [17] => 3248 [18] => 540 [19] => 3276 [20] => 30 ) )` * `AND ( ( wp_posts.post_date >= '1993-09-06 00:00:00' AND wp_posts.post_date < = '2021-01-21 17:47:27' ) ) AND wp_posts.ID NOT IN (89,30,3248,303,20,541,542,539,3282,540,3281,3283,4801,4738,4917,3,3247,3248,540,3276,30) AND ( 0 = 1 ) AND wp_posts.post_type = 'page' AND ((wp_posts.post_status = 'publish' OR wp_posts.post_status = 'inherit')) AND MATCH (wp_posts.post_title,wp_posts. post_content) AGAINST ('…')` * I see the term id 58 in the array, but not in the query string. `apply_filters` is a WordPress function as far as I can see. Is the array structure valid in this case? * Best Cls Viewing 15 replies - 1 through 15 (of 23 total) 1 [2](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/page/2/?output_format=md) [→](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/page/2/?output_format=md) The topic ‘SHORTCODE – include_cat_IDs works incorrect’ is closed to new replies. * ![](https://ps.w.org/top-10/assets/icon-256x256.png?rev=2986432) * [WebberZone Top 10 — Popular Posts](https://wordpress.org/plugins/top-10/) * [Frequently Asked Questions](https://wordpress.org/plugins/top-10/#faq) * [Support Threads](https://wordpress.org/support/plugin/top-10/) * [Active Topics](https://wordpress.org/support/plugin/top-10/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/top-10/unresolved/) * [Reviews](https://wordpress.org/support/plugin/top-10/reviews/) * 23 replies * 4 participants * Last reply from: [Ajay](https://wordpress.org/support/users/ajay/) * Last activity: [5 years, 3 months ago](https://wordpress.org/support/topic/shortcode-include_cat_ids-works-incorrect/page/2/#post-13948041) * Status: resolved