Index: trunk/Mars/datacenter/scripts/writemcsequencefile
===================================================================
--- trunk/Mars/datacenter/scripts/writemcsequencefile	(revision 10042)
+++ 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" = "" ]