using System;

using Newtonsoft.Json.Linq;

public class Program

{

    public static void Main()

    {

        const string journeyJson = "{'3336':{'Id':3336,'Title':'Travel online stores ','Order':1,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 6 items: [, , , , , ]','Before StripItemsRemovingStage - Strip has 6 items: [, , , , , ]','After StripItemsRemovingStage - Strip has 6 items: [, , , , , ]','Items before StripItemsSorter - Strip has 6 items: [, , , , , ]','Items After StripItemsSorter - Strip has 6 items: [, , , , , ]','Before StripsSortingStage - Strip order is: 1','After StripsSortingStage - Strip order is: 1']},'4573':{'Id':4573,'Title':'Hotels & Lodging','Order':null,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 1 items: []','Before StripItemsRemovingStage - Strip has 1 items: []','After StripItemsRemovingStage - Strip has 1 items: []','StripsValidatorStage - Strip is invalid according to WebStripsValidationStrategy']},'4581':{'Id':4581,'Title':'Travel Excursions Equipment','Order':5,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 6 items: [, , , , , ]','Before StripItemsRemovingStage - Strip has 6 items: [, , , , , ]','During StripItemsRemovingStage - Filtered some items in StripsDuplicateItemsFilter. Reason: Items are duplicate in page; Items Count:[2]; Filtered Items:[ , ]','After StripItemsRemovingStage - Strip has 4 items: [, , , ]','Items before StripItemsSorter - Strip has 4 items: [, , , ]','Items After StripItemsSorter - Strip has 4 items: [, , , ]','Before StripsSortingStage - Strip order is: 6','After StripsSortingStage - Strip order is: 5']},'4785':{'Id':4785,'Title':'Capture the moment','Order':10,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 20 items: [637475923, 374187886, 391033496, 502010676, 533779714, 475933725, 166167653, 478177419, 367021891, 672148880, 599369861, 689353993, 715513416, 581057703, 694688508, 715513043, 599369907, 482687338, 715512411, 715512539]','Before StripItemsRemovingStage - Strip has 20 items: [637475923, 374187886, 391033496, 502010676, 533779714, 475933725, 166167653, 478177419, 367021891, 672148880, 599369861, 689353993, 715513416, 581057703, 694688508, 715513043, 599369907, 482687338, 715512411, 715512539]','After StripItemsRemovingStage - Strip has 20 items: [637475923, 374187886, 391033496, 502010676, 533779714, 475933725, 166167653, 478177419, 367021891, 672148880, 599369861, 689353993, 715513416, 581057703, 694688508, 715513043, 599369907, 482687338, 715512411, 715512539]','Items before StripItemsSorter - Strip has 20 items: [637475923, 374187886, 391033496, 502010676, 533779714, 475933725, 166167653, 478177419, 367021891, 672148880, 599369861, 689353993, 715513416, 581057703, 694688508, 715513043, 599369907, 482687338, 715512411, 715512539]','Items After StripItemsSorter - Strip has 20 items: [637475923, 374187886, 391033496, 502010676, 533779714, 475933725, 166167653, 478177419, 367021891, 672148880, 599369861, 689353993, 715513416, 581057703, 694688508, 715513043, 599369907, 482687338, 715512411, 715512539]','Before StripsSortingStage - Strip order is: 11','After StripsSortingStage - Strip order is: 10']},'4797':{'Id':4797,'Title':'Travelers favorites','Order':9,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 4 items: [f5b7b4cd-3d91-47c2-aca1-dff8879824cf, 1b4b23a4-2bde-416f-a7c4-eee47f7039a3, eaaea487-32cf-4195-8bcc-2c467cb270c7, 915dda46-c599-4ac0-a0ed-31ccb866e161]','Before StripItemsRemovingStage - Strip has 4 items: [f5b7b4cd-3d91-47c2-aca1-dff8879824cf, 1b4b23a4-2bde-416f-a7c4-eee47f7039a3, eaaea487-32cf-4195-8bcc-2c467cb270c7, 915dda46-c599-4ac0-a0ed-31ccb866e161]','After StripItemsRemovingStage - Strip has 4 items: [f5b7b4cd-3d91-47c2-aca1-dff8879824cf, 1b4b23a4-2bde-416f-a7c4-eee47f7039a3, eaaea487-32cf-4195-8bcc-2c467cb270c7, 915dda46-c599-4ac0-a0ed-31ccb866e161]','Items before StripItemsSorter - Strip has 4 items: [f5b7b4cd-3d91-47c2-aca1-dff8879824cf, 1b4b23a4-2bde-416f-a7c4-eee47f7039a3, eaaea487-32cf-4195-8bcc-2c467cb270c7, 915dda46-c599-4ac0-a0ed-31ccb866e161]','Items After StripItemsSorter - Strip has 4 items: [f5b7b4cd-3d91-47c2-aca1-dff8879824cf, 1b4b23a4-2bde-416f-a7c4-eee47f7039a3, eaaea487-32cf-4195-8bcc-2c467cb270c7, 915dda46-c599-4ac0-a0ed-31ccb866e161]','Before StripsSortingStage - Strip order is: 10','After StripsSortingStage - Strip order is: 9']},'4801':{'Id':4801,'Title':'Travel accessories everyone wants','Order':3,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 20 items: [471495020, 432693575, 440614906, 396799633, 343749916, 495807613, 389160145, 408438914, 472272009, 357295469, 462493360, 391369416, 533854355, 4749703, 463664521, 414561675, 391369340, 463664160, 527454831, 453965486]','Before StripItemsRemovingStage - Strip has 20 items: [471495020, 432693575, 440614906, 396799633, 343749916, 495807613, 389160145, 408438914, 472272009, 357295469, 462493360, 391369416, 533854355, 4749703, 463664521, 414561675, 391369340, 463664160, 527454831, 453965486]','After StripItemsRemovingStage - Strip has 20 items: [471495020, 432693575, 440614906, 396799633, 343749916, 495807613, 389160145, 408438914, 472272009, 357295469, 462493360, 391369416, 533854355, 4749703, 463664521, 414561675, 391369340, 463664160, 527454831, 453965486]','Items before StripItemsSorter - Strip has 20 items: [471495020, 432693575, 440614906, 396799633, 343749916, 495807613, 389160145, 408438914, 472272009, 357295469, 462493360, 391369416, 533854355, 4749703, 463664521, 414561675, 391369340, 463664160, 527454831, 453965486]','Items After StripItemsSorter - Strip has 20 items: [462493360, 396799633, 471495020, 432693575, 440614906, 343749916, 495807613, 389160145, 408438914, 472272009, 357295469, 391369416, 533854355, 4749703, 463664521, 414561675, 391369340, 463664160, 527454831, 453965486]','Before StripsSortingStage - Strip order is: 4','After StripsSortingStage - Strip order is: 3']},'4803':{'Id':4803,'Title':'Travel Categories Curated','Order':12,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 5 items: [5cc1f44d-9181-4755-8843-c24343da2fde, 989db6b7-a730-406f-8ed9-bc04f73cd0b2, c7453bc2-f125-44e5-becd-06ab3e784ba5, 5ede73b9-1fef-4d86-a73c-a7e09a722f75, 45241c1c-bd06-4ee4-8b62-1530b9cc8325]','Before StripItemsRemovingStage - Strip has 5 items: [5cc1f44d-9181-4755-8843-c24343da2fde, 989db6b7-a730-406f-8ed9-bc04f73cd0b2, c7453bc2-f125-44e5-becd-06ab3e784ba5, 5ede73b9-1fef-4d86-a73c-a7e09a722f75, 45241c1c-bd06-4ee4-8b62-1530b9cc8325]','After StripItemsRemovingStage - Strip has 5 items: [989db6b7-a730-406f-8ed9-bc04f73cd0b2, c7453bc2-f125-44e5-becd-06ab3e784ba5, 5cc1f44d-9181-4755-8843-c24343da2fde, 5ede73b9-1fef-4d86-a73c-a7e09a722f75, 45241c1c-bd06-4ee4-8b62-1530b9cc8325]','Items before StripItemsSorter - Strip has 5 items: [989db6b7-a730-406f-8ed9-bc04f73cd0b2, c7453bc2-f125-44e5-becd-06ab3e784ba5, 5cc1f44d-9181-4755-8843-c24343da2fde, 5ede73b9-1fef-4d86-a73c-a7e09a722f75, 45241c1c-bd06-4ee4-8b62-1530b9cc8325]','Items After StripItemsSorter - Strip has 5 items: [989db6b7-a730-406f-8ed9-bc04f73cd0b2, c7453bc2-f125-44e5-becd-06ab3e784ba5, 5cc1f44d-9181-4755-8843-c24343da2fde, 5ede73b9-1fef-4d86-a73c-a7e09a722f75, 45241c1c-bd06-4ee4-8b62-1530b9cc8325]','Before StripsSortingStage - Strip order is: 13','After StripsSortingStage - Strip order is: 12']},'5211':{'Id':5211,'Title':'web hotels Pec perm','Order':0,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','Before StripItemsRemovingStage - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','After StripItemsRemovingStage - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','Items before StripItemsSorter - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','Items After StripItemsSorter - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','Before StripsSortingStage - Strip order is: 0','After StripsSortingStage - Strip order is: 0']},'5383':{'Id':5383,'Title':'Best selling items for travel','Order':7,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 20 items: [641236575, 250303495, 212800846, 697671901, 234787566, 74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','Before StripItemsRemovingStage - Strip has 20 items: [641236575, 250303495, 212800846, 697671901, 234787566, 74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','During StripItemsRemovingStage - Filtered some items in StripsDuplicateItemsFilter. Reason: Items are duplicate in page; Items Count:[10]; Filtered Items:[641236575 , 250303495 , 212800846 , 697671901 , 234787566 , 74934 , 465277584 , 498538117 , 34189 , 186276466]','After StripItemsRemovingStage - Strip has 10 items: [338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','Items before StripItemsSorter - Strip has 10 items: [338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','Items After StripItemsSorter - Strip has 10 items: [398487607, 689748945, 499381383, 346734043, 25410053, 526808854, 288402552, 338180640, 234787595, 221850792]','Before StripsSortingStage - Strip order is: 8','After StripsSortingStage - Strip order is: 7']},'5385':{'Id':5385,'Title':'Travel products the community loves','Order':6,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 20 items: [641236575, 250303495, 212800846, 697671901, 234787566, 74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','Before StripItemsRemovingStage - Strip has 20 items: [641236575, 250303495, 212800846, 697671901, 234787566, 74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','During StripItemsRemovingStage - Filtered some items in StripsDuplicateItemsFilter. Reason: Items are duplicate in page; Items Count:[5]; Filtered Items:[641236575 , 250303495 , 212800846 , 697671901 , 234787566]','After StripItemsRemovingStage - Strip has 15 items: [74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','Items before StripItemsSorter - Strip has 15 items: [74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','Items After StripItemsSorter - Strip has 15 items: [338180640, 234787595, 465277584, 498538117, 186276466, 398487607, 689748945, 499381383, 346734043, 25410053, 526808854, 288402552, 34189, 221850792, 74934]','Before StripsSortingStage - Strip order is: 7','After StripsSortingStage - Strip order is: 6']},'5387':{'Id':5387,'Title':'Redeemable travel products','Order':2,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 20 items: [641236575, 250303495, 212800846, 697671901, 234787566, 74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','Before StripItemsRemovingStage - Strip has 20 items: [641236575, 250303495, 212800846, 697671901, 234787566, 74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','After StripItemsRemovingStage - Strip has 20 items: [641236575, 250303495, 212800846, 697671901, 234787566, 74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','Items before StripItemsSorter - Strip has 20 items: [641236575, 250303495, 212800846, 697671901, 234787566, 74934, 465277584, 498538117, 34189, 186276466, 338180640, 398487607, 221850792, 689748945, 288402552, 499381383, 234787595, 346734043, 526808854, 25410053]','Items After StripItemsSorter - Strip has 20 items: [34189, 221850792, 250303495, 234787566, 74934, 338180640, 234787595, 212800846, 697671901, 465277584, 498538117, 186276466, 398487607, 689748945, 499381383, 346734043, 25410053, 526808854, 288402552, 641236575]','Before StripsSortingStage - Strip order is: 2','After StripsSortingStage - Strip order is: 2']},'5491':{'Id':5491,'Title':'web Travel Tag online stores','Order':4,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','Before StripItemsRemovingStage - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','After StripItemsRemovingStage - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','Items before StripItemsSorter - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','Items After StripItemsSorter - Strip has 1 items: [12bd9072-a4dd-449f-9fdc-0d7921a4ed9e]','Before StripsSortingStage - Strip order is: 5','After StripsSortingStage - Strip order is: 4']},'5553':{'Id':5553,'Title':'web Uber travel acquistion perm','Order':11,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 1 items: [0c9f48dd-6e83-415c-b5cb-1d1f0f346085]','Before StripItemsRemovingStage - Strip has 1 items: [0c9f48dd-6e83-415c-b5cb-1d1f0f346085]','After StripItemsRemovingStage - Strip has 1 items: [0c9f48dd-6e83-415c-b5cb-1d1f0f346085]','Items before StripItemsSorter - Strip has 1 items: [0c9f48dd-6e83-415c-b5cb-1d1f0f346085]','Items After StripItemsSorter - Strip has 1 items: [0c9f48dd-6e83-415c-b5cb-1d1f0f346085]','Before StripsSortingStage - Strip order is: 12','After StripsSortingStage - Strip order is: 11']},'5565':{'Id':5565,'Title':'web Uber Pec post travel acq perm','Order':null,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip was filtered in StripsTargetingSegmentsFilter - Did not match the targeting segments']},'5663':{'Id':5663,'Title':'RelatedVideos','Order':8,'StripBoostingScores':{},'LogMessages':['StripsFromConfigurationProvider - Strip is part of main configuration','StripsFilteringStage - Strip passed all filters','MergeConfigurations - Strip was merged into main configuration','StripsBuildStage - Strip was built successfully','StripsBuildStage - Strip has 5 items: [717fdfce-d40e-447b-bbfe-b1321be34946, e1143e5e-4eea-46cb-a12f-b32e831d043d, 12c86fe4-30e8-4b10-9ccd-95cab9db0869, ec89c7d5-f801-46fe-a50c-879bfc9414fc, 6974d227-ed91-4ed6-a647-323c826b5dbd]','Before StripItemsRemovingStage - Strip has 5 items: [717fdfce-d40e-447b-bbfe-b1321be34946, e1143e5e-4eea-46cb-a12f-b32e831d043d, 12c86fe4-30e8-4b10-9ccd-95cab9db0869, ec89c7d5-f801-46fe-a50c-879bfc9414fc, 6974d227-ed91-4ed6-a647-323c826b5dbd]','After StripItemsRemovingStage - Strip has 5 items: [717fdfce-d40e-447b-bbfe-b1321be34946, e1143e5e-4eea-46cb-a12f-b32e831d043d, 12c86fe4-30e8-4b10-9ccd-95cab9db0869, ec89c7d5-f801-46fe-a50c-879bfc9414fc, 6974d227-ed91-4ed6-a647-323c826b5dbd]','Items before StripItemsSorter - Strip has 5 items: [717fdfce-d40e-447b-bbfe-b1321be34946, e1143e5e-4eea-46cb-a12f-b32e831d043d, 12c86fe4-30e8-4b10-9ccd-95cab9db0869, ec89c7d5-f801-46fe-a50c-879bfc9414fc, 6974d227-ed91-4ed6-a647-323c826b5dbd]','Items After StripItemsSorter - Strip has 5 items: [717fdfce-d40e-447b-bbfe-b1321be34946, e1143e5e-4eea-46cb-a12f-b32e831d043d, 12c86fe4-30e8-4b10-9ccd-95cab9db0869, ec89c7d5-f801-46fe-a50c-879bfc9414fc, 6974d227-ed91-4ed6-a647-323c826b5dbd]','Before StripsSortingStage - Strip order is: 9','After StripsSortingStage - Strip order is: 8']}}";

        var journeyObject = JObject.Parse(journeyJson);

        var databox14Query = new System.Text.StringBuilder("SELECT * FROM structured_homepage_configuration WHERE 1=1 ");       

        foreach(var strip in journeyObject.Properties())

        {

            databox14Query.Append("AND stripslist LIKE '%\"Id\":" + strip.Name + ",%' ");

        }       

        Console.WriteLine(databox14Query.ToString());

    }

}