Free Course Catalog

SELECT DISTINCT ACA.int_actor_type_id
			FROM tbl_access_control_rules ACR
			INNER JOIN tbl_access_control_allow ACA ON ACR.int_access_rule_id = ACA.int_access_rule_id
			WHERE
				
					str_fuse_action LIKE ? 
				AND ISNULL(ACA.int_actor_type_id,'')<>''
				AND ACA.bit_allow = 1

SET NOCOUNT ON

	DECLARE @UsesRefundRequest CHAR(1)

	SET @UsesRefundRequest = 0
	SET @UsesRefundRequest = (
			SELECT 1
			FROM RefundPaymentMethods
			WHERE RefundPaymentMethodID = 7
				AND STATUS = 'A'
			)

	SELECT TOP 1 rg.RegionID
		, rg.NAME
		, rg.Address1
		, rg.Address2
		, rtrim(rg.City) + ', ' + rg.STATE + '  ' + rg.Zip AS CSZ
		, rg.Phone1
		, rg.SiteTitle
		, rg.Footer
		/**/
		, rg.prefooter
		, rg.brandingfooter
		/**/
		, rg.MetaText
		, rg.EmailAux4
		, IsNull((
				SELECT Fee
				FROM Products
				WHERE Code = 'REGFEE'
					AND STATUS = 'A'
					AND RegionID = rg.RegionID
				), 0.00) AS RegistrationFee
		, IsNull((
				SELECT Fee
				FROM Products
				WHERE Code = 'DEFERRED_PAYMENT_FEE'
					AND STATUS = 'A'
					AND RegionID = rg.RegionID
				), 0.00) AS deferred_payment_fee
		, fc.*
		, @UsesRefundRequest AS UsesRefundRequest
		, rg.privacy_data_mask_id
		, rg.str_google_verify
		, rg.str_yahoo_verify
		, rg.str_hubspot_portal_id
		, rg.str_hubspot_salog_version
		, rg.str_hubspot_ppa
		, rg.str_genoo_api_key
		, rg.str_genoo_tracking_code
		, rg.TimeZoneHourAdjustment
		/**/
		/**/
		/**/
		, e.str_erp_name
		/**/
		/**/
		, CAST(DecryptByKeyAutoCert(cert_id('LumensCert'), NULL, ec.varbin_erp_password) AS NVARCHAR(500)) AS str_erp_password_decrypted
		/**/
		/**/
		, rg.theURL
		, rg.URLText
		, rg.str_analytics_linked_domains
		, rg.GTMContainerID
		, rg.str_social_media_sharing
		, ec.*
		, (
			SELECT TOP 1 Description
			FROM PaymentMethods
			WHERE PaymentMethodID >= 200
				AND STATUS = 'A'
		) AS str_internal_payment_method_name
	FROM FeatureConfiguration fc
	INNER JOIN Regions rg ON fc.RegionID = rg.RegionID
	LEFT JOIN tbl_erp e ON fc.int_erp_id = e.int_erp_id
	LEFT JOIN tbl_erp_config ec ON ec.str_erp_url <> ''
	WHERE rg.STATUS = 'A'

SELECT regionId,orgID
				FROM featureConfigurationQry
				WHERE baseurl LIKE '%v8template2.augusoft.net%'

