text: -- This SQL code was generated by sklearn2sql (development version).
  -- Copyright 2018
  
  -- Model : CaretClassifier_cforest_pca
  -- Dataset : BreastCancer
  -- Database : oracle
  
  
  -- This SQL code can contain one or more statements, to be executed in the order they appear in this file.
  
  
  
  -- Model deployment code
  
  WITH "ADS_sca_1_OUT" AS 
  (SELECT "ADS"."KEY" AS "KEY", (CAST("ADS"."Feature_0" AS BINARY_DOUBLE) - 14.07771208791209) / 3.5490515005403798 AS "Feature_0", (CAST("ADS"."Feature_1" AS BINARY_DOUBLE) - 19.03905494505495) / 4.166878656652379 AS "Feature_1", (CAST("ADS"."Feature_2" AS BINARY_DOUBLE) - 91.66178021978024) / 24.53094385251417 AS "Feature_2", (CAST("ADS"."Feature_3" AS BINARY_DOUBLE) - 650.9676923076922) / 356.0943508808365 AS "Feature_3", (CAST("ADS"."Feature_4" AS BINARY_DOUBLE) - 0.09642184615384616) / 0.01421344742747642 AS "Feature_4", (CAST("ADS"."Feature_5" AS BINARY_DOUBLE) - 0.1044161318681319) / 0.053462476960143265 AS "Feature_5", (CAST("ADS"."Feature_6" AS BINARY_DOUBLE) - 0.08826232681318681) / 0.08200216346057157 AS "Feature_6", (CAST("ADS"."Feature_7" AS BINARY_DOUBLE) - 0.0485164) / 0.03941645600907594 AS "Feature_7", (CAST("ADS"."Feature_8" AS BINARY_DOUBLE) - 0.1815885714285714) / 0.02782064728498547 AS "Feature_8", (CAST("ADS"."Feature_9" AS BINARY_DOUBLE) - 0.0629403076923077) / 0.007027080900659396 AS "Feature_9", (CAST("ADS"."Feature_10" AS BINARY_DOUBLE) - 0.4099173626373626) / 0.2915245412208004 AS "Feature_10", (CAST("ADS"."Feature_11" AS BINARY_DOUBLE) - 1.217069450549451) / 0.5369800521839988 AS "Feature_11", (CAST("ADS"."Feature_12" AS BINARY_DOUBLE) - 2.9052490109890114) / 2.144852707447646 AS "Feature_12", (CAST("ADS"."Feature_13" AS BINARY_DOUBLE) - 40.87988571428571) / 48.2778362287006 AS "Feature_13", (CAST("ADS"."Feature_14" AS BINARY_DOUBLE) - 0.0070559714285714295) / 0.002866803723188527 AS "Feature_14", (CAST("ADS"."Feature_15" AS BINARY_DOUBLE) - 0.02556783076923077) / 0.01796676819246774 AS "Feature_15", (CAST("ADS"."Feature_16" AS BINARY_DOUBLE) - 0.031999256263736266) / 0.03169979081746389 AS "Feature_16", (CAST("ADS"."Feature_17" AS BINARY_DOUBLE) - 0.01197236923076923) / 0.006399041370931476 AS "Feature_17", (CAST("ADS"."Feature_18" AS BINARY_DOUBLE) - 0.0208962) / 0.008592357424589265 AS "Feature_18", (CAST("ADS"."Feature_19" AS BINARY_DOUBLE) - 0.003846551868131868) / 0.0027466275188339 AS "Feature_19", (CAST("ADS"."Feature_20" AS BINARY_DOUBLE) - 16.17776483516484) / 4.822761469227882 AS "Feature_20", (CAST("ADS"."Feature_21" AS BINARY_DOUBLE) - 25.26505494505495) / 5.929844025113361 AS "Feature_21", (CAST("ADS"."Feature_22" AS BINARY_DOUBLE) - 106.68156043956041) / 33.740956745431944 AS "Feature_22", (CAST("ADS"."Feature_23" AS BINARY_DOUBLE) - 870.863956043956) / 567.6191564029466 AS "Feature_23", (CAST("ADS"."Feature_24" AS BINARY_DOUBLE) - 0.1318275604395604) / 0.02277324683369087 AS "Feature_24", (CAST("ADS"."Feature_25" AS BINARY_DOUBLE) - 0.2499180659340659) / 0.1526367614098782 AS "Feature_25", (CAST("ADS"."Feature_26" AS BINARY_DOUBLE) - 0.2654615934065934) / 0.2071534531545495 AS "Feature_26", (CAST("ADS"."Feature_27" AS BINARY_DOUBLE) - 0.1134879802197802) / 0.06645447985497112 AS "Feature_27", (CAST("ADS"."Feature_28" AS BINARY_DOUBLE) - 0.2897881318681318) / 0.06227317635385585 AS "Feature_28", (CAST("ADS"."Feature_29" AS BINARY_DOUBLE) - 0.08364145054945055) / 0.01708392968253732 AS "Feature_29" 
  FROM "BREASTCANCER" "ADS"), 
  "ADS_pre_1_OUT" AS 
  (SELECT "ADS_sca_1_OUT"."KEY" AS "KEY", "ADS_sca_1_OUT"."Feature_0" * -0.21768343094223108 + "ADS_sca_1_OUT"."Feature_1" * -0.10393262184047268 + "ADS_sca_1_OUT"."Feature_2" * -0.2265164944329179 + "ADS_sca_1_OUT"."Feature_3" * -0.21993736711575185 + "ADS_sca_1_OUT"."Feature_4" * -0.14268833980412854 + "ADS_sca_1_OUT"."Feature_5" * -0.24024798670573505 + "ADS_sca_1_OUT"."Feature_6" * -0.257355901686626 + "ADS_sca_1_OUT"."Feature_7" * -0.2597680750587679 + "ADS_sca_1_OUT"."Feature_8" * -0.13868620385317515 + "ADS_sca_1_OUT"."Feature_9" * -0.06712190195264113 + "ADS_sca_1_OUT"."Feature_10" * -0.2069150720147228 + "ADS_sca_1_OUT"."Feature_11" * -0.03305717760079786 + "ADS_sca_1_OUT"."Feature_12" * -0.212828518237874 + "ADS_sca_1_OUT"."Feature_13" * -0.2013439160056293 + "ADS_sca_1_OUT"."Feature_14" * -0.02049865164066569 + "ADS_sca_1_OUT"."Feature_15" * -0.1750181653895911 + "ADS_sca_1_OUT"."Feature_16" * -0.1519078637342155 + "ADS_sca_1_OUT"."Feature_17" * -0.1865203607950731 + "ADS_sca_1_OUT"."Feature_18" * -0.053039357385151385 + "ADS_sca_1_OUT"."Feature_19" * -0.10231665221046024 + "ADS_sca_1_OUT"."Feature_20" * -0.226956028801125 + "ADS_sca_1_OUT"."Feature_21" * -0.10317017778958812 + "ADS_sca_1_OUT"."Feature_22" * -0.23602999862163965 + "ADS_sca_1_OUT"."Feature_23" * -0.2240006176535796 + "ADS_sca_1_OUT"."Feature_24" * -0.12717220549829955 + "ADS_sca_1_OUT"."Feature_25" * -0.21222759880468806 + "ADS_sca_1_OUT"."Feature_26" * -0.22758988828313426 + "ADS_sca_1_OUT"."Feature_27" * -0.2490125441701701 + "ADS_sca_1_OUT"."Feature_28" * -0.11944032522919835 + "ADS_sca_1_OUT"."Feature_29" * -0.13166419338876287 AS "PC1", "ADS_sca_1_OUT"."Feature_0" * 0.2388263496095884 + "ADS_sca_1_OUT"."Feature_1" * 0.05323416968015016 + "ADS_sca_1_OUT"."Feature_2" * 0.21941449489711815 + "ADS_sca_1_OUT"."Feature_3" * 0.2342171388843593 + "ADS_sca_1_OUT"."Feature_4" * -0.17925865624129375 + "ADS_sca_1_OUT"."Feature_5" * -0.14316495439683485 + "ADS_sca_1_OUT"."Feature_6" * -0.06042147680146465 + "ADS_sca_1_OUT"."Feature_7" * 0.03722975887665922 + "ADS_sca_1_OUT"."Feature_8" * -0.19462120663415455 + "ADS_sca_1_OUT"."Feature_9" * -0.3731777815015735 + "ADS_sca_1_OUT"."Feature_10" * 0.0948169433203506 + "ADS_sca_1_OUT"."Feature_11" * -0.10262087159564362 + "ADS_sca_1_OUT"."Feature_12" * 0.08014049234060505 + "ADS_sca_1_OUT"."Feature_13" * 0.14683589434398536 + "ADS_sca_1_OUT"."Feature_14" * -0.21665542062253368 + "ADS_sca_1_OUT"."Feature_15" * -0.22633882980546735 + "ADS_sca_1_OUT"."Feature_16" * -0.2013330897413932 + "ADS_sca_1_OUT"."Feature_17" * -0.13744139199061656 + "ADS_sca_1_OUT"."Feature_18" * -0.1851008068283944 + "ADS_sca_1_OUT"."Feature_19" * -0.2787797373414811 + "ADS_sca_1_OUT"."Feature_20" * 0.22285850281808672 + "ADS_sca_1_OUT"."Feature_21" * 0.04796372561185864 + "ADS_sca_1_OUT"."Feature_22" * 0.20144532663199727 + "ADS_sca_1_OUT"."Feature_23" * 0.22117900125773696 + "ADS_sca_1_OUT"."Feature_24" * -0.16388533650733236 + "ADS_sca_1_OUT"."Feature_25" * -0.12771851864859946 + "ADS_sca_1_OUT"."Feature_26" * -0.0920845205598406 + "ADS_sca_1_OUT"."Feature_27" * 0.01180363799025717 + "ADS_sca_1_OUT"."Feature_28" * -0.13218791158615573 + "ADS_sca_1_OUT"."Feature_29" * -0.272971048775739 AS "PC2", "ADS_sca_1_OUT"."Feature_0" * -0.005390218995132989 + "ADS_sca_1_OUT"."Feature_1" * 0.07559188324769446 + "ADS_sca_1_OUT"."Feature_2" * -0.006630034456413209 + "ADS_sca_1_OUT"."Feature_3" * 0.03307539547257528 + "ADS_sca_1_OUT"."Feature_4" * -0.11408606276317496 + "ADS_sca_1_OUT"."Feature_5" * -0.08243204451061603 + "ADS_sca_1_OUT"."Feature_6" * -0.0034631546527687713 + "ADS_sca_1_OUT"."Feature_7" * -0.025369092650600944 + "ADS_sca_1_OUT"."Feature_8" * -0.03545304892446201 + "ADS_sca_1_OUT"."Feature_9" * -0.033460358570260834 + "ADS_sca_1_OUT"."Feature_10" * 0.2702606607101766 + "ADS_sca_1_OUT"."Feature_11" * 0.38895800748244913 + "ADS_sca_1_OUT"."Feature_12" * 0.265539009843534 + "ADS_sca_1_OUT"."Feature_13" * 0.22087996051915645 + "ADS_sca_1_OUT"."Feature_14" * 0.30083207092269965 + "ADS_sca_1_OUT"."Feature_15" * 0.14870995945035803 + "ADS_sca_1_OUT"."Feature_16" * 0.15617929564803443 + "ADS_sca_1_OUT"."Feature_17" * 0.20527006718186183 + "ADS_sca_1_OUT"."Feature_18" * 0.2727509234513494 + "ADS_sca_1_OUT"."Feature_19" * 0.20491559570513843 + "ADS_sca_1_OUT"."Feature_20" * -0.04651017214243354 + "ADS_sca_1_OUT"."Feature_21" * -0.030620841495121995 + "ADS_sca_1_OUT"."Feature_22" * -0.04908306111118616 + "ADS_sca_1_OUT"."Feature_23" * -0.009372073109054205 + "ADS_sca_1_OUT"."Feature_24" * -0.2716162372345253 + "ADS_sca_1_OUT"."Feature_25" * -0.2404036986894661 + "ADS_sca_1_OUT"."Feature_26" * -0.17728088382408685 + "ADS_sca_1_OUT"."Feature_27" * -0.1759158149922438 + "ADS_sca_1_OUT"."Feature_28" * -0.2741603341993864 + "ADS_sca_1_OUT"."Feature_29" * -0.23752113369727115 AS "PC3", "ADS_sca_1_OUT"."Feature_0" * 0.032221335163821266 + "ADS_sca_1_OUT"."Feature_1" * -0.5981813597757002 + "ADS_sca_1_OUT"."Feature_2" * 0.03274684636104511 + "ADS_sca_1_OUT"."Feature_3" * 0.051633089886458795 + "ADS_sca_1_OUT"."Feature_4" * 0.1894886130432605 + "ADS_sca_1_OUT"."Feature_5" * 0.025213175765623888 + "ADS_sca_1_OUT"."Feature_6" * 0.020686309537882627 + "ADS_sca_1_OUT"."Feature_7" * 0.06556536720486286 + "ADS_sca_1_OUT"."Feature_8" * 0.07581347598658743 + "ADS_sca_1_OUT"."Feature_9" * 0.039784025514564836 + "ADS_sca_1_OUT"."Feature_10" * 0.12103267182656124 + "ADS_sca_1_OUT"."Feature_11" * -0.3253456701348236 + "ADS_sca_1_OUT"."Feature_12" * 0.10403160451161235 + "ADS_sca_1_OUT"."Feature_13" * 0.13096113686887037 + "ADS_sca_1_OUT"."Feature_14" * 0.08529767241873171 + "ADS_sca_1_OUT"."Feature_15" * -0.05050256477826615 + "ADS_sca_1_OUT"."Feature_16" * -0.013858636956129685 + "ADS_sca_1_OUT"."Feature_17" * 0.051636470783270175 + "ADS_sca_1_OUT"."Feature_18" * 0.07845623611137836 + "ADS_sca_1_OUT"."Feature_19" * -0.01800224834117843 + "ADS_sca_1_OUT"."Feature_20" * 0.01340810356608377 + "ADS_sca_1_OUT"."Feature_21" * -0.6255117301896479 + "ADS_sca_1_OUT"."Feature_22" * 0.008890529878086695 + "ADS_sca_1_OUT"."Feature_23" * 0.03206575052269575 + "ADS_sca_1_OUT"."Feature_24" * 0.06218614198553856 + "ADS_sca_1_OUT"."Feature_25" * -0.10208562087194813 + "ADS_sca_1_OUT"."Feature_26" * -0.07404407884842225 + "ADS_sca_1_OUT"."Feature_27" * -0.001759497416926437 + "ADS_sca_1_OUT"."Feature_28" * -0.020695280701914644 + "ADS_sca_1_OUT"."Feature_29" * -0.09172275305484348 AS "PC4", "ADS_sca_1_OUT"."Feature_0" * -0.03583586526438166 + "ADS_sca_1_OUT"."Feature_1" * 0.10668556494546105 + "ADS_sca_1_OUT"."Feature_2" * -0.03580063384563657 + "ADS_sca_1_OUT"."Feature_3" * -0.01186523434650828 + "ADS_sca_1_OUT"."Feature_4" * 0.3472926626357166 + "ADS_sca_1_OUT"."Feature_5" * -0.01279638595762936 + "ADS_sca_1_OUT"."Feature_6" * -0.09686339610083955 + "ADS_sca_1_OUT"."Feature_7" * 0.030262925273250155 + "ADS_sca_1_OUT"."Feature_8" * 0.2919734843378978 + "ADS_sca_1_OUT"."Feature_9" * 0.024129207305013743 + "ADS_sca_1_OUT"."Feature_10" * 0.13199923484872902 + "ADS_sca_1_OUT"."Feature_11" * 0.21157425482633896 + "ADS_sca_1_OUT"."Feature_12" * 0.10248820501553313 + "ADS_sca_1_OUT"."Feature_13" * 0.10874553311679416 + "ADS_sca_1_OUT"."Feature_14" * 0.2544812741423084 + "ADS_sca_1_OUT"."Feature_15" * -0.2746684061050128 + "ADS_sca_1_OUT"."Feature_16" * -0.3540979971305165 + "ADS_sca_1_OUT"."Feature_17" * -0.19847452634975313 + "ADS_sca_1_OUT"."Feature_18" * 0.24138551945384004 + "ADS_sca_1_OUT"."Feature_19" * -0.27461076869519324 + "ADS_sca_1_OUT"."Feature_20" * 0.00438970711748895 + "ADS_sca_1_OUT"."Feature_21" * 0.15304890309187444 + "ADS_sca_1_OUT"."Feature_22" * -0.0062975700081063036 + "ADS_sca_1_OUT"."Feature_23" * 0.02449023484088534 + "ADS_sca_1_OUT"."Feature_24" * 0.3212354882834555 + "ADS_sca_1_OUT"."Feature_25" * -0.10048955127484832 + "ADS_sca_1_OUT"."Feature_26" * -0.18301792369043487 + "ADS_sca_1_OUT"."Feature_27" * -0.04092825303637145 + "ADS_sca_1_OUT"."Feature_28" * 0.25478475230789854 + "ADS_sca_1_OUT"."Feature_29" * -0.09149620178238 AS "PC5", "ADS_sca_1_OUT"."Feature_0" * 0.02578277051115795 + "ADS_sca_1_OUT"."Feature_1" * -0.03488683150504261 + "ADS_sca_1_OUT"."Feature_2" * 0.02337879624440808 + "ADS_sca_1_OUT"."Feature_3" * 5.311632734197533e-05 + "ADS_sca_1_OUT"."Feature_4" * -0.2831599190004263 + "ADS_sca_1_OUT"."Feature_5" * -0.0182359166955445 + "ADS_sca_1_OUT"."Feature_6" * -0.00606493341165939 + "ADS_sca_1_OUT"."Feature_7" * -0.04670696605311275 + "ADS_sca_1_OUT"."Feature_8" * 0.3517020411433183 + "ADS_sca_1_OUT"."Feature_9" * -0.1269409741371922 + "ADS_sca_1_OUT"."Feature_10" * -0.044449703384920235 + "ADS_sca_1_OUT"."Feature_11" * -0.05130045078703252 + "ADS_sca_1_OUT"."Feature_12" * -0.015070584315048681 + "ADS_sca_1_OUT"."Feature_13" * -0.06214481224260445 + "ADS_sca_1_OUT"."Feature_14" * -0.300750288327894 + "ADS_sca_1_OUT"."Feature_15" * 0.05383577001601851 + "ADS_sca_1_OUT"."Feature_16" * 0.07247828206101359 + "ADS_sca_1_OUT"."Feature_17" * -0.0041762502813039925 + "ADS_sca_1_OUT"."Feature_18" * 0.4992859784606968 + "ADS_sca_1_OUT"."Feature_19" * -0.05341104577876922 + "ADS_sca_1_OUT"."Feature_20" * 0.004227623567498342 + "ADS_sca_1_OUT"."Feature_21" * -0.04884501480701089 + "ADS_sca_1_OUT"."Feature_22" * 0.01367243473013742 + "ADS_sca_1_OUT"."Feature_23" * -0.025887660162104482 + "ADS_sca_1_OUT"."Feature_24" * -0.3595690657677812 + "ADS_sca_1_OUT"."Feature_25" * 0.03179116825393049 + "ADS_sca_1_OUT"."Feature_26" * 0.02848854626295261 + "ADS_sca_1_OUT"."Feature_27" * -0.024367902666235317 + "ADS_sca_1_OUT"."Feature_28" * 0.5192968623188767 + "ADS_sca_1_OUT"."Feature_29" * -0.1046011433247024 AS "PC6", "ADS_sca_1_OUT"."Feature_0" * -0.12457908312011272 + "ADS_sca_1_OUT"."Feature_1" * 0.043675631031051536 + "ADS_sca_1_OUT"."Feature_2" * -0.11727029149412173 + "ADS_sca_1_OUT"."Feature_3" * -0.0486941022474712 + "ADS_sca_1_OUT"."Feature_4" * -0.17248329424325504 + "ADS_sca_1_OUT"."Feature_5" * -0.01162088057329262 + "ADS_sca_1_OUT"."Feature_6" * -0.1260478446835378 + "ADS_sca_1_OUT"."Feature_7" * -0.19103591169799236 + "ADS_sca_1_OUT"."Feature_8" * -0.07463523147781233 + "ADS_sca_1_OUT"."Feature_9" * 0.25365336934237714 + "ADS_sca_1_OUT"."Feature_10" * 0.31534600516947087 + "ADS_sca_1_OUT"."Feature_11" * -0.20406041132463007 + "ADS_sca_1_OUT"."Feature_12" * 0.3129999653561438 + "ADS_sca_1_OUT"."Feature_13" * 0.36739957495731773 + "ADS_sca_1_OUT"."Feature_14" * -0.168697058125119 + "ADS_sca_1_OUT"."Feature_15" * 0.03886218090385512 + "ADS_sca_1_OUT"."Feature_16" * -0.17964511528914745 + "ADS_sca_1_OUT"."Feature_17" * -0.3603043202671293 + "ADS_sca_1_OUT"."Feature_18" * -0.04631020413416123 + "ADS_sca_1_OUT"."Feature_19" * 0.19111982295929997 + "ADS_sca_1_OUT"."Feature_20" * -0.0005144819631284318 + "ADS_sca_1_OUT"."Feature_21" * 0.030363622992810892 + "ADS_sca_1_OUT"."Feature_22" * 0.008358940593792955 + "ADS_sca_1_OUT"."Feature_23" * 0.0811779959920401 + "ADS_sca_1_OUT"."Feature_24" * -0.08858951896614652 + "ADS_sca_1_OUT"."Feature_25" * 0.13376257671354125 + "ADS_sca_1_OUT"."Feature_26" * -0.0655332998308909 + "ADS_sca_1_OUT"."Feature_27" * -0.1772937084691342 + "ADS_sca_1_OUT"."Feature_28" * 0.06513011232874036 + "ADS_sca_1_OUT"."Feature_29" * 0.369067836821968 AS "PC7" 
  FROM "ADS_sca_1_OUT"), 
  "DT_node_lookup" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.6577936932615345) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -5.804935824673063) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -2.4597188265185417) THEN 5 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -1.011849865868495) THEN 7 ELSE 8 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.012419833045249) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 1.280384434221947) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -1.2005742989964618) THEN 12 ELSE 13 END ELSE 14 END ELSE 15 END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.285714285714286 AS "P_0", 0.714285714285714 AS "P_1", 1 AS "D", 0.714285714285714 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 7 AS nid, 0.3 AS "P_0", 0.7 AS "P_1", 1 AS "D", 0.7 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 12 AS nid, 0.285714285714286 AS "P_0", 0.714285714285714 AS "P_1", 1 AS "D", 0.714285714285714 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL) "Values"), 
  "DT_Output" AS 
  (SELECT "DT_node_lookup"."KEY" AS "KEY", "DT_node_lookup".node_id_2 AS node_id_2, "DT_node_data".nid AS nid, "DT_node_data"."P_0" AS "P_0", "DT_node_data"."P_1" AS "P_1", "DT_node_data"."D" AS "D", "DT_node_data"."DP" AS "DP" 
  FROM "DT_node_lookup" LEFT OUTER JOIN "DT_node_data" ON "DT_node_lookup".node_id_2 = "DT_node_data".nid), 
  "RF_Model_0" AS 
  (SELECT "DT_Output"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output"."P_0" AS "Proba_0", CASE WHEN ("DT_Output"."P_0" IS NULL OR "DT_Output"."P_0" > 0.0) THEN ln("DT_Output"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output"."P_1" AS "Proba_1", CASE WHEN ("DT_Output"."P_1" IS NULL OR "DT_Output"."P_1" > 0.0) THEN ln("DT_Output"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output"), 
  "DT_node_lookup_1" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2493210488246035) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.733626410562294) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -1.210431346725052) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -2.1417966264444432) THEN 6 ELSE 7 END ELSE 8 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.8041191107097434) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.4551547592712303) THEN 11 ELSE 12 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.7903404826859886) THEN 14 ELSE 15 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_1" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.0625 AS "P_0", 0.9375 AS "P_1", 1 AS "D", 0.9375 AS "DP" FROM DUAL UNION ALL SELECT 6 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 7 AS nid, 0.875 AS "P_0", 0.125 AS "P_1", 0 AS "D", 0.875 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 0.7058823529411763 AS "P_0", 0.2941176470588237 AS "P_1", 0 AS "D", 0.7058823529411763 AS "DP" FROM DUAL UNION ALL SELECT 11 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 12 AS nid, 0.636363636363636 AS "P_0", 0.363636363636364 AS "P_1", 0 AS "D", 0.636363636363636 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.142857142857143 AS "P_0", 0.857142857142857 AS "P_1", 1 AS "D", 0.857142857142857 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_1" AS 
  (SELECT "DT_node_lookup_1"."KEY" AS "KEY", "DT_node_lookup_1".node_id_2 AS node_id_2, "DT_node_data_1".nid AS nid, "DT_node_data_1"."P_0" AS "P_0", "DT_node_data_1"."P_1" AS "P_1", "DT_node_data_1"."D" AS "D", "DT_node_data_1"."DP" AS "DP" 
  FROM "DT_node_lookup_1" LEFT OUTER JOIN "DT_node_data_1" ON "DT_node_lookup_1".node_id_2 = "DT_node_data_1".nid), 
  "RF_Model_1" AS 
  (SELECT "DT_Output_1"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_1"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_1"."P_0" IS NULL OR "DT_Output_1"."P_0" > 0.0) THEN ln("DT_Output_1"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_1"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_1"."P_1" IS NULL OR "DT_Output_1"."P_1" > 0.0) THEN ln("DT_Output_1"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_1"), 
  "DT_node_lookup_2" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2493210488246035) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -1.889700691682504) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -1.365689903713131) THEN 5 ELSE 6 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.012419833045249) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 1.127526881771057) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.120024758516615) THEN 10 ELSE 11 END ELSE 12 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.940604668982251) THEN 14 ELSE 15 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_2" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.428571428571429 AS "P_0", 0.571428571428571 AS "P_1", 1 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 0.733333333333333 AS "P_0", 0.266666666666667 AS "P_1", 0 AS "D", 0.733333333333333 AS "DP" FROM DUAL UNION ALL SELECT 6 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 10 AS nid, 0.142857142857143 AS "P_0", 0.857142857142857 AS "P_1", 1 AS "D", 0.857142857142857 AS "DP" FROM DUAL UNION ALL SELECT 11 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 12 AS nid, 0.555555555555556 AS "P_0", 0.444444444444444 AS "P_1", 0 AS "D", 0.555555555555556 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.25 AS "P_0", 0.75 AS "P_1", 1 AS "D", 0.75 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_2" AS 
  (SELECT "DT_node_lookup_2"."KEY" AS "KEY", "DT_node_lookup_2".node_id_2 AS node_id_2, "DT_node_data_2".nid AS nid, "DT_node_data_2"."P_0" AS "P_0", "DT_node_data_2"."P_1" AS "P_1", "DT_node_data_2"."D" AS "D", "DT_node_data_2"."DP" AS "DP" 
  FROM "DT_node_lookup_2" LEFT OUTER JOIN "DT_node_data_2" ON "DT_node_lookup_2".node_id_2 = "DT_node_data_2".nid), 
  "RF_Model_2" AS 
  (SELECT "DT_Output_2"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_2"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_2"."P_0" IS NULL OR "DT_Output_2"."P_0" > 0.0) THEN ln("DT_Output_2"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_2"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_2"."P_1" IS NULL OR "DT_Output_2"."P_1" > 0.0) THEN ln("DT_Output_2"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_2"), 
  "DT_node_lookup_3" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2493210488246035) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -3.4328002776640862) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.157128533324294) THEN 4 ELSE 5 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.4787494298747238) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -1.365689903713131) THEN 8 ELSE 9 END ELSE 10 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.6500636434222127) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.585426513178066) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.5042275588960071) THEN 14 ELSE 15 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.95276272970019) THEN 17 ELSE 18 END END ELSE 19 END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_3" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 4 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 0.07142857142857137 AS "P_0", 0.9285714285714286 AS "P_1", 1 AS "D", 0.9285714285714286 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 0.888888888888889 AS "P_0", 0.111111111111111 AS "P_1", 0 AS "D", 0.888888888888889 AS "DP" FROM DUAL UNION ALL SELECT 9 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 10 AS nid, 0.636363636363636 AS "P_0", 0.363636363636364 AS "P_1", 0 AS "D", 0.636363636363636 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 0.375 AS "P_0", 0.625 AS "P_1", 1 AS "D", 0.625 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 18 AS nid, 0.133333333333333 AS "P_0", 0.866666666666667 AS "P_1", 1 AS "D", 0.866666666666667 AS "DP" FROM DUAL UNION ALL SELECT 19 AS nid, 0.5 AS "P_0", 0.5 AS "P_1", 0 AS "D", 0.5 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_3" AS 
  (SELECT "DT_node_lookup_3"."KEY" AS "KEY", "DT_node_lookup_3".node_id_2 AS node_id_2, "DT_node_data_3".nid AS nid, "DT_node_data_3"."P_0" AS "P_0", "DT_node_data_3"."P_1" AS "P_1", "DT_node_data_3"."D" AS "D", "DT_node_data_3"."DP" AS "DP" 
  FROM "DT_node_lookup_3" LEFT OUTER JOIN "DT_node_data_3" ON "DT_node_lookup_3".node_id_2 = "DT_node_data_3".nid), 
  "RF_Model_3" AS 
  (SELECT "DT_Output_3"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_3"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_3"."P_0" IS NULL OR "DT_Output_3"."P_0" > 0.0) THEN ln("DT_Output_3"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_3"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_3"."P_1" IS NULL OR "DT_Output_3"."P_1" > 0.0) THEN ln("DT_Output_3"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_3"), 
  "DT_node_lookup_4" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.7910881490697043) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.059883108356034) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -2.216642042060263) THEN 5 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -1.011849865868495) THEN 7 ELSE 8 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.012419833045249) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 0.5000114205097542) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.1193127623737757) THEN 12 ELSE 13 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -0.7560730118386707) THEN 15 ELSE 16 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.889191737833252) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.940604668982251) THEN 19 ELSE 20 END ELSE 21 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_4" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.428571428571429 AS "P_0", 0.571428571428571 AS "P_1", 1 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 7 AS nid, 0.428571428571429 AS "P_0", 0.571428571428571 AS "P_1", 1 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 12 AS nid, 0.166666666666667 AS "P_0", 0.833333333333333 AS "P_1", 1 AS "D", 0.833333333333333 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.142857142857143 AS "P_0", 0.857142857142857 AS "P_1", 1 AS "D", 0.857142857142857 AS "DP" FROM DUAL UNION ALL SELECT 16 AS nid, 0.823529411764706 AS "P_0", 0.176470588235294 AS "P_1", 0 AS "D", 0.823529411764706 AS "DP" FROM DUAL UNION ALL SELECT 19 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 20 AS nid, 0.142857142857143 AS "P_0", 0.857142857142857 AS "P_1", 1 AS "D", 0.857142857142857 AS "DP" FROM DUAL UNION ALL SELECT 21 AS nid, 0.111111111111111 AS "P_0", 0.888888888888889 AS "P_1", 1 AS "D", 0.888888888888889 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_4" AS 
  (SELECT "DT_node_lookup_4"."KEY" AS "KEY", "DT_node_lookup_4".node_id_2 AS node_id_2, "DT_node_data_4".nid AS nid, "DT_node_data_4"."P_0" AS "P_0", "DT_node_data_4"."P_1" AS "P_1", "DT_node_data_4"."D" AS "D", "DT_node_data_4"."DP" AS "DP" 
  FROM "DT_node_lookup_4" LEFT OUTER JOIN "DT_node_data_4" ON "DT_node_lookup_4".node_id_2 = "DT_node_data_4".nid), 
  "RF_Model_4" AS 
  (SELECT "DT_Output_4"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_4"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_4"."P_0" IS NULL OR "DT_Output_4"."P_0" > 0.0) THEN ln("DT_Output_4"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_4"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_4"."P_1" IS NULL OR "DT_Output_4"."P_1" > 0.0) THEN ln("DT_Output_4"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_4"), 
  "DT_node_lookup_5" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2493210488246035) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -3.4328002776640862) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.059883108356034) THEN 4 ELSE 5 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -2.136922521160094) THEN 7 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -1.011849865868495) THEN 9 ELSE 10 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.7714398895332006) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -1.171982931531136) THEN 13 ELSE 14 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.889191737833252) THEN 16 ELSE 17 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_5" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 4 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 0.727272727272727 AS "P_0", 0.272727272727273 AS "P_1", 0 AS "D", 0.727272727272727 AS "DP" FROM DUAL UNION ALL SELECT 7 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 9 AS nid, 0.3 AS "P_0", 0.7 AS "P_1", 1 AS "D", 0.7 AS "DP" FROM DUAL UNION ALL SELECT 10 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 0.588235294117647 AS "P_0", 0.411764705882353 AS "P_1", 0 AS "D", 0.588235294117647 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 16 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.111111111111111 AS "P_0", 0.888888888888889 AS "P_1", 1 AS "D", 0.888888888888889 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_5" AS 
  (SELECT "DT_node_lookup_5"."KEY" AS "KEY", "DT_node_lookup_5".node_id_2 AS node_id_2, "DT_node_data_5".nid AS nid, "DT_node_data_5"."P_0" AS "P_0", "DT_node_data_5"."P_1" AS "P_1", "DT_node_data_5"."D" AS "D", "DT_node_data_5"."DP" AS "DP" 
  FROM "DT_node_lookup_5" LEFT OUTER JOIN "DT_node_data_5" ON "DT_node_lookup_5".node_id_2 = "DT_node_data_5".nid), 
  "RF_Model_5" AS 
  (SELECT "DT_Output_5"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_5"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_5"."P_0" IS NULL OR "DT_Output_5"."P_0" > 0.0) THEN ln("DT_Output_5"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_5"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_5"."P_1" IS NULL OR "DT_Output_5"."P_1" > 0.0) THEN ln("DT_Output_5"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_5"), 
  "DT_node_lookup_6" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.4267906820342579) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.839342992626872) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.7910881490697043) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -2.136922521160094) THEN 6 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.892613000373466) THEN 8 ELSE 9 END END ELSE 10 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.8041191107097434) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -1.171982931531136) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -0.1900478168078311) THEN 15 ELSE 16 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.7903404826859886) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.940604668982251) THEN 19 ELSE 20 END ELSE 21 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_6" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.25 AS "P_0", 0.75 AS "P_1", 1 AS "D", 0.75 AS "DP" FROM DUAL UNION ALL SELECT 6 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 0.571428571428571 AS "P_0", 0.428571428571429 AS "P_1", 0 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 9 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 10 AS nid, 0.555555555555556 AS "P_0", 0.444444444444444 AS "P_1", 0 AS "D", 0.555555555555556 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 16 AS nid, 0.272727272727273 AS "P_0", 0.727272727272727 AS "P_1", 1 AS "D", 0.727272727272727 AS "DP" FROM DUAL UNION ALL SELECT 19 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 20 AS nid, 0.06666666666666672 AS "P_0", 0.9333333333333333 AS "P_1", 1 AS "D", 0.9333333333333333 AS "DP" FROM DUAL UNION ALL SELECT 21 AS nid, 0.444444444444444 AS "P_0", 0.555555555555556 AS "P_1", 1 AS "D", 0.555555555555556 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_6" AS 
  (SELECT "DT_node_lookup_6"."KEY" AS "KEY", "DT_node_lookup_6".node_id_2 AS node_id_2, "DT_node_data_6".nid AS nid, "DT_node_data_6"."P_0" AS "P_0", "DT_node_data_6"."P_1" AS "P_1", "DT_node_data_6"."D" AS "D", "DT_node_data_6"."DP" AS "DP" 
  FROM "DT_node_lookup_6" LEFT OUTER JOIN "DT_node_data_6" ON "DT_node_lookup_6".node_id_2 = "DT_node_data_6".nid), 
  "RF_Model_6" AS 
  (SELECT "DT_Output_6"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_6"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_6"."P_0" IS NULL OR "DT_Output_6"."P_0" > 0.0) THEN ln("DT_Output_6"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_6"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_6"."P_1" IS NULL OR "DT_Output_6"."P_1" > 0.0) THEN ln("DT_Output_6"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_6"), 
  "DT_node_lookup_7" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2493210488246035) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -1.670573795292143) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.7910881490697043) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -1.365689903713131) THEN 6 ELSE 7 END ELSE 8 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.573052900964338) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.6456578055759552) THEN 11 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.95276272970019) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 2.4585486385243396) THEN 15 ELSE 16 END END END ELSE 17 END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_7" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.333333333333333 AS "P_0", 0.666666666666667 AS "P_1", 1 AS "D", 0.666666666666667 AS "DP" FROM DUAL UNION ALL SELECT 6 AS nid, 0.857142857142857 AS "P_0", 0.142857142857143 AS "P_1", 0 AS "D", 0.857142857142857 AS "DP" FROM DUAL UNION ALL SELECT 7 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 0.642857142857143 AS "P_0", 0.357142857142857 AS "P_1", 0 AS "D", 0.642857142857143 AS "DP" FROM DUAL UNION ALL SELECT 11 AS nid, 0.166666666666667 AS "P_0", 0.833333333333333 AS "P_1", 1 AS "D", 0.833333333333333 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.285714285714286 AS "P_0", 0.714285714285714 AS "P_1", 1 AS "D", 0.714285714285714 AS "DP" FROM DUAL UNION ALL SELECT 16 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.333333333333333 AS "P_0", 0.666666666666667 AS "P_1", 1 AS "D", 0.666666666666667 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_7" AS 
  (SELECT "DT_node_lookup_7"."KEY" AS "KEY", "DT_node_lookup_7".node_id_2 AS node_id_2, "DT_node_data_7".nid AS nid, "DT_node_data_7"."P_0" AS "P_0", "DT_node_data_7"."P_1" AS "P_1", "DT_node_data_7"."D" AS "D", "DT_node_data_7"."DP" AS "DP" 
  FROM "DT_node_lookup_7" LEFT OUTER JOIN "DT_node_data_7" ON "DT_node_lookup_7".node_id_2 = "DT_node_data_7".nid), 
  "RF_Model_7" AS 
  (SELECT "DT_Output_7"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_7"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_7"."P_0" IS NULL OR "DT_Output_7"."P_0" > 0.0) THEN ln("DT_Output_7"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_7"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_7"."P_1" IS NULL OR "DT_Output_7"."P_1" > 0.0) THEN ln("DT_Output_7"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_7"), 
  "DT_node_lookup_8" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.8042311490806986) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.733626410562294) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 1.7763392038891093) THEN 5 ELSE 6 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.7903404826859886) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.7181818434121698) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 0.8783017525521704) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.3904335097259442) THEN 11 ELSE 12 END ELSE 13 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.95276272970019) THEN 15 ELSE 16 END END ELSE 17 END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_8" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.08333333333333329 AS "P_0", 0.9166666666666667 AS "P_1", 1 AS "D", 0.9166666666666667 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 6 AS nid, 0.714285714285714 AS "P_0", 0.285714285714286 AS "P_1", 0 AS "D", 0.714285714285714 AS "DP" FROM DUAL UNION ALL SELECT 11 AS nid, 0.111111111111111 AS "P_0", 0.888888888888889 AS "P_1", 1 AS "D", 0.888888888888889 AS "DP" FROM DUAL UNION ALL SELECT 12 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 16 AS nid, 0.07142857142857137 AS "P_0", 0.9285714285714286 AS "P_1", 1 AS "D", 0.9285714285714286 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.5 AS "P_0", 0.5 AS "P_1", 0 AS "D", 0.5 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_8" AS 
  (SELECT "DT_node_lookup_8"."KEY" AS "KEY", "DT_node_lookup_8".node_id_2 AS node_id_2, "DT_node_data_8".nid AS nid, "DT_node_data_8"."P_0" AS "P_0", "DT_node_data_8"."P_1" AS "P_1", "DT_node_data_8"."D" AS "D", "DT_node_data_8"."DP" AS "DP" 
  FROM "DT_node_lookup_8" LEFT OUTER JOIN "DT_node_data_8" ON "DT_node_lookup_8".node_id_2 = "DT_node_data_8".nid), 
  "RF_Model_8" AS 
  (SELECT "DT_Output_8"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_8"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_8"."P_0" IS NULL OR "DT_Output_8"."P_0" > 0.0) THEN ln("DT_Output_8"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_8"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_8"."P_1" IS NULL OR "DT_Output_8"."P_1" > 0.0) THEN ln("DT_Output_8"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_8"), 
  "DT_node_lookup_9" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.6577936932615345) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -3.706082012434202) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -3.9417847977647584) THEN 5 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -1.011849865868495) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -2.179944424004562) THEN 8 ELSE 9 END ELSE 10 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 3.0692365924494434) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.7181818434121698) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 0.5000114205097542) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.201605358635934) THEN 15 ELSE 16 END ELSE 17 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.892625384619096) THEN 19 ELSE 20 END END ELSE 21 END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_9" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 0.714285714285714 AS "P_0", 0.285714285714286 AS "P_1", 0 AS "D", 0.714285714285714 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 9 AS nid, 0.666666666666667 AS "P_0", 0.333333333333333 AS "P_1", 0 AS "D", 0.666666666666667 AS "DP" FROM DUAL UNION ALL SELECT 10 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.142857142857143 AS "P_0", 0.857142857142857 AS "P_1", 1 AS "D", 0.857142857142857 AS "DP" FROM DUAL UNION ALL SELECT 16 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.571428571428571 AS "P_0", 0.428571428571429 AS "P_1", 0 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 19 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 20 AS nid, 0.08333333333333329 AS "P_0", 0.9166666666666667 AS "P_1", 1 AS "D", 0.9166666666666667 AS "DP" FROM DUAL UNION ALL SELECT 21 AS nid, 0.875 AS "P_0", 0.125 AS "P_1", 0 AS "D", 0.875 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_9" AS 
  (SELECT "DT_node_lookup_9"."KEY" AS "KEY", "DT_node_lookup_9".node_id_2 AS node_id_2, "DT_node_data_9".nid AS nid, "DT_node_data_9"."P_0" AS "P_0", "DT_node_data_9"."P_1" AS "P_1", "DT_node_data_9"."D" AS "D", "DT_node_data_9"."DP" AS "DP" 
  FROM "DT_node_lookup_9" LEFT OUTER JOIN "DT_node_data_9" ON "DT_node_lookup_9".node_id_2 = "DT_node_data_9".nid), 
  "RF_Model_9" AS 
  (SELECT "DT_Output_9"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_9"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_9"."P_0" IS NULL OR "DT_Output_9"."P_0" > 0.0) THEN ln("DT_Output_9"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_9"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_9"."P_1" IS NULL OR "DT_Output_9"."P_1" > 0.0) THEN ln("DT_Output_9"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_9"), 
  "RF_0" AS 
  (SELECT "RF_esu_0"."KEY" AS "KEY", "RF_esu_0"."Score_0" AS "Score_0", "RF_esu_0"."Proba_0" AS "Proba_0", "RF_esu_0"."LogProba_0" AS "LogProba_0", "RF_esu_0"."Score_1" AS "Score_1", "RF_esu_0"."Proba_1" AS "Proba_1", "RF_esu_0"."LogProba_1" AS "LogProba_1" 
  FROM (SELECT "RF_Model_0"."KEY" AS "KEY", CAST("RF_Model_0"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_0"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_0"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_0"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_0"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_0"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_0" UNION ALL SELECT "RF_Model_1"."KEY" AS "KEY", CAST("RF_Model_1"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_1"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_1"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_1"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_1"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_1"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_1" UNION ALL SELECT "RF_Model_2"."KEY" AS "KEY", CAST("RF_Model_2"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_2"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_2"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_2"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_2"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_2"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_2" UNION ALL SELECT "RF_Model_3"."KEY" AS "KEY", CAST("RF_Model_3"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_3"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_3"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_3"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_3"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_3"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_3" UNION ALL SELECT "RF_Model_4"."KEY" AS "KEY", CAST("RF_Model_4"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_4"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_4"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_4"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_4"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_4"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_4" UNION ALL SELECT "RF_Model_5"."KEY" AS "KEY", CAST("RF_Model_5"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_5"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_5"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_5"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_5"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_5"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_5" UNION ALL SELECT "RF_Model_6"."KEY" AS "KEY", CAST("RF_Model_6"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_6"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_6"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_6"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_6"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_6"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_6" UNION ALL SELECT "RF_Model_7"."KEY" AS "KEY", CAST("RF_Model_7"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_7"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_7"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_7"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_7"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_7"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_7" UNION ALL SELECT "RF_Model_8"."KEY" AS "KEY", CAST("RF_Model_8"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_8"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_8"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_8"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_8"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_8"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_8" UNION ALL SELECT "RF_Model_9"."KEY" AS "KEY", CAST("RF_Model_9"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_9"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_9"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_9"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_9"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_9"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_9") "RF_esu_0"), 
  "DT_node_lookup_10" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.4267906820342579) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.059883108356034) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -1.284058497236106) THEN 5 ELSE 6 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.012419833045249) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.15410257490127) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -2.0914682187130134) THEN 10 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.07310488172337827) THEN 12 ELSE 13 END END ELSE 14 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.741736416351395) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.95276272970019) THEN 17 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 2.480126396113) THEN 19 ELSE 20 END END ELSE 21 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_10" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.2 AS "P_0", 0.8 AS "P_1", 1 AS "D", 0.8 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 0.9924812030075187 AS "P_0", 0.007518796992481198 AS "P_1", 0 AS "D", 0.9924812030075187 AS "DP" FROM DUAL UNION ALL SELECT 6 AS nid, 0.8 AS "P_0", 0.2 AS "P_1", 0 AS "D", 0.8 AS "DP" FROM DUAL UNION ALL SELECT 10 AS nid, 0.571428571428571 AS "P_0", 0.428571428571429 AS "P_1", 0 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 12 AS nid, 0.428571428571429 AS "P_0", 0.571428571428571 AS "P_1", 1 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 0.8 AS "P_0", 0.2 AS "P_1", 0 AS "D", 0.8 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 19 AS nid, 0.125 AS "P_0", 0.875 AS "P_1", 1 AS "D", 0.875 AS "DP" FROM DUAL UNION ALL SELECT 20 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 21 AS nid, 0.285714285714286 AS "P_0", 0.714285714285714 AS "P_1", 1 AS "D", 0.714285714285714 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_10" AS 
  (SELECT "DT_node_lookup_10"."KEY" AS "KEY", "DT_node_lookup_10".node_id_2 AS node_id_2, "DT_node_data_10".nid AS nid, "DT_node_data_10"."P_0" AS "P_0", "DT_node_data_10"."P_1" AS "P_1", "DT_node_data_10"."D" AS "D", "DT_node_data_10"."DP" AS "DP" 
  FROM "DT_node_lookup_10" LEFT OUTER JOIN "DT_node_data_10" ON "DT_node_lookup_10".node_id_2 = "DT_node_data_10".nid), 
  "RF_Model_10" AS 
  (SELECT "DT_Output_10"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_10"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_10"."P_0" IS NULL OR "DT_Output_10"."P_0" > 0.0) THEN ln("DT_Output_10"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_10"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_10"."P_1" IS NULL OR "DT_Output_10"."P_1" > 0.0) THEN ln("DT_Output_10"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_10"), 
  "DT_node_lookup_11" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.4787494298747238) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.059883108356034) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -1.688065171929614) THEN 5 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.3433987086099874) THEN 7 ELSE 8 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2493210488246035) THEN 10 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.541823244242415) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.585426513178066) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -0.2218970434468187) THEN 14 ELSE 15 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.95276272970019) THEN 17 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 2.207052339765932) THEN 19 ELSE 20 END END END ELSE 21 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_11" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.25 AS "P_0", 0.75 AS "P_1", 1 AS "D", 0.75 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 7 AS nid, 0.571428571428571 AS "P_0", 0.428571428571429 AS "P_1", 0 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 10 AS nid, 0.363636363636364 AS "P_0", 0.636363636363636 AS "P_1", 1 AS "D", 0.636363636363636 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.285714285714286 AS "P_0", 0.714285714285714 AS "P_1", 1 AS "D", 0.714285714285714 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 19 AS nid, 0.428571428571429 AS "P_0", 0.571428571428571 AS "P_1", 1 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 20 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 21 AS nid, 0.3 AS "P_0", 0.7 AS "P_1", 1 AS "D", 0.7 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_11" AS 
  (SELECT "DT_node_lookup_11"."KEY" AS "KEY", "DT_node_lookup_11".node_id_2 AS node_id_2, "DT_node_data_11".nid AS nid, "DT_node_data_11"."P_0" AS "P_0", "DT_node_data_11"."P_1" AS "P_1", "DT_node_data_11"."D" AS "D", "DT_node_data_11"."DP" AS "DP" 
  FROM "DT_node_lookup_11" LEFT OUTER JOIN "DT_node_data_11" ON "DT_node_lookup_11".node_id_2 = "DT_node_data_11".nid), 
  "RF_Model_11" AS 
  (SELECT "DT_Output_11"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_11"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_11"."P_0" IS NULL OR "DT_Output_11"."P_0" > 0.0) THEN ln("DT_Output_11"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_11"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_11"."P_1" IS NULL OR "DT_Output_11"."P_1" > 0.0) THEN ln("DT_Output_11"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_11"), 
  "DT_node_lookup_12" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.3560392928541898) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -3.4328002776640862) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.059883108356034) THEN 4 ELSE 5 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -1.0418326280779708) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -2.246227880091509) THEN 8 ELSE 9 END ELSE 10 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.012419833045249) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 0.2347669397993014) THEN 13 ELSE 14 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.95276272970019) THEN 16 ELSE 17 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_12" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 4 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 0.846153846153846 AS "P_0", 0.153846153846154 AS "P_1", 0 AS "D", 0.846153846153846 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 9 AS nid, 0.5 AS "P_0", 0.5 AS "P_1", 0 AS "D", 0.5 AS "DP" FROM DUAL UNION ALL SELECT 10 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 0.333333333333333 AS "P_0", 0.666666666666667 AS "P_1", 1 AS "D", 0.666666666666667 AS "DP" FROM DUAL UNION ALL SELECT 16 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.07142857142857137 AS "P_0", 0.9285714285714286 AS "P_1", 1 AS "D", 0.9285714285714286 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_12" AS 
  (SELECT "DT_node_lookup_12"."KEY" AS "KEY", "DT_node_lookup_12".node_id_2 AS node_id_2, "DT_node_data_12".nid AS nid, "DT_node_data_12"."P_0" AS "P_0", "DT_node_data_12"."P_1" AS "P_1", "DT_node_data_12"."D" AS "D", "DT_node_data_12"."DP" AS "DP" 
  FROM "DT_node_lookup_12" LEFT OUTER JOIN "DT_node_data_12" ON "DT_node_lookup_12".node_id_2 = "DT_node_data_12".nid), 
  "RF_Model_12" AS 
  (SELECT "DT_Output_12"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_12"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_12"."P_0" IS NULL OR "DT_Output_12"."P_0" > 0.0) THEN ln("DT_Output_12"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_12"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_12"."P_1" IS NULL OR "DT_Output_12"."P_1" > 0.0) THEN ln("DT_Output_12"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_12"), 
  "DT_node_lookup_13" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.7910881490697043) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.881768117989556) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -2.2959279772902357) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.1768096786961982) THEN 6 ELSE 7 END ELSE 8 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.8041191107097434) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.15410257490127) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -0.8063921580348845) THEN 12 ELSE 13 END ELSE 14 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.541823244242415) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.940604668982251) THEN 17 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 2.480126396113) THEN 19 ELSE 20 END END ELSE 21 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_13" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.285714285714286 AS "P_0", 0.714285714285714 AS "P_1", 1 AS "D", 0.714285714285714 AS "DP" FROM DUAL UNION ALL SELECT 6 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 7 AS nid, 0.75 AS "P_0", 0.25 AS "P_1", 0 AS "D", 0.75 AS "DP" FROM DUAL UNION ALL SELECT 8 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 12 AS nid, 0.333333333333333 AS "P_0", 0.666666666666667 AS "P_1", 1 AS "D", 0.666666666666667 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 0.032258064516129 AS "P_0", 0.967741935483871 AS "P_1", 1 AS "D", 0.967741935483871 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 0.75 AS "P_0", 0.25 AS "P_1", 0 AS "D", 0.75 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 19 AS nid, 0.285714285714286 AS "P_0", 0.714285714285714 AS "P_1", 1 AS "D", 0.714285714285714 AS "DP" FROM DUAL UNION ALL SELECT 20 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 21 AS nid, 0.375 AS "P_0", 0.625 AS "P_1", 1 AS "D", 0.625 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_13" AS 
  (SELECT "DT_node_lookup_13"."KEY" AS "KEY", "DT_node_lookup_13".node_id_2 AS node_id_2, "DT_node_data_13".nid AS nid, "DT_node_data_13"."P_0" AS "P_0", "DT_node_data_13"."P_1" AS "P_1", "DT_node_data_13"."D" AS "D", "DT_node_data_13"."DP" AS "DP" 
  FROM "DT_node_lookup_13" LEFT OUTER JOIN "DT_node_data_13" ON "DT_node_lookup_13".node_id_2 = "DT_node_data_13".nid), 
  "RF_Model_13" AS 
  (SELECT "DT_Output_13"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_13"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_13"."P_0" IS NULL OR "DT_Output_13"."P_0" > 0.0) THEN ln("DT_Output_13"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_13"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_13"."P_1" IS NULL OR "DT_Output_13"."P_1" > 0.0) THEN ln("DT_Output_13"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_13"), 
  "DT_node_lookup_14" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2795304939476403) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -3.530944544267773) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.157128533324294) THEN 4 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -3.1349654116104215) THEN 6 ELSE 7 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -1.670573795292143) THEN 9 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -2.136922521160094) THEN 11 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -1.011849865868495) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -0.3309071503843168) THEN 15 ELSE 16 END END END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.012419833045249) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 1.280384434221947) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.099033851669089) THEN 20 ELSE 21 END ELSE 22 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.53909486679076) THEN 24 ELSE 25 END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_14" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 4 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 6 AS nid, 0.444444444444444 AS "P_0", 0.555555555555556 AS "P_1", 1 AS "D", 0.555555555555556 AS "DP" FROM DUAL UNION ALL SELECT 7 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 9 AS nid, 0.5 AS "P_0", 0.5 AS "P_1", 0 AS "D", 0.5 AS "DP" FROM DUAL UNION ALL SELECT 11 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 13 AS nid, 0.5 AS "P_0", 0.5 AS "P_1", 0 AS "D", 0.5 AS "DP" FROM DUAL UNION ALL SELECT 15 AS nid, 0.875 AS "P_0", 0.125 AS "P_1", 0 AS "D", 0.875 AS "DP" FROM DUAL UNION ALL SELECT 16 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 20 AS nid, 0.285714285714286 AS "P_0", 0.714285714285714 AS "P_1", 1 AS "D", 0.714285714285714 AS "DP" FROM DUAL UNION ALL SELECT 21 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 22 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 24 AS nid, 0.004444444444444438 AS "P_0", 0.9955555555555555 AS "P_1", 1 AS "D", 0.9955555555555555 AS "DP" FROM DUAL UNION ALL SELECT 25 AS nid, 0.1 AS "P_0", 0.9 AS "P_1", 1 AS "D", 0.9 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_14" AS 
  (SELECT "DT_node_lookup_14"."KEY" AS "KEY", "DT_node_lookup_14".node_id_2 AS node_id_2, "DT_node_data_14".nid AS nid, "DT_node_data_14"."P_0" AS "P_0", "DT_node_data_14"."P_1" AS "P_1", "DT_node_data_14"."D" AS "D", "DT_node_data_14"."DP" AS "DP" 
  FROM "DT_node_lookup_14" LEFT OUTER JOIN "DT_node_data_14" ON "DT_node_lookup_14".node_id_2 = "DT_node_data_14".nid), 
  "RF_Model_14" AS 
  (SELECT "DT_Output_14"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_14"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_14"."P_0" IS NULL OR "DT_Output_14"."P_0" > 0.0) THEN ln("DT_Output_14"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_14"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_14"."P_1" IS NULL OR "DT_Output_14"."P_1" > 0.0) THEN ln("DT_Output_14"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_14"), 
  "DT_node_lookup_15" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.4787494298747238) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.839342992626872) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -1.134733454913752) THEN 5 ELSE 6 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.8041191107097434) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.6525686547223992) THEN 9 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2795304939476403) THEN 11 ELSE 12 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.9068014598314071) THEN 14 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -0.8666761232516241) THEN 16 ELSE 17 END END END END AS node_id_2 
  FROM "ADS_pre_1_OUT"), 
  "DT_node_data_15" AS 
  (SELECT "Values".nid AS nid, "Values"."P_0" AS "P_0", "Values"."P_1" AS "P_1", "Values"."D" AS "D", "Values"."DP" AS "DP" 
  FROM (SELECT 3 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 5 AS nid, 0.857142857142857 AS "P_0", 0.142857142857143 AS "P_1", 0 AS "D", 0.857142857142857 AS "DP" FROM DUAL UNION ALL SELECT 6 AS nid, 0.9929577464788732 AS "P_0", 0.007042253521126762 AS "P_1", 0 AS "D", 0.9929577464788732 AS "DP" FROM DUAL UNION ALL SELECT 9 AS nid, 0.625 AS "P_0", 0.375 AS "P_1", 0 AS "D", 0.625 AS "DP" FROM DUAL UNION ALL SELECT 11 AS nid, 0.25 AS "P_0", 0.75 AS "P_1", 1 AS "D", 0.75 AS "DP" FROM DUAL UNION ALL SELECT 12 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 14 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL UNION ALL SELECT 16 AS nid, 0.428571428571429 AS "P_0", 0.571428571428571 AS "P_1", 1 AS "D", 0.571428571428571 AS "DP" FROM DUAL UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" FROM DUAL) "Values"), 
  "DT_Output_15" AS 
  (SELECT "DT_node_lookup_15"."KEY" AS "KEY", "DT_node_lookup_15".node_id_2 AS node_id_2, "DT_node_data_15".nid AS nid, "DT_node_data_15"."P_0" AS "P_0", "DT_node_data_15"."P_1" AS "P_1", "DT_node_data_15"."D" AS "D", "DT_node_data_15"."DP" AS "DP" 
  FROM "DT_node_lookup_15" LEFT OUTER JOIN "DT_node_data_15" ON "DT_node_lookup_15".node_id_2 = "DT_node_data_15".nid), 
  "RF_Model_15" AS 
  (SELECT "DT_Output_15"."KEY" AS "KEY", CAST(NULL AS BINARY_DOUBLE) AS "Score_0", "DT_Output_15"."P_0" AS "Proba_0", CASE WHEN ("DT_Output_15"."P_0" IS NULL OR "DT_Output_15"."P_0" > 0.0) THEN ln("DT_Output_15"."P_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CAST(NULL AS BINARY_DOUBLE) AS "Score_1", "DT_Output_15"."P_1" AS "Proba_1", CASE WHEN ("DT_Output_15"."P_1" IS NULL OR "DT_Output_15"."P_1" > 0.0) THEN ln("DT_Output_15"."P_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1" 
  FROM "DT_Output_15"), 
  "RF_1" AS 
  (SELECT "RF_esu_1"."KEY" AS "KEY", "RF_esu_1"."Score_0" AS "Score_0", "RF_esu_1"."Proba_0" AS "Proba_0", "RF_esu_1"."LogProba_0" AS "LogProba_0", "RF_esu_1"."Score_1" AS "Score_1", "RF_esu_1"."Proba_1" AS "Proba_1", "RF_esu_1"."LogProba_1" AS "LogProba_1" 
  FROM (SELECT "RF_Model_10"."KEY" AS "KEY", CAST("RF_Model_10"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_10"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_10"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_10"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_10"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_10"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_10" UNION ALL SELECT "RF_Model_11"."KEY" AS "KEY", CAST("RF_Model_11"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_11"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_11"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_11"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_11"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_11"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_11" UNION ALL SELECT "RF_Model_12"."KEY" AS "KEY", CAST("RF_Model_12"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_12"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_12"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_12"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_12"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_12"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_12" UNION ALL SELECT "RF_Model_13"."KEY" AS "KEY", CAST("RF_Model_13"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_13"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_13"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_13"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_13"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_13"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_13" UNION ALL SELECT "RF_Model_14"."KEY" AS "KEY", CAST("RF_Model_14"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_14"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_14"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_14"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_14"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_14"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_14" UNION ALL SELECT "RF_Model_15"."KEY" AS "KEY", CAST("RF_Model_15"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_Model_15"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_Model_15"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_Model_15"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_Model_15"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_Model_15"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_Model_15") "RF_esu_1"), 
  "RF" AS 
  (SELECT "RFbig_esu"."KEY" AS "KEY", "RFbig_esu"."Score_0" AS "Score_0", "RFbig_esu"."Proba_0" AS "Proba_0", "RFbig_esu"."LogProba_0" AS "LogProba_0", "RFbig_esu"."Score_1" AS "Score_1", "RFbig_esu"."Proba_1" AS "Proba_1", "RFbig_esu"."LogProba_1" AS "LogProba_1" 
  FROM (SELECT "RF_0"."KEY" AS "KEY", CAST("RF_0"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_0"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_0"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_0"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_0"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_0"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_0" UNION ALL SELECT "RF_1"."KEY" AS "KEY", CAST("RF_1"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("RF_1"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("RF_1"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("RF_1"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("RF_1"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("RF_1"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF_1") "RFbig_esu"), 
  "RF_avg" AS 
  (SELECT "T"."KEY" AS "KEY", CAST("T"."Score_0" AS BINARY_DOUBLE) AS "Score_0", CAST("T"."Proba_0" AS BINARY_DOUBLE) AS "Proba_0", CAST("T"."LogProba_0" AS BINARY_DOUBLE) AS "LogProba_0", CAST("T"."Score_1" AS BINARY_DOUBLE) AS "Score_1", CAST("T"."Proba_1" AS BINARY_DOUBLE) AS "Proba_1", CAST("T"."LogProba_1" AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM (SELECT "RF"."KEY" AS "KEY", avg(CAST("RF"."Score_0" AS BINARY_DOUBLE)) AS "Score_0", avg(CAST("RF"."Proba_0" AS BINARY_DOUBLE)) AS "Proba_0", CAST(NULL AS BINARY_DOUBLE) AS "LogProba_0", avg(CAST("RF"."Score_1" AS BINARY_DOUBLE)) AS "Score_1", avg(CAST("RF"."Proba_1" AS BINARY_DOUBLE)) AS "Proba_1", CAST(NULL AS BINARY_DOUBLE) AS "LogProba_1" 
  FROM "RF" GROUP BY "RF"."KEY") "T"), 
  orig_cte AS 
  (SELECT "RF_avg"."KEY" AS "KEY", "RF_avg"."Score_0" AS "Score_0", "RF_avg"."Score_1" AS "Score_1", "RF_avg"."Proba_0" AS "Proba_0", "RF_avg"."Proba_1" AS "Proba_1", "RF_avg"."LogProba_0" AS "LogProba_0", "RF_avg"."LogProba_1" AS "LogProba_1", CAST(NULL AS NUMBER(19)) AS "Decision", CAST(NULL AS BINARY_DOUBLE) AS "DecisionProba" 
  FROM "RF_avg"), 
  score_class_union AS 
  (SELECT scu."KEY_u" AS "KEY_u", scu.class AS class, scu."LogProba" AS "LogProba", scu."Proba" AS "Proba", scu."Score" AS "Score" 
  FROM (SELECT orig_cte."KEY" AS "KEY_u", 0 AS class, orig_cte."LogProba_0" AS "LogProba", orig_cte."Proba_0" AS "Proba", orig_cte."Score_0" AS "Score" 
  FROM orig_cte UNION ALL SELECT orig_cte."KEY" AS "KEY_u", 1 AS class, orig_cte."LogProba_1" AS "LogProba", orig_cte."Proba_1" AS "Proba", orig_cte."Score_1" AS "Score" 
  FROM orig_cte) scu), 
  score_max AS 
  (SELECT orig_cte."KEY" AS "KEY", orig_cte."Score_0" AS "Score_0", orig_cte."Score_1" AS "Score_1", orig_cte."Proba_0" AS "Proba_0", orig_cte."Proba_1" AS "Proba_1", orig_cte."LogProba_0" AS "LogProba_0", orig_cte."LogProba_1" AS "LogProba_1", orig_cte."Decision" AS "Decision", orig_cte."DecisionProba" AS "DecisionProba", max_select."KEY_m" AS "KEY_m", max_select."max_Proba" AS "max_Proba" 
  FROM orig_cte LEFT OUTER JOIN (SELECT score_class_union."KEY_u" AS "KEY_m", max(score_class_union."Proba") AS "max_Proba" 
  FROM score_class_union GROUP BY score_class_union."KEY_u") max_select ON orig_cte."KEY" = max_select."KEY_m"), 
  union_with_max AS 
  (SELECT score_class_union."KEY_u" AS "KEY_u", score_class_union.class AS class, score_class_union."LogProba" AS "LogProba", score_class_union."Proba" AS "Proba", score_class_union."Score" AS "Score", score_max."KEY" AS "KEY", score_max."Score_0" AS "Score_0", score_max."Score_1" AS "Score_1", score_max."Proba_0" AS "Proba_0", score_max."Proba_1" AS "Proba_1", score_max."LogProba_0" AS "LogProba_0", score_max."LogProba_1" AS "LogProba_1", score_max."Decision" AS "Decision", score_max."DecisionProba" AS "DecisionProba", score_max."KEY_m" AS "KEY_m", score_max."max_Proba" AS "max_Proba" 
  FROM score_class_union LEFT OUTER JOIN score_max ON score_class_union."KEY_u" = score_max."KEY"), 
  arg_max_cte AS 
  (SELECT score_max."KEY" AS "KEY", score_max."Score_0" AS "Score_0", score_max."Score_1" AS "Score_1", score_max."Proba_0" AS "Proba_0", score_max."Proba_1" AS "Proba_1", score_max."LogProba_0" AS "LogProba_0", score_max."LogProba_1" AS "LogProba_1", score_max."Decision" AS "Decision", score_max."DecisionProba" AS "DecisionProba", score_max."KEY_m" AS "KEY_m", score_max."max_Proba" AS "max_Proba", "arg_max_t_Proba"."KEY_Proba" AS "KEY_Proba", "arg_max_t_Proba"."arg_max_Proba" AS "arg_max_Proba" 
  FROM score_max LEFT OUTER JOIN (SELECT union_with_max."KEY" AS "KEY_Proba", max(union_with_max.class) AS "arg_max_Proba" 
  FROM union_with_max 
  WHERE union_with_max."max_Proba" <= union_with_max."Proba" GROUP BY union_with_max."KEY") "arg_max_t_Proba" ON score_max."KEY" = "arg_max_t_Proba"."KEY_Proba")
   SELECT arg_max_cte."KEY" AS "KEY", arg_max_cte."Score_0" AS "Score_0", arg_max_cte."Score_1" AS "Score_1", arg_max_cte."Proba_0" AS "Proba_0", arg_max_cte."Proba_1" AS "Proba_1", CASE WHEN (arg_max_cte."Proba_0" IS NULL OR arg_max_cte."Proba_0" > 0.0) THEN ln(arg_max_cte."Proba_0") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_0", CASE WHEN (arg_max_cte."Proba_1" IS NULL OR arg_max_cte."Proba_1" > 0.0) THEN ln(arg_max_cte."Proba_1") ELSE -BINARY_DOUBLE_INFINITY END AS "LogProba_1", arg_max_cte."arg_max_Proba" AS "Decision", arg_max_cte."max_Proba" AS "DecisionProba" 
  FROM arg_max_cte