| View of all frame sets defined for the UKIDSS LAS |
| This view is simply a union of all frame set / multiframe combinations from the LAS merge log. This provides a direct link between a given frame set and it's constituent multiframes and detector frames in a single queryable object. View allFrameSets provides a view of all archived sets. |
select frameSetID,ymfID as multiframeID,yeNum as extNum from lasMergeLog where deprecated=0
union all
select frameSetID,j_1mfID as multiframeID,j_1eNum as extNum from lasMergeLog where deprecated=0
union all
select frameSetID,j_2mfID as multiframeID,j_2eNum as extNum from lasMergeLog where deprecated=0
union all
select frameSetID,hmfID as multiframeID,heNum as extNum from lasMergeLog where deprecated=0
union all
select frameSetID,kmfID as multiframeID,keNum as extNum from lasMergeLog where deprecated=0