DROP TABLE TABLES;

CREATE TABLE TABLES AS
WITH
T AS
(SELECT ROWNUM i FROM dual connect BY ROWNUM < 9)
SELECT t1.i r, t2.i c,
       (t1.i-1)*8+t2.i ID
  FROM T t1, T t2
;

DROP TABLE s;

CREATE TABLE s
AS
WITH
s AS(
SELECT  1 r,  2 c FROM dual UNION ALL
SELECT  1 r, -2 c FROM dual UNION ALL
SELECT  2 r, -1 c FROM dual UNION ALL
SELECT  2 r,  1 c FROM dual UNION ALL
SELECT -1 r,  2 c FROM dual UNION ALL
SELECT -1 r, -2 c FROM dual UNION ALL
SELECT -2 r, -1 c FROM dual UNION ALL
SELECT -2 r,  1 c FROM dual
)
SELECT t_from.ID id_from,
       t_from.r r_from,
       t_from.c c_from,
       t_to.ID id_to,
       t_to.r  r_to,
       t_to.c  c_to
  FROM TABLES t_from,
       s,
       TABLES t_to
 WHERE t_from.r + s.r = t_to.r
   AND t_from.c + s.c = t_to.c
 ORDER BY id_from, id_to;


DROP TABLE ss;

CREATE TABLE ss AS
SELECT s1.id_from, s1.id_to id_to1, s2.id_to id_to2
  FROM s s1,
       s s2
 WHERE s2.id_from = s1.id_to;

WITH
t0 AS
(SELECT ',1,' ID, 1 id_new FROM dual),
t1 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T0 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t2 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T1 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t3 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T2 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t4 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T3 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t5 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T4 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t6 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T5 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t7 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T6 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t8 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T7 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t9 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T8 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t10 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T9 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t11 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T10 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t12 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T11 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t13 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T12 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t14 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T13 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t15 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T14 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t16 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T15 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t17 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T16 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t18 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T17 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t19 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T18 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t20 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T19 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t21 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T20 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t22 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T21 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t23 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T22 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t24 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T23 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t25 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T24 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t26 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T25 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t27 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T26 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t28 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T27 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t29 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T28 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t30 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T29 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t31 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T30 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t32 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T31 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t33 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T32 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t34 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T33 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t35 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T34 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t36 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T35 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t37 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T36 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t38 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T37 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t39 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T38 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t40 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T39 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t41 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T40 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t42 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T41 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t43 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T42 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t44 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T43 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t45 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T44 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t46 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T45 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t47 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T46 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t48 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T47 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t49 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T48 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t50 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T49 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t51 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T50 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t52 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T51 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t53 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T52 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t54 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T53 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t55 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T54 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t56 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T55 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t57 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T56 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t58 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T57 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t59 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T58 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t60 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T59 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t61 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T60 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t62 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T61 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
   AND T.ID NOT LIKE '%,'||ss.id_to2||',%' 
 GROUP BY ss.id_to1
)),

t63 AS
(SELECT ID||id_new||',' ID, id_new FROM(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, MAX(MAX(ID)) ID
  FROM T62 T,
       ss
 WHERE ss.id_from = T.id_new
   AND T.ID NOT LIKE '%,'||ss.id_to1||',%' 
 GROUP BY ss.id_to1
))
SELECT * FROM t63

WITH
T0 AS (SELECT ROWNUM-1 I0, ROWNUM I FROM dual connect BY ROWNUM < 64)
SELECT
't' || i || ' AS
(select id||id_new||'','' id, id_new from(
SELECT MAX(ss.id_to1) KEEP(DENSE_RANK FIRST ORDER BY COUNT(*)) ID_new, max(max(id)) id
  FROM T' || i0 || ' t,
       ss
 WHERE ss.id_from = t.id_new
   AND T.id not like ''%,''||ss.id_to1||'',%'' 
   AND T.id not like ''%,''||ss.id_to2||'',%'' 
 GROUP BY ss.id_to1
)),
' FROM t0 

WITH Z AS
        (SELECT ROWNUM I
            FROM DUAL
         CONNECT BY ROWNUM < 9
        ),
     TABLES AS
        (SELECT T1.I R, T2.I C, (T1.I - 1) * 8 + T2.I ID
           FROM Z T1, Z T2
         ),
     Sint
     AS (SELECT  1 R,  2 C FROM DUAL UNION ALL
         SELECT  1 R, -2 C FROM DUAL UNION ALL
         SELECT  2 R, -1 C FROM DUAL UNION ALL
         SELECT  2 R,  1 C FROM DUAL UNION ALL
         SELECT -1 R,  2 C FROM DUAL UNION ALL
         SELECT -1 R, -2 C FROM DUAL UNION ALL
         SELECT -2 R, -1 C FROM DUAL UNION ALL
         SELECT -2 R,  1 C FROM DUAL
        ),
     S AS
        (SELECT T_from.ID Id_from,
                T_from.R R_from,
                T_from.C C_from,
                T_to.ID Id_to,
                T_to.R R_to,
                T_to.C C_to
           FROM TABLES T_from, Sint S, TABLES T_to
          WHERE T_from.R + S.R = T_to.R AND T_from.C + S.C = T_to.C
        ),
     Ss
     AS (SELECT S1.Id_from, S1.Id_to Id_to1, S2.Id_to Id_to2
           FROM S S1, S S2
          WHERE S2.Id_from = S1.Id_to
        ),
     T0 AS (SELECT cast(',' AS VARCHAR2(4000)) ID FROM DUAL),
     T (ID, Id_new, L)
     AS (
         SELECT ID, 1 Id_new, 1 L FROM T0
         UNION ALL
         SELECT   ID || Id_new || ',' ID,
                  (
                     SELECT      MAX(Ss.Id_to1) KEEP (DENSE_RANK FIRST ORDER BY COUNT(*))
                         FROM Ss
                        WHERE Ss.Id_from = T.Id_new
                          AND T.ID || Id_new || ',' NOT LIKE '%,' || Ss.Id_to1 || ',%'
                          AND (T.ID || Id_new || ',' NOT LIKE '%,' || Ss.Id_to2 || ',%' OR l = 63)
                     GROUP BY Ss.Id_to1
                  )   Id_new,
                  L+1 L
             FROM T
            WHERE L < 64
        )
SELECT ID || id_new
  FROM T
 WHERE l = 64