Your SQL command was:
SELECT TOP 10 P.ObjID
FROM PhotoPrimary AS P
JOIN Neighbors AS N ON P.ObjID = N.ObjID
JOIN PhotoPrimary AS L ON L.ObjID = N.NeighborObjID
WHERE
P.ObjID < L. ObjID
and abs((P.u-P.g)-(L.u-L.g))<0.05
and abs((P.g-P.r)-(L.g-L.r))<0.05
and abs((P.r-P.i)-(L.r-L.i))<0.05
and abs((P.i-P.z)-(L.i-L.z))<0.05
Your query output (max 500,000 rows):
ObjID |
1237651758284999319 |
1237651758284934748 |
1237651758284997763 |
1237651758284933029 |
1237651758284933029 |
1237651758284934729 |
1237651758284934729 |
1237651758284997777 |
1237651758284997163 |
1237651758284997182 |