jsoc_sums=> select online_status, owning_series,username,ds_index,arch_tape_fn from sum_main where arch_tape='014758L4' and arch_tape_fn >= 1027 and arch_tape_fn <= 1065 order by owning_series; online_status | owning_series | username | ds_index | arch_tape_fn ---------------+------------------+------------+-----------+-------------- Y | hmi.Ic_45s | phil | 116261229 | 1064 Y | hmi.Ic_720s | phil | 117844289 | 1032 Y | hmi.Ld_45s | phil | 110521372 | 1051 Y | hmi.Ld_720s | phil | 117841485 | 1045 Y | hmi.Lw_45s | phil | 110521373 | 1037 Y | hmi.Lw_45s | phil | 115468021 | 1061 Y | hmi.Lw_720s | phil | 115471627 | 1049 Y | hmi.ME_720s | keiji | 112852424 | 1056 Y | hmi.ME_720s | keiji | 112855155 | 1044 Y | hmi.ME_720s | keiji | 112856865 | 1053 Y | hmi.ME_720s | keiji | 112858048 | 1039 Y | hmi.ME_720s | keiji | 112860146 | 1063 Y | hmi.ME_720s | keiji | 112853199 | 1047 Y | hmi.ME_720s | keiji | 112853965 | 1046 Y | hmi.ME_720s | keiji | 112854363 | 1045 Y | hmi.M_45s | phil | 115468018 | 1062 Y | hmi.M_45s | phil | 110521718 | 1035 Y | hmi.M_720s | phil | 115471625 | 1031 N | hmi.Marmask_720s | phil | 117843955 | 1058 N | hmi.Marmask_720s | phil | 116268709 | 1065 Y | hmi.Mpatch_720s | phil | 115472654 | 1047 N | hmi.Mpatch_720s | phil | 117843783 | 1036 N | hmi.Mpatch_720s | phil | 117843866 | 1058 N | hmi.Mpatch_720s | phil | 115472324 | 1028 N | hmi.Mpatch_720s | phil | 104453612 | 1042 N | hmi.Mpatch_720s | phil | 115471971 | 1030 N | hmi.Mpatch_720s | phil | 104450283 | 1029 N | hmi.Mpatch_720s | phil | 104450333 | 1048 N | hmi.Mpatch_720s | phil | 117843784 | 1051 N | hmi.Mpatch_720s | phil | 117844100 | 1034 N | hmi.Mpatch_720s | phil | 117844061 | 1050 N | hmi.Mpatch_720s | phil | 117844229 | 1033 Y | hmi.Mpatch_720s | phil | 115472674 | 1056 N | hmi.Mpatch_720s | phil | 117843001 | 1040 N | hmi.Mpatch_720s | phil | 117843867 | 1060 N | hmi.Mpatch_720s | phil | 117843868 | 1062 N | hmi.Mpatch_720s | phil | 110529978 | 1062 N | hmi.Mpatch_720s | phil | 110529886 | 1053 N | hmi.Mpatch_720s | phil | 110529887 | 1059 N | hmi.Mpatch_720s | phil | 110529977 | 1061 N | hmi.Mpatch_720s | phil | 110529954 | 1040 N | hmi.Mpatch_720s | phil | 110530819 | 1053 N | hmi.Mpatch_720s | phil | 110530776 | 1040 Y | hmi.Mpatch_720s | phil | 115472703 | 1027 Y | hmi.S_720s | phil | 115467066 | 1028 Y | hmi.V_720s | phil | 110529327 | 1041 Y | hmi.V_720s | phil | 115472286 | 1028 N | hmi.lev1 | production | 106502808 | 1043 N | hmi.lev1 | production | 106502835 | 1054 N | hmi.lev1 | production | 106504536 | 1042 N | hmi.lev1 | production | 106504538 | 1054 N | hmi.lev1 | production | 106506330 | 1053 N | hmi.lev1 | production | 106506482 | 1040 N | hmi.lev1 | production | 106507013 | 1040 N | hmi.lev1 | production | 106508025 | 1058 N | hmi.lev1 | production | 106509352 | 1039 N | hmi.lev1 | production | 106510044 | 1039 N | hmi.lev1 | production | 106510046 | 1052 N | hmi.lev1 | production | 106510562 | 1038 N | hmi.lev1 | production | 106511910 | 1051 N | hmi.lev1 | production | 106511912 | 1036 N | hmi.lev1 | production | 106513157 | 1034 N | hmi.lev1 | production | 106513644 | 1033 N | hmi.lev1 | production | 106514631 | 1033 N | hmi.lev1 | production | 106514656 | 1050 Y | hmi.lev1 | production | 106514659 | 1057 Y | hmi.lev1 | production | 106515436 | 1060 Y | hmi.lev1 | production | 106515423 | 1057 N | hmi.lev1 | production | 106493377 | 1030 Y | hmi.lev1 | production | 106495641 | 1056 Y | hmi.lev1 | production | 106495667 | 1062 Y | hmi.lev1 | production | 106515435 | 1062 Y | hmi.lev1 | production | 110520358 | 1031 Y | hmi.lev1 | production | 110520542 | 1030 Y | hmi.lev1 | production | 110520689 | 1048 Y | hmi.lev1 | production | 110521427 | 1056 N | hmi.lev1 | production | 110522114 | 1059 Y | hmi.lev1 | production | 110522282 | 1027 N | hmi.lev1 | production | 110524493 | 1045 Y | hmi.lev1 | production | 106515424 | 1031 Y | hmi.lev1 | production | 106515421 | 1049 Y | hmi.lev1 | production | 106510042 | 1060 N | hmi.lev1 | production | 106510971 | 1052 N | hmi.lev1 | production | 106510047 | 1058 N | hmi.lev1 | production | 106512021 | 1036 Y | hmi.lev1 | production | 115474537 | 1042 Y | hmi.lev1 | production | 115474519 | 1054 Y | hmi.lev1 | production | 115475191 | 1042 Y | hmi.lev1 | production | 115475299 | 1041 Y | hmi.lev1 | production | 115475421 | 1041 Y | hmi.lev1 | production | 115475817 | 1040 Y | hmi.lev1 | production | 115475836 | 1053 Y | hmi.lev1 | production | 115476173 | 1052 Y | hmi.lev1 | production | 115476722 | 1038 Y | hmi.lev1 | production | 115476737 | 1038 Y | hmi.lev1 | production | 115476834 | 1036 Y | hmi.lev1 | production | 115477119 | 1034 Y | hmi.lev1 | production | 115477147 | 1034 Y | hmi.lev1 | production | 115477144 | 1050 Y | hmi.lev1 | production | 115477399 | 1033 Y | hmi.lev1 | production | 115477401 | 1057 Y | hmi.lev1 | production | 115477397 | 1050 Y | hmi.lev1 | production | 115477402 | 1060 Y | hmi.lev1 | production | 115477736 | 1032 Y | hmi.lev1 | production | 115477728 | 1049 Y | hmi.lev1 | production | 115477815 | 1032 N | hmi.lev1 | production | 116245026 | 1065 N | hmi.lev1 | production | 116245043 | 1065 N | hmi.lev1 | production | 106493755 | 1030 N | hmi.lev1 | production | 106494471 | 1029 N | hmi.lev1 | production | 106494789 | 1029 N | hmi.lev1 | production | 106495080 | 1029 N | hmi.lev1 | production | 106495090 | 1048 N | hmi.lev1 | production | 106495482 | 1048 N | hmi.lev1 | production | 106495480 | 1028 Y | hmi.lev1 | production | 106496037 | 1047 Y | hmi.lev1 | production | 106496040 | 1027 Y | hmi.lev1 | production | 106496283 | 1027 N | hmi.lev1 | production | 106497497 | 1046 N | hmi.lev1 | production | 106497483 | 1055 N | hmi.lev1 | production | 106497480 | 1059 N | hmi.lev1 | production | 106500531 | 1055 N | hmi.lev1 | production | 106500539 | 1044 N | hmi.lev1 | production | 106501193 | 1044 N | hmi.lev1 | production | 106501674 | 1055 N | hmi.lev1 | production | 106501665 | 1043 N | hmi.lev1 | production | 106501663 | 1059 N | hmi.lev1 | production | 106502222 | 1043 (128 rows)