SELECT SHP_SYS_ID, PATH_1, SHP_LINK_URL, LINK_URL, PARENT_ID FROM ( SELECT SHP_SYS_ID, '::Blog' || SYS_CONNECT_BY_PATH(SHP_DESC, '::') AS PATH_1, -- Capture full hierarchy '::Blog' || SYS_CONNECT_BY_PATH(SHP_LINK_URL, '::') AS LINK_URL, SHP_LINK_URL, SHP_SHP_SYS_ID PARENT_ID, SHP_PAGE_NAME FROM SITE_M_HOME_PAGE START WITH SHP_SHP_SYS_ID = 453842 AND SHP_ST_SYS_ID = '100001' AND SHP_LANG_CODE = 'en' AND NVL (SHP_APPLICABLE_COUNTRIES, 'AE') LIKE '%' ||'BH'|| '%' CONNECT BY PRIOR SHP_SYS_ID = SHP_SHP_SYS_ID AND SHP_ST_SYS_ID = '100001' AND SHP_LANG_CODE = 'en' AND NVL (SHP_APPLICABLE_COUNTRIES, 'AE') LIKE '%' ||'BH'|| '%' ORDER BY SHP_SYS_ID) WHERE (UPPER(SHP_PAGE_NAME) ='LIVING' OR UPPER(SHP_LINK_URL) = 'LIVING') AND ROWNUM = 1{ "return_status": 0, "error_message": "Success", "result": { "COMPONENT": [ { "PARENT": { "component_title": "Blog", "component_url": "Component/Blog/index", "title": "Living", "description": "", "image_path": null, "image_path_01": null, "image_path_02": null, "image_path_03": null, "image_path_portrait": null, "image_path_landscape": null, "timer": "0", "autoplay": "N", "link_title": null, "link_url": "living", "class_name": null, "image_alt_seo": null, "country_iso": "BHR", "cn_iso": "BH", "detect_country": "bhr", "applicable_countries": "AE,BH,XX,SA,OM,QA,KW,EG", "CHILD": [ { "title": "A small living", "description": "

How to build a happy home

Sunt ex ea anim fugiat quis proident qui est elit. Adipisicing est anim amet laboris sunt nulla voluptate. Qui veniam exercitation in mollit ullamco minim reprehenderit ullamco. Nisi quis fugiat velit proident dolore. Culpa exercitation commodo aute incididunt enim nostrud do dolor. Veniam nulla laboris reprehenderit exercitation et proident. Velit aliquip fugiat ex aliquip ex officia consectetur do ad. Exercitation ea sint sunt in fugiat laborum. Dolor sunt nulla veniam nulla. Mollit est consectetur labore duis nostrud velit. Nisi ad incididunt irure tempor sint cillum nostrud. Consequat officia laborum laborum aute nulla proident. Anim eu pariatur eiusmod in.

Sunt ex ea anim fugiat quis proident qui est elit. Adipisicing est anim amet laboris sunt nulla voluptate. Qui veniam exercitation in mollit ullamco minim reprehenderit ullamco. Nisi quis fugiat velit proident dolore. Culpa exercitation commodo aute incididunt enim nostrud do dolor. Veniam nulla laboris reprehenderit exercitation et proident. Velit aliquip fugiat ex aliquip ex officia consectetur do ad. Exercitation ea sint sunt in fugiat laborum. Dolor sunt nulla veniam nulla. Mollit est consectetur labore duis nostrud velit. Nisi ad incididunt irure tempor sint cillum nostrud. Consequat officia laborum laborum aute nulla proident. Anim eu pariatur eiusmod in.

", "image_path": "https://uatapi.sedarglobal.com/uploads/100001/content/blog/1720599202_318fa9f142c9240bb37c.png", "image_path_01": "https://uatapi.sedarglobal.com/uploads/100001/content/blog/big_desktop/1720599202_318fa9f142c9240bb37c.png", "image_path_02": "https://uatapi.sedarglobal.com/uploads/100001/content/blog/desktop/1720599202_318fa9f142c9240bb37c.png", "image_path_03": "https://uatapi.sedarglobal.com/uploads/100001/content/blog/laptop/1720599202_318fa9f142c9240bb37c.png", "image_path_portrait": null, "image_path_landscape": null, "timer": "0", "autoplay": "N", "link_title": null, "link_url": "a-small-living", "class_name": null, "image_alt_seo": null, "country_iso": "BHR", "cn_iso": "BH", "detect_country": "bhr", "applicable_countries": "AE,BH,XX,SA,OM,QA,KW,EG", "MATERIAL_LIST": [], "page_name": "blog", "category_id": null, "pr_item_code": null, "pro_id": "", "SHP_SYS_ID": "453846" }, { "title": "A small living space with a balance of class and comfort", "description": "

Incididunt reprehenderit eiusmod deserunt aute reprehenderit culpa. Adipisicing fugiat dolore nulla do esse aute. Ex proident dolore sunt sint nisi labore. Fugiat nostrud veniam ut ut ipsum proident pariatur voluptate velit. Enim nisi deserunt occaecat adipisicing. Ea dolore mollit fugiat sit aliquip occaecat.

Aliquip incididunt anim exercitation nostrud excepteur quis. Laboris commodo esse commodo laboris duis. Et sint esse tempor sunt minim exercitation tempor. Lorem labore in id mollit est. Mollit aute tempor voluptate labore. Magna occaecat culpa enim velit qui duis enim reprehenderit exercitation. Lorem in est voluptate duis sint magna voluptate ut. Ut in et exercitation elit quis. Magna nisi deserunt elit esse ut magna sint anim tempor. In fugiat mollit magna laborum nostrud veniam. Cupidatat proident magna ipsum culpa qui.

Cillum commodo et sint cupidatat veniam cillum ullamco. Consequat commodo ut occaecat excepteur voluptate est deserunt. Proident aute ullamco aute magna. Dolor amet aliquip tempor exercitation ea do laboris sit. Dolore esse ex sunt labore voluptate officia adipisicing. In proident ea cillum elit nostrud. In fugiat cillum labore velit ut magna incididunt fugiat. Minim sint proident tempor labore exercitation tempor est incididunt. Ullamco ut duis dolor nostrud eu. Elit ipsum ad sit qui.

Officia aliquip veniam enim Lorem culpa culpa aliquip ad magna. Ullamco est do ad do aute veniam sunt. Cupidatat amet qui excepteur reprehenderit. Sunt eu duis anim tempor ea. Incididunt ea nostrud ullamco eu. Quis veniam quis eu sint labore incididunt Lorem nisi. Non culpa velit culpa est.

", "image_path": "https://uatapi.sedarglobal.com/uploads/100001/content/blog/1720522454_08a8aef39c2b44134356.png", "image_path_01": "https://uatapi.sedarglobal.com/uploads/100001/content/blog/big_desktop/1720522454_08a8aef39c2b44134356.png", "image_path_02": "https://uatapi.sedarglobal.com/uploads/100001/content/blog/desktop/1720522454_08a8aef39c2b44134356.png", "image_path_03": "https://uatapi.sedarglobal.com/uploads/100001/content/blog/laptop/1720522454_08a8aef39c2b44134356.png", "image_path_portrait": null, "image_path_landscape": null, "timer": "0", "autoplay": "N", "link_title": null, "link_url": "a-small-living-space-with-a-balance-of-class-and-comfort", "class_name": null, "image_alt_seo": null, "country_iso": "BHR", "cn_iso": "BH", "detect_country": "bhr", "applicable_countries": "AE,BH,XX,SA,OM,QA,KW,EG", "MATERIAL_LIST": [], "page_name": "blog", "category_id": null, "pr_item_code": null, "pro_id": "", "SHP_SYS_ID": "453844" } ] } } ], "BREADCRUMB": { "Blog": "bhr-en/blog", "Living": "bhr-en/blog/living" } } }