Archive TeamThis wiki area should be used as the main source of communication for this operations group. The group's email address is archive_@_pessto.org and the group's google drive area can be found here: Team Leader : O. Yaron Phase 3 Date Product Standards
Marshall DevelopmentData reduced archive @ IA2 DevelopmentSample queries for executing in WISeREP My-SQL-Query pageCopy the required query from below, paste in: My-SQL-Query page and click submit. (Make sure you're logged in with the pessto username.)
SELECT typ.name as type, count(*) as spectra FROM spectra spec JOIN objects obj on spec.objid=obj.id LEFT JOIN objtypes typ on obj.objtypeid=typ.id WHERE spec.progid=22 GROUP BY typ.name
SELECT typ.name as type, count(*) as objects FROM objects obj LEFT JOIN objtypes typ on obj.objtypeid=typ.id where typ.name like '%SN%' and obj.progid=22 and exists (select s.id from spectra s where s.objid=obj.id) GROUP BY typ.name
|