From e1d622c49f95aec51e5c1bd521dcd6fe2a9a5372 Mon Sep 17 00:00:00 2001
From: Max Kostikov <max@kostikov.co>
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(-)

(limited to 'include/taxonomy.php')

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