SELECT   a.[field_name]  AS COL1,
         a.[module_name] AS COL2,
         a.[type_name]   AS COL3,
         a.[TABLE_NAME]  AS COL4
FROM     [sf_meta_data_mapping] a
WHERE    (
                  a.[type_name] IN (@p0,
                                    @p1))
ORDER BY col1,
         col2,
         col3SELECT   a.[field_name]  AS COL1,
         a.[module_name] AS COL2,
         a.[type_name]   AS COL3,
         a.[TABLE_NAME]  AS COL4
FROM     [sf_meta_data_mapping] a
WHERE    (
                  a.[type_name] IN (@p0,
                                    @p1))
ORDER BY col1,
         col2,
         col3SELECT   a.[field_name]  AS col1,
         a.[module_name] AS col2,
         a.[type_name]   AS col3,
         a.[TABLE_NAME]  AS col4
FROM     [sf_meta_data_mapping] a
WHERE    (
                  a.[type_name] IN (@p0,
                                    @p1))
ORDER BY col1,
         col2,
         col3 beginCOMMITSELECT COUNT(1) AS EXPR1
FROM   [sf_libraries] a
WHERE  a.[app_name] = @p0
AND    a.[voa_class] = 447337637SELECT    TOP(@__TAKE) a.[content_id]      AS COL1,
          a.[voa_class]                    AS COL2,
          a.[test_bool]                    AS COL3,
          a.[test_choice]                  AS COL4,
          a.[test_date_time]               AS COL5,
          a.[test_decimal]                 AS COL6,
          a.[test_guid]                    AS COL7,
          a.[test_long_text_field_name]    AS COL8,
          b.[testlongtextfieldname_en]     AS COL9,
          c.[testlongtextfieldname_en_us]  AS COL10,
          a.[test_short_text_field_name]   AS COL11,
          b.[testshorttextfieldname_en]    AS COL12,
          c.[testshorttextfieldname_en_us] AS COL13,
          a.[test_string]                  AS COL14,
          a.[new_size]                     AS COL15,
          a.[resize_on_upload]             AS COL16,
          a.[description_]                 AS COL17,
          a.[title_]                       AS COL18,
          a.[title_aa]                     AS COL19,
          a.[title_ar_ma]                  AS COL20,
          a.[title_bg_bg]                  AS COL21,
          a.[title_de_de]                  AS COL22,
          a.[title_en]                     AS COL23,
          a.[title_en_us]                  AS COL24,
          a.[title_fr_fr]                  AS COL25,
          a.[title_sr_cyrl_ba]             AS COL26,
          a.[title_tr_tr]                  AS COL27,
          a.[url_name_]                    AS COL28,
          a.[allow_comments]               AS COL29,
          a.[allow_track_backs]            AS COL30,
          a.[app_name]                     AS COL31,
          a.[approve_comments]             AS COL32,
          a.[content_state]                AS COL33,
          a.[date_created]                 AS COL34,
          a.[default_page_id]              AS COL35,
          a.[draft_culture]                AS COL36,
          a.[email_author]                 AS COL37,
          a.[expiration_date]              AS COL38,
          a.[include_in_sitemap]           AS COL39,
          a.[last_modified]                AS COL40,
          a.[last_modified_by]             AS COL41,
          a.[original_content_id]          AS COL42,
          a.[ownr]                         AS COL43,
          a.[post_rights]                  AS COL44,
          a.[publication_date]             AS COL45,
          a.[source_key]                   AS COL46,
          a.[STATUS]                       AS COL47,
          a.[vrsion]                       AS COL48,
          a.[views_count]                  AS COL49,
          a.[visible]                      AS COL50,
          a.[votes_count]                  AS COL51,
          a.[votes_sum]                    AS COL52,
          b.[description_en]               AS COL53,
          c.[description_en_us]            AS COL54,
          a.[item_default_url_]            AS COL55,
          b.[itemdefaulturl_en]            AS COL56,
          c.[itemdefaulturl_en_us]         AS COL57,
          b.[urlname_en]                   AS COL58,
          c.[urlname_en_us]                AS COL59,
          a.[blob_storage]                 AS COL60,
          a.[cache_profile]                AS COL61,
          a.[can_inherit_permissions]      AS COL62,
          a.[client_cache_profile]         AS COL63,
          a.[cover_id]                     AS COL64,
          a.[security_provider]            AS COL65,
          a.[inherits_permissions]         AS COL66,
          a.[is_deleted]                   AS COL67,
          a.[max_item_size]                AS COL68,
          a.[max_size]                     AS COL69,
          a.[tmb_regen]                    AS COL70,
          a.[running_task]                 AS COL71
