From e1d622c49f95aec51e5c1bd521dcd6fe2a9a5372 Mon Sep 17 00:00:00 2001 From: Max Kostikov Date: Sat, 6 Feb 2021 11:36:22 +0100 Subject: Use datetime interval in public tag cloud query to support queueworker deduplication --- include/taxonomy.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/include/taxonomy.php b/include/taxonomy.php index 7745b6a5b..5fa4fde3f 100644 --- a/include/taxonomy.php +++ b/include/taxonomy.php @@ -345,7 +345,7 @@ function pub_tagadelic($net,$site,$limit,$recent,$safemode,$type) { } if($recent) - $sql_extra .= " and item.created > '" . datetime_convert('UTC','UTC', 'now - ' . intval($recent) . ' days ') . "' "; + $sql_extra .= " and item.created > NOW() - INTERVAL " . db_quoteinterval(intval($recent) . ' DAY') . " "; if($safemode) { -- cgit v1.2.3