From 8736c2d227e02e3a49c1b517e715a0268adb4eb7 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sat, 30 Sep 2006 06:58:18 +0100 Subject: remove unneeded total counter subquery from feedlist query --- backend.php | 5 ----- 1 file changed, 5 deletions(-) (limited to 'backend.php') diff --git a/backend.php b/backend.php index 34ec1bcf2..6e3fdcece 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')) { -- cgit v1.2.3