Index: trunk/DataCheck/Setup/steps_fact_isdc.rc
===================================================================
--- trunk/DataCheck/Setup/steps_fact_isdc.rc	(revision 18759)
+++ trunk/DataCheck/Setup/steps_fact_isdc.rc	(revision 18760)
@@ -47,11 +47,14 @@
 Callisto.MainTable: Callisto
 Callisto.Primaries: fNight, fSequenceID
-Callisto.Needs: RawFileAvailISDC SequenceFileAvailISDC
-Callisto.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)
+#Callisto.Needs: RawFileAvailISDC SequenceFileAvailISDC
+Callisto.Needs: SequenceFileAvailISDC
+#Callisto.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID) LEFT JOIN SequenceInfo USING(fNight, fSequenceID) 
+Callisto.SpecialJoin: LEFT JOIN SequenceInfo USING(fNight, fSequenceID) 
+Callisto.SpecialWhere: AND fNumRuns=fNumRawfilesAvailISDC
 
 Star.MainTable: Star
 Star.Primaries: fNight, fSequenceID
 Star.Needs: RawFileAvailISDC Callisto DriveFileAvailISDC RatesFileAvailISDC SequenceFileAvailISDC
-Star.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID)
+Star.SpecialJoin: LEFT JOIN RunInfo USING(fNight, fSequenceID) LEFT JOIN SequenceInfo USING(fNight, fSequenceID) 
 
 #Merpp.MainTable: Merpp
Index: trunk/DataCheck/Sourcefile.sh
===================================================================
--- trunk/DataCheck/Sourcefile.sh	(revision 18759)
+++ trunk/DataCheck/Sourcefile.sh	(revision 18760)
@@ -266,24 +266,25 @@
       query=$query" AND fProductionHostKEY=$2 "
    fi
-   if ! echo $query | grep UPDATE >/dev/null 2>&1
-   then 
-      query=$query" GROUP BY "${prims[@]}
-   fi
+   query=$query`getfromsetup $step "SpecialWhere"`
    # add condition for needs, i.e. that step is done
    for (( k=0 ; k < ${#needs[@]} ; k++ ))
    do
-      if [ $k -eq 0 ]
-      then 
-         query=$query" HAVING "
-      else
+#      if [ $k -eq 0 ]
+#      then 
+#         query=$query" HAVING "
+#      else
          query=$query" AND "
-      fi
-      query=$query" COUNT(*)=COUNT(IF("
+#      fi
+#      query=$query" COUNT(*)=COUNT(IF("
       query=$query" NOT ISNULL("${needs[$k]}"Status.fStartTime) "
       query=$query" AND NOT ISNULL("${needs[$k]}"Status.fStopTime) "
       query=$query" AND NOT ISNULL("${needs[$k]}"Status.fAvailable) "
       query=$query" AND ISNULL("${needs[$k]}"Status.fReturnCode) "
-      query=$query" , 1, NULL)) "
+#      query=$query" , 1, NULL)) "
    done
+#   if ! echo $query | grep UPDATE >/dev/null 2>&1
+#   then 
+#      query=$query" GROUP BY "${prims[@]}
+#   fi
 }