text: -- This SQL code was generated by sklearn2sql (development version).
  -- Copyright 2018
  
  -- Model : CaretClassifier_rf_pca
  -- Dataset : BinaryClass_10
  -- Database : pgsql
  
  
  -- This SQL code can contain one or more statements, to be executed in the order they appear in this file.
  
  
  
  -- Model deployment code
  
  WITH "RF_0" AS 
  (WITH "ADS_sca_1_OUT" AS 
  (SELECT "ADS"."KEY" AS "KEY", (CAST("ADS"."Feature_0" AS FLOAT) - 0.06182920523813451) / 1.236134089597546 AS "Feature_0", (CAST("ADS"."Feature_1" AS FLOAT) - 0.17702463767183327) / 0.946757498519011 AS "Feature_1", (CAST("ADS"."Feature_2" AS FLOAT) - 0.041383850049034464) / 1.0809597326983538 AS "Feature_2", (CAST("ADS"."Feature_3" AS FLOAT) - 0.13060646805847148) / 1.0860335106241017 AS "Feature_3", (CAST("ADS"."Feature_4" AS FLOAT) - -0.05955810471983085) / 1.1165897507633815 AS "Feature_4", (CAST("ADS"."Feature_5" AS FLOAT) - -0.048929089870105816) / 1.3868824547243672 AS "Feature_5", (CAST("ADS"."Feature_6" AS FLOAT) - 0.19101797861713127) / 0.979670721363872 AS "Feature_6", (CAST("ADS"."Feature_7" AS FLOAT) - 0.02204959673267471) / 0.4775973825125086 AS "Feature_7", (CAST("ADS"."Feature_8" AS FLOAT) - -0.05772981403414008) / 1.0713243581907332 AS "Feature_8", (CAST("ADS"."Feature_9" AS FLOAT) - -0.052549592052032364) / 1.2322587258530384 AS "Feature_9" 
  FROM "BinaryClass_10" AS "ADS"), 
  "ADS_pre_1_OUT" AS 
  (SELECT "ADS_sca_1_OUT"."KEY" AS "KEY", "ADS_sca_1_OUT"."Feature_0" * 0.5661592321920361 + "ADS_sca_1_OUT"."Feature_1" * -0.035526328604152946 + "ADS_sca_1_OUT"."Feature_2" * -0.0467879363120513 + "ADS_sca_1_OUT"."Feature_3" * 0.008946515209953917 + "ADS_sca_1_OUT"."Feature_4" * 0.0829511888403661 + "ADS_sca_1_OUT"."Feature_5" * -0.10205221296100445 + "ADS_sca_1_OUT"."Feature_6" * 0.1424451507903749 + "ADS_sca_1_OUT"."Feature_7" * 0.5666566688831561 + "ADS_sca_1_OUT"."Feature_8" * -0.06631427728790784 + "ADS_sca_1_OUT"."Feature_9" * -0.5593289854950824 AS "PC1", "ADS_sca_1_OUT"."Feature_0" * 0.0767125800279515 + "ADS_sca_1_OUT"."Feature_1" * -0.40153794458328573 + "ADS_sca_1_OUT"."Feature_2" * 0.5677578250446825 + "ADS_sca_1_OUT"."Feature_3" * 0.2369735703010663 + "ADS_sca_1_OUT"."Feature_4" * -0.09632922916256215 + "ADS_sca_1_OUT"."Feature_5" * -0.5767787279161882 + "ADS_sca_1_OUT"."Feature_6" * -0.3216376934797878 + "ADS_sca_1_OUT"."Feature_7" * -0.006693968243624504 + "ADS_sca_1_OUT"."Feature_8" * -0.06421158945215161 + "ADS_sca_1_OUT"."Feature_9" * 0.06932008034543824 AS "PC2", "ADS_sca_1_OUT"."Feature_0" * -0.04428807917268944 + "ADS_sca_1_OUT"."Feature_1" * 0.02244286142288565 + "ADS_sca_1_OUT"."Feature_2" * -0.1709384323174772 + "ADS_sca_1_OUT"."Feature_3" * 0.4187938020309751 + "ADS_sca_1_OUT"."Feature_4" * 0.4638804547130563 + "ADS_sca_1_OUT"."Feature_5" * 0.12436384332391155 + "ADS_sca_1_OUT"."Feature_6" * -0.2491197630750001 + "ADS_sca_1_OUT"."Feature_7" * -0.02707014062139766 + "ADS_sca_1_OUT"."Feature_8" * -0.7066063892300462 + "ADS_sca_1_OUT"."Feature_9" * 0.01375528233133572 AS "PC3", "ADS_sca_1_OUT"."Feature_0" * 0.035505292609370916 + "ADS_sca_1_OUT"."Feature_1" * 0.4629415976318115 + "ADS_sca_1_OUT"."Feature_2" * 0.39703949728185695 + "ADS_sca_1_OUT"."Feature_3" * 0.108176435008563 + "ADS_sca_1_OUT"."Feature_4" * -0.5443880279914196 + "ADS_sca_1_OUT"."Feature_5" * 0.3886991214463785 + "ADS_sca_1_OUT"."Feature_6" * -0.3136270685510785 + "ADS_sca_1_OUT"."Feature_7" * 0.09412147953130984 + "ADS_sca_1_OUT"."Feature_8" * -0.2041303312264922 + "ADS_sca_1_OUT"."Feature_9" * -0.1369183431411648 AS "PC4", "ADS_sca_1_OUT"."Feature_0" * -0.02395611334530353 + "ADS_sca_1_OUT"."Feature_1" * 0.3059663067403714 + "ADS_sca_1_OUT"."Feature_2" * 0.1244148619727216 + "ADS_sca_1_OUT"."Feature_3" * 0.7205232130433498 + "ADS_sca_1_OUT"."Feature_4" * -0.010360887714254759 + "ADS_sca_1_OUT"."Feature_5" * -0.12313866467327145 + "ADS_sca_1_OUT"."Feature_6" * 0.5630711251768787 + "ADS_sca_1_OUT"."Feature_7" * -0.04287636501865158 + "ADS_sca_1_OUT"."Feature_8" * 0.18391692419974146 + "ADS_sca_1_OUT"."Feature_9" * 0.056520588594192574 AS "PC5", "ADS_sca_1_OUT"."Feature_0" * 0.048169250614026715 + "ADS_sca_1_OUT"."Feature_1" * 0.6239362496677012 + "ADS_sca_1_OUT"."Feature_2" * 0.20083118524117005 + "ADS_sca_1_OUT"."Feature_3" * -0.1618608106397551 + "ADS_sca_1_OUT"."Feature_4" * 0.5432007330496692 + "ADS_sca_1_OUT"."Feature_5" * -0.2436186036944093 + "ADS_sca_1_OUT"."Feature_6" * -0.3147233303086936 + "ADS_sca_1_OUT"."Feature_7" * 0.01337545211610092 + "ADS_sca_1_OUT"."Feature_8" * 0.29670903412359584 + "ADS_sca_1_OUT"."Feature_9" * 0.01296934529502586 AS "PC6", "ADS_sca_1_OUT"."Feature_0" * -0.06773590863463053 + "ADS_sca_1_OUT"."Feature_1" * -0.11758181773858208 + "ADS_sca_1_OUT"."Feature_2" * 0.6477095493436038 + "ADS_sca_1_OUT"."Feature_3" * -0.3112272823678729 + "ADS_sca_1_OUT"."Feature_4" * 0.33477688181210946 + "ADS_sca_1_OUT"."Feature_5" * 0.29496375499110145 + "ADS_sca_1_OUT"."Feature_6" * 0.4607366756100071 + "ADS_sca_1_OUT"."Feature_7" * -0.025868856528122847 + "ADS_sca_1_OUT"."Feature_8" * -0.2305082370268579 + "ADS_sca_1_OUT"."Feature_9" * -0.005964439285718312 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"."PC5" <= -1.2538768517609693) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.600617866217818) THEN 3 ELSE 4 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.3920350515412316) THEN 5 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 1.024752662201724) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -0.7858194485615796) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.7292055148660814) THEN 13 ELSE 14 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.275714633725316) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 0.3129815627768403) THEN 19 ELSE 20 END ELSE 16 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 0.19893902599080487) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.05888351391057156) THEN 17 ELSE 18 END ELSE 12 END END 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.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 4 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 5 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 12 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 14 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 16 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 19 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC6" <= -1.5208604993564032) THEN 1 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.1496373286270022) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.384546803384205) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -1.241924325004483) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -0.11642709013706798) THEN 15 ELSE 16 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.10298677658705375) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.8820048946666798) THEN 23 ELSE 24 END ELSE 18 END END ELSE 6 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -0.6323753346095173) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.0658192213167253) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.5582337318875772) THEN 19 ELSE 20 END ELSE 12 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.8032344180361841) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 1.274344322379883) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 0.21212189665055486) THEN 25 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 0.24260872249745666) THEN 29 ELSE 30 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.016831229442561962) THEN 27 ELSE 28 END END END 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 1 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 6 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 12 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 16 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 19 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 23 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 24 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 25 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 27 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 28 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 29 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 30 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC7" <= -0.7469501432176594) THEN 1 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.6913834461684127) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.18257010206730023) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.1223329790287864) THEN 9 ELSE 10 END ELSE 6 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2538445673893805) THEN 7 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 1.016161901183401) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -1.4875652784498083) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 2.6113661777574424) THEN 15 ELSE 16 END END ELSE 12 END 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 1 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 6 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 7 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 9 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 10 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 12 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 16 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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.2538445673893805) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -1.3329711053978828) THEN 3 ELSE 4 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -1.3677658057350288) THEN 5 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.9964296846718556) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.7330456081285673) THEN 9 ELSE 10 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 2.326824084833865) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.7676647825644543) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.9912596755816544) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.3337337159125616) THEN 17 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.5505342482542456) THEN 19 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.610245661913518) THEN 21 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.6829406340999813) THEN 23 ELSE 24 END END END END ELSE 16 END ELSE 14 END ELSE 12 END END 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 3 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 4 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 5 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 9 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 10 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 12 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 14 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 16 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 19 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 21 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 23 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 24 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC4" <= -0.5324716064301069) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.8644335018453683) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -1.3677658057350288) THEN 7 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.8390238801399375) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.5903406991786255) THEN 21 ELSE 22 END END END ELSE 4 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -0.006808548791279935) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 0.4635657780122585) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.7976317157643816) THEN 15 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.11538303780349038) THEN 23 ELSE 24 END END ELSE 10 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 0.8510716336047729) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 1.1903250362746722) THEN 17 ELSE 18 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.5575584938425491) THEN 19 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.3468524384333766) THEN 25 ELSE 26 END END 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 4 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 7 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 10 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 19 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 21 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 22 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 23 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 24 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 25 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 26 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC6" <= -0.4645628991699671) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -1.6859336482891407) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.3979304062829789) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -1.5208604993564032) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.21483791937351426) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.6297322184723241) THEN 25 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.8784963062150318) THEN 33 ELSE 34 END END ELSE 20 END END ELSE 8 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 0.9970953569736272) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 0.7687355996247963) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.2046880468007225) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.5013901790903511) THEN 21 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.8010492832957645) THEN 27 ELSE 28 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 0.3082392267019629) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -0.8611567194406478) THEN 29 ELSE 30 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 1.2758299010138303) THEN 31 ELSE 32 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -1.1261256356481346) THEN 17 ELSE 18 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.1937370527806443) THEN 11 ELSE 12 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 3 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 8 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 11 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 12 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 21 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 25 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 27 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 28 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 29 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 30 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 31 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 32 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 33 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 34 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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.681882683075102) THEN 1 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.2310928929758946) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 0.4735109425875206) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.758913451224959) THEN 9 ELSE 10 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.7819928723184768) THEN 11 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 0.36506848843230105) THEN 13 ELSE 14 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 1.552399305427758) THEN 7 ELSE 8 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 1 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 7 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 8 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 9 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 10 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 11 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 14 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC2" <= -0.7822239266577539) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.8007521216000376) THEN 3 ELSE 4 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.3148300024091841) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 1.0376869805145512) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.3162062817684355) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.14156532491156207) THEN 15 ELSE 16 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.7767914234991549) THEN 17 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.7043997498571715) THEN 21 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.06752714143778424) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.3394358681135847) THEN 27 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -1.1022490142959251) THEN 29 ELSE 30 END END ELSE 26 END END END END ELSE 8 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 0.6048238107160796) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -0.7544859456620666) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.2415995731254266) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.6438330953865352) THEN 23 ELSE 24 END ELSE 20 END END ELSE 10 END 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.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 4 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 8 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 10 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 16 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 21 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 23 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 24 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 26 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 27 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 29 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 30 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC7" <= 0.07393649675423462) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.27405342780336095) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -1.222242081095242) THEN 7 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.9929325215727742) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -0.709015911715484) THEN 21 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.29956211184085774) THEN 29 ELSE 30 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 1.2327948575501921) THEN 23 ELSE 24 END END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.6064564787617581) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.06911113523758178) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -1.4840789479981111) THEN 15 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.9636821143999094) THEN 25 ELSE 26 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.5505342482542456) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 0.3915523424530717) THEN 27 ELSE 28 END ELSE 18 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.6583458671467259) THEN 11 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 0.986356402738605) THEN 19 ELSE 20 END END 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.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 7 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 11 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 19 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 21 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 23 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 24 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 25 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 26 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 27 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 28 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 29 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 30 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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.19716044299340799) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -1.3484444948285599) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.22404606765812377) THEN 7 ELSE 8 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.7741860491057798) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.9038692091813716) THEN 13 ELSE 14 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.03681832045140075) THEN 15 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 0.3782109326736365) THEN 21 ELSE 22 END END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -1.3677658057350288) THEN 5 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.9293306505934495) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.4073425404383593) THEN 17 ELSE 18 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.1993709986593954) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.0809686399906664) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.157540868277235) THEN 25 ELSE 26 END ELSE 24 END ELSE 20 END END 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 5 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 7 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 8 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 14 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 21 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 22 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 24 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 25 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 26 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_1" 
  FROM "DT_Output_9")
   SELECT "RF_esu_0"."KEY", "RF_esu_0"."Score_0", "RF_esu_0"."Proba_0", "RF_esu_0"."LogProba_0", "RF_esu_0"."Score_1", "RF_esu_0"."Proba_1", "RF_esu_0"."LogProba_1" 
  FROM (SELECT "RF_Model_0"."KEY" AS "KEY", CAST("RF_Model_0"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_0"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_0"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_0"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_0"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_0"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_0" UNION ALL SELECT "RF_Model_1"."KEY" AS "KEY", CAST("RF_Model_1"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_1"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_1"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_1"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_1"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_1"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_1" UNION ALL SELECT "RF_Model_2"."KEY" AS "KEY", CAST("RF_Model_2"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_2"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_2"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_2"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_2"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_2"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_2" UNION ALL SELECT "RF_Model_3"."KEY" AS "KEY", CAST("RF_Model_3"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_3"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_3"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_3"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_3"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_3"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_3" UNION ALL SELECT "RF_Model_4"."KEY" AS "KEY", CAST("RF_Model_4"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_4"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_4"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_4"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_4"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_4"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_4" UNION ALL SELECT "RF_Model_5"."KEY" AS "KEY", CAST("RF_Model_5"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_5"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_5"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_5"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_5"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_5"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_5" UNION ALL SELECT "RF_Model_6"."KEY" AS "KEY", CAST("RF_Model_6"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_6"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_6"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_6"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_6"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_6"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_6" UNION ALL SELECT "RF_Model_7"."KEY" AS "KEY", CAST("RF_Model_7"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_7"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_7"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_7"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_7"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_7"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_7" UNION ALL SELECT "RF_Model_8"."KEY" AS "KEY", CAST("RF_Model_8"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_8"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_8"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_8"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_8"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_8"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_8" UNION ALL SELECT "RF_Model_9"."KEY" AS "KEY", CAST("RF_Model_9"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_9"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_9"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_9"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_9"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_9"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_9") AS "RF_esu_0"), 
  "RF_1" AS 
  (WITH "ADS_sca_1_OUT" AS 
  (SELECT "ADS"."KEY" AS "KEY", (CAST("ADS"."Feature_0" AS FLOAT) - 0.06182920523813451) / 1.236134089597546 AS "Feature_0", (CAST("ADS"."Feature_1" AS FLOAT) - 0.17702463767183327) / 0.946757498519011 AS "Feature_1", (CAST("ADS"."Feature_2" AS FLOAT) - 0.041383850049034464) / 1.0809597326983538 AS "Feature_2", (CAST("ADS"."Feature_3" AS FLOAT) - 0.13060646805847148) / 1.0860335106241017 AS "Feature_3", (CAST("ADS"."Feature_4" AS FLOAT) - -0.05955810471983085) / 1.1165897507633815 AS "Feature_4", (CAST("ADS"."Feature_5" AS FLOAT) - -0.048929089870105816) / 1.3868824547243672 AS "Feature_5", (CAST("ADS"."Feature_6" AS FLOAT) - 0.19101797861713127) / 0.979670721363872 AS "Feature_6", (CAST("ADS"."Feature_7" AS FLOAT) - 0.02204959673267471) / 0.4775973825125086 AS "Feature_7", (CAST("ADS"."Feature_8" AS FLOAT) - -0.05772981403414008) / 1.0713243581907332 AS "Feature_8", (CAST("ADS"."Feature_9" AS FLOAT) - -0.052549592052032364) / 1.2322587258530384 AS "Feature_9" 
  FROM "BinaryClass_10" AS "ADS"), 
  "ADS_pre_1_OUT" AS 
  (SELECT "ADS_sca_1_OUT"."KEY" AS "KEY", "ADS_sca_1_OUT"."Feature_0" * 0.5661592321920361 + "ADS_sca_1_OUT"."Feature_1" * -0.035526328604152946 + "ADS_sca_1_OUT"."Feature_2" * -0.0467879363120513 + "ADS_sca_1_OUT"."Feature_3" * 0.008946515209953917 + "ADS_sca_1_OUT"."Feature_4" * 0.0829511888403661 + "ADS_sca_1_OUT"."Feature_5" * -0.10205221296100445 + "ADS_sca_1_OUT"."Feature_6" * 0.1424451507903749 + "ADS_sca_1_OUT"."Feature_7" * 0.5666566688831561 + "ADS_sca_1_OUT"."Feature_8" * -0.06631427728790784 + "ADS_sca_1_OUT"."Feature_9" * -0.5593289854950824 AS "PC1", "ADS_sca_1_OUT"."Feature_0" * 0.0767125800279515 + "ADS_sca_1_OUT"."Feature_1" * -0.40153794458328573 + "ADS_sca_1_OUT"."Feature_2" * 0.5677578250446825 + "ADS_sca_1_OUT"."Feature_3" * 0.2369735703010663 + "ADS_sca_1_OUT"."Feature_4" * -0.09632922916256215 + "ADS_sca_1_OUT"."Feature_5" * -0.5767787279161882 + "ADS_sca_1_OUT"."Feature_6" * -0.3216376934797878 + "ADS_sca_1_OUT"."Feature_7" * -0.006693968243624504 + "ADS_sca_1_OUT"."Feature_8" * -0.06421158945215161 + "ADS_sca_1_OUT"."Feature_9" * 0.06932008034543824 AS "PC2", "ADS_sca_1_OUT"."Feature_0" * -0.04428807917268944 + "ADS_sca_1_OUT"."Feature_1" * 0.02244286142288565 + "ADS_sca_1_OUT"."Feature_2" * -0.1709384323174772 + "ADS_sca_1_OUT"."Feature_3" * 0.4187938020309751 + "ADS_sca_1_OUT"."Feature_4" * 0.4638804547130563 + "ADS_sca_1_OUT"."Feature_5" * 0.12436384332391155 + "ADS_sca_1_OUT"."Feature_6" * -0.2491197630750001 + "ADS_sca_1_OUT"."Feature_7" * -0.02707014062139766 + "ADS_sca_1_OUT"."Feature_8" * -0.7066063892300462 + "ADS_sca_1_OUT"."Feature_9" * 0.01375528233133572 AS "PC3", "ADS_sca_1_OUT"."Feature_0" * 0.035505292609370916 + "ADS_sca_1_OUT"."Feature_1" * 0.4629415976318115 + "ADS_sca_1_OUT"."Feature_2" * 0.39703949728185695 + "ADS_sca_1_OUT"."Feature_3" * 0.108176435008563 + "ADS_sca_1_OUT"."Feature_4" * -0.5443880279914196 + "ADS_sca_1_OUT"."Feature_5" * 0.3886991214463785 + "ADS_sca_1_OUT"."Feature_6" * -0.3136270685510785 + "ADS_sca_1_OUT"."Feature_7" * 0.09412147953130984 + "ADS_sca_1_OUT"."Feature_8" * -0.2041303312264922 + "ADS_sca_1_OUT"."Feature_9" * -0.1369183431411648 AS "PC4", "ADS_sca_1_OUT"."Feature_0" * -0.02395611334530353 + "ADS_sca_1_OUT"."Feature_1" * 0.3059663067403714 + "ADS_sca_1_OUT"."Feature_2" * 0.1244148619727216 + "ADS_sca_1_OUT"."Feature_3" * 0.7205232130433498 + "ADS_sca_1_OUT"."Feature_4" * -0.010360887714254759 + "ADS_sca_1_OUT"."Feature_5" * -0.12313866467327145 + "ADS_sca_1_OUT"."Feature_6" * 0.5630711251768787 + "ADS_sca_1_OUT"."Feature_7" * -0.04287636501865158 + "ADS_sca_1_OUT"."Feature_8" * 0.18391692419974146 + "ADS_sca_1_OUT"."Feature_9" * 0.056520588594192574 AS "PC5", "ADS_sca_1_OUT"."Feature_0" * 0.048169250614026715 + "ADS_sca_1_OUT"."Feature_1" * 0.6239362496677012 + "ADS_sca_1_OUT"."Feature_2" * 0.20083118524117005 + "ADS_sca_1_OUT"."Feature_3" * -0.1618608106397551 + "ADS_sca_1_OUT"."Feature_4" * 0.5432007330496692 + "ADS_sca_1_OUT"."Feature_5" * -0.2436186036944093 + "ADS_sca_1_OUT"."Feature_6" * -0.3147233303086936 + "ADS_sca_1_OUT"."Feature_7" * 0.01337545211610092 + "ADS_sca_1_OUT"."Feature_8" * 0.29670903412359584 + "ADS_sca_1_OUT"."Feature_9" * 0.01296934529502586 AS "PC6", "ADS_sca_1_OUT"."Feature_0" * -0.06773590863463053 + "ADS_sca_1_OUT"."Feature_1" * -0.11758181773858208 + "ADS_sca_1_OUT"."Feature_2" * 0.6477095493436038 + "ADS_sca_1_OUT"."Feature_3" * -0.3112272823678729 + "ADS_sca_1_OUT"."Feature_4" * 0.33477688181210946 + "ADS_sca_1_OUT"."Feature_5" * 0.29496375499110145 + "ADS_sca_1_OUT"."Feature_6" * 0.4607366756100071 + "ADS_sca_1_OUT"."Feature_7" * -0.025868856528122847 + "ADS_sca_1_OUT"."Feature_8" * -0.2305082370268579 + "ADS_sca_1_OUT"."Feature_9" * -0.005964439285718312 AS "PC7" 
  FROM "ADS_sca_1_OUT"), 
  "DT_node_lookup_10" AS 
  (SELECT "ADS_pre_1_OUT"."KEY" AS "KEY", CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.03737317693384511) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 1.6752927836164655) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.3920350515412316) THEN 7 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.7723998903472691) THEN 13 ELSE 14 END END ELSE 4 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.9912596755816544) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -0.7858194485615796) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.1952877021381214) THEN 15 ELSE 16 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.3337337159125616) THEN 17 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -0.5923209244263494) THEN 21 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.5505342482542456) THEN 23 ELSE 24 END END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -0.7095926559969505) THEN 11 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.9972681475501544) THEN 19 ELSE 20 END 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 4 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 7 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 11 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 14 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 16 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 19 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 21 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 23 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 24 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC5" <= 0.3680172110073571) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -1.2905412848322855) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.7648650864900648) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -0.1615078971402125) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 0.08987575436809182) THEN 17 ELSE 18 END ELSE 12 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 0.9970953569736272) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.6006818385442623) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.11554868889780985) THEN 23 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -0.041686314386890105) THEN 27 ELSE 28 END END ELSE 20 END ELSE 14 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -0.7774713974091808) THEN 5 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.14191473835547427) THEN 9 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= -0.8756602595427116) THEN 15 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.06562730186530216) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.032835900960116404) THEN 25 ELSE 26 END ELSE 22 END END 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, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 5 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 9 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 12 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 14 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 22 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 23 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 25 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 26 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 27 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 28 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC3" <= 1.474896436575509) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.1642118162806515) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.6452186706281346) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.3950767777463443) THEN 9 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -0.5932960267278362) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 1.8209992654656924) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 1.308613076009592) THEN 19 ELSE 20 END ELSE 18 END END END ELSE 6 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 0.4770545877636643) THEN 7 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 0.13203477643173747) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 1.0274593421651201) THEN 15 ELSE 16 END ELSE 12 END END END ELSE 2 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 2 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 6 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 7 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 9 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 12 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 16 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 19 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC3" <= 0.4404906096905343) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -0.6978847789201025) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -0.9831982217937516) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -1.4866905129223813) THEN 13 ELSE 14 END ELSE 8 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.19064361131490962) THEN 9 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 1.0629461800434907) THEN CASE WHEN ("ADS_pre_1_OUT"."PC2" <= 2.2385036431497247) THEN 19 ELSE 20 END ELSE 16 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.4936827908594948) THEN 5 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.37685219024314015) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 1.9073115716665825) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.39692961358607753) THEN 21 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.2263693823523077) THEN 23 ELSE 24 END END ELSE 18 END ELSE 12 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 5 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 8 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 9 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 12 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 14 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 16 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 19 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 21 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 23 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 24 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC2" <= 0.31501313259899655) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= 0.4671114528438084) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.5449215547387063) THEN 7 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.6711338481717012) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -0.17787423073944802) THEN CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.6064564787617581) THEN CASE WHEN ("ADS_pre_1_OUT"."PC6" <= -0.8965843059586076) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -2.311423751265543) THEN 37 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.5251899830460717) THEN 39 ELSE 40 END END ELSE 36 END ELSE 32 END ELSE 22 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 1.6752927836164655) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.4891712495873274) THEN 33 ELSE 34 END ELSE 24 END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC2" <= -1.8714409533382543) THEN 9 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC7" <= 0.4534377731879599) THEN 15 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.7801005167718602) THEN 25 ELSE 26 END END END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC3" <= 2.135967475378304) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -0.07025574208952565) THEN CASE WHEN ("ADS_pre_1_OUT"."PC3" <= -1.352033025863361) THEN 17 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.1352103408358193) THEN 27 ELSE 28 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 1.0271768286611775) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 0.2207841189696224) THEN 29 ELSE 30 END ELSE 20 END END ELSE 6 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 6 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 7 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 9 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 20 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 22 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 24 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 25 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 26 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 27 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 28 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 29 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 30 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 32 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 33 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 34 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 36 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 37 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 39 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 40 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 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"."PC6" <= -0.6679956487224556) THEN CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -1.7498869022464294) THEN 3 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= 0.03357577901857884) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.8784963062150318) THEN 13 ELSE CASE WHEN ("ADS_pre_1_OUT"."PC5" <= -0.2350327996485655) THEN 17 ELSE 18 END END ELSE 8 END END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC1" <= -0.10114498837519965) THEN CASE WHEN ("ADS_pre_1_OUT"."PC4" <= -0.9068600961779164) THEN 9 ELSE 10 END ELSE CASE WHEN ("ADS_pre_1_OUT"."PC4" <= 0.5505342482542456) THEN CASE WHEN ("ADS_pre_1_OUT"."PC1" <= 1.3212967243527736) THEN 15 ELSE 16 END ELSE 12 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" UNION ALL SELECT 8 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 9 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 10 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 12 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 13 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 15 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 16 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP" UNION ALL SELECT 17 AS nid, 0.0 AS "P_0", 1.0 AS "P_1", 1 AS "D", 1.0 AS "DP" UNION ALL SELECT 18 AS nid, 1.0 AS "P_0", 0.0 AS "P_1", 0 AS "D", 1.0 AS "DP") AS "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 FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_0", CAST(NULL AS FLOAT) 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 -1.79769313486231e+308 END AS "LogProba_1" 
  FROM "DT_Output_15")
   SELECT "RF_esu_1"."KEY", "RF_esu_1"."Score_0", "RF_esu_1"."Proba_0", "RF_esu_1"."LogProba_0", "RF_esu_1"."Score_1", "RF_esu_1"."Proba_1", "RF_esu_1"."LogProba_1" 
  FROM (SELECT "RF_Model_10"."KEY" AS "KEY", CAST("RF_Model_10"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_10"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_10"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_10"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_10"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_10"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_10" UNION ALL SELECT "RF_Model_11"."KEY" AS "KEY", CAST("RF_Model_11"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_11"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_11"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_11"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_11"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_11"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_11" UNION ALL SELECT "RF_Model_12"."KEY" AS "KEY", CAST("RF_Model_12"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_12"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_12"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_12"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_12"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_12"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_12" UNION ALL SELECT "RF_Model_13"."KEY" AS "KEY", CAST("RF_Model_13"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_13"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_13"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_13"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_13"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_13"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_13" UNION ALL SELECT "RF_Model_14"."KEY" AS "KEY", CAST("RF_Model_14"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_14"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_14"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_14"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_14"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_14"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_14" UNION ALL SELECT "RF_Model_15"."KEY" AS "KEY", CAST("RF_Model_15"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_Model_15"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_Model_15"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_Model_15"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_Model_15"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_Model_15"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_Model_15") AS "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 FLOAT) AS "Score_0", CAST("RF_0"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_0"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_0"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_0"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_0"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_0" UNION ALL SELECT "RF_1"."KEY" AS "KEY", CAST("RF_1"."Score_0" AS FLOAT) AS "Score_0", CAST("RF_1"."Proba_0" AS FLOAT) AS "Proba_0", CAST("RF_1"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("RF_1"."Score_1" AS FLOAT) AS "Score_1", CAST("RF_1"."Proba_1" AS FLOAT) AS "Proba_1", CAST("RF_1"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM "RF_1") AS "RFbig_esu"), 
  "RF_avg" AS 
  (SELECT "T"."KEY" AS "KEY", CAST("T"."Score_0" AS FLOAT) AS "Score_0", CAST("T"."Proba_0" AS FLOAT) AS "Proba_0", CAST("T"."LogProba_0" AS FLOAT) AS "LogProba_0", CAST("T"."Score_1" AS FLOAT) AS "Score_1", CAST("T"."Proba_1" AS FLOAT) AS "Proba_1", CAST("T"."LogProba_1" AS FLOAT) AS "LogProba_1" 
  FROM (SELECT "RF"."KEY" AS "KEY", avg(CAST("RF"."Score_0" AS FLOAT)) AS "Score_0", avg(CAST("RF"."Proba_0" AS FLOAT)) AS "Proba_0", CAST(NULL AS FLOAT) AS "LogProba_0", avg(CAST("RF"."Score_1" AS FLOAT)) AS "Score_1", avg(CAST("RF"."Proba_1" AS FLOAT)) AS "Proba_1", CAST(NULL AS FLOAT) AS "LogProba_1" 
  FROM "RF" GROUP BY "RF"."KEY") AS "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 BIGINT) AS "Decision", CAST(NULL AS FLOAT) 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) AS 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") AS 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") AS "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 -1.79769313486231e+308 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 -1.79769313486231e+308 END AS "LogProba_1", arg_max_cte."arg_max_Proba" AS "Decision", arg_max_cte."max_Proba" AS "DecisionProba" 
  FROM arg_max_cte