| View of GCS frame sets having complete (ZYJHK) passband coverage |
| This view of the UKIDSS GCS frame sets tracked in gcsMergeLog simply contains all those sets having complete colour coverage, i.e. those sets having frames in ZYJHK. |
SELECT *
FROM gcsMergeLog
WHERE zmfID > 0 AND ymfID > 0 AND jmfID > 0 and hmfID > 0 and k_1mfID > 0
The details of the table defined by this view are available here.