SP1 - Details for Query 387

Submitted Time: 2026/06/25 16:21:46
Duration: 0.7 s
Succeeded Jobs: 497 498

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" AdaptiveSparkPlan "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (3)\n \nduration: 300 ms"; 2 [labelType="html" label=" Project "]; 3 [labelType="html" label=" Project "]; 4 [labelType="html" label=" Project "]; 5 [labelType="html" label=" Project "]; 6 [labelType="html" label="Filter number of output rows: 554"]; } 7 [labelType="html" label="Window spill size: 0.0 B"]; subgraph cluster8 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 12 ms"; 9 [labelType="html" label="Sort sort time: 0 ms peak memory: 16.1 MiB spill size: 0.0 B"]; } 10 [labelType="html" label="AQEShuffleRead number of partitions: 1 partition data size: 609.1 KiB number of coalesced partitions: 1"]; 11 [labelType="html" label="Exchange shuffle records written: 1,455 local merged chunks fetched: 0 shuffle write time: 1 ms remote merged bytes read: 0.0 B local merged blocks fetched: 0 corrupt merged block chunks: 0 remote merged reqs duration: 0 ms remote merged blocks fetched: 0 records read: 1,455 local bytes read: 563.6 KiB fetch wait time: 0 ms remote bytes read: 0.0 B merged fetch fallback count: 0 local blocks read: 1 remote merged chunks fetched: 0 remote blocks read: 0 data size: 1222.2 KiB local merged bytes read: 0.0 B number of partitions: 10 remote reqs duration: 0 ms remote bytes read to disk: 0.0 B shuffle bytes written: 563.6 KiB"]; subgraph cluster12 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 23 ms"; 13 [labelType="html" label=" Project "]; 14 [labelType="html" label="ColumnarToRow number of output rows: 1,455 number of input batches: 1"]; } 15 [labelType="html" label="Scan parquet number of files read: 1 scan time: 8 ms metadata time: 0 ms size of files read: 276.8 KiB number of output rows: 1,455"]; 2->0; 3->2; 4->3; 5->4; 6->5; 7->6; 9->7; 10->9; 11->10; 13->11; 14->13; 15->14; }

AdaptiveSparkPlan isFinalPlan=true

Project [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, ... 31 more fields]

