X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=pumpio%2Fpumpio.php;h=357f17433b1bf495eb1868760b8fc00ae124b264;hb=7777f080475df3218c851bd48ab609bcc54a071d;hp=19f111908a3ca6cc551ca18551edaf9bea38405a;hpb=b4644212d48256d636f9fbd063b228c23b03b2f0;p=friendica-addons.git

diff --git a/pumpio/pumpio.php b/pumpio/pumpio.php
index 19f11190..357f1743 100644
--- a/pumpio/pumpio.php
+++ b/pumpio/pumpio.php
@@ -1299,10 +1299,10 @@ function pumpio_fetchinbox(App $a, $uid)
 	$self = q("SELECT * FROM `contact` WHERE `self` = 1 AND `uid` = %d LIMIT 1",
 		intval($uid));
 
-	$lastitems = q("SELECT `uri` FROM `thread`
-			INNER JOIN `item` ON `item`.`id` = `thread`.`iid`
-			WHERE `thread`.`network` = '%s' AND `thread`.`uid` = %d AND `item`.`extid` != ''
-			ORDER BY `thread`.`commented` DESC LIMIT 10",
+	$lastitems = q("SELECT `uri` FROM `post-thread-user`
+			INNER JOIN `post-view` ON `post-view`.`id` = `post-thread-user`.`iid`
+			WHERE `post-thread-user`.`network` = '%s' AND `post-thread-user`.`uid` = %d AND `post-view`.`extid` != ''
+			ORDER BY `post-thread-user`.`commented` DESC LIMIT 10",
 				DBA::escape(Protocol::PUMPIO),
 				intval($uid)
 			);