From 8736c2d227e02e3a49c1b517e715a0268adb4eb7 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@madoka.spb.ru>
Date: Sat, 30 Sep 2006 06:58:18 +0100
Subject: [PATCH] remove unneeded total counter subquery from feedlist query

---
 backend.php | 5 -----
 1 file changed, 5 deletions(-)

diff --git a/backend.php b/backend.php
index 34ec1bcf..6e3fdcec 100644
--- a/backend.php
+++ b/backend.php
@@ -213,10 +213,6 @@
 
 			$result = db_query($link, "SELECT ttrss_feeds.*,
 				SUBSTRING(last_updated,1,19) AS last_updated_noms,
-				(SELECT COUNT(id) FROM ttrss_entries,ttrss_user_entries
-					WHERE feed_id = ttrss_feeds.id AND 
-					ttrss_user_entries.ref_id = ttrss_entries.id AND
-					owner_uid = '$owner_uid') AS total,
 				(SELECT COUNT(id) FROM ttrss_entries,ttrss_user_entries
 					WHERE feed_id = ttrss_feeds.id AND unread = true
 						AND ttrss_user_entries.ref_id = ttrss_entries.id
@@ -250,7 +246,6 @@
 	
 				$subop = $_GET["subop"];
 				
-				$total = $line["total"];
 				$unread = $line["unread"];
 
 				if (get_pref($link, 'HEADLINES_SMART_DATE')) {
-- 
2.39.5