Index: trunk/DataCheck/DataCheck/InfoForMWL.sh
===================================================================
--- trunk/DataCheck/DataCheck/InfoForMWL.sh	(revision 15321)
+++ trunk/DataCheck/DataCheck/InfoForMWL.sh	(revision 15322)
@@ -10,9 +10,10 @@
 printprocesslog "INFO starting $0 $1"
 
+# getting db info for query
 getdbsetup
 
 function get_table()
 {
-   echo "writing "$file" ..."
+   printprocesslog "INFO writing "$file
    query="SELECT Datediff(Max(fRunStop), '1858-11-17') as MJD, "
    query=$query" Date_format(Max(fRunStop), '%Y/%m/%d') as DATE, "
@@ -28,9 +29,11 @@
    query=$query" WHERE fSourceKEY="$sourcekey
    query=$query" AND fRunTypeKEY=1 "
+   query=$query" AND fNight BETWEEN "$start" AND "$stop
    query=$query" GROUP BY fNight "
    query=$query" ORDER BY fNight "
    #echo $query
-   echo ""
+   #echo ""
    printprocesslog "DEBUG sendquery QUERY: "$query
+   # sendquery can't be used as it writes everything into a variable
    mysql -s -u $us --password=$pw --host=$ho $db -e " $query " > $file
 }