FROM      [sf_libraries] a
LEFT JOIN [sf_libraries_en] AS b
ON        (
                    a.[content_id] = b.[content_id])
LEFT JOIN [sf_libraries_en_us] AS c
ON        (
                    a.[content_id] = c.[content_id])
WHERE     a.[app_name] = @p0
AND       a.[voa_class] = 447337637SELECT    a.[content_id]                  AS COL1,
          a.[content_id]                  AS COL2,
          a.[voa_class]                   AS COL3,
          a.[alternative_text_]           AS COL4,
          b.[alternativetext_en]          AS COL5,
          c.[alternativetext_en_us]       AS COL6,
          a.[description_]                AS COL7,
          a.[title_]                      AS COL8,
          a.[title_aa]                    AS COL9,
          a.[title_ar_ma]                 AS COL10,
          a.[title_bg_bg]                 AS COL11,
          a.[title_de_de]                 AS COL12,
          a.[title_en]                    AS COL13,
          a.[title_en_us]                 AS COL14,
          a.[title_fr_fr]                 AS COL15,
          a.[title_sr_cyrl_ba]            AS COL16,
          a.[title_tr_tr]                 AS COL17,
          a.[url_name_]                   AS COL18,
          a.[allow_comments]              AS COL19,
          a.[allow_track_backs]           AS COL20,
          a.[app_name]                    AS COL21,
          a.[approve_comments]            AS COL22,
          a.[content_state]               AS COL23,
          a.[date_created]                AS COL24,
          a.[default_page_id]             AS COL25,
          a.[draft_culture]               AS COL26,
          a.[email_author]                AS COL27,
          a.[expiration_date]             AS COL28,
          a.[include_in_sitemap]          AS COL29,
          a.[last_modified]               AS COL30,
          a.[last_modified_by]            AS COL31,
          a.[original_content_id]         AS COL32,
          a.[ownr]                        AS COL33,
          a.[post_rights]                 AS COL34,
          a.[publication_date]            AS COL35,
          a.[source_key]                  AS COL36,
          a.[STATUS]                      AS COL37,
          a.[vrsion]                      AS COL38,
          a.[views_count]                 AS COL39,
          a.[visible]                     AS COL40,
          a.[votes_count]                 AS COL41,
          a.[votes_sum]                   AS COL42,
          a.[approval_workflow_state_]    AS COL43,
          b.[approvalworkflowstate_en]    AS COL44,
          c.[approvalworkflowstate_en_us] AS COL45,
          a.[author_]                     AS COL46,
          b.[author_en]                   AS COL47,
          c.[author_en_us]                AS COL48,
          b.[description_en]              AS COL49,
          c.[description_en_us]           AS COL50,
          a.[item_default_url_]           AS COL51,
          b.[itemdefaulturl_en]           AS COL52,
          c.[itemdefaulturl_en_us]        AS COL53,
          a.[media_file_url_name_]        AS COL54,
          b.[mediafileurlname_en]         AS COL55,
          c.[mediafileurlname_en_us]      AS COL56,
          b.[urlname_en]                  AS COL57,
          c.[urlname_en_us]               AS COL58,
          a.[blob_storage]                AS COL59,
          a.[can_inherit_permissions]     AS COL60,
          a.[folder_id]                   AS COL61,
          a.[inherits_permissions]        AS COL62,
          a.[tmb_regen]                   AS COL63,
          a.[ordinal]                     AS COL64,
          a.[parent_id]                   AS COL65,
          a.[parent_id]                   AS COL66,
          a.[tmb_vrsn]                    AS COL67,
          a.[uploaded]                    AS COL68,
          a.[lgcy_tmb_strg]               AS COL69,
          a.[was_published]               AS COL70,
          a.[voa_version]                 AS COL71,
          d.[id]                          AS COL72,
          d.[app_name]                    AS COL73,
          d.[content_id]                  AS COL74,
          d.[chunk_size]                  AS COL75,
          d.[culture]                     AS COL76,
          d.[default_url]                 AS COL77,
          d.[extension]                   AS COL78,
          d.[file_id]                     AS COL79,
          d.[file_path]                   AS COL80,
          d.[height]                      AS COL81,
          d.[content_id]                  AS COL82,
          d.[mime_type]                   AS COL83,
          d.[number_of_chunks]            AS COL84,
          d.[total_size]                  AS COL85,
          d.[width]                       AS COL86
