1.1 --- a/java/HrisniciSpameri/src/java/cz/frantovo/hrisniciSpameri/dao/SouhrnDAO.sql.xml Sat Feb 28 21:50:25 2009 +0100
1.2 +++ b/java/HrisniciSpameri/src/java/cz/frantovo/hrisniciSpameri/dao/SouhrnDAO.sql.xml Sun Mar 01 00:09:40 2009 +0100
1.3 @@ -18,6 +18,7 @@
1.4 WHERE den >= date_trunc('day', ?::date)
1.5 AND den <= date_trunc('day', ?::date)
1.6 GROUP BY ip, domena, cil, id, nazev, url, selekt, databaze
1.7 + ORDER BY max(den) DESC
1.8 ]]>
1.9 </entry>
1.10 <entry key="DENNI_SOUHRN_CIL">
1.11 @@ -38,6 +39,7 @@
1.12 AND den <= date_trunc('day', ?::date)
1.13 AND cil = ?
1.14 GROUP BY ip, domena, cil, id, nazev, url, selekt, databaze
1.15 + ORDER BY max(den) DESC
1.16 ]]>
1.17 </entry>
1.18 </properties>
1.19 \ No newline at end of file