From 9b93dc51373878d7a0cbce3053e4308e7715b9c1 Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Sat, 8 Apr 2023 20:18:17 +0000
Subject: split up a potentially long running sql query

---
 Zotlabs/Lib/Libzot.php | 14 ++++++++++----
 1 file changed, 10 insertions(+), 4 deletions(-)

(limited to 'Zotlabs/Lib/Libzot.php')

diff --git a/Zotlabs/Lib/Libzot.php b/Zotlabs/Lib/Libzot.php
index 129ac6b56..97ea1bbfd 100644
--- a/Zotlabs/Lib/Libzot.php
+++ b/Zotlabs/Lib/Libzot.php
@@ -1389,14 +1389,20 @@ class Libzot {
 		$r = [];
 		$thread_parent = self::find_parent($env, $act);
 		if ($thread_parent) {
-			$z = q("select channel_hash as hash from channel left join item on channel.channel_id = item.uid where ( item.thr_parent = '%s' OR item.parent_mid = '%s' ) and channel_hash != '%s'",
+			$uids = q("SELECT uid FROM item WHERE thr_parent = '%s' OR parent_mid = '%s'",
 				dbesc($thread_parent),
-				dbesc($thread_parent),
-				dbesc($env['sender'])
+				dbesc($thread_parent)
 			);
+
+			$uids = ids_to_querystr($uids, 'uid');
+
+			$z = q("SELECT channel_hash FROM channel WHERE channel_hash != '%s' AND channel_id IN ($uids)",
+				dbesc($msg['sender'])
+			);
+
 			if ($z) {
 				foreach ($z as $zv) {
-					$r[] = $zv['hash'];
+					$r[] = $zv['channel_hash'];
 				}
 			}
 		}
-- 
cgit v1.2.3