Fixed a very old bug with the VN search matching on release titles of older revisions

It's a pretty tricky bug, so finding a proper fix took a while...

2 files changed, 4 insertions, 1 deletions

diff --git a/ChangeLog b/ChangeLog
index 3feea7d9..659fdfe4 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -11,6 +11,7 @@
 	- Hide the vote dropdown on v+ pages when the VN is already on the wishlist
 	- Don't search for the ADV category when searching for the Game Boy Advance
 	- Keep VN relations on r+ pages ordered by title
+	- VN search doesn't match on titles of older release revisions anymore
 
 2.1 - 2008-12-29
 	- Skin support
diff --git a/lib/VNDB/DB/VN.pm b/lib/VNDB/DB/VN.pm
index 617bb523..dc386286 100644
--- a/lib/VNDB/DB/VN.pm
+++ b/lib/VNDB/DB/VN.pm
@@ -50,7 +50,9 @@ sub dbVNGet {
   );
 
   if($o{search}) {
-    my @w;
+    my @w = (
+      '(irr.id IS NULL OR ir.latest = irr.id)' => 1
+    );
     for (split /[ -,]/, $o{search}) {
       s/%//g;
       next if length($_) < 2;