Menu
▾
▴
#738 tag.cgi shows duplicate results whenever a tag has been used more than once
Example: looking up titles tagged "into-movie": http://www.isfdb.org/cgi-bin/tag.cgi?1731
The Martian, The Maze Runner, Cloud Atlas, Dream Catcher, Timeline, and others show up twice. All of these have "(2)" after "to-movie" in the Tags column . For these dupes, the links in the "Title" column all point to the same URLs, so it's not a case of the tags referring to different records in the titles table.
I've not looked at the code (yet...) but I suspect the fix might be something as simple as changing a SELECT query to SELECT DISTINCT?
Discussion
Anonymous
Fixed in common/SQLparsing.py, installed in SVN 458 on 2019-10-01. Closing the bug.