Index: /trunk/Mars/Changelog
===================================================================
--- /trunk/Mars/Changelog	(revision 10043)
+++ /trunk/Mars/Changelog	(revision 10044)
@@ -18,4 +18,11 @@
 
                                                  -*-*- END OF LINE -*-*-
+
+ 2010/10/28 Daniela Dorner
+
+   * datacenter/scripts/writemcsequencefile:
+     - bug fix (every run was listed several times)
+
+
 
  2010/10/27 Daniela Dorner
Index: /trunk/Mars/datacenter/scripts/writemcsequencefile
===================================================================
--- /trunk/Mars/datacenter/scripts/writemcsequencefile	(revision 10043)
+++ /trunk/Mars/datacenter/scripts/writemcsequencefile	(revision 10044)
@@ -66,5 +66,5 @@
    
    # data runs
-   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence
+   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=2 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    datruns=`sendquery`
    if [ "$datruns" = "" ]
@@ -74,5 +74,5 @@
    fi
    # pedestal runs
-   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence
+   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=3 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    pedruns=`sendquery`
    if [ "$pedruns" = "" ]
@@ -82,5 +82,5 @@
    fi
    # calibration runs
-   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence
+   query="SELECT CONCAT(fRunNumber, '.', RIGHT(fFileNumber, 3)) FROM CeresInfo WHERE fRunTypeKEY=4 AND fSequenceNumber="$sequence" GROUP BY fRunNumber, fFileNumber "
    calruns=`sendquery`
    if [ "$calruns" = "" ]