diff options
author | Andrew Dolgov <[email protected]> | 2006-09-30 06:58:18 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2006-09-30 06:58:18 +0100 |
commit | 8736c2d227e02e3a49c1b517e715a0268adb4eb7 (patch) | |
tree | 2b2f7477400be435f49c96d358755798f7e0f086 /backend.php | |
parent | 5430c959d4faae2ceb7b1d1f7c9b947e7a00c4ef (diff) |
remove unneeded total counter subquery from feedlist query
Diffstat (limited to 'backend.php')
-rw-r--r-- | backend.php | 5 |
1 files changed, 0 insertions, 5 deletions
diff --git a/backend.php b/backend.php index 34ec1bcf2..6e3fdcece 100644 --- a/backend.php +++ b/backend.php @@ -214,10 +214,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 AND owner_uid = '$owner_uid') as unread, @@ -250,7 +246,6 @@ $subop = $_GET["subop"]; - $total = $line["total"]; $unread = $line["unread"]; if (get_pref($link, 'HEADLINES_SMART_DATE')) { |