Filter (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#147742)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#147742)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#147750)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#147750)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#147765)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#147765)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MEUBLE) END, Meublé, Non Meublé))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MEUBLE) END, Meublé, Non Meublé))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, T\d+), 0))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, T\d+), 0))), MAISON) END)

WholeStageCodegen (3)

Window [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L], [1], [1 DESC NULLS LAST]

Sort [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

WholeStageCodegen (2)

AQEShuffleRead coalesced

Exchange hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=20095]

Project [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#147371 AS COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#147372 AS COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#147373 AS COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#147374 AS COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#147375 AS COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#147376 AS COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#147377 AS COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#147378 AS COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#147379 AS COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#147380 AS COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#147381 AS COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#147382 AS COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#147383 AS COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#147384 AS COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#147385 AS COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#147386 AS COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#147387 AS COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_0DB61D05_5348_40DB_8F16_C7916849A669#147388 AS COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#147389 AS COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#147390 AS COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#147391 AS COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#147392 AS COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#147393 AS COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_33CEA792_75B9_44A1_896B_B422BD28B923#147394 AS COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, ... 20 more fields]

ColumnarToRow

WholeStageCodegen (1)

FileScan parquet [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#147371,COL_EC7474ED_A0A6_401C_BA97_20D63A467807#147372,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#147373,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#147374,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#147375,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#147376,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#147377,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#147378,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#147379,COL_D4E1F01A_72C8_4621_905A_881FB0249F81#147380,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#147381,COL_871E0000_AA32_4679_83B0_C8AA49007BCF#147382,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#147383,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#147384,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#147385,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#147386,COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#147387,COL_0DB61D05_5348_40DB_8F16_C7916849A669#147388,COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#147389,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#147390,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#147391,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#147392,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#147393,COL_33CEA792_75B9_44A1_896B_B422BD28B923#147394,... 20 more fields] Batched: true, DataFilters: [], Format: Parquet, Location: InMemoryFileIndex(1 paths)[file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405206], PartitionFilters: [], PushedFilters: [], ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:s...

Details

== Physical Plan ==
AdaptiveSparkPlan (24)
+- == Final Plan ==
   * Project (13)
   +- * Project (12)
      +- * Project (11)
         +- * Project (10)
            +- * Filter (9)
               +- Window (8)
                  +- * Sort (7)
                     +- AQEShuffleRead (6)
                        +- ShuffleQueryStage (5), Statistics(sizeInBytes=1222.2 KiB, rowCount=1.46E+3)
                           +- Exchange (4)
                              +- * Project (3)
                                 +- * ColumnarToRow (2)
                                    +- Scan parquet  (1)
+- == Initial Plan ==
   CollectLimit (23)
   +- Project (22)
      +- Project (21)
         +- Project (20)
            +- Project (19)
               +- Filter (18)
                  +- Window (17)
                     +- Sort (16)
                        +- Exchange (15)
                           +- Project (14)
                              +- Scan parquet  (1)


(1) Scan parquet 
Output [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#147371, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#147372, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#147373, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#147374, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#147375, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#147376, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#147377, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#147378, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#147379, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#147380, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#147381, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#147382, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#147383, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#147384, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#147385, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#147386, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#147387, COL_0DB61D05_5348_40DB_8F16_C7916849A669#147388, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#147389, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#147390, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#147391, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#147392, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#147393, COL_33CEA792_75B9_44A1_896B_B422BD28B923#147394, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#147395, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#147396, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#147397, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#147398, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#147399, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#147400, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#147401, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#147402, COL_924860D6_14C4_4F33_B84C_E428E89E2817#147403, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#147404, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#147405, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#147406, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#147407, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#147408, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#147409, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#147410, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#147411, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#147412, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#147413, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#147414]
Batched: true
Location: InMemoryFileIndex [file:/data/output/cache/parquet/datablock/MATCHING_ANALYS_405206]
ReadSchema: struct<COL_BA552F89_FE8A_4EC3_A09E_640A661C9019:string,COL_EC7474ED_A0A6_401C_BA97_20D63A467807:string,COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB:string,COL_8467C1BB_F0A2_44E6_88D6_8477052876CA:string,COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929:string,COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B:string,COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E:string,COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93:string,COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355:string,COL_D4E1F01A_72C8_4621_905A_881FB0249F81:string,COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED:string,COL_871E0000_AA32_4679_83B0_C8AA49007BCF:string,COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8:string,COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C:string,COL_9263F342_2220_4C7C_BA3D_B7B7386988B7:string,COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB:string,COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC:string,COL_0DB61D05_5348_40DB_8F16_C7916849A669:string,COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96:string,COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C:string,COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38:string,COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB:string,COL_BBEA900F_6FE8_40DA_B278_36CA822C312A:string,COL_33CEA792_75B9_44A1_896B_B422BD28B923:string,COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48:string,COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25:string,COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5:string,COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267:string,COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27:string,COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2:string,COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23:string,COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC:string,COL_924860D6_14C4_4F33_B84C_E428E89E2817:string,COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C:string,COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF:string,COL_730C7D9D_95B5_4388_983E_C4F260C553BD:string,COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D:string,COL_90791789_DD87_40BC_92F0_F5FB1BD5126F:string,COL_FB26292A_034B_4B72_8403_8A7AE83CFC56:string,COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E:string,COL_FC403537_BB94_4C83_AC18_B668C51A4E0A:string,COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142:string,COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4:string,COL_0798550D_6632_4F18_8CE3_72BAF75D68CC:string>

(2) ColumnarToRow [codegen id : 1]
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#147371, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#147372, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#147373, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#147374, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#147375, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#147376, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#147377, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#147378, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#147379, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#147380, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#147381, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#147382, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#147383, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#147384, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#147385, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#147386, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#147387, COL_0DB61D05_5348_40DB_8F16_C7916849A669#147388, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#147389, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#147390, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#147391, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#147392, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#147393, COL_33CEA792_75B9_44A1_896B_B422BD28B923#147394, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#147395, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#147396, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#147397, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#147398, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#147399, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#147400, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#147401, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#147402, COL_924860D6_14C4_4F33_B84C_E428E89E2817#147403, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#147404, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#147405, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#147406, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#147407, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#147408, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#147409, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#147410, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#147411, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#147412, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#147413, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#147414]

(3) Project [codegen id : 1]
Output [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#147371 AS COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#147372 AS COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#147373 AS COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#147374 AS COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#147375 AS COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#147376 AS COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#147377 AS COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#147378 AS COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#147379 AS COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#147380 AS COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#147381 AS COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#147382 AS COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#147383 AS COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#147384 AS COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#147385 AS COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#147386 AS COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#147387 AS COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_0DB61D05_5348_40DB_8F16_C7916849A669#147388 AS COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#147389 AS COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#147390 AS COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#147391 AS COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#147392 AS COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#147393 AS COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_33CEA792_75B9_44A1_896B_B422BD28B923#147394 AS COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#147395 AS COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#147396 AS COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#147397 AS COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#147398 AS COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#147399 AS COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#147400 AS COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#147401 AS COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#147402 AS COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_924860D6_14C4_4F33_B84C_E428E89E2817#147403 AS COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#147404 AS COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#147405 AS COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#147406 AS COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#147407 AS COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#147408 AS COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#147409 AS COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#147410 AS COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#147411 AS COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#147412 AS COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#147413 AS COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#147414 AS COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#147371, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#147372, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#147373, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#147374, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#147375, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#147376, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#147377, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#147378, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#147379, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#147380, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#147381, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#147382, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#147383, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#147384, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#147385, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#147386, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#147387, COL_0DB61D05_5348_40DB_8F16_C7916849A669#147388, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#147389, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#147390, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#147391, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#147392, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#147393, COL_33CEA792_75B9_44A1_896B_B422BD28B923#147394, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#147395, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#147396, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#147397, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#147398, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#147399, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#147400, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#147401, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#147402, COL_924860D6_14C4_4F33_B84C_E428E89E2817#147403, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#147404, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#147405, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#147406, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#147407, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#147408, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#147409, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#147410, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#147411, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#147412, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#147413, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#147414]

(4) Exchange
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=20095]

(5) ShuffleQueryStage
Output [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Arguments: 0

(6) AQEShuffleRead
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Arguments: coalesced

(7) Sort [codegen id : 2]
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(8) Window
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Arguments: [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L], [1], [1 DESC NULLS LAST]

(9) Filter [codegen id : 3]
Input [45]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#147742)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#147742)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#147750)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#147750)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#147765)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#147765)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE) END, Meublé, Non Meublé))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE) END, Meublé, Non Meublé))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, T\d+), 0))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, T\d+), 0))), MAISON) END)

(10) Project [codegen id : 3]
Output [45]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##) AS COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, str_to_dec(COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, ##,##) AS COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##) AS COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, str_to_dec(COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, ##,##) AS COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##) AS COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Input [45]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L]

(11) Project [codegen id : 3]
Output [46]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, dec_round(dec_if_with_rule((COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754 <=> ), dec_mult(array(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, dec_mult(array(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 0.01)))), null), 2) AS COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131]
Input [45]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]

(12) Project [codegen id : 3]
Output [50]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, dec_round(dec_div(array(COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, 12.0)), 2) AS COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#148178, dec_round(dec_div(array(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080)), 2) AS COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#148226, dec_round(dec_div(array(COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080)), 2) AS COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#148275, dec_round(dec_div(array(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, 12.0)), 2) AS COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325]
Input [46]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131]

(13) Project [codegen id : 3]
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#148178, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#148226, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#148275, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))) AS COL_8068E186_2734_4730_8D2C_A788B2226179#148376, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 08 - NR, is_null, [null], [0.0], 08 - NR, , null))) AS COL_DA667933_29E5_49E1_8724_A537DCE9735F#148428, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))) AS COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#148481, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE) END, Meublé, Non Meublé) AS COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#148535, str_list_get(str_extract_by_regex(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, T\d+), 0) AS COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#148590]
Input [50]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#148178, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#148226, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#148275, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325]

(14) Project
Output [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#147371 AS COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#147372 AS COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#147373 AS COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#147374 AS COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#147375 AS COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#147376 AS COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#147377 AS COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#147378 AS COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#147379 AS COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#147380 AS COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#147381 AS COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#147382 AS COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#147383 AS COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#147384 AS COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#147385 AS COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#147386 AS COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#147387 AS COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_0DB61D05_5348_40DB_8F16_C7916849A669#147388 AS COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#147389 AS COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#147390 AS COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#147391 AS COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#147392 AS COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#147393 AS COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_33CEA792_75B9_44A1_896B_B422BD28B923#147394 AS COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#147395 AS COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#147396 AS COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#147397 AS COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#147398 AS COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#147399 AS COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#147400 AS COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#147401 AS COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#147402 AS COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_924860D6_14C4_4F33_B84C_E428E89E2817#147403 AS COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#147404 AS COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#147405 AS COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#147406 AS COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#147407 AS COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#147408 AS COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#147409 AS COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#147410 AS COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#147411 AS COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#147412 AS COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#147413 AS COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#147414 AS COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Input [44]: [COL_BA552F89_FE8A_4EC3_A09E_640A661C9019#147371, COL_EC7474ED_A0A6_401C_BA97_20D63A467807#147372, COL_60F4CF3D_E693_4CD0_A9AA_B46D0F8B66BB#147373, COL_8467C1BB_F0A2_44E6_88D6_8477052876CA#147374, COL_27B17E0B_907D_44D3_B4DA_5D8A52B48929#147375, COL_55A6EDE7_A230_436B_98E0_978F6BDABD7B#147376, COL_BF0790B6_BE4E_4B35_88D1_AF1204028C1E#147377, COL_A6FAA0D2_6BE4_4E6C_9624_1051256FDD93#147378, COL_91A0CCF7_4180_4F35_9CFF_31F5FAB4D355#147379, COL_D4E1F01A_72C8_4621_905A_881FB0249F81#147380, COL_EF43AB50_4FC5_4F89_9B24_3646DD00E0ED#147381, COL_871E0000_AA32_4679_83B0_C8AA49007BCF#147382, COL_1D461FB3_254A_4AE9_B5BD_252DFBF74DF8#147383, COL_D55BFEB7_C99E_4002_B6DE_43C59B5A515C#147384, COL_9263F342_2220_4C7C_BA3D_B7B7386988B7#147385, COL_D44F34D5_4CC2_43CE_A245_8A50E96BF4CB#147386, COL_06EBFD69_C44E_4E8F_BC8B_3D39AE1808FC#147387, COL_0DB61D05_5348_40DB_8F16_C7916849A669#147388, COL_8AC6FD78_FF02_4F12_A5D1_FD5437385F96#147389, COL_0DD2348E_F57A_4892_8B69_5DC0D122B60C#147390, COL_A9BE5C21_B288_48A0_A321_05B6DD8C7E38#147391, COL_9C3D033A_EBC6_4C85_B782_359B5B1194DB#147392, COL_BBEA900F_6FE8_40DA_B278_36CA822C312A#147393, COL_33CEA792_75B9_44A1_896B_B422BD28B923#147394, COL_698CA40C_BF83_4900_8682_B0D1ECD9ED48#147395, COL_AE8F8AD5_345F_44CF_B0E3_2AB350A33E25#147396, COL_0CC5BF4D_1F35_475E_A8C9_89F714E0BCD5#147397, COL_BD48FE9D_9E5D_4047_B3B1_3A4127CDF267#147398, COL_8CBEE43E_9F72_4EC8_885F_E40373FA0D27#147399, COL_9FEF5922_71F1_4AF2_8F26_B3D3614C3BA2#147400, COL_C3C30992_D740_4F6C_ADA8_C5C74880CE23#147401, COL_1055A94E_D533_4DE5_A864_E5DD62BB83AC#147402, COL_924860D6_14C4_4F33_B84C_E428E89E2817#147403, COL_EEC51E24_A0E1_4E7D_B541_2CC8D1B1EA0C#147404, COL_9DEDEB5B_787A_4D17_872D_F3EF2E45AECF#147405, COL_730C7D9D_95B5_4388_983E_C4F260C553BD#147406, COL_B3A80DDF_0C1C_4D98_A77C_0D7A4A3DF77D#147407, COL_90791789_DD87_40BC_92F0_F5FB1BD5126F#147408, COL_FB26292A_034B_4B72_8403_8A7AE83CFC56#147409, COL_901FC7B7_8CF7_4A24_AA81_D95559B8998E#147410, COL_FC403537_BB94_4C83_AC18_B668C51A4E0A#147411, COL_ACC30F85_812D_4AD9_9C3A_A17F6C2D6142#147412, COL_D1EA10C2_92C7_46D6_B85F_236B137DF7F4#147413, COL_0798550D_6632_4F18_8CE3_72BAF75D68CC#147414]

(15) Exchange
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Arguments: hashpartitioning(1, 10), ENSURE_REQUIREMENTS, [plan_id=20075]

(16) Sort
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Arguments: [1 ASC NULLS FIRST, 1 DESC NULLS LAST], false, 0

(17) Window
Input [44]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Arguments: [count(1) windowspecdefinition(1, 1 DESC NULLS LAST, specifiedwindowframe(RangeFrame, unboundedpreceding$(), currentrow$())) AS COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L], [1], [1 DESC NULLS LAST]

(18) Filter
Input [45]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L]
Condition : (((((((((((((((((((((((((((((((((((((((((((CASE WHEN isnull(Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723)), MAISON) END OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#147742)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_98B2878A_418E_4331_B333_2493994BB807#147742)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#147750)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D897344F_9AC3_429E_A95D_88390F445758#147750)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#147765)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_1FF33786_C88A_4789_B428_364FF98B1905#147765)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766)), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766)), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(dec_round(dec_div(array(str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##), 12.0)), 2), > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##), 08 - NR, is_null, [null], [0.0], 08 - NR, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##), 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE) END, Meublé, Non Meublé))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE) END, Meublé, Non Meublé))), MAISON) END) OR CASE WHEN isnull(Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, T\d+), 0))), MAISON)) THEN false ELSE Contains(str_remove_accent(upper(str_list_get(str_extract_by_regex(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, T\d+), 0))), MAISON) END)

(19) Project
Output [45]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, str_to_dec(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, ##.##) AS COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, str_to_dec(COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, ##,##) AS COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, str_to_dec(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, ##,##) AS COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, str_to_dec(COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, ##,##) AS COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, str_to_dec(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, ##.##) AS COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]
Input [45]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#147737, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#147739, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#147740, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#147741, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#147753, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L]

(20) Project
Output [46]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, dec_round(dec_if_with_rule((COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754 <=> ), dec_mult(array(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, dec_mult(array(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 0.01)))), null), 2) AS COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131]
Input [45]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766]

(21) Project
Output [50]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, dec_round(dec_div(array(COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, 12.0)), 2) AS COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#148178, dec_round(dec_div(array(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080)), 2) AS COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#148226, dec_round(dec_div(array(COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080)), 2) AS COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#148275, dec_round(dec_div(array(COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, 12.0)), 2) AS COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325]
Input [46]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131]

(22) Project
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#148178, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#148226, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#148275, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 01 - < 600 €, less, [600.0], [0.0], 01 - < 600 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 02 - 600 – 800 €, between, [600.0], [799.99], 02 - 600 – 800 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 03 - 800 – 1 000 €, between, [800.0], [999.99], 03 - 800 – 1 000 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 04 - 1 000 – 1 300 €, between, [1000.0], [1299.99], 04 - 1 000 – 1 300 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, 05 - 1 300 – 1 700 €, between, [1300.0], [1700.0], 05 - 1 300 – 1 700 €, , null), RANKING_DOUBLE(COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, > 1 700 €, greater, [1700.0], [0.0], 06 - > 1 700 €, , null))) AS COL_8068E186_2734_4730_8D2C_A788B2226179#148376, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, < 20 m², less, [20.0], [0.0], 01 - < 20 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 02 - 20 – 30 m², between, [20.0], [30.0], 02 - 20 – 30 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 03 - 30 – 40 m², between, [30.0], [40.0], 03 - 30 – 40 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 04 - 40 – 50 m², between, [40.0], [50.0], 04 - 40 – 50 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 05 - 50 – 70 m², between, [50.0], [70.0], 05 - 50 – 70 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 06 - 70 – 100 m², between, [70.0], [100.0], 06 - 70 – 100 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 07 - > 100 m², greater, [100.0], [0.0], 07 - > 100 m², , null), RANKING_DOUBLE(COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, 08 - NR, is_null, [null], [0.0], 08 - NR, , null))) AS COL_DA667933_29E5_49E1_8724_A537DCE9735F#148428, RANKING_RESULTS_CONNECTOR(STOP_IF_TRUE, null, array(RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 01 - < 3 %, less, [3.0], [0.0], 01 - < 3 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 02 - 3 – 3,99 %, between, [3.0], [3.99], 02 - 3 – 3,99 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 03 - 4 – 4,99 %, between, [4.0], [4.99], 03 - 4 – 4,99 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 04 - 5 – 5,99 %, between, [5.0], [5.99], 04 - 5 – 5,99 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 05 - 6 – 6,99 %, between, [6.0], [6.99], 05 - 6 – 6,99 %, , null), RANKING_DOUBLE(COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, 06 - >= 7 %, greater_or_equal, [7.0], [0.0], 06 - >= 7 %, , null))) AS COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#148481, str_if_with_rule(CASE WHEN isnull(Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE)) THEN false ELSE Contains(str_remove_accent(upper(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735)),  MEUBLE) END, Meublé, Non Meublé) AS COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#148535, str_list_get(str_extract_by_regex(COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, T\d+), 0) AS COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#148590]
Input [50]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#148178, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#148226, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#148275, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325]

(23) CollectLimit
Input [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#148178, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#148226, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#148275, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, COL_8068E186_2734_4730_8D2C_A788B2226179#148376, COL_DA667933_29E5_49E1_8724_A537DCE9735F#148428, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#148481, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#148535, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#148590]
Arguments: 1500

(24) AdaptiveSparkPlan
Output [55]: [COL_DFF5C88B_EC4F_4F3A_8D04_56CFE00B3399#147723, COL_956F91E2_2027_457F_A229_B9CF20D9FF63#147724, COL_CC11ABBF_8FF5_4174_A0A8_0023479D75B3#147725, COL_97C271EC_5E5F_4F9D_8B8E_F64EF2C08BE3#147726, COL_27A5D399_7515_4FD9_8BAF_3903A6AF098C#147727, COL_FB65F162_1AB6_4971_99DA_F8A943944A66#147728, COL_04BFCB87_D14B_4364_A366_6B179BF9CD20#147729, COL_E4E3639A_F4C8_44FB_BC6A_E9227BDADC0C#147730, COL_573E3A58_7401_4F3F_9EFA_058729D28B72#147731, COL_E5D25971_416B_45A5_B990_0E2D85EEC9AF#147732, COL_0903E31F_8D85_4A6F_BA3C_9B86A0F2C159#147733, COL_FF732B43_3698_4BD8_A8AB_F16BC337E5C9#147734, COL_CD5E797F_F8C4_49EC_BA6C_9ED22E6F7084#147735, COL_C42F735E_237B_4569_996D_76FF5A4A65DF#147736, COL_280ABAAC_E0C3_4D6B_9FFD_C2F4C25A3214#147738, COL_98B2878A_418E_4331_B333_2493994BB807#147742, COL_F1463C5C_56EA_436B_AFE1_7C04B8A44F9C#147743, COL_C3AE9E1E_BC83_422D_AF1B_A39B4181A1FF#147744, COL_14E49AF8_68CB_4FA5_B0E6_9678DC5AC8FE#147745, COL_82DB0DB2_A11D_4C73_BDB7_6941D6772B63#147746, COL_E722B691_2CA2_4160_A578_D9CD4920A842#147747, COL_D600764E_8D81_4891_BF21_ACC3F0938E57#147748, COL_FE2BBF7D_6837_4D79_9ABB_AB9F742E41E5#147749, COL_D897344F_9AC3_429E_A95D_88390F445758#147750, COL_22BB8CFF_0E57_4224_8F83_F1E092BDC4D9#147751, COL_52167438_70F6_4E26_B5CD_17C5990F8948#147752, COL_9C243A28_6EED_43CB_ADC1_2A093DB56A17#147754, COL_F6E5CDD3_D89B_4653_A792_1330FF1124D3#147755, COL_CA1DC1D9_20F6_42AB_B56B_FE4E61DC2539#147756, COL_4CA53CB8_B3E3_4741_A096_6DAB740500B9#147757, COL_53A78B5E_7ABC_4112_A79E_604E0CDB99A6#147758, COL_C228A1B6_114E_46D1_8AD3_63CA3FA788E9#147759, COL_EE5C6142_4177_4FAF_8D67_D84AA5D39E49#147760, COL_89915B9D_6567_4690_A34F_4CE89C5C0CE7#147761, COL_D0A8A26A_A602_4462_BBB1_8286F0724054#147762, COL_10B71399_BEF9_4A5A_ABC9_0146F1348B30#147763, COL_D9F6D6B9_54DE_431A_A44B_DDC174B58EC3#147764, COL_1FF33786_C88A_4789_B428_364FF98B1905#147765, COL_35375170_B542_49DE_AFA2_0A2D31967891#147859L, COL_1841F771_16DF_485A_B9B9_9B9C75CEA7FF#148080, COL_0FB12CFD_6BE9_4BB6_B7BB_187E82AA1FA9#148081, COL_C0CA120C_6738_4CF5_B569_FD209A7B518A#148082, COL_DA3E1E5A_BB1E_44D6_980C_ED6A5F23E2C3#148083, COL_E682A08A_BBA8_4717_9D96_AEC5FE5E42DE#148084, COL_0D8E2436_E961_45FA_A7F3_A7C5D2ED89CF#148131, COL_47F63D6D_6938_4D8F_855E_E5A0106D02AD#148178, COL_566EB258_CFF9_4285_BB8C_DBD46A1BE5B9#148226, COL_23424D2C_0B0A_403F_9061_1D8B148D6A67#148275, COL_5CDC74F0_3D28_463C_9042_237BDAB52540#147766, COL_EAFDA249_1ED2_4EA1_B82E_F10F08D7F028#148325, COL_8068E186_2734_4730_8D2C_A788B2226179#148376, COL_DA667933_29E5_49E1_8724_A537DCE9735F#148428, COL_473AC9C4_6A73_495F_A399_4B9C1E23BBC4#148481, COL_C5B37418_B2B7_49D0_8C7C_3E0D61B4DAD7#148535, COL_A6B4C7B1_4D23_4C04_AACE_CCD82E9AC458#148590]
Arguments: isFinalPlan=true

SQL / DataFrame Properties

Name	Value
spark.sql.optimizer.nestedPredicatePushdown.supportedFileSources	parquet,orc,geoparquet