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
-
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, 702. 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, 70Hey, 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, 18I 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, 18Best
ClsI 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, 6There 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
- The topic ‘SHORTCODE – include_cat_IDs works incorrect’ is closed to new replies.
