From: Steinar H. Gunderson <sesse@debian.org>
Date: Tue, 24 Jul 2007 21:36:14 +0000 (+0200)
Subject: Remove an unneeded ORDER BY.
X-Git-Url: https://git.sesse.net/?p=pr0n;a=commitdiff_plain;h=4027d980629cd7b6fa9f7999c66fba098fd3de4c;ds=sidebyside

Remove an unneeded ORDER BY.
---

diff --git a/perl/Sesse/pr0n/Index.pm b/perl/Sesse/pr0n/Index.pm
index 23b6e14..f28245c 100644
--- a/perl/Sesse/pr0n/Index.pm
+++ b/perl/Sesse/pr0n/Index.pm
@@ -186,7 +186,7 @@ sub handler {
 					TRIM(model.value) AS model,
 					coalesce(TRIM(lens_spec.value), TRIM(lens.value)) AS lens,
 					COUNT(*) AS num
-				FROM ( SELECT * FROM images WHERE vhost=? $where ORDER BY (date - INTERVAL '6 hours')::date,takenby,date,filename ) i
+				FROM ( SELECT * FROM images WHERE vhost=? $where ) i
 					LEFT JOIN exif_info model ON i.id=model.image
 					LEFT JOIN ( SELECT * FROM exif_info WHERE tag='Lens' ) lens ON i.id=lens.image
 					LEFT JOIN ( SELECT * FROM exif_info WHERE tag='LensSpec') lens_spec ON i.id=lens_spec.image