Changes between Version 3 and Version 4 of Psps_MD_PV2_120214

Timestamp:

Dec 3, 2014, 2:43:09 PM (12 years ago)

Author:

heather

Comment:

--

Psps_MD_PV2_120214

@@ -10 +10 @@
 select top 100000 ra, dec, primaryF from stackDetectionFull order by newid() 
 select top 100000 ra, dec, batchid from Object order by newid() 
+select batchid, count(*)  from StackDetectionFull join StackMeta on StackDetectionFull.StackMetaID = StackMeta.StackMetaID group by batchid 
+select batchid, count(objid)  from Detection join ImageMeta on Detection.imageID = ImageMeta.imageID join FrameMeta on FrameMeta.frameID = imageMeta.frameID group by batchid
+select batchId, count(*) from Object group by batchID;
 
 }}}