JelStein

32 SELECT option_value
FROM wp_options
WHERE option_name = ‘tptn_db_version’
LIMIT 1
get_option()
Plugin installeren: top-10 1 0,0002
48 SELECT option_value
FROM wp_options
WHERE option_name = ‘medium_crop’
LIMIT 1
get_option()
Plugin installeren: top-10 0 0,0003
49 SELECT option_value
FROM wp_options
WHERE option_name = ‘medium_large_crop’
LIMIT 1
get_option()
Plugin installeren: top-10 0 0,0002
50 SELECT option_value
FROM wp_options
WHERE option_name = ‘large_crop’
LIMIT 1
get_option()
Plugin installeren: top-10 0 0,0002
250 SELECT post_id, meta_value
FROM wp_postmeta
WHERE meta_key = ‘tptn_post_meta’
tptn_exclude_post_ids()
Plugin installeren: top-10 0 0,0003
251 SELECT wp_posts.*,wp_top_ten.postnumber, wp_top_ten.cntaccess as visits, wp_top_ten.blog_id
FROM wp_posts
INNER JOIN wp_top_ten
ON wp_top_ten.postnumber=wp_posts.ID
WHERE 1=1
AND ( ( wp_posts.post_date >= ‘2022-09-04 22:00:00’
AND wp_posts.post_date <= ‘2022-09-19 22:17:10’ ) )
AND wp_posts.post_type = ‘post’
AND ((wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘inherit’))
AND wp_top_ten.blog_id IN (‘1’)
ORDER BY visits DESC
LIMIT 0, 15
WP_Query->get_posts()
Plugin installeren: top-10 15 0,0151
252 SELECT DISTINCT t.term_id, tr.object_id
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN (‘category’, ‘post_tag’, ‘post_format’)
AND tr.object_id IN (121520, 121093, 121450, 121136, 121252, 121425, 121417, 121221, 121076, 120996, 121388, 121064, 121194, 121293, 121463)
ORDER BY t.name ASC
WP_Term_Query->get_terms()
Plugin installeren: top-10 58 0,0010
253 SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
WHERE t.term_id IN (4067,9174,151,469,330,830,4917,1887,829,9169,5493,639,7905,4119,3581,1119,6229,4354,9173,9171,4333,21,9167,325)
_prime_term_caches()
Plugin installeren: top-10 24 0,0006
254 SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (121520,121093,121450,121136,121252,121425,121417,121221,121076,120996,121388,121064,121194,121293,121463)
ORDER BY meta_id ASC
update_meta_cache()
Plugin installeren: top-10 377 0,0015
255 SELECT *
FROM wp_users
WHERE ID = ‘182’
LIMIT 1
WP_User::get_data_by()
Plugin installeren: top-10 1 0,0003
256 SELECT user_id, meta_key, meta_value
FROM wp_usermeta
WHERE user_id IN (182)
ORDER BY umeta_id ASC
update_meta_cache()
Plugin installeren: top-10 38 0,0004
257 SELECT *
FROM wp_users
WHERE ID = ’20’
LIMIT 1
WP_User::get_data_by()
Plugin installeren: top-10 1 0,0003
258 SELECT user_id, meta_key, meta_value
FROM wp_usermeta
WHERE user_id IN (20)
ORDER BY umeta_id ASC
update_meta_cache()
Plugin installeren: top-10 80 0,0006
259 SELECT *
FROM wp_users
WHERE ID = ’75’
LIMIT 1
WP_User::get_data_by()
Plugin installeren: top-10 1 0,0002
260 SELECT user_id, meta_key, meta_value
FROM wp_usermeta
WHERE user_id IN (75)
ORDER BY umeta_id ASC
update_meta_cache()
Plugin installeren: top-10 38 0,0003
294 SELECT post_id, meta_value
FROM wp_postmeta
WHERE meta_key = ‘tptn_post_meta’
tptn_exclude_post_ids()
Plugin installeren: top-10 0 0,0003
295 SELECT wp_posts.*,wp_top_ten_daily.postnumber, SUM(wp_top_ten_daily.cntaccess) as visits, wp_top_ten_daily.blog_id
FROM wp_posts
INNER JOIN wp_top_ten_daily
ON wp_top_ten_daily.postnumber=wp_posts.ID
WHERE 1=1
AND ( wp_posts.post_date <= ‘2022-09-19 22:17:10’ )
AND wp_posts.post_type = ‘post’
AND ((wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘inherit’))
AND wp_top_ten_daily.blog_id IN (‘1’)
AND wp_top_ten_daily.dp_date >= ‘2022-09-16 22:0:0’
GROUP BY wp_top_ten_daily.postnumber
ORDER BY visits DESC
LIMIT 0, 15
WP_Query->get_posts()
Plugin installeren: top-10 15 0,3005
296 SELECT DISTINCT t.term_id, tr.object_id
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
INNER JOIN wp_term_relationships AS tr
ON tr.term_taxonomy_id = tt.term_taxonomy_id
WHERE tt.taxonomy IN (‘category’, ‘post_tag’, ‘post_format’)
AND tr.object_id IN (121476, 121482, 121527, 121511, 121551, 121540, 121485, 121490, 121496)
ORDER BY t.name ASC
WP_Term_Query->get_terms()
Plugin installeren: top-10 33 0,0008
297 SELECT t.*, tt.*
FROM wp_terms AS t
INNER JOIN wp_term_taxonomy AS tt
ON t.term_id = tt.term_id
WHERE t.term_id IN (7564,300,1452,7448,986,269,9176,6439,5389,9172,5437,9175,819)
_prime_term_caches()
Plugin installeren: top-10 13 0,0007
298 SELECT post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id IN (121476,121482,121527,121511,121551,121540,121485,121490,121496)
ORDER BY meta_id ASC
update_meta_cache()
Plugin installeren: top-10 233 0,0018
299 SELECT post_id, meta_value
FROM wp_postmeta
WHERE meta_key = ‘tptn_post_meta’
tptn_exclude_post_ids()
Plugin installeren: top-10 0 0,0003
300 SELECT wp_posts.*,wp_top_ten_daily.postnumber, SUM(wp_top_ten_daily.cntaccess) as visits, wp_top_ten_daily.blog_id
FROM wp_posts
INNER JOIN wp_top_ten_daily
ON wp_top_ten_daily.postnumber=wp_posts.ID
WHERE 1=1
AND ( wp_posts.post_date <= ‘2022-09-19 22:17:11’ )
AND wp_posts.post_type = ‘post’
AND ((wp_posts.post_status = ‘publish’
OR wp_posts.post_status = ‘inherit’))
AND wp_top_ten_daily.blog_id IN (‘1’)
AND wp_top_ten_daily.dp_date >= ‘2022-09-16 22:0:0’
GROUP BY wp_top_ten_daily.postnumber
ORDER BY visits DESC
LIMIT 0, 15

