diff options
Diffstat (limited to 'lib/Bookmarks/M/DB/Tags.pm')
-rw-r--r-- | lib/Bookmarks/M/DB/Tags.pm | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/lib/Bookmarks/M/DB/Tags.pm b/lib/Bookmarks/M/DB/Tags.pm index 2bf38aa..b01695a 100644 --- a/lib/Bookmarks/M/DB/Tags.pm +++ b/lib/Bookmarks/M/DB/Tags.pm @@ -5,11 +5,12 @@ use strict; __PACKAGE__->has_many( links => ['Bookmarks::M::DB::LinksTags' => 'link'] ); __PACKAGE__->set_sql('related_tags', <<'END_SQL'); -SELECT tags.pk +SELECT DISTINCT tags.pk FROM tags, links_tags lt1, links_tags lt2 WHERE tags.pk = lt1.tag - AND lt2.link = lt2.link + AND lt1.link = lt2.link AND lt2.tag = ? + AND lt1.tag != lt2.tag END_SQL __PACKAGE__->set_sql('popularity', <<'END_SQL'); |