summaryrefslogtreecommitdiff
path: root/opml.php
diff options
context:
space:
mode:
Diffstat (limited to 'opml.php')
-rw-r--r--opml.php8
1 files changed, 3 insertions, 5 deletions
diff --git a/opml.php b/opml.php
index 9f76797b6..63f64a670 100644
--- a/opml.php
+++ b/opml.php
@@ -35,11 +35,9 @@
$result = db_query($link, "SELECT
ttrss_feeds.feed_url AS feed_url,
ttrss_feeds.title AS title,
- ttrss_feed_categories.title AS cat_title
- FROM ttrss_feeds,ttrss_feed_categories
- WHERE
- cat_id = ttrss_feed_categories.id
- ORDER BY ttrss_feed_categories.title,ttrss_feeds.title");
+ (SELECT title FROM ttrss_feed_categories WHERE id = cat_id) as cat_title
+ FROM ttrss_feeds
+ ORDER BY cat_title,title");
} else {
$result = db_query($link, "SELECT * FROM ttrss_feeds
ORDER BY title");