Index: trunk/ippToPsps/jython/gpc1db.py
===================================================================
--- trunk/ippToPsps/jython/gpc1db.py	(revision 37935)
+++ trunk/ippToPsps/jython/gpc1db.py	(revision 38090)
@@ -113,5 +113,5 @@
 
             stage = "diff"
-            sql = "SELECT DISTINCT stage_extra1, radeg,decdeg \
+            sql = "SELECT stage_id, avg(radeg),avg(decdeg) \
                    FROM addRun \
                    JOIN addProcessedExp using (add_id) \
@@ -140,11 +140,11 @@
                    AND radeg BETWEEN " + str(minRA) + " AND " + str(maxRA) + " \
                    AND dateobs >= '" + tstart + "'\
-                   AND dateobs <= '" + tend  + "'"
-
+                   AND dateobs <= '" + tend  + "'\
+                   GROUP BY stage_id"                   
 
         elif batchType == "FW":
             
             stage = "fullforce"
-            sql = "SELECT DISTINCT add_id, radeg, decdeg FROM fullForceInput \
+            sql = "SELECT stage_id, avg(radeg), avg(decdeg) FROM fullForceInput \
                    JOIN addRun ON(fullForceInput.ff_id = addRun.stage_id AND fullForceInput.warp_id = addRun.stage_extra1) \
                    JOIN minidvodbRun USING(minidvodb_name) \
@@ -167,5 +167,6 @@
                    AND radeg BETWEEN " + str(minRA) + " AND " + str(maxRA) + " \
                    AND mjd_obs >= (to_days('" + tstart + "')-678941) \
-                   AND mjd_obs <= (to_days('" + tend + "') - 678941) "
+                   AND mjd_obs <= (to_days('" + tend + "') - 678941) \
+                   GROUP BY stage_id"
 
         try: