string DECLARE @menuName_1 VARCHAR( 255 ); DECLARE @websiteId INT; DECLARE @menuName_2 VARCHAR( 255 ); DECLARE @menuName_3 VARCHAR( 255 ); SET @menuName_1 = :menuName_1; SET @websiteId = :websiteId; SET @menuName_2 = :menuName_2; SET @menuName_3 = :menuName_3; SELECT DISTINCT nav_level_3.assetmeta_nID FROM vw_selectAsset AS nav_level_1 INNER JOIN mid_assetmetaAssetmeta AS link_1_2 ON nav_level_1.assetmeta_nId = link_1_2.assetmetaAssetmeta_x_nParentID INNER JOIN vw_selectAsset AS nav_level_2 ON link_1_2.assetmetaAssetmeta_x_nChildId = nav_level_2.assetmeta_nID INNER JOIN mid_assetmetaAssetmeta AS link_2_3 ON nav_level_2.assetmeta_nId = link_2_3.assetmetaAssetmeta_x_nParentID INNER JOIN vw_selectAsset AS nav_level_3 ON link_2_3.assetmetaAssetmeta_x_nChildId = nav_level_3.assetmeta_nID WHERE nav_level_1.assetmeta_x_nBwsId = @websiteId AND nav_level_1.assetmeta_x_nTypeId IN ( 2, 3 ) AND nav_level_1.assetmeta_x_nBmId = 14 AND dbo.variableFormatMstng( nav_level_1.assetcontent_sTitleText ) = @menuName_1 AND nav_level_2.assetmeta_x_nBwsId = @websiteId AND nav_level_2.assetmeta_x_nTypeId IN ( 2, 3 ) AND nav_level_2.assetmeta_x_nBmId = 14 AND dbo.variableFormatMstng( nav_level_2.assetcontent_sTitleText ) IN ( @menuName_2, '_' + @menuName_2, REPLACE( @menuName_2, '-', '_' ), '_' + REPLACE( @menuName_2, '-', '_' ) ) AND nav_level_3.assetmeta_x_nBwsId = @websiteId AND nav_level_3.assetmeta_x_nTypeId IN ( 2, 3 ) AND nav_level_3.assetmeta_x_nBmId = 14 AND dbo.variableFormatMstng( nav_level_3.assetcontent_sTitleText ) IN ( @menuName_3, '_' + @menuName_3, REPLACE( @menuName_3, '-', '_' ), '_' + REPLACE( @menuName_3, '-', '_' ) )
Struct
menuName_1
stringnl
menuName_2
stringmeesterweek
menuName_3
stringover-ons
websiteId
number431