SET NOCOUNT ON

			SELECT OrgID
				, RegionID
				, MenuItemID
				, MenuItemType
				, MainLevel
				, SubLevel
				
				,MainLevelSortOrder
				, SubLevelSortOrder
				, 
					SiteURL
				
				, AccessLevel
				, IsNull(DisplayCriteria_1, '') AS DisplayCriteria_1
				
				, IsNull(DisplayValue_1, '') AS DisplayValue_1
				, IsNull(DisplayCriteria_2, '') AS DisplayCriteria_2
				, IsNull(DisplayValue_2, '') AS DisplayValue_2
				, Condition
				, LTRIM(RTRIM(IsNull(NewWindowName, ''))) AS NewWindowName
				, m.Label AS UniqueLable
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"'), 'Member', 'Member')
										/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Donate')
										/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE Replace(Replace(Replace(m.Label, '\', '\\'), '''', '\'''), '"', '\"')
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN (str_user_nav_label)
							ELSE str_user_nav_label
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS Label
				
				, CASE
					WHEN str_user_nav_label IS NULL
						THEN CASE
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9440'
									THEN Replace(m.Label, 'Membership', 'Membership')
								WHEN MenuItemType != 'Lnk'
									AND SiteURL = 'index.cfm?fuseaction=9620'
									THEN Replace(m.Label, 'Member', 'Member')
									/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'Donate'
									THEN Replace(m.Label, 'Donate', 'Donate')
									/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
								WHEN m.Label LIKE 'MERCHANDISE'
									THEN Replace(m.Label, 'MERCHANDISE', 'Merchandise')
								WHEN m.UniqueLabel = 'registration/scholarships' OR m.UniqueLabel = 'myscholarships'
									THEN Replace(m.Label, 'Scholarships', 'Scholarship')
								ELSE m.Label
								END
					ELSE
						/*BEGIN NEO 00106  20 FEB 2015 Student Donations UC-02 */
						CASE
							WHEN str_menu_label LIKE 'Donate'
								THEN dbo.fun_strip_html((str_user_nav_label))
							ELSE dbo.fun_strip_html(str_user_nav_label)
							END
						/*END NEO 00106  20 FEB 2015 Student Donations UC-02 */
					END AS LabelNoHTML 
				
				, ISNULL(int_parent_id,0) as int_parent_id
				, int_sort_order
				, m.UniqueLabel
				, m.bit_default_behavior
			FROM MenuItems m
			LEFT JOIN tbl_user_nav_menu_label u ON m.MenuItemID = u.int_menu_item_id
			WHERE STATUS = 'A'
				AND SubCategoryID IS NULL
				AND (
					
						int_actor_type_id = ?
						OR
						(
							int_actor_type_id IS NULL
							AND AccessLevel = ?
						)
					
				)
				
				AND ISNULL(SiteURL, '') NOT LIKE 'index.cfm?fuseaction=1010' /*29 MAY 2012 NEO 00043 TRACKER 29863*/
				
			ORDER BY int_sort_order

SET ANSI_NULLS ON

		SELECT IsNull((
					CASE
						WHEN str_dashboard_name = ''
							THEN NULL
						ELSE str_dashboard_name
						END
					), CASE
					WHEN ActorTypeID = 55
						THEN 'Dashboard'
					ELSE 'my dashboard'
					END) AS str_dashboard_name /* 02 APRIL 2014 NEO 0088 TRACKER 40005 */
		FROM ActorTypes
		WHERE ActorTypeID = ?

SELECT pfo.int_order
				, pf.str_field_display_name
				, pf.str_field_name
				, pfo.int_profile_field_tab_id
				, pf.str_actor_types
				, pf.chr_field_type
			FROM tbl_profile_field_order pfo
			INNER JOIN tbl_profile_field pf ON pfo.int_profile_field_id = pf.int_profile_field_id
			WHERE pf.int_region_id = ?
				AND bit_enabled = ?
				AND
				(
					(
						pf.chr_field_type not in ('C','O')
					)
					
						OR
						(
							pf.chr_field_type in ('C','O') AND
							(
								pf.str_actor_types LIKE ? 
							)
						)
					
				)
			ORDER BY pfo.int_profile_field_tab_id
				, pfo.int_order ASC

select * from tbl_social_media_details WHERE int_region_id = ?
			order by int_order asc

select * from UIVariables where RegionID = ?

SELECT menitms.SiteURL AS nav_site_url
			, menitms.label AS nav_label
			, menitms.rowNum
			, COUNT(menitms.rowNum) OVER () AS Total_Rows
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel 
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_nav=1
				AND STATUS = ?
				
	) menitms

SELECT menitms.SiteURL
			, menitms.label
			, menitms.AccessLevel
			, menitms.rowNum
			, ((rowNum - 1) / 4) + 1 AS block
			, menitms.DisplayCriteria_1
			, menitms.DisplayValue_1
			, menitms.DisplayCriteria_2
			, menitms.DisplayValue_2
			, menitms.Condition
			, menitms.NewWindowName
		FROM (
			SELECT SiteURL
				, label
				, AccessLevel
				, DisplayCriteria_1
				, DisplayValue_1
				, DisplayCriteria_2
				, DisplayValue_2
				, Condition
				, Row_Number() OVER (
					ORDER BY MenuitemID ASC
					) AS rowNum
				, NewWindowName
			FROM MenuItems
			WHERE AccessLevel
			
			
					= ? 
			
				AND RegionID = ?
			AND bit_display_in_footer=1
				AND STATUS = ?
				
	) menitms

UPDATE tbl_cart_class_detail
			SET EnteredDate = dbo.fun_GetDateCT()
			WHERE SessionID = ?;
			DELETE
			FROM tbl_cart_class_detail
			WHERE DATEDIFF(minute,EnteredDate,dbo.fun_GetDateCT()) >= 61;
			UPDATE tbl_cart_merchandise_detail
			SET EnteredDate = dbo.fun_GetDateCT()
			WHERE SessionID = ?;
			DELETE FROM tbl_cart_merchandise_detail
			WHERE DATEDIFF(minute,EnteredDate,dbo.fun_GetDateCT()) >= 61;

SELECT str_header_script
				, str_footer_script
			FROM tbl_style_settings WITH (NOLOCK)
			-- WHERE int_region_id = Commented as long as multiple regions are not there

select * from qTempMenu where MenuItemID NOT IN  (562,2,633)

SELECT isNull(str_user_nav_label,'') AS str_menu_label
		FROM tbl_user_nav_menu_label
		WHERE int_actor_type_id = ?
		AND str_menu_label LIKE 'DONATE'
		AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';

select * from qMenu where int_parent_id = 532

select * from qMenu where int_parent_id = 538

select * from qMenu where int_parent_id = 539

select * from qMenu where int_parent_id = 540

select * from qMenu where int_parent_id = 5

select * from qMenu where int_parent_id = 6

select * from qMenu where int_parent_id = 7

select * from qMenu where int_parent_id = 458

select * from qMenu where int_parent_id = 500

select * from qMenu where int_parent_id = 532

select * from qMenu where int_parent_id = 538

select * from qMenu where int_parent_id = 539

select * from qMenu where int_parent_id = 540

select * from qMenu where int_parent_id = 5

select * from qMenu where int_parent_id = 6

select * from qMenu where int_parent_id = 7

select * from qMenu where int_parent_id = 458

select * from qMenu where int_parent_id = 500

SELECT isNull(str_user_nav_label,'') AS str_menu_label
		FROM tbl_user_nav_menu_label
		WHERE int_actor_type_id = ?
		AND str_menu_label LIKE 'DONATE'
		AND str_display_condition='application.appvars[ri].bit_allow_student_donation EQ 1 AND application.appvars[ri].bit_display_donate_in_navmenu EQ 1';

SELECT OrgID, RegionID, CustomizationID, rtrim(ltrim(FuseAction)) as fuseAction, Status, 
	CASE Status When 'A' Then 'Active' When 'I' Then 'Inactive' END AS StatusDesc,
	CreateDate, CustomizationName, CustomizationDesc
	FROM Customizations c
	WHERE Status = 'A'
	AND RegionID = 1
	Order By Status, Fuseaction

SELECT int_country_id
		, str_country_code
		, str_country_name
	FROM tbl_country
	ORDER BY str_country_name

SELECT StateId
		, StateName
		, STATE
		, int_country_id
		
			, 'States' AS OptGroupLabel
		
	FROM States
	
		ORDER BY stateName

SET NOCOUNT ON

SELECT rg.ApplName
    , rg.NAME
    , rg.EMail
    , rg.EMailAux1
    , rg.EMailAux2
    , rg.EMailAux3
    , rg.EMailAux4
    , rg.EMailAux5
    , rg.EMailAux6
    , rg.theUrl
    , rg.BadWeatherText
    , rg.Phone1
    , rg.Phone1Ext
    , rg.Address1
    , rg.Address2
    , rtrim(rg.City) + ', ' + rg.STATE + '  ' + rg.Zip AS CSZ
    , rg.City
    , rg.STATE
    , rg.Zip
    , rg.ZipPlus4
    , rg.Footer
    , rg.SiteTitle
    , rtrim(rg.City) + ', ' + rg.STATE + ', ' + rg.Zip AS OrganizationCityStateZip
FROM Regions rg
WHERE rg.RegionID = ?
    AND rg.Status = 'A'

SET NOCOUNT ON

    SELECT rg.ApplName
        , rg.NAME AS OrganizationName
        , rg.EMail
        , rg.EMailAux1
        , rg.EMailAux2
        , rg.EMailAux3
        , rg.EMailAux4 AS Mailbox4
        , rg.EMailAux4 AS Mailbox5
        , rg.theUrl
        , rg.BadWeatherText
        , rg.Phone1 AS OrganizationPhone
        , rg.Phone1Ext
        , rg.Address1 AS OrganizationAddress
        , rg.Address2 AS OrganizationAddress2
        , rtrim(rg.City) + ', ' + rg.STATE + ', ' + rg.Zip AS OrganizationCityStateZip
        , rg.City
        , rg.State
        , rg.Zip
        , rg.ZipPlus4
        , rg.Footer
        , rg.SiteTitle
        -- Issue TT59300 OrganizationCity,OrganizationState,OrganizationZip
        , rg.City AS OrganizationCity
        , rg.State AS OrganizationState
        , rg.Zip AS OrganizationZip
    FROM Regions rg
    WHERE rg.RegionID = ?
        AND rg.Status = 'A'

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
	DECLARE @TimeZoneShift AS FLOAT;
	/**/
	SET @TimeZoneShift = IsNull((
				SELECT TimeZoneHourAdjustment
				FROM Regions
				WHERE RegionID = ?
				), 0)

	DROP TABLE IF EXISTS #altCatalogs

	SELECT COUNT(tbl_class_detail.int_class_id) as cnt,altCatalogs.value
	INTO #altCatalogs
	FROM tbl_class_detail
	CROSS APPLY STRING_SPLIT(tbl_class_detail.str_alt_catalog_ids, ',') altCatalogs
	WHERE NULLIF(TRIM(tbl_class_detail.str_alt_catalog_ids),'') IS NOT NULL
	GROUP BY altCatalogs.value
	
	SELECT Name
		, STATUS
		, CatalogID
		, SortOrder
		, CampusCode
		, county_id
		, dbo.fun_base_custom_field_stored_value(county_id, 'county_id', RegionID) AS county_id_description
		, AvailableForRequest
		, CASE 
			WHEN EXISTS (
					SELECT 'x'
					FROM Classes
					INNER JOIN tbl_class_listing tcl ON classes.classid = tcl.classid
					WHERE (
							Classes.STATUS = 'A'
							OR Classes.STATUS = 'C'
							) 
						
						AND DateAdd(hh, @TimeZoneShift, dbo.fun_GetDateCT()) BETWEEN Classes.AppearanceStartDate
							AND DateAdd(ms, - 10, Classes.AppearanceEndDate)
						AND tcl.bit_display_to_public = 1 
						
						AND (
							Classes.CatalogID = Catalogs.CatalogID
							OR (',' + RTRIM(tcl.str_alt_catalog_ids) + ',') LIKE '%,' + CAST(Catalogs.CatalogID AS VARCHAR) + ',%'
							)
					)
				THEN 1
			ELSE 0
			END AS ClassActive
		, CASE 
			WHEN (
					SELECT COUNT(ClassID)
					FROM Classes
					WHERE Classes.CatalogID = Catalogs.CatalogID
				) > 0
				THEN 1
			WHEN (
				SELECT cnt
				FROM #altCatalogs
				WHERE [value] = Catalogs.CatalogID
			) > 0
				THEN 1
			ELSE 0
			END AS EverHadClass
		, str_catalog_display_name
		, bit_hide_from_menu AS hide_from_menu
		, dbo.fun_strip_html(Name) AS NameNoHTML
	FROM Catalogs
	WHERE 1 = 1
		
			AND Status IN (?)
		
			 AND AvailableForRequest = ? 
	ORDER BY SortOrder
	SET TRANSACTION ISOLATION LEVEL READ COMMITTED

SELECT * FROM qCatalog WHERE EverHadClass = 1

SELECT PhoneTypeID, Name
	FROM PhoneTypes
	WHERE Status = 'A'
	Order By SortOrder, Name

SELECT *
			  FROM (SELECT field.base_field_id,
			  			   NULL AS REGEX_VALIDATE,
						   bt.table_name AS base_table,
						   bt.description As base_table_description,
						   bt.base_table_id,
						   bt.base_table_unique_key,
						   bt.str_default_criteria,
						   field.base_field,
						   field.description,
						   field.default_field_value_id,
						   field.label,
						   field.hint_text,
						   field.reporting_field_name,
						   IsNull(field.is_required,0) AS is_required,
						   field.form_field_type_id,
						   f.description AS form_field_type,
						   field.field_data_type_id,
						   dt.description AS field_data_type,
						   field.range,
						   field.max_length,
						   IsNull(field.use_privacy_mask,0) AS use_privacy_mask,
						   field.is_enabled,
						   CASE IsNull(value_def.field_value_description, '')
						   		WHEN '' THEN value.field_value_description
								ELSE value_def.field_value_description
						   END AS default_value,
						   CASE
						   		WHEN IsNull(customized_base_field_id, 0) > 0 THEN 1
								WHEN IsNull(custom_v.base_field_id, 0) > 0 THEN 1
								ELSE 0
						   END AS is_customized,
						   CASE IsNull(field.customized_base_field_id, 0)
						   		WHEN 0 THEN dbo.fun_field_actor_type_list(field.base_field_id, 'B')
								ELSE dbo.fun_field_actor_type_list(field.customized_base_field_id, 'B')
						   END AS access_list,
						   field.base_field as base_fld,
						   CASE IsNull(field.customized_base_field_id, 0)
						   		WHEN 0 THEN dbo.fun_field_location_list(field.base_field_id, 'B')
								ELSE dbo.fun_field_location_list(field.customized_base_field_id, 'B')
						   END AS location_list,
						   CASE Isnull(field.customized_base_field_id, 0)
						WHEN 0 THEN 0
						ELSE IsNull((SELECT top 1 show_on_youth_profile FROM field_Access WHERE field_id = field.customized_base_field_id AND actor_type_id = 50),0)
				   END as ShowOnYouthProfile,
				   field.bit_EncryptValue
					
				   ,CASE IsNull(value_def.str_erp_code, '')
				   		WHEN '' THEN value.str_erp_code
						ELSE value_def.str_erp_code
				   END AS str_erp_code
					
					
					,bit_use_in_slim_profile
					,bit_required_in_slim_profile
					,int_sort_order_in_slim_profile
					,IsNull(bit_collect_at_registration,0) AS bit_collect_at_registration
					
					  FROM base_field_customized field LEFT OUTER JOIN
					  	   (SELECT field_value_description, customized_field_value_id
							   ,str_erp_code 
						       FROM base_field_customized_value
							  WHERE region_id = ?) value_def ON value_def.customized_field_value_id = field.default_field_value_id LEFT OUTER JOIN
		                   (SELECT field_value_description, field_value_id
							   ,str_erp_code 
						      FROM base_field_customized_value) value ON value.field_value_id = field.default_field_value_id INNER JOIN
						   form_field_type f ON f.form_field_type_id = field.form_field_type_id INNER JOIN
						   base_field_table bt ON bt.base_table_id = field.base_table_id LEFT JOIN
						   form_field_data_type dt ON dt.field_data_type_id = field.field_data_type_id LEFT JOIN
		                   (SELECT DISTINCT base_field_id
		                      FROM base_field_customized_value
		                     WHERE region_id = ?) custom_v ON custom_v.base_field_id = field.base_field_id
					 WHERE (field.region_id = ?
					    OR (field.region_id IS NULL
							AND NOT EXISTS
		                          (SELECT 'Y'
		                             FROM base_field_customized
		                            WHERE region_id = ?
									  AND customized_base_field_id = field.base_field_id)))) f
			WHERE 0=0
				
			   AND f.base_table_description IN (?)
				
				AND f.is_enabled = ? 
				AND CHARINDEX(CAST(90 AS varchar(4)), access_list) > 0
				
					AND f.base_field <> 'str_salesforce_stage'
				

			 ORDER BY f.base_table, f.label

SELECT *
			  FROM (SELECT field.custom_field_id,
						   bt.table_name AS base_table,
						   bt.description As base_table_description,
						   bt.base_table_id,
						   bt.base_table_unique_key,
						   field.description,
						   field.default_field_value_id,
						   field.label,
						   field.hint_text,
						   IsNull(field.is_required,0) AS is_required,
						   field.form_field_type_id,
						   f.description AS form_field_type,
						   field.field_data_type_id,
						   dt.description AS field_data_type,
						   field.range,
						   field.max_length,
		                   IsNull(field.use_privacy_mask,0) AS use_privacy_mask,
						   IsNull(field.is_enabled, 0) AS is_enabled,
						   value.field_value_description AS default_value,
						   dbo.fun_field_actor_type_list(field.custom_field_id, 'C') AS access_list,
						   dbo.fun_field_location_list(field.custom_field_id, 'B') AS location_list,
						   CASE WHEN IsNull(field.use_privacy_mask,0) > 0 THEN
							   CASE field.form_field_type_id
						   			WHEN 5 THEN dbo.fun_privacy_data_mask(text_entry.text_entry,Rg.privacy_data_mask_id)
									WHEN 6 THEN dbo.fun_privacy_data_mask(text_entry.text_entry,Rg.privacy_data_mask_id)
									ELSE dbo.fun_privacy_data_mask(CAST(selected.field_value_id AS VARCHAR(10)),Rg.privacy_data_mask_id)
							   END
                            ELSE
                               CASE field.form_field_type_id
                                    WHEN 5 THEN text_entry.text_entry
                                    WHEN 6 THEN text_entry.text_entry
									WHEN 4 THEN text_entry.text_entry 
                                    ELSE CAST(selected.field_value_id AS VARCHAR(10))
                               END
                           END AS field_stored_value,
						   CASE WHEN IsNull(field.use_privacy_mask,0) > 0 THEN
							   CASE field.form_field_type_id
						   			WHEN 5 THEN dbo.fun_privacy_data_mask(text_entry.text_entry,Rg.privacy_data_mask_id)
									WHEN 6 THEN dbo.fun_privacy_data_mask(text_entry.text_entry,Rg.privacy_data_mask_id)
									ELSE dbo.fun_privacy_data_mask(CAST(selected.field_value_id AS VARCHAR(10)),Rg.privacy_data_mask_id)
							   END
                            ELSE
                               CASE field.form_field_type_id
								/*BEGIN 8 JUNE 2012 TRACKER 29830*/
								WHEN 4 THEN
								 (SELECT  STUFF((SELECT ', ' + CAST(field_value_description AS VARCHAR(MAX))
								FROM field_customized_value
								WHERE custom_field_id = v.custom_field_id AND ','+t1.text_entry+',' LIKE '%,'+ CAST(field_value_id AS Varchar(10))+',%' AND related_object_id=?
								FOR XML PATH('')),1,1,'')  AS field_value_description
								FROM field_customized_value v
								INNER JOIN
								field_customized_text_entry  t1 ON t1.custom_field_id=v.custom_field_id AND t1.related_object_id= ? WHERE t1.custom_field_id=field.custom_field_id
									GROUP BY t1.related_object_id,v.custom_field_id,t1.text_entry)
									/*END 8 JUNE 2012 TRACKER 29830*/

                                    WHEN 5 THEN text_entry.text_entry
                                    WHEN 6 THEN text_entry.text_entry
                                    ELSE selected.field_value_description
                               END
                            END AS field_stored_description
                           /* BEGIN NEO 00049 02 June 2013 AI Company Qty Reg Use Cases 2013-02-21.docx UC 05 */
						  ,field.bit_use_in_slim_profile
						  ,field.bit_required_in_slim_profile
						  ,field.int_sort_order_in_slim_profile
						  ,field.xml_title
                          /* END NEO 00049 02 June 2013 AI Company Qty Reg Use Cases 2013-02-21.docx UC 05 */
						, CASE
						WHEN field.form_field_type_id IN (4,5,6) THEN text_entry.dat_expiry_date
						ELSE selected.dat_expiry_date
						END AS dat_expiry_date
						, CASE
						WHEN field.form_field_type_id IN (4,5,6) THEN text_entry.dat_last_expired_on
						ELSE selected.dat_last_expired_on
						END AS dat_last_expired_on
						, field.bit_allow_data_expiration
					  FROM field_customized field
					  INNER JOIN Regions Rg ON Rg.RegionID = field.region_id
					  LEFT OUTER JOIN(SELECT field_value_description, field_value_id
						      FROM field_customized_value) value ON value.field_value_id = field.default_field_value_id
							  INNER JOIN form_field_type f ON f.form_field_type_id = field.form_field_type_id
							  INNER JOIN base_field_table bt ON bt.base_table_id = field.base_table_id
							  LEFT JOIN form_field_data_type dt ON dt.field_data_type_id = field.field_data_type_id
							  LEFT JOIN(SELECT s.custom_field_id, s.field_value_id, v.field_value_description,s.dat_expiry_date,s.dat_last_expired_on FROM field_customized_selection s
							  INNER JOIN field_customized_value v ON v.field_value_id = s.field_value_id
							 WHERE s.related_object_id = ?)selected ON selected.custom_field_id = field.custom_field_id LEFT JOIN
						   (SELECT custom_field_id, text_entry,dat_expiry_date,dat_last_expired_on
						      FROM field_customized_text_entry
							 WHERE related_object_id = ?) text_entry ON text_entry.custom_field_id = field.custom_field_id
					 WHERE field.region_id = ?) f
			WHERE 0=0
				
				
					and base_table_description in (?)
				
				
			  AND f.is_enabled = ? 
				AND (
						CHARINDEX(CAST(90 AS varchar(4)), access_list) > 0
						
					)
				

			ORDER BY f.custom_field_id

select * from qSocialMedia order by int_order desc

q_customer_by_domain (Datasource=LumensCustomers, Time=0ms) in E:\Lumens\app_setup.cfc @ 11:56:55.055

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\Lumens\index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=
HTTP_COOKIE=
HTTP_HOST=v8template2.augusoft.net
HTTP_REFERER=
HTTP_URL=/index.cfm?fuseaction=1008
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=172.31.100.167
PATH_INFO=
PATH_TRANSLATED=E:\Lumens\index.cfm
QUERY_STRING=fuseaction=1008
REMOTE_ADDR=172.31.102.252
REMOTE_HOST=172.31.102.252
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=v8template2.augusoft.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
LUMPERSIST=2E30782DFFFB79CE3F0183C3A8DEBA41

Session Variables:
actortypeid=90
addtoken=CFID=9901803&CFTOKEN=7831e988c2844824-44E1B349-EC30-F81E-0DD65FC9B815FE85&jsessionid=DE93ED62DF94422CB94161FFE39B3873.cfusion
allowunmaskeddata=0
appname=v8Template2
basecfcs=versions.v81QA
basecode=/versions/v81QA
bit_canvas_failed_process=false
bit_member=0
customcct=
customcfcs=Customers.v8Template2
customerid=487
custompath=/Customers/v8Template2/custom
debug=0
debugoutput=1
docxdir=DocxHTML
domain=v8template2.augusoft.net
ds=v8Template2
enabledlivechat=false
enabledsupportwidget=false
enteredsiteusingipaddress=1
foundeo_firewall_ip=3.144.84.155
foundeo_firewall_ua=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
loggedin=No
loggeduseremail=
loggeduserfname=Guest
loggeduserlname=
membershiptypeid=0
menuid=1
orgid=1
privacypolicyack=
regionid=1
sessionid=DE93ED62DF94422CB94161FFE39B3873.cfusion
sitepath=/Customers/v8Template2
sslreturnurl=https://v8template2.augusoft.net/
stylesheetpath=/Customers/v8Template2/StyleSheets/style.css
timeoutminutes=60
urltoken=CFID=9901803&CFTOKEN=7831e988c2844824-44E1B349-EC30-F81E-0DD65FC9B815FE85&jsessionid=DE93ED62DF94422CB94161FFE39B3873.cfusion
version=v81QA

URL Parameters:
fuseaction=1008