--- a/quotedb.tcl	Wed Sep 07 14:08:42 2011 +0300
+++ b/quotedb.tcl	Wed Sep 07 14:09:49 2011 +0300
@@ -280,19 +280,21 @@
 proc qdb_get {utable unick uchan uindex upublic} {
   global quotedb
 
-  set usql "SELECT id AS quoteID, utext AS utext, user AS uuser FROM $utable"
+  set usql "SELECT total(${utable}_votes.vote) AS uvote, ${utable}.id AS quoteID, ${utable}.utext AS utext, ${utable}.user AS uuser FROM ${utable} LEFT JOIN ${utable}_votes ON ${utable}_votes.urlid = ${utable}.id"
+#  set usql "$usql GROUP BY ${utable}.id"
+#  set usql "SELECT id AS quoteID, utext AS utext, user AS uuser FROM $utable"
   if {$uindex >= 0} {
-    set usql "$usql WHERE id=$uindex"
+    set usql "$usql WHERE ${utable}.id=$uindex GROUP BY ${utable}.id"
     qdb_log "$unick searched $utable #$uindex"
   } else {
-    set usql "$usql ORDER BY RANDOM() LIMIT 1"
+    set usql "$usql GROUP BY ${utable}.id ORDER BY RANDOM() LIMIT 1"
     qdb_log "$unick get random $utable"
   }
 
   set uresults 0
   quotedb eval $usql {
     incr uresults
-    qdb_msg $upublic $unick $uchan "#${quoteID}: $utext ($uuser)"
+    qdb_msg $upublic $unick $uchan "#${quoteID}: $utext ($uuser, $uvote)"
   }
 }