I have a similar problem. I have updated today to the latest version 3.2.1.

in the shortcode below, which I succesfully use for over 5 years, INCLUDE_CAT_IDS are no longer applied by the plugin.

[tptn_list heading=’0′ how_old=14 include_cat_ids=”10″ show_date = ‘1’ limit=’5′ disp_list_count = ‘0’ show_author=’1′]

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 4 years, 2 months ago by JelStein.

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 ]

I only wrote ID in capitals in my text NOT in the shortode parameters (see my example)

It really does not work!

Here is the cause & temporary solution:

https://www.ads-software.com/plugins/enable-jquery-migrate-helper/

I created a new reuqest!

https://www.ads-software.com/support/topic/form-does-not-send-3/

How come status says RESOLVED?

Who fixed What and How can I get that solution?

@wordpresslover7 That does not fix my problem

MUST BE A REAL & GENERAL PROBLEM THEN??

I have the same problem: all forms stopped sending from 11 June 2017 afternoon. The funny thing is that I did completetly nothing – no updates. I run CF7 version 4.8 and wordpress 4.8.

to my opinion you have NOT resolved the “Publish Twice” issue.

A scheduled post gets posted TWICE.
Have you any solution yet?

elseweher it says: This is cause and solution

https://www.ads-software.com/support/topic/post-sometimes-published-twice?replies=2

anyone successfull ?

When debugging one specific page of our siste via FAcebook tool
https://developers.facebook.com/tools/debug/og/object/

the 2 warnings I get all the time:

Inferred Property The ‘og:url’ property should be explicitly provided, even if a value can be inferred from other tags.

Inferred Property The ‘og:title’ property should be explicitly provided, even if a value can be inferred from other tags.

I suspect this is due to a missing part of WOOCommerce?

pleas advise!

Terry it is not (!) a solution. just a limited workaroumd

It is way to much effrt to do this for every product page in my shop with over 800 products….

The solutionw works only for individual posts / products, which requires manual effort for each product

I can not even translate at all via plugin “Localisation” which supports translating

WooCommerce plugin is incompatible with plugin “Localisation”

Localisation plugin produces error:

“Using [load_textdomain]function in stead of [load_plugin_textdomain] can cause problems in the behaviour of WordPress, because some filters and actions will not work”