Index: trunk/ippToPsps/test/sascheck.v0.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v0.sql	(revision 39176)
+++ 	(revision )
@@ -1,25 +1,0 @@
-
--- get a set of measurements matched by detID
-select 
-   gra,
-   gdec,
-   objID,             
-   HEX(ippObjID),          
-   surveyID,          
-   tessID,            
-   projectionID,      
-   skyCellID,         
-   randomStackObjID,  
-   stackDetectRowID,  
-   primaryDetection,  
--- bestDetection,     
-   dvoRegionID,       
-   dataRelease,       
-   gippDetectID,      
-   gstackDetectID,    
-   gstackMetaID,      
-   HEX(ginfoFlag),        
-   HEX(ginfoFlag2),       
-   gnFrames         
-from StackObjectThin 
-limit 50
Index: trunk/ippToPsps/test/sascheck.v1.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v1.sql	(revision 39176)
+++ 	(revision )
@@ -1,44 +1,0 @@
--- compare g mags across stack tables
-select 
-       gra,
-       gdec,
-       graErr,
-       gdecErr,
-       gPSFMag,
-       gKronMag,
-       gApMag,
-       gExpMag,
-       gSerMag,
-       gDeVMag,
-       gpetMag,
-       gPSFMagErr,
-       gKronMagErr,
-       gApMagErr,
-       gExpMagErr,
-       gSerMagErr,
-       gDeVMagErr,
-       gpetMagErr,
-       gpsfLikelihood,    
-       gpsfQf,            
-       gpsfQfPerfect,     
-       gippDetectID
-       from StackObjectThin 
-       -- left join StackObjectRaw   using (gippDetectID)
-       -- left join StackModelFitExp using (gippDetectID)
-       -- left join StackModelFitDeV using (gippDetectID)
-       -- left join StackModelFitSer using (gippDetectID)
-       -- left join StackPetrosian   using (gippDetectID)
-       -- left join StackApFlxFull   using (gippDetectID)
-       -- left join StackApFlxFullC1 using (gippDetectID)
-       -- left join StackApFlxFullC2 using (gippDetectID)
-       join StackObjectRaw   using (gippDetectID)
-       join StackModelFitExp using (gippDetectID)
-       join StackModelFitDeV using (gippDetectID)
-       join StackModelFitSer using (gippDetectID)
-       join StackPetrosian   using (gippDetectID)
-       join StackApFlxFull   using (gippDetectID)
-       join StackApFlxFullC1 using (gippDetectID)
-       join StackApFlxFullC2 using (gippDetectID)
-       -- where (gippDetectID = 189)
-       -- where (gpsfQfPerfect > 0.85)
-       limit 50
Index: trunk/ippToPsps/test/sascheck.v2.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v2.sql	(revision 39176)
+++ 	(revision )
@@ -1,29 +1,0 @@
--- compare g raw PSF values
-select 
-  gippDetectID,
-  gxPos,             
-  gyPos,             
-  gxPosErr,          
-  gyPosErr,          
-  gpsfMajorFWHM,     
-  gpsfMinorFWHM,     
-  gpsfTheta,         
-  gpsfCore,          
-  gpsfLikelihood,    
-  gpsfQf,            
-  gpsfQfPerfect,     
-  gpsfChiSq,         
-  gmomentXX,         
-  gmomentXY,         
-  gmomentYY,         
-  gmomentR1,         
-  gmomentRH,         
-  gApFillFac,        
-  gKronRad,          
-  gsky,
-  gskyErr,
-  gexpTime,          
-  gzp              
-  from StackObjectThin 
-  join StackObjectRaw using (gippDetectID)
-  limit 80
Index: trunk/ippToPsps/test/sascheck.v3.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v3.sql	(revision 39176)
+++ 	(revision )
@@ -1,32 +1,0 @@
--- compare g fluxes across tables
-select 
-       gra,
-       gdec,
-       gPSFFlux,
-       gKronFlux,
-       gApFlux,
-       gPSFFluxErr,
-       gKronFluxErr,
-       gApFluxErr,
-       gApFillFac,
-       gflxR1,
-       gflxR2,
-       gflxR3,
-       gflxR4,
-       gflxR5,
-       gflxR6,
-       gflxR7,
-       gflxR8,
-       gflxR9,
-       gflxR10,
-       gippDetectID
-       from StackObjectThin 
-       join StackObjectRaw   using (gippDetectID)
-       join StackModelFitExp using (gippDetectID)
-       join StackModelFitDeV using (gippDetectID)
-       join StackModelFitSer using (gippDetectID)
-       join StackPetrosian   using (gippDetectID)
-       join StackApFlxFull   using (gippDetectID)
-       join StackApFlxFullC1 using (gippDetectID)
-       join StackApFlxFullC2 using (gippDetectID)
-       limit 50
Index: trunk/ippToPsps/test/sascheck.v4.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v4.sql	(revision 39176)
+++ 	(revision )
@@ -1,38 +1,0 @@
--- compare g fluxes across tables
-select 
-       gra,
-       gdec,
-       gPSFFlux,
-       gKronFlux,
-       gApFlux,
-       gflxR1,
-       gc1flxR1,
-       gc2flxR1,
-       gflxR2,
-       gc1flxR2,
-       gc2flxR2,
-       gflxR3,
-       gc1flxR3,
-       gc2flxR3,
-       gflxR4,
-       gc1flxR4,
-       gc2flxR4,
-       gflxR5,
-       gc1flxR5,
-       gc2flxR5,
-       gPSFFluxErr,
-       gKronFluxErr,
-       gApFluxErr,
-       gApFillFac,
-       gpsfQfPerfect,
-       gippDetectID
-       from StackObjectThin 
-       join StackObjectRaw   using (gippDetectID)
-       join StackModelFitExp using (gippDetectID)
-       join StackModelFitDeV using (gippDetectID)
-       join StackModelFitSer using (gippDetectID)
-       join StackPetrosian   using (gippDetectID)
-       join StackApFlxFull   using (gippDetectID)
-       join StackApFlxFullC1 using (gippDetectID)
-       join StackApFlxFullC2 using (gippDetectID)
-       limit 50
Index: trunk/ippToPsps/test/sascheck.v5.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v5.sql	(revision 39176)
+++ 	(revision )
@@ -1,32 +1,0 @@
--- compare g mags across stack tables
-select 
-       gra,
-       gdec,
-       gExpMag,
-       gSerMag,
-       gDeVMag,
-       gExpRadius,
-       gSerRadius,
-       gDeVRadius,
-       gExpAb,
-       gSerAb,
-       gDeVAb,
-       gExpPhi,
-       gSerPhi,
-       gDeVPhi,
-       gippDetectID
-       from StackObjectThin 
-       -- left join StackObjectRaw   using (gippDetectID)
-       -- left join StackModelFitExp using (gippDetectID)
-       -- left join StackModelFitDeV using (gippDetectID)
-       -- left join StackModelFitSer using (gippDetectID)
-       -- left join StackPetrosian   using (gippDetectID)
-       -- left join StackApFlxFull   using (gippDetectID)
-       -- left join StackApFlxFullC1 using (gippDetectID)
-       -- left join StackApFlxFullC2 using (gippDetectID)
-       join StackObjectRaw   using (gippDetectID)
-       join StackModelFitExp using (gippDetectID)
-       join StackModelFitDeV using (gippDetectID)
-       join StackModelFitSer using (gippDetectID)
-       -- where (gpsfQfPerfect > 0.85)
-       limit 50
Index: trunk/ippToPsps/test/sascheck.v6.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v6.sql	(revision 39176)
+++ 	(revision )
@@ -1,25 +1,0 @@
--- compare g mags across stack tables
-select 
-       gra,
-       gdec,
-       gExpMag,
-       gExpMagErr,
-       gExpRadius,
-       gExpRadiusErr,
-       gExpAb,
-       gExpAbErr,
-       gExpPhi,
-       gExpPhiErr,
-       gExpRa,
-       gExpDec,
-       gExpRaErr,
-       gExpDecErr,
-       gExpCf,
-       gExpLikelihood,
-       gippDetectID
-       from StackObjectThin 
-       join StackModelFitExp using (gippDetectID)
-       join StackModelFitDeV using (gippDetectID)
-       join StackModelFitSer using (gippDetectID)
-       -- where (gpsfQfPerfect > 0.85)
-       limit 50
Index: trunk/ippToPsps/test/sascheck.v7.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v7.sql	(revision 39176)
+++ 	(revision )
@@ -1,25 +1,0 @@
--- compare g mags across stack tables
-select 
-       gra,
-       gdec,
-       gDeVMag,
-       gDeVMagErr,
-       gDeVRadius,
-       gDeVRadiusErr,
-       gDeVAb,
-       gDeVAbErr,
-       gDeVPhi,
-       gDeVPhiErr,
-       gDeVRa,
-       gDeVDec,
-       gDeVRaErr,
-       gDeVDecErr,
-       gDeVCf,
-       gDeVLikelihood,
-       gippDetectID
-       from StackObjectThin 
-       join StackModelFitExp using (gippDetectID)
-       join StackModelFitDeV using (gippDetectID)
-       join StackModelFitSer using (gippDetectID)
-       -- where (gpsfQfPerfect > 0.85)
-       limit 50
Index: trunk/ippToPsps/test/sascheck.v8.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v8.sql	(revision 39176)
+++ 	(revision )
@@ -1,27 +1,0 @@
--- compare g mags across stack tables
-select 
-       gra,
-       gdec,
-       gSerMag,
-       gSerMagErr,
-       gSerRadius,
-       gSerRadiusErr,
-       gSerAb,
-       gSerAbErr,
-       gSerNu,
-       gSerNuErr,
-       gSerPhi,
-       gSerPhiErr,
-       gSerRa,
-       gSerDec,
-       gSerRaErr,
-       gSerDecErr,
-       gSerCf,
-       gSerLikelihood,
-       gippDetectID
-       from StackObjectThin 
-       join StackModelFitExp using (gippDetectID)
-       join StackModelFitDeV using (gippDetectID)
-       join StackModelFitSer using (gippDetectID)
-       -- where (gpsfQfPerfect > 0.85)
-       limit 50
Index: trunk/ippToPsps/test/sascheck.v9.sql
===================================================================
--- trunk/ippToPsps/test/sascheck.v9.sql	(revision 39176)
+++ 	(revision )
@@ -1,29 +1,0 @@
--- compare g fluxes across tables
-select 
-       gra,
-       gdec,
-       gxPos,
-       gyPos,
-       gPSFFlux,
-       gApFlux,
-       gPSFFluxErr,
-       gApFluxErr,
-       gApFillFac,
-       gflxR3,
-       gflxR4,
-       gflxR5,
-       gflxR3Err,
-       gflxR4Err,
-       gflxR5Err,
-       gflxR3Std,
-       gflxR4Std,
-       gflxR5Std,
-       gflxR3Fill,
-       gflxR4Fill,
-       gflxR5Fill,
-       gippDetectID
-       from StackObjectThin 
-       join StackObjectRaw   using (gippDetectID)
-       join StackApFlx       using (gippDetectID)
-       where gPSFFlux > 1000
-       limit 50
Index: trunk/ippToPsps/test/testscripts/sascheck.v0.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v0.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v0.sql	(revision 39179)
@@ -0,0 +1,25 @@
+
+-- get a set of measurements matched by detID
+select 
+   gra,
+   gdec,
+   objID,             
+   HEX(ippObjID),          
+   surveyID,          
+   tessID,            
+   projectionID,      
+   skyCellID,         
+   randomStackObjID,  
+   stackDetectRowID,  
+   primaryDetection,  
+-- bestDetection,     
+   dvoRegionID,       
+   dataRelease,       
+   gippDetectID,      
+   gstackDetectID,    
+   gstackMetaID,      
+   HEX(ginfoFlag),        
+   HEX(ginfoFlag2),       
+   gnFrames         
+from StackObjectThin 
+limit 50
Index: trunk/ippToPsps/test/testscripts/sascheck.v1.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v1.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v1.sql	(revision 39179)
@@ -0,0 +1,44 @@
+-- compare g mags across stack tables
+select 
+       gra,
+       gdec,
+       graErr,
+       gdecErr,
+       gPSFMag,
+       gKronMag,
+       gApMag,
+       gExpMag,
+       gSerMag,
+       gDeVMag,
+       gpetMag,
+       gPSFMagErr,
+       gKronMagErr,
+       gApMagErr,
+       gExpMagErr,
+       gSerMagErr,
+       gDeVMagErr,
+       gpetMagErr,
+       gpsfLikelihood,    
+       gpsfQf,            
+       gpsfQfPerfect,     
+       gippDetectID
+       from StackObjectThin 
+       -- left join StackObjectRaw   using (gippDetectID)
+       -- left join StackModelFitExp using (gippDetectID)
+       -- left join StackModelFitDeV using (gippDetectID)
+       -- left join StackModelFitSer using (gippDetectID)
+       -- left join StackPetrosian   using (gippDetectID)
+       -- left join StackApFlxFull   using (gippDetectID)
+       -- left join StackApFlxFullC1 using (gippDetectID)
+       -- left join StackApFlxFullC2 using (gippDetectID)
+       join StackObjectRaw   using (gippDetectID)
+       join StackModelFitExp using (gippDetectID)
+       join StackModelFitDeV using (gippDetectID)
+       join StackModelFitSer using (gippDetectID)
+       join StackPetrosian   using (gippDetectID)
+       join StackApFlxFull   using (gippDetectID)
+       join StackApFlxFullC1 using (gippDetectID)
+       join StackApFlxFullC2 using (gippDetectID)
+       -- where (gippDetectID = 189)
+       -- where (gpsfQfPerfect > 0.85)
+       limit 50
Index: trunk/ippToPsps/test/testscripts/sascheck.v2.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v2.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v2.sql	(revision 39179)
@@ -0,0 +1,29 @@
+-- compare g raw PSF values
+select 
+  gippDetectID,
+  gxPos,             
+  gyPos,             
+  gxPosErr,          
+  gyPosErr,          
+  gpsfMajorFWHM,     
+  gpsfMinorFWHM,     
+  gpsfTheta,         
+  gpsfCore,          
+  gpsfLikelihood,    
+  gpsfQf,            
+  gpsfQfPerfect,     
+  gpsfChiSq,         
+  gmomentXX,         
+  gmomentXY,         
+  gmomentYY,         
+  gmomentR1,         
+  gmomentRH,         
+  gApFillFac,        
+  gKronRad,          
+  gsky,
+  gskyErr,
+  gexpTime,          
+  gzp              
+  from StackObjectThin 
+  join StackObjectRaw using (gippDetectID)
+  limit 80
Index: trunk/ippToPsps/test/testscripts/sascheck.v3.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v3.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v3.sql	(revision 39179)
@@ -0,0 +1,32 @@
+-- compare g fluxes across tables
+select 
+       gra,
+       gdec,
+       gPSFFlux,
+       gKronFlux,
+       gApFlux,
+       gPSFFluxErr,
+       gKronFluxErr,
+       gApFluxErr,
+       gApFillFac,
+       gflxR1,
+       gflxR2,
+       gflxR3,
+       gflxR4,
+       gflxR5,
+       gflxR6,
+       gflxR7,
+       gflxR8,
+       gflxR9,
+       gflxR10,
+       gippDetectID
+       from StackObjectThin 
+       join StackObjectRaw   using (gippDetectID)
+       join StackModelFitExp using (gippDetectID)
+       join StackModelFitDeV using (gippDetectID)
+       join StackModelFitSer using (gippDetectID)
+       join StackPetrosian   using (gippDetectID)
+       join StackApFlxFull   using (gippDetectID)
+       join StackApFlxFullC1 using (gippDetectID)
+       join StackApFlxFullC2 using (gippDetectID)
+       limit 50
Index: trunk/ippToPsps/test/testscripts/sascheck.v4.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v4.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v4.sql	(revision 39179)
@@ -0,0 +1,38 @@
+-- compare g fluxes across tables
+select 
+       gra,
+       gdec,
+       gPSFFlux,
+       gKronFlux,
+       gApFlux,
+       gflxR1,
+       gc1flxR1,
+       gc2flxR1,
+       gflxR2,
+       gc1flxR2,
+       gc2flxR2,
+       gflxR3,
+       gc1flxR3,
+       gc2flxR3,
+       gflxR4,
+       gc1flxR4,
+       gc2flxR4,
+       gflxR5,
+       gc1flxR5,
+       gc2flxR5,
+       gPSFFluxErr,
+       gKronFluxErr,
+       gApFluxErr,
+       gApFillFac,
+       gpsfQfPerfect,
+       gippDetectID
+       from StackObjectThin 
+       join StackObjectRaw   using (gippDetectID)
+       join StackModelFitExp using (gippDetectID)
+       join StackModelFitDeV using (gippDetectID)
+       join StackModelFitSer using (gippDetectID)
+       join StackPetrosian   using (gippDetectID)
+       join StackApFlxFull   using (gippDetectID)
+       join StackApFlxFullC1 using (gippDetectID)
+       join StackApFlxFullC2 using (gippDetectID)
+       limit 50
Index: trunk/ippToPsps/test/testscripts/sascheck.v5.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v5.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v5.sql	(revision 39179)
@@ -0,0 +1,32 @@
+-- compare g mags across stack tables
+select 
+       gra,
+       gdec,
+       gExpMag,
+       gSerMag,
+       gDeVMag,
+       gExpRadius,
+       gSerRadius,
+       gDeVRadius,
+       gExpAb,
+       gSerAb,
+       gDeVAb,
+       gExpPhi,
+       gSerPhi,
+       gDeVPhi,
+       gippDetectID
+       from StackObjectThin 
+       -- left join StackObjectRaw   using (gippDetectID)
+       -- left join StackModelFitExp using (gippDetectID)
+       -- left join StackModelFitDeV using (gippDetectID)
+       -- left join StackModelFitSer using (gippDetectID)
+       -- left join StackPetrosian   using (gippDetectID)
+       -- left join StackApFlxFull   using (gippDetectID)
+       -- left join StackApFlxFullC1 using (gippDetectID)
+       -- left join StackApFlxFullC2 using (gippDetectID)
+       join StackObjectRaw   using (gippDetectID)
+       join StackModelFitExp using (gippDetectID)
+       join StackModelFitDeV using (gippDetectID)
+       join StackModelFitSer using (gippDetectID)
+       -- where (gpsfQfPerfect > 0.85)
+       limit 50
Index: trunk/ippToPsps/test/testscripts/sascheck.v6.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v6.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v6.sql	(revision 39179)
@@ -0,0 +1,25 @@
+-- compare g mags across stack tables
+select 
+       gra,
+       gdec,
+       gExpMag,
+       gExpMagErr,
+       gExpRadius,
+       gExpRadiusErr,
+       gExpAb,
+       gExpAbErr,
+       gExpPhi,
+       gExpPhiErr,
+       gExpRa,
+       gExpDec,
+       gExpRaErr,
+       gExpDecErr,
+       gExpCf,
+       gExpLikelihood,
+       gippDetectID
+       from StackObjectThin 
+       join StackModelFitExp using (gippDetectID)
+       join StackModelFitDeV using (gippDetectID)
+       join StackModelFitSer using (gippDetectID)
+       -- where (gpsfQfPerfect > 0.85)
+       limit 50
Index: trunk/ippToPsps/test/testscripts/sascheck.v7.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v7.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v7.sql	(revision 39179)
@@ -0,0 +1,25 @@
+-- compare g mags across stack tables
+select 
+       gra,
+       gdec,
+       gDeVMag,
+       gDeVMagErr,
+       gDeVRadius,
+       gDeVRadiusErr,
+       gDeVAb,
+       gDeVAbErr,
+       gDeVPhi,
+       gDeVPhiErr,
+       gDeVRa,
+       gDeVDec,
+       gDeVRaErr,
+       gDeVDecErr,
+       gDeVCf,
+       gDeVLikelihood,
+       gippDetectID
+       from StackObjectThin 
+       join StackModelFitExp using (gippDetectID)
+       join StackModelFitDeV using (gippDetectID)
+       join StackModelFitSer using (gippDetectID)
+       -- where (gpsfQfPerfect > 0.85)
+       limit 50
Index: trunk/ippToPsps/test/testscripts/sascheck.v8.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v8.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v8.sql	(revision 39179)
@@ -0,0 +1,27 @@
+-- compare g mags across stack tables
+select 
+       gra,
+       gdec,
+       gSerMag,
+       gSerMagErr,
+       gSerRadius,
+       gSerRadiusErr,
+       gSerAb,
+       gSerAbErr,
+       gSerNu,
+       gSerNuErr,
+       gSerPhi,
+       gSerPhiErr,
+       gSerRa,
+       gSerDec,
+       gSerRaErr,
+       gSerDecErr,
+       gSerCf,
+       gSerLikelihood,
+       gippDetectID
+       from StackObjectThin 
+       join StackModelFitExp using (gippDetectID)
+       join StackModelFitDeV using (gippDetectID)
+       join StackModelFitSer using (gippDetectID)
+       -- where (gpsfQfPerfect > 0.85)
+       limit 50
Index: trunk/ippToPsps/test/testscripts/sascheck.v9.sql
===================================================================
--- trunk/ippToPsps/test/testscripts/sascheck.v9.sql	(revision 39179)
+++ trunk/ippToPsps/test/testscripts/sascheck.v9.sql	(revision 39179)
@@ -0,0 +1,29 @@
+-- compare g fluxes across tables
+select 
+       gra,
+       gdec,
+       gxPos,
+       gyPos,
+       gPSFFlux,
+       gApFlux,
+       gPSFFluxErr,
+       gApFluxErr,
+       gApFillFac,
+       gflxR3,
+       gflxR4,
+       gflxR5,
+       gflxR3Err,
+       gflxR4Err,
+       gflxR5Err,
+       gflxR3Std,
+       gflxR4Std,
+       gflxR5Std,
+       gflxR3Fill,
+       gflxR4Fill,
+       gflxR5Fill,
+       gippDetectID
+       from StackObjectThin 
+       join StackObjectRaw   using (gippDetectID)
+       join StackApFlx       using (gippDetectID)
+       where gPSFFlux > 1000
+       limit 50