X-Git-Url: https://git.sesse.net/?p=pr0n;a=blobdiff_plain;f=perl%2FSesse%2Fpr0n%2FIndex.pm;h=5a635d4c190aac8a5fff7e9fc3a05c1ae4aa25b8;hp=737eba6e7f908a42fa0cd7a57d225297ff919ee2;hb=6b6a6afa90a6be24ae430324ec5ca7fd83f4fe93;hpb=a19e038e99eef4319288ef57ea8e79ccc40d3389

diff --git a/perl/Sesse/pr0n/Index.pm b/perl/Sesse/pr0n/Index.pm
index 737eba6..5a635d4 100644
--- a/perl/Sesse/pr0n/Index.pm
+++ b/perl/Sesse/pr0n/Index.pm
@@ -156,8 +156,8 @@ sub handler {
 		# Find the equipment used
 		my $eq = $dbh->prepare('
 			SELECT 
-				model.value AS model,
-				coalesce(lens_spec.value, lens.value) AS lens,
+				TRIM(model.value) AS model,
+				coalesce(TRIM(lens_spec.value), TRIM(lens.value)) AS lens,
 				COUNT(*) AS num
 			FROM images i
 				LEFT JOIN exif_info model ON i.id=model.image