Index: trunk/MagicSoft/Mars/datacenter/macros/plotdb.C
===================================================================
--- trunk/MagicSoft/Mars/datacenter/macros/plotdb.C	(revision 7124)
+++ trunk/MagicSoft/Mars/datacenter/macros/plotdb.C	(revision 7129)
@@ -104,5 +104,5 @@
 
         TGraph g2;
-        g2.SetNameTitle(name, Form("%s vs ZdMin", name.Data()));
+        g2.SetNameTitle(name, Form("%s vs <Zd>", name.Data()));
         g2.SetMarkerStyle(kFullDotMedium);
 
@@ -236,5 +236,5 @@
     {
         TString named  = "Sequences.fRunStart";
-        TString named2 = "Sequences.fZenithDistanceMin";
+        TString named2 = "(Sequences.fZenithDistanceMin+Sequences.fZenithDistanceMax)/2";
         TString namev  = value;
         TString join   = "fSequenceFirst";
@@ -246,9 +246,6 @@
         TString valued = named(named.First('.')+1, named.Length());
 
-        TString tabled2 = named2(0, named2.First('.'));
-        TString valued2 = named2(named2.First('.')+1, named2.Length());
-
         TString query;
-        query  = Form("select %s, %s, %s ",        valued.Data(), valued2.Data(), valuev.Data());
+        query  = Form("select %s, %s, %s ",    valued.Data(), named2.Data(), valuev.Data());
         query += Form("from %s left join %s ", tabled.Data(), tablev.Data());
         query += Form("on %s.%s=%s.%s ",       tabled.Data(), join.Data(), tablev.Data(), join.Data());
@@ -260,5 +257,5 @@
         query += "order by fRunStart";
 
-        cout << "q: " << query << endl;
+        //cout << "q: " << query << endl;
 
         TSQLResult *res = fServer.Query(query);