X-Git-Url: https://mop.ddnsfree.com/gitweb/?a=blobdiff_plain;f=sql%2FSTORAGE.txt;h=df9bc216bfea602d35859ad70969b98acf005407;hb=f6a01481a38713553a82314f845bf39fddaa998d;hp=749e71f3a2abd9db730a4ed2602f8b3b6f5959a1;hpb=00efaa64a898c38f0cc0e1ba3e2ec5411f9ed21e;p=brisk.git

diff --git a/sql/STORAGE.txt b/sql/STORAGE.txt
index 749e71f..df9bc21 100644
--- a/sql/STORAGE.txt
+++ b/sql/STORAGE.txt
@@ -1,3 +1,6 @@
+== how to move match ==
+select m.code, m.ttok, min(g.tstamp) from bsk_bin5_matches as m, bsk_bin5_games as g where g.mcode = m.code GROUP BY m.code, m.ttok;
+
 == rende la view dei punteggi ==
 select m.ttok, m.tidx, g.code, g.tstamp, p.pts, u.login from bsk_bin5_points as p, bsk_bin5_games as g, bsk_bin5_matches as m, bsk_users as u where p.ucode = u.code AND p.gcode = g.code AND g.mcode = m.code AND g.tstamp > '2010-10-01 00:00:00' ORDER BY g.tstamp;