diff options
author | Andrew Dolgov <[email protected]> | 2005-12-29 07:19:27 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-12-29 07:19:27 +0100 |
commit | db42b934a1edbdcfc7e8b0274f9addaa62287c6e (patch) | |
tree | 21a131de2e6e98033b173494b32b38e4d75fef82 /functions.php | |
parent | 587b0b084d1ed0657f4826febc16dfdc1e20a348 (diff) |
counters for linked feeds, misc SQL optimizations
Diffstat (limited to 'functions.php')
-rw-r--r-- | functions.php | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/functions.php b/functions.php index aececd8d9..11eb26796 100644 --- a/functions.php +++ b/functions.php @@ -245,12 +245,12 @@ $filters = array(); $result = db_query($link, "SELECT reg_exp, - (SELECT name FROM ttrss_filter_types - WHERE id = filter_type) as name, - (SELECT name FROM ttrss_filter_actions - WHERE id = action_id) as action - FROM ttrss_filters WHERE - owner_uid = $owner_uid AND + ttrss_filter_types.name AS name, + ttrss_filter_actions.name AS action + FROM ttrss_filters,ttrss_filter_types,ttrss_filter_actions WHERE + owner_uid = $owner_uid AND + ttrss_filter_types.id = filter_type AND + ttrss_filter_actions.id = action_id AND (feed_id IS NULL OR feed_id = '$feed')"); while ($line = db_fetch_assoc($result)) { |