query
RESULTSET	query   DISPLAYRANK HREFTARGET LIVE MENUSELECTIONCODE NAME ONCLICK PARENTSECTIONID PORTAL_NAME PORTAL_OWNERID PORTAL_OWNERTYPE REQUIREDPERMISSION SECTIONID SITENAME URI WEBSITEID 1 100 [empty string] N re:/CDA/index.cfm\?.*&?set=bigtrain-promotionalmaterial Promotional Material [empty string] [empty string] kerryfoodservice 2252 MFR STP 5285 Kerry Foodservice Solutions Sales Team Portal /apps/CDA/index.cfm?set=bigtrain-promotionalmaterial 727 2 100 [empty string] N re:/CDA/index.cfm\?.*&?set=bigtrain-promotionalmaterial Promotional Material [empty string] [empty string] kerryfoodservice 2252 MFR STP 5286 Kerry Foodservice Solutions Sales Team Portal /apps/CDA/index.cfm?set=bigtrain-promotionalmaterial 727 3 150 [empty string] Y re:/CDA/index.cfm\?.*&?set=equipmentandservice Equipment [empty string] [empty string] kerryfoodservice 2252 MFR 19205 7531 Kerry Foodservice Solutions Sales Team Portal /apps/CDA/index.cfm?set=equipmentandservice 727 4 199 [empty string] Y re:/CDA/index.cfm\?.*&?set=customerandchannel DDT [empty string] [empty string] kerryfoodservice 2252 MFR 19206 5272 Kerry Foodservice Solutions Sales Team Portal /apps/CDA/index.cfm?set=customerandchannel 727 5 200 [empty string] Y re:/CDA/index.cfm\?.*&?set=productsandmarketing Marketing [empty string] [empty string] kerryfoodservice 2252 MFR 2439 5251 Kerry Foodservice Solutions Sales Team Portal /apps/CDA/index.cfm?set=productsandmarketing 727 6 300 [empty string] Y re:/CDA/index.cfm\?.*&?set=trackingandreporting Reporting [empty string] [empty string] kerryfoodservice 2252 MFR 5239 5252 Kerry Foodservice Solutions Sales Team Portal /apps/CDA/index.cfm?set=trackingandreporting 727 7 400 [empty string] N re:/CDA/index.cfm\?.*&?set=documents Documents [empty string] [empty string] kerryfoodservice 2252 MFR STP 2798 Kerry Foodservice Solutions Sales Team Portal /apps/CDA/index.cfm?set=documents 727 8 400 [empty string] Y re:/CDA/index.cfm\?.*&?set=supportassetss Support Assets [empty string] [empty string] kerryfoodservice 2252 MFR 19208 15399 Kerry Foodservice Solutions Sales Team Portal /apps/CDA/index.cfm?set=supportassetss 727
CACHED	false
EXECUTIONTIME	50
SQL	select w.websiteid, w.name as SiteName, s.sectionid, s.name, s.uri, s.parentsectionid, s.requiredpermission, s.menuSelectionCode, s.displayRank, s.hrefTarget, s.onClick, s.live, w.portal_ownerId, w.portal_ownerType, w.portal_name from fsenablers..tbl_CUS_WebSitesections s inner join fsenablers..tbl_CUS_WebSites w on s.websiteid = w.websiteid where w.websiteid = ? and nullif(rtrim(s.parentsectionid),'') IS NULL and s.uri like '%/CDA/%' order by displayRank, s.name, parentsectionid
SQLPARAMETERS	array 1 727

Promotional Material
Promotional Material
Equipment
DDT
Marketing
Reporting
Documents
Support Assets