FROM      [sf_media_content] a
LEFT JOIN [sf_media_content_en] AS b
ON        (
                    a.[content_id] = b.[content_id])
LEFT JOIN [sf_media_content_en_us] AS c
ON        (
                    a.[content_id] = c.[content_id])
LEFT JOIN [sf_media_file_links] AS d
ON        (
                    a.[content_id] = d.[content_id])
WHERE     a.[app_name] = @p0
AND       a.[STATUS] = @p1
AND       (((
                                        a.[folder_id] IN (@p2,
                                                          @p3,
                                                          @p4,
                                                          @p5,
                                                          @p6,
                                                          @p7))
                    OR        (
                                        a.[parent_id] IN (@p8,
                                                          @p9,
                                                          @p10,
                                                          @p11,
                                                          @p12,
                                                          @p13))))
AND       a.[voa_class] = 1053642113
ORDER BY  col24 DESC,
          col1,
          col74SELECT    a.[id]                           AS COL1,
          a.[last_modified]                AS COL2,
          a.[description_]                 AS COL3,
          b.[description_en]               AS COL4,
          c.[description_en_us]            AS COL5,
          a.[test_bool]                    AS COL6,
          a.[test_choice]                  AS COL7,
          a.[test_date_time]               AS COL8,
          a.[test_decimal]                 AS COL9,
          a.[test_guid]                    AS COL10,
          a.[test_long_text_field_name]    AS COL11,
          b.[testlongtextfieldname_en]     AS COL12,
          c.[testlongtextfieldname_en_us]  AS COL13,
          a.[test_short_text_field_name]   AS COL14,
          b.[testshorttextfieldname_en]    AS COL15,
          c.[testshorttextfieldname_en_us] AS COL16,
          a.[test_string]                  AS COL17,
          a.[title_]                       AS COL18,
          a.[title_aa]                     AS COL19,
          a.[title_ar_ma]                  AS COL20,
          a.[title_bg_bg]                  AS COL21,
          a.[title_de_de]                  AS COL22,
          a.[title_en]                     AS COL23,
          a.[title_en_us]                  AS COL24,
          a.[title_fr_fr]                  AS COL25,
          a.[title_sr_cyrl_ba]             AS COL26,
          a.[title_tr_tr]                  AS COL27,
          a.[url_name_]                    AS COL28,
          b.[urlname_en]                   AS COL29,
          c.[urlname_en_us]                AS COL30,
          a.[app_name]                     AS COL31,
          a.[cover_id]                     AS COL32,
          a.[is_deleted]                   AS COL33,
          a.[parent_id]                    AS COL34,
          a.[parent_id]                    AS COL35,
          a.[path]                         AS COL36,
          a.[root_id]                      AS COL37,
          a.[voa_version]                  AS COL38, (
          CASE
                    WHEN a.[title_en_us] IS NULL THEN a.[title_]
                    ELSE a.[title_en_us]
          END) AS xj1
FROM      [sf_folders] a
LEFT JOIN [sf_folders_en] AS b
ON        (
                    a.[id] = b.[id])
LEFT JOIN [sf_folders_en_us] AS c
ON        (
                    a.[id] = c.[id])
WHERE     a.[app_name] = @p0
AND       (
                    a.[root_id] IN (@p1,
                                    @p2,
                                    @p3,
                                    @p4,
                                    @p5,
                                    @p6))
AND       a.[parent_id] IS NULL
ORDER BY  xj1,
          col1