]> git.wh0rd.org - tt-rss.git/commitdiff
get_article_tags: subquery fix (closes #132)
authorAndrew Dolgov <fox@madoka.spb.ru>
Wed, 30 May 2007 05:54:37 +0000 (06:54 +0100)
committerAndrew Dolgov <fox@madoka.spb.ru>
Wed, 30 May 2007 05:54:37 +0000 (06:54 +0100)
functions.php

index 308ae748ae9833aeb82dbe4eca4f1842c1644f31..841045bb78405fc8318aa88f630251db0b56add4 100644 (file)
                $tmp_result = db_query($link, "SELECT DISTINCT tag_name, 
                        owner_uid as owner FROM
                        ttrss_tags WHERE post_int_id = (SELECT int_id FROM ttrss_user_entries WHERE
-                               ref_id = '$a_id') ORDER BY tag_name");
+                               ref_id = '$a_id' LIMIT 1) ORDER BY tag_name");
 
                $tags = array();