SourceList 1: 183751 2df_V_18
SourceList 2: 183741 2df_R_18
Area:  [(10.66, -28.649999999999999), (10.66, -28.66), (10.65, -28.66), (10.65, -28.649999999999999)]
Sources in area in SL1: 1
Sources in area in SL2: 1
[tinsley] 15:43:01 - Preparing for the matching
SQL Command  
DELETE FROM AWOPER."ASSOCIATELIST_PAIRS_01"

SQL Command  
DELETE FROM AWOPER."ASSOCIATELIST_INPUTS"

SQL Command  
INSERT INTO AWOPER."ASSOCIATELIST_INPUTS" (SLID, SID, HTM, RA, DEC)
SELECT  T.SLID, T.SID, T.HTM, T.RA, T.DEC
FROM AWOPER."SOURCELIST*SOURCES" T
WHERE T.SLID IN (183751) AND (("HTM" >= 9133687937433600 and "HTM" <= 9133687954210815) or ("HTM" >= 9133687962599424 and "HTM" <= 9133687963647999) or ("HTM" >= 9133687964696576 and "HTM" <= 9133687966793727) or ("HTM" >= 9133687970988032 and "HTM" <= 9133687987765247) or ("HTM" >= 9133688142954496 and "HTM" <= 9133688144003071) or ("HTM" >= 9133688155537408 and "HTM" <= 9133688189091839))  AND (BITAND(T."Flag",0) = T."Flag")
Inserting query took    0.01 seconds (1 sources in SourceList with SLID = 183751)
[tinsley] 15:43:01 - Found 1 sources in SourceList with SLID = 183751
SQL Command  
INSERT INTO AWOPER."ASSOCIATELIST_INPUTS" (SLID, SID, HTM, RA, DEC)
SELECT  T.SLID, T.SID, T.HTM, T.RA, T.DEC
FROM AWOPER."SOURCELIST*SOURCES" T
WHERE T.SLID = 183741 AND (("HTM" >= 9133687937433600 and "HTM" <= 9133687954210815) or ("HTM" >= 9133687962599424 and "HTM" <= 9133687963647999) or ("HTM" >= 9133687964696576 and "HTM" <= 9133687966793727) or ("HTM" >= 9133687970988032 and "HTM" <= 9133687987765247) or ("HTM" >= 9133688142954496 and "HTM" <= 9133688144003071) or ("HTM" >= 9133688155537408 and "HTM" <= 9133688189091839))  AND (BITAND(T."Flag",0) = T."Flag")
Inserting query took    0.00 seconds (1 sources in SourceList with SLID = 183741)
[tinsley] 15:43:01 - Found 1 sources in SourceList with SLID = 183741
SQL Command  
INSERT INTO AWOPER."ASSOCIATELIST_PAIRS_01" (AID, SLID1, SID1, SLID2, SID2, DIST)
SELECT ROWNUM-1 AID, SLID1, SID1, SLID2, SID2, AWOPER.AW_UTIL.SECDISTANCE(RA1,DEC1,RA2,DEC2) DIST
FROM (
    SELECT SLID SLID1, SID SID1, HTM, RA RA1, DEC DEC1
    FROM AWOPER."ASSOCIATELIST_INPUTS"
    WHERE SLID = 183751
) T1, (
    SELECT SLID SLID2, SID SID2, HTM, RA RA2, DEC DEC2, COLUMN_VALUE VHTM
    FROM AWOPER."ASSOCIATELIST_INPUTS" T0, TABLE(AWOPER.AW_UTIL.RADIUSTEST(15, T0.RA, T0.DEC, 5.000000/3600.0))
    WHERE SLID = 183741
) T2
WHERE (
    TRUNC(T1.HTM/1048576) = T2.VHTM AND AWOPER.AW_UTIL.SECDISTANCE(RA1,DEC1,RA2,DEC2) <= 5.000000
)
[tinsley] 15:43:01 - Looking for pairs
[(0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,)]
Paring query took    0.05 seconds (1 pairs)
[(0,), (2,), (0,), (0,), (0,), (0,), (0,), (1,), (0,), (1,), (0,), (0,), (0,), (0,), (0,), (0,)]
[tinsley] 15:43:01 - Looking for closest pairs
SQL Command  
DELETE FROM AWOPER."ASSOCIATELIST_PAIRS_02"

SQL Command  
INSERT INTO AWOPER."ASSOCIATELIST_PAIRS_02" (AID, SLID1, SID1, SLID2, SID2, DIST)
SELECT ROWNUM-1 AID, Q.SLID1, Q.SID1, Q.SLID2, Q.SID2, Q.DIST
FROM (
    (
        SELECT A1.SLID1, A1.SID1, A1.SLID2, A1.SID2, A1.DIST
        FROM AWOPER."ASSOCIATELIST_PAIRS_01" A1, (
            SELECT T1.SID2, MIN(T1.DIST) MINDIST
            FROM (
                SELECT A2.SID1, A2.SID2, A2.DIST
                FROM AWOPER."ASSOCIATELIST_PAIRS_01" A2, (
                    SELECT T2.SID1, MIN(T2.DIST) MINDIST
                    FROM AWOPER."ASSOCIATELIST_PAIRS_01" T2
                    GROUP BY T2.SID1
                ) B2
                WHERE (A2.SID1 = B2.SID1 AND A2.DIST = B2.MINDIST)
            ) T1
            GROUP BY T1.SID2
        ) B1
        WHERE (A1.SID2 = B1.SID2 AND A1.DIST = B1.MINDIST)
    )
    UNION
    (
        SELECT A1.SLID1, A1.SID1, A1.SLID2, A1.SID2, A1.DIST
        FROM AWOPER."ASSOCIATELIST_PAIRS_01" A1, (
            SELECT T1.SID1, MIN(T1.DIST) MINDIST
            FROM (
                SELECT A2.SID2, A2.SID1, A2.DIST
                FROM AWOPER."ASSOCIATELIST_PAIRS_01" A2, (
                    SELECT T2.SID2, MIN(T2.DIST) MINDIST
                    FROM AWOPER."ASSOCIATELIST_PAIRS_01" T2
                    GROUP BY T2.SID2
                ) B2
                WHERE (A2.SID2 = B2.SID2 AND A2.DIST = B2.MINDIST)
            ) T1
            GROUP BY T1.SID1
        ) B1
        WHERE (A1.SID1 = B1.SID1 AND A1.DIST = B1.MINDIST)
    )
) Q
[(0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,)]
Filter query took    0.00 seconds (1 pairs): 
[(0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,), (0,)]
[tinsley] 15:43:01 - Filtered out 0 pairs
[tinsley] 15:43:01 - Found 1 pairs
[tinsley] 15:43:01 - Inserting first half of pairs
SQL Command =  
                INSERT INTO AWOPER."ASSOCIATELIST*ASSOCIATES" (ALID, AID, SLID, SID, FLAG)
                SELECT 77711 ALID, T1.AID AID, 183751 SLID, T1.SID1 SID, 3 FLAG
                FROM AWOPER."ASSOCIATELIST_PAIRS_02" T1
            
Inserting first part took    0.02 seconds
[tinsley] 15:43:01 - Inserting second half of pairs
SQL Command =  
                INSERT INTO AWOPER."ASSOCIATELIST*ASSOCIATES" (ALID, AID, SLID, SID, FLAG)
                SELECT 77711, T1.AID, 183741, T1.SID2, 3
                FROM AWOPER."ASSOCIATELIST_PAIRS_02" T1
            
Inserting second part took    0.02 seconds (1 records)
[tinsley] 15:43:01 - Inserting null associations from last input list
SQL Command =  
                INSERT INTO AWOPER."ASSOCIATELIST*ASSOCIATES" (ALID, AID, SLID, SID, FLAG)
                SELECT 77711 ALID, ROWNUM+0 AID, 183741 SLID, A1.SID, 2 FLAG
                FROM (
                    SELECT T1.SID SID
                    FROM AWOPER."ASSOCIATELIST_INPUTS" T1
                    MINUS
                    SELECT T2.SID2 SID
                    FROM AWOPER."ASSOCIATELIST_PAIRS_02" T2
                ) A1
             
Ingesting 1 singles from table with SLID = 183751 took    0.03 seconds
[tinsley] 15:43:01 - Inserting null associations from first input list
SQL Command =  
                INSERT INTO AWOPER."ASSOCIATELIST*ASSOCIATES" (ALID, AID, SLID, SID, FLAG)
                SELECT 77711 ALID, ROWNUM+1 AID, 183751 SLID, A1.SID, 1 FLAG
                FROM (
                    SELECT T1.SID SID
                    FROM AWOPER."ASSOCIATELIST_INPUTS" T1
                    MINUS
                    SELECT T2.SID1 SID
                    FROM AWOPER."ASSOCIATELIST_PAIRS_02" T2
                ) A1
            
Ingesting 1 singles from table with SLID = 183741 took    0.05 seconds
[tinsley] 15:43:01 - Created Chain AssociateList with ALID = 77711, name =  and 3 associates!
SQL Command =  
WITH Q AS (
    SELECT A.AID, A.SLID, A.SID
    FROM AWOPER."ASSOCIATELIST*ASSOCIATES" A
    WHERE (A.ALID = 77711 AND A.AID BETWEEN 0 AND 2 )
)
SELECT /*+ USE_NL(A,T) */ A.AID, T."SLID", T."SID", T."RA", T."DEC", T."HTM"
FROM Q A, AWOPER."SOURCELIST*SOURCES" T
WHERE T.SLID in (183751,183741) AND A.SLID = T.SLID AND A.SID = T.SID
ORDER BY AID

AID,SLID,SID,RA,DEC,HTM
0 [183751L, 590L, 10.658662629355399, -28.646318923467501, 9133688156790416L]
0 [183741L, 752L, 10.6586519018445, -28.646297732074299, 9133688156840465L]

1 [183741L, 590L, 10.6675241830053, -28.691657626438602, 9133689464519126L]

2 [183751L, 752L, 10.7524247997027, -28.580125536728701, 9133874796226817L]