Index: trunk/Mars/datacenter/scripts/runceres
===================================================================
--- trunk/Mars/datacenter/scripts/runceres	(revision 9898)
+++ trunk/Mars/datacenter/scripts/runceres	(revision 9919)
@@ -55,5 +55,5 @@
 setupfile=$setuppath/$program/`printf %03d $cereskey`/ceres.rc
 
-query="SELECT fRunTypeKEY FROM CeresInfo WHERE fRunNumber="$run" AND fCeresSetupKEY="$cereskey
+query="SELECT fRunTypeKEY FROM CeresInfo WHERE fRunNumber="$run" AND fCeresSetupKEY="$cereskey" GROUP BY fRunNumber"
 runkey=`sendquery`
 
@@ -61,6 +61,6 @@
    2) printprocesslog "INFO run $run is a data run (key="$runkey")"
       printprocesslog "INFO getting file numbers for run "$run
-      query="SELECT CONCAT('"$mcpath"/corsika/', RIGHT(LPAD(CeresInfo.fRunNumber, 8, '0'), 4),"
-      query=$query" '"$mcpath"/corsika/', LEFT(LPAD(CeresInfo.fRunNumber, 8, '0'), 4), '/cer000'"
+      query="SELECT CONCAT('"$mcpath"/corsika/', LEFT(LPAD(CeresInfo.fRunNumber, 8, '0'), 4),"
+      query=$query" '/', RIGHT(LPAD(CeresInfo.fRunNumber, 8, '0'), 4), '/cer000', "
       query=$query" RIGHT(LPAD(CeresInfo.fFileNumber, 6, '0'), 3)) from CeresInfo "
       query=$query" WHERE fRunNumber="$run" AND fCeresSetupKEY="$cereskey
@@ -94,6 +94,6 @@
       check1=$?
       ;;
-   *) printprocesslog "WARN not valid fRunTypeKEY ("$runkey")was queried from the DB."
-      finish
+   *) printprocesslog "WARN not valid fRunTypeKEY ("$runkey") was queried from the DB."
+      check="no"
       ;;
 esac