Home

select * from tclustercommands
				where instanceID='9B5887A5-A267-45CF-98F9CA454E9D2D69'
				and created < {ts '2026-08-07 03:58:05'}

SELECT blocked
			FROM variables.internal.iplog
			WHERE IP = '216.73.216.36'

select tusers.userID, tusers.GroupName, tusers.Fname, tusers.Lname, tusers.UserName,tusers.PasswordCreated, tusers.Email, tusers.Company, tusers.JobTitle, tusers.MobilePhone, tusers.Website, tusers.Type, tusers.subType, tusers.ContactForm, tusers.S2, tusers.LastLogin, tusers.LastUpdate, tusers.LastUpdateBy, tusers.LastUpdateByID, tusers.Perm, tusers.InActive, tusers.IsPublic, tusers.SiteID, tusers.Subscribe, tusers.Notes, tusers.description, tusers.Interests, tusers.keepPrivate, tusers.PhotoFileID, tusers.IMName, tusers.IMService, tusers.Created, tusers.RemoteID, tusers.Tags, tusers.tablist, tfiles.fileEXT photoFileExt
			from tusers
			left join tfiles on tusers.photoFileId=tfiles.fileid
			where tusers.userid= ''

select tclassextenddatauseractivity.baseid, tclassextendattributes.name, tclassextendattributes.type, tclassextendattributes.validation,
			
				tclassextendattributes.label
			,
			tclassextendattributes.attributeID,tclassextendattributes.defaultValue,tclassextendattributes.extendSetID,

			tclassextenddatauseractivity.attributeValue, tclassextenddatauseractivity.datetimevalue

			from tclassextenddatauseractivity 
			inner join tclassextendattributes  On (tclassextenddatauseractivity.attributeID=tclassextendattributes.attributeID)
			where tclassextenddatauseractivity.baseID='DC7DC98F-999D-419C-B352D5B8CC585B91'

select tcontent.Active,tcontent.Approved,tcontent.audience,tcontent.Body,tcontent.ContentHistID,
tcontent.ContentID,tcontent.Credits,tcontent.Display,tcontent.DisplayStart,tcontent.DisplayStop,tcontent.featureStart,
tcontent.featureStop,tcontent.FileID,tcontent.Filename,tcontent.forceSSL,tcontent.inheritObjects,tcontent.isFeature,
tcontent.IsLocked,tcontent.IsNav,tcontent.keyPoints,tcontent.lastUpdate,tcontent.lastUpdateBy,tcontent.lastUpdateByID,
tcontent.MenuTitle,tcontent.MetaDesc,tcontent.MetaKeyWords,tcontent.moduleAssign,tcontent.ModuleID,tcontent.nextN,
tcontent.Notes,tcontent.OrderNo,tcontent.ParentID,tcontent.displayTitle,tcontent.ReleaseDate,tcontent.RemoteID,
tcontent.RemotePubDate,tcontent.RemoteSource,tcontent.RemoteSourceURL,tcontent.RemoteURL,tcontent.responseChart,
tcontent.responseDisplayFields,tcontent.responseMessage,tcontent.responseSendTo,tcontent.Restricted,tcontent.RestrictGroups,
tcontent.searchExclude,tcontent.SiteID,tcontent.sortBy,tcontent.sortDirection,tcontent.Summary,tcontent.Target,
tcontent.TargetParams,tcontent.Template,tcontent.Title,tcontent.Type,tcontent.subType,tcontent.Path,tcontent.tags,
tcontent.doCache,tcontent.created,tcontent.urltitle,tcontent.htmltitle,tcontent.mobileExclude,tcontent.changesetID,
tcontent.imageSize,tcontent.imageHeight,tcontent.imageWidth,tcontent.childTemplate,tcontent.majorVersion,tcontent.minorVersion,tcontent.expires,tcontent.displayInterval,tcontent.objectParams
, tfiles.fileSize,
					tfiles.contentType, tfiles.contentSubType, tfiles.fileExt,tfiles.filename as assocFilename,
				tapprovalrequests.status as approvalStatus, tapprovalrequests.requestID,tapprovalrequests.groupid as approvalGroupID
					from tcontent
					left join tfiles on (tcontent.fileid=tfiles.fileid)
					left join tapprovalrequests on (tcontent.contenthistid=tapprovalrequests.contenthistid)
					where tcontent.contentid='00000000000000000000000000000000001'
					
	
	
	
		
			
		
		
			and tcontent.active = 1
		
	

					and tcontent.siteid='default'
					and type in ('Page','Folder','File','Calendar','Link','Gallery','Component','Form','Variation','Module')

select tcontent.contenthistid, tcontent.contentid,tcontent.title, tcontent.menutitle,tcontent.urltitle, tcontent.filename, tcontent.parentid, tcontent.type,
			tcontent.subtype, tcontent.target, tcontent.targetParams,
			tcontent.siteid, tcontent.restricted, tcontent.restrictgroups,tcontent.template,tcontent.childTemplate,tcontent.inheritObjects,tcontent.metadesc,tcontent.metakeywords,tcontent.sortBy,
			tcontent.sortDirection,tapprovalassignments.chainID,
			
			length(tcontent.path) depth
			
			,tfiles.fileExt,tapprovalassignments.exemptID,tcontent.moduleid

			from tcontent
			left join tfiles on(tcontent.fileID=tfiles.fileID)
			left join tapprovalassignments on (tcontent.contentid=tapprovalassignments.contentid
											and tcontent.siteID=tapprovalassignments.siteID)
			where
			tcontent.contentID in ('00000000000000000000000000000000001')
			and tcontent.active=1
			and tcontent.siteid= 'default'
			order by depth desc

select tusers.groupname,isPublic from tusers INNER JOIN tpermissions ON (tusers.userid = tpermissions.groupid) where tpermissions.contentid='00000000000000000000000000000000000' and tpermissions.siteid='default'

select tclassextenddata.baseid, tclassextendattributes.name, tclassextendattributes.type, tclassextendattributes.validation,
			
				tclassextendattributes.label
			,
			tclassextendattributes.attributeID,tclassextendattributes.defaultValue,tclassextendattributes.extendSetID,

			tclassextenddata.attributeValue, tclassextenddata.datetimevalue

			from tclassextenddata 
			inner join tclassextendattributes  On (tclassextenddata.attributeID=tclassextendattributes.attributeID)
			where tclassextenddata.baseID='04158935-B65E-4595-84F57EA09F8E6761'
			
				and tclassextendattributes.siteid='default'

select baseID, name, type, validation, label, attributeID, defaultValue, extendSetID, attributeValue
			from rsExtended

			union all

			select '' baseID, attributename as name, type, validation, label, attributeID, defaultValue, extendSetID, '' attributeValue
			from rsDefinitions
			where siteID='default'
			and (
				type='Page'
				
					or type='Base'
				
				)
          	and (
                 
                 subtype='Default'
                  )
			
			and attributeID not in (198,199,200,201,288,289,286,383,384,385,287)

select * from tcontentfeeds
	where siteID= 'default'
	and Type= 'Local'
	
	and isPublic=1
	

	
	and isactive=1
	
	order by name

select contentid,menutitle,filename,type
			from tcontent
			where parentID='00000000000000000000000000000000001'
				and siteid='MRC'
			AND isNav = '1'
			AND Approved = '1'
			AND Active = '1'
			AND type in ('Page','Folder','Calendar')
			AND (
				Display = 2
				AND (
					( DisplayStart <= NOW()
						AND ( DisplayStop > NOW() OR DisplayStop is null )))
						OR Display = 1
					)
					order by orderno asc

Select
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid,authtype
	from tcontentfeeds where
	name= 'Header links'
	and siteid='default'

SELECT
				
				

				
					
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups,
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary,
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
					

					
				

			FROM
				 tcontent 

				

				
				

				
				

				
					left Join tfiles  on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent  on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

			WHERE
				tcontent.siteid in ('default')
				
	
	
	
		
			
				
			
			
				and tcontent.active = 1
				and tcontent.Approved = 1
			
		
	

				
					AND tcontent.isNav = 1
				

				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				

				
					AND tcontent.searchExclude = 0
				

				
					AND tcontent.contentid <> '00000000000000000000000000000000001'
				

				AND tcontent.type <>'Module'

				
				

				

				

				

				

				
					AND (
						tcontent.Display = 1
						OR
							(
								tcontent.Display = 2


								AND
								(

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= 
	
		{ts '2026-08-07 03:55:00'}
										and (tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										

										and tcontent.DisplayStart <= 
	
		{ts '2027-08-07 03:55:00'}
										and (tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null)
									)
								)
							)

					)

					AND (
						tcontent.mobileExclude is null
						OR
						
							tcontent.mobileExclude in (0,1)
						
					)
				

				
				
				

				
					
						order by

						
							
									
										tcontent.lastUpdate desc
									
								

							
						
					
					
					
						limit 20

select tcontent.Active,tcontent.Approved,tcontent.audience,tcontent.Body,tcontent.ContentHistID,
tcontent.ContentID,tcontent.Credits,tcontent.Display,tcontent.DisplayStart,tcontent.DisplayStop,tcontent.featureStart,
tcontent.featureStop,tcontent.FileID,tcontent.Filename,tcontent.forceSSL,tcontent.inheritObjects,tcontent.isFeature,
tcontent.IsLocked,tcontent.IsNav,tcontent.keyPoints,tcontent.lastUpdate,tcontent.lastUpdateBy,tcontent.lastUpdateByID,
tcontent.MenuTitle,tcontent.MetaDesc,tcontent.MetaKeyWords,tcontent.moduleAssign,tcontent.ModuleID,tcontent.nextN,
tcontent.Notes,tcontent.OrderNo,tcontent.ParentID,tcontent.displayTitle,tcontent.ReleaseDate,tcontent.RemoteID,
tcontent.RemotePubDate,tcontent.RemoteSource,tcontent.RemoteSourceURL,tcontent.RemoteURL,tcontent.responseChart,
tcontent.responseDisplayFields,tcontent.responseMessage,tcontent.responseSendTo,tcontent.Restricted,tcontent.RestrictGroups,
tcontent.searchExclude,tcontent.SiteID,tcontent.sortBy,tcontent.sortDirection,tcontent.Summary,tcontent.Target,
tcontent.TargetParams,tcontent.Template,tcontent.Title,tcontent.Type,tcontent.subType,tcontent.Path,tcontent.tags,
tcontent.doCache,tcontent.created,tcontent.urltitle,tcontent.htmltitle,tcontent.mobileExclude,tcontent.changesetID,
tcontent.imageSize,tcontent.imageHeight,tcontent.imageWidth,tcontent.childTemplate,tcontent.majorVersion,tcontent.minorVersion,tcontent.expires,tcontent.displayInterval,tcontent.objectParams
, tfiles.fileSize,
					tfiles.contentType, tfiles.contentSubType, tfiles.fileExt,tfiles.filename as assocFilename,
					tapprovalrequests.status as approvalStatus, tapprovalrequests.requestID,tapprovalrequests.groupid as approvalGroupID
					 from tcontent
					left join tfiles on (tcontent.fileid=tfiles.fileid)
					left join tapprovalrequests on (tcontent.contenthistid=tapprovalrequests.contenthistid)
					where
					tcontent.contenthistid in ('3B2BA4F7-FDA6-4C05-B10A730150FC2B1B','27B443A2-D603-4FC2-964AFECF4714082F','895CBA9C-5CC9-474C-81D52A5688719A05','CB72CCCF-990F-4575-8D788690221DAA01','7C27542F-866B-45EB-94D0304800419552','C8B42516-67A7-4394-90056E3DFD288FC9','A675F6B6-D8FC-4F9E-845095E67A8EBAC8','A90DEC9C-A5CF-4B51-8A863B2BE31ABEDF','D13C7D38-583B-42D5-B425763012E82C8D','8A60E4D2-E290-40F3-941BEFD256DB6CE8','35F3A7EE-7099-4613-B3138A91D03335B9','B3B54708-C243-4744-9D085B7D8B002E6C','BC284863-FCC3-42B8-82FFFCDFA9B37655','6C2BB92D-E407-41E8-A13D8773B559A43D','467132C6-9636-4652-92CC3BBA4A1596CB','E248A4F5-E1E5-4775-9BABBFF19497B2C4','306123DB-CF08-40E5-B62A3CD43DCABBC0','42D43F77-303E-40E2-B3D5333C57E2F506','3E4A59FC-3C89-42D2-B4F37F243901BFFD','931BE5B5-FA65-4303-BD741619257E70E3')

select * from rsPage where contenthistid='3B2BA4F7-FDA6-4C05-B10A730150FC2B1B'

select * from rsPage where contenthistid='27B443A2-D603-4FC2-964AFECF4714082F'

select * from rsPage where contenthistid='895CBA9C-5CC9-474C-81D52A5688719A05'

select * from rsPage where contenthistid='CB72CCCF-990F-4575-8D788690221DAA01'

select * from rsPage where contenthistid='7C27542F-866B-45EB-94D0304800419552'

select * from rsPage where contenthistid='C8B42516-67A7-4394-90056E3DFD288FC9'

select * from rsPage where contenthistid='A675F6B6-D8FC-4F9E-845095E67A8EBAC8'

select * from rsPage where contenthistid='A90DEC9C-A5CF-4B51-8A863B2BE31ABEDF'

select * from rsPage where contenthistid='D13C7D38-583B-42D5-B425763012E82C8D'

select * from rsPage where contenthistid='8A60E4D2-E290-40F3-941BEFD256DB6CE8'

select * from rsPage where contenthistid='35F3A7EE-7099-4613-B3138A91D03335B9'

select * from rsPage where contenthistid='B3B54708-C243-4744-9D085B7D8B002E6C'

select * from rsPage where contenthistid='BC284863-FCC3-42B8-82FFFCDFA9B37655'

select * from rsPage where contenthistid='6C2BB92D-E407-41E8-A13D8773B559A43D'

select * from rsPage where contenthistid='467132C6-9636-4652-92CC3BBA4A1596CB'

select * from rsPage where contenthistid='E248A4F5-E1E5-4775-9BABBFF19497B2C4'

select * from rsPage where contenthistid='306123DB-CF08-40E5-B62A3CD43DCABBC0'

select * from rsPage where contenthistid='42D43F77-303E-40E2-B3D5333C57E2F506'

select * from rsPage where contenthistid='3E4A59FC-3C89-42D2-B4F37F243901BFFD'

select * from rsPage where contenthistid='931BE5B5-FA65-4303-BD741619257E70E3'

SELECT
				
				

				
					
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups,
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary,
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
					

					
				

			FROM
				 tcontent 

				

				
				

				
				

				
					left Join tfiles  on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent  on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

			WHERE
				tcontent.siteid in ('default')
				
	
	
	
		
			
				
			
			
				and tcontent.active = 1
				and tcontent.Approved = 1
			
		
	

				
					AND tcontent.isNav = 1
				

				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				

				
					AND tcontent.searchExclude = 0
				

				
					AND tcontent.contentid <> '00000000000000000000000000000000001'
				

				AND tcontent.type <>'Module'

				
				
					
					

					
						

	
	

	
		

	

	
		
	

	
	
	
		
	

	

	
		
	

	

	

	
 			
 		


	
	

	
		
	
	

	
	
	

	
		
	
	
			
					
				
		
	


	
	
		
	

	

	

						
	
							
	
		

							
								
								and (
							

							
	
	
	
	
	
	

							
							

							
	
								
	
								
										
	
		tcontent.parentid
										
	
		=
										
	
		
											
											
	
	
	
		
	
		'00000000000000000000000000000000001'
											
										
								
								
								
							
						
					

					)
				

				

				

				

				

				
					AND (
						tcontent.Display = 1
						OR
							(
								tcontent.Display = 2


								AND
								(

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= 
	
		{ts '2026-08-07 03:55:00'}
										and (tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										

										and tcontent.DisplayStart <= 
	
		{ts '2027-08-07 03:55:00'}
										and (tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null)
									)
								)
							)

					)

					AND (
						tcontent.mobileExclude is null
						OR
						
							tcontent.mobileExclude in (0,1)
						
					)
				

				
				
				

				
					
						order by

						
							
									orderno
							
						
					
					
					
						limit 20

SELECT 

				
				tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate,tcontent.summary, tcontent.tags,tcontent.filename, tcontent.type,tcontent.subType, tcontent.siteid,
				tcontent.contentid, tcontent.contentHistID, tcontent.target, tcontent.targetParams,
				tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection,
				tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL,
				tfiles.fileSize,tfiles.fileExt, tcontent.audience, tcontent.keypoints
				,tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes
				,tcontentstats.comments, '' as parentType, null as kids,tcontent.path, tcontent.created, tcontent.nextn,
				tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
				tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
				

				
				FROM  tcontent 

				
					Left Join tfiles  ON (tcontent.fileID=tfiles.fileID)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

				
				
				

				

				WHERE
				    tcontent.parentid = '00000000000000000000000000000000001'
					
	
	
 	
 		
 			
 		
		
			and tcontent.active = 1
			and tcontent.Approved = 1
		
	

					AND tcontent.isNav = 1
					AND tcontent.moduleid = '00000000000000000000000000000000000'
					AND tcontent.siteid = 'default'

					

					AND (
					   	

			

					 	tcontent.Display = 1
					  	OR
					  	(
					  		tcontent.Display = 2
					 		AND
					 	 		(
					 	 			tcontent.DisplayStart < 
	
		{ts '2026-08-07 03:55:00'}
						  			AND
						  				(
						  					tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null
						  				)
						  		)
						)

					  


		  				)

					

					


					

					


				
	
	and (tcontent.mobileExclude is null
		OR
		
			tcontent.mobileExclude in (0,1)
		
	)
	


				order by

				
						
						tcontent.orderno asc

select menutitle,filename from tcontent where contentID='00000000000000000000000000000000001' and siteid='default' and active=1

SELECT 

				
				tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate,tcontent.summary, tcontent.tags,tcontent.filename, tcontent.type,tcontent.subType, tcontent.siteid,
				tcontent.contentid, tcontent.contentHistID, tcontent.target, tcontent.targetParams,
				tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection,
				tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL,
				tfiles.fileSize,tfiles.fileExt, tcontent.audience, tcontent.keypoints
				,tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes
				,tcontentstats.comments, '' as parentType, null as kids,tcontent.path, tcontent.created, tcontent.nextn,
				tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
				tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
				

				
				FROM  tcontent 

				
					Left Join tfiles  ON (tcontent.fileID=tfiles.fileID)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

				
				
				

				

				WHERE
				    tcontent.parentid = '3C8A733F-3751-4592-935676531FC0F58F'
					
	
	
 	
 		
 			
 		
		
			and tcontent.active = 1
			and tcontent.Approved = 1
		
	

					AND tcontent.isNav = 1
					AND tcontent.moduleid = '00000000000000000000000000000000000'
					AND tcontent.siteid = 'default'

					

					AND (
					   	

			

					 	tcontent.Display = 1
					  	OR
					  	(
					  		tcontent.Display = 2
					 		AND
					 	 		(
					 	 			tcontent.DisplayStart < 
	
		{ts '2026-08-07 03:55:00'}
						  			AND
						  				(
						  					tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null
						  				)
						  		)
						)

					  


		  				)

					

					


					

					


				
	
	and (tcontent.mobileExclude is null
		OR
		
			tcontent.mobileExclude in (0,1)
		
	)
	


				order by

				
						
						tcontent.orderno asc

SELECT 

				
				tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate,tcontent.summary, tcontent.tags,tcontent.filename, tcontent.type,tcontent.subType, tcontent.siteid,
				tcontent.contentid, tcontent.contentHistID, tcontent.target, tcontent.targetParams,
				tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection,
				tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL,
				tfiles.fileSize,tfiles.fileExt, tcontent.audience, tcontent.keypoints
				,tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes
				,tcontentstats.comments, '' as parentType, null as kids,tcontent.path, tcontent.created, tcontent.nextn,
				tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
				tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
				

				
				FROM  tcontent 

				
					Left Join tfiles  ON (tcontent.fileID=tfiles.fileID)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

				
				
				

				

				WHERE
				    tcontent.parentid = '4E5A17FB-CD10-44F0-A212474915976B32'
					
	
	
 	
 		
 			
 		
		
			and tcontent.active = 1
			and tcontent.Approved = 1
		
	

					AND tcontent.isNav = 1
					AND tcontent.moduleid = '00000000000000000000000000000000000'
					AND tcontent.siteid = 'default'

					

					AND (
					   	

			

					 	tcontent.Display = 1
					  	OR
					  	(
					  		tcontent.Display = 2
					 		AND
					 	 		(
					 	 			tcontent.DisplayStart < 
	
		{ts '2026-08-07 03:55:00'}
						  			AND
						  				(
						  					tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null
						  				)
						  		)
						)

					  


		  				)

					

					


					

					


				
	
	and (tcontent.mobileExclude is null
		OR
		
			tcontent.mobileExclude in (0,1)
		
	)
	


				order by

				
						
						tcontent.orderno asc

SELECT 

				
				tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate,tcontent.summary, tcontent.tags,tcontent.filename, tcontent.type,tcontent.subType, tcontent.siteid,
				tcontent.contentid, tcontent.contentHistID, tcontent.target, tcontent.targetParams,
				tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection,
				tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL,
				tfiles.fileSize,tfiles.fileExt, tcontent.audience, tcontent.keypoints
				,tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes
				,tcontentstats.comments, '' as parentType, null as kids,tcontent.path, tcontent.created, tcontent.nextn,
				tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
				tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
				

				
				FROM  tcontent 

				
					Left Join tfiles  ON (tcontent.fileID=tfiles.fileID)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

				
				
				

				

				WHERE
				    tcontent.parentid = '1111BE9F-481F-4784-8F5305A65B808C36'
					
	
	
 	
 		
 			
 		
		
			and tcontent.active = 1
			and tcontent.Approved = 1
		
	

					AND tcontent.isNav = 1
					AND tcontent.moduleid = '00000000000000000000000000000000000'
					AND tcontent.siteid = 'default'

					

					AND (
					   	

			

					 	tcontent.Display = 1
					  	OR
					  	(
					  		tcontent.Display = 2
					 		AND
					 	 		(
					 	 			tcontent.DisplayStart < 
	
		{ts '2026-08-07 03:55:00'}
						  			AND
						  				(
						  					tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null
						  				)
						  		)
						)

					  


		  				)

					

					


					

					


				
	
	and (tcontent.mobileExclude is null
		OR
		
			tcontent.mobileExclude in (0,1)
		
	)
	


				order by

				
						
						tcontent.orderno asc

SELECT 

				
				tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate,tcontent.summary, tcontent.tags,tcontent.filename, tcontent.type,tcontent.subType, tcontent.siteid,
				tcontent.contentid, tcontent.contentHistID, tcontent.target, tcontent.targetParams,
				tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection,
				tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL,
				tfiles.fileSize,tfiles.fileExt, tcontent.audience, tcontent.keypoints
				,tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes
				,tcontentstats.comments, '' as parentType, null as kids,tcontent.path, tcontent.created, tcontent.nextn,
				tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
				tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
				

				
				FROM  tcontent 

				
					Left Join tfiles  ON (tcontent.fileID=tfiles.fileID)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

				
				
				

				

				WHERE
				    tcontent.parentid = '69AD14E1-E9B7-40DB-9F886F510BDDDCB5'
					
	
	
 	
 		
 			
 		
		
			and tcontent.active = 1
			and tcontent.Approved = 1
		
	

					AND tcontent.isNav = 1
					AND tcontent.moduleid = '00000000000000000000000000000000000'
					AND tcontent.siteid = 'default'

					

					AND (
					   	

			

					 	tcontent.Display = 1
					  	OR
					  	(
					  		tcontent.Display = 2
					 		AND
					 	 		(
					 	 			tcontent.DisplayStart < 
	
		{ts '2026-08-07 03:55:00'}
						  			AND
						  				(
						  					tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null
						  				)
						  		)
						)

					  


		  				)

					

					


					

					


				
	
	and (tcontent.mobileExclude is null
		OR
		
			tcontent.mobileExclude in (0,1)
		
	)
	


				order by

				
						
						tcontent.orderno asc

SELECT 

				
				tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate,tcontent.summary, tcontent.tags,tcontent.filename, tcontent.type,tcontent.subType, tcontent.siteid,
				tcontent.contentid, tcontent.contentHistID, tcontent.target, tcontent.targetParams,
				tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection,
				tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL,
				tfiles.fileSize,tfiles.fileExt, tcontent.audience, tcontent.keypoints
				,tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes
				,tcontentstats.comments, '' as parentType, null as kids,tcontent.path, tcontent.created, tcontent.nextn,
				tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
				tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
				

				
				FROM  tcontent 

				
					Left Join tfiles  ON (tcontent.fileID=tfiles.fileID)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

				
				
				

				

				WHERE
				    tcontent.parentid = '8B05F448-9965-4C86-934450C1125ECEF0'
					
	
	
 	
 		
 			
 		
		
			and tcontent.active = 1
			and tcontent.Approved = 1
		
	

					AND tcontent.isNav = 1
					AND tcontent.moduleid = '00000000000000000000000000000000000'
					AND tcontent.siteid = 'default'

					

					AND (
					   	

			

					 	tcontent.Display = 1
					  	OR
					  	(
					  		tcontent.Display = 2
					 		AND
					 	 		(
					 	 			tcontent.DisplayStart < 
	
		{ts '2026-08-07 03:55:00'}
						  			AND
						  				(
						  					tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null
						  				)
						  		)
						)

					  


		  				)

					

					


					

					


				
	
	and (tcontent.mobileExclude is null
		OR
		
			tcontent.mobileExclude in (0,1)
		
	)
	


				order by

				
						
						tcontent.orderno asc

SELECT 

				
				tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate,tcontent.summary, tcontent.tags,tcontent.filename, tcontent.type,tcontent.subType, tcontent.siteid,
				tcontent.contentid, tcontent.contentHistID, tcontent.target, tcontent.targetParams,
				tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection,
				tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL,
				tfiles.fileSize,tfiles.fileExt, tcontent.audience, tcontent.keypoints
				,tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes
				,tcontentstats.comments, '' as parentType, null as kids,tcontent.path, tcontent.created, tcontent.nextn,
				tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
				tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
				

				
				FROM  tcontent 

				
					Left Join tfiles  ON (tcontent.fileID=tfiles.fileID)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

				
				
				

				

				WHERE
				    tcontent.parentid = '99DF9E21-3CA3-43C0-A7D60538AB0254A0'
					
	
	
 	
 		
 			
 		
		
			and tcontent.active = 1
			and tcontent.Approved = 1
		
	

					AND tcontent.isNav = 1
					AND tcontent.moduleid = '00000000000000000000000000000000000'
					AND tcontent.siteid = 'default'

					

					AND (
					   	

			

					 	tcontent.Display = 1
					  	OR
					  	(
					  		tcontent.Display = 2
					 		AND
					 	 		(
					 	 			tcontent.DisplayStart < 
	
		{ts '2026-08-07 03:55:00'}
						  			AND
						  				(
						  					tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null
						  				)
						  		)
						)

					  


		  				)

					

					


					

					


				
	
	and (tcontent.mobileExclude is null
		OR
		
			tcontent.mobileExclude in (0,1)
		
	)
	


				order by

				
						
						tcontent.orderno asc

SELECT 

				
				tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate,tcontent.summary, tcontent.tags,tcontent.filename, tcontent.type,tcontent.subType, tcontent.siteid,
				tcontent.contentid, tcontent.contentHistID, tcontent.target, tcontent.targetParams,
				tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection,
				tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL,
				tfiles.fileSize,tfiles.fileExt, tcontent.audience, tcontent.keypoints
				,tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes
				,tcontentstats.comments, '' as parentType, null as kids,tcontent.path, tcontent.created, tcontent.nextn,
				tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
				tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
				

				
				FROM  tcontent 

				
					Left Join tfiles  ON (tcontent.fileID=tfiles.fileID)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

				
				
				

				

				WHERE
				    tcontent.parentid = '71074100-1579-46AE-88607D55EC8B3F9C'
					
	
	
 	
 		
 			
 		
		
			and tcontent.active = 1
			and tcontent.Approved = 1
		
	

					AND tcontent.isNav = 1
					AND tcontent.moduleid = '00000000000000000000000000000000000'
					AND tcontent.siteid = 'default'

					

					AND (
					   	

			

					 	tcontent.Display = 1
					  	OR
					  	(
					  		tcontent.Display = 2
					 		AND
					 	 		(
					 	 			tcontent.DisplayStart < 
	
		{ts '2026-08-07 03:55:00'}
						  			AND
						  				(
						  					tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null
						  				)
						  		)
						)

					  


		  				)

					

					


					

					


				
	
	and (tcontent.mobileExclude is null
		OR
		
			tcontent.mobileExclude in (0,1)
		
	)
	


				order by

				
						
						tcontent.orderno asc

SELECT 

				
				tcontent.title, tcontent.releasedate, tcontent.menuTitle, tcontent.lastupdate,tcontent.summary, tcontent.tags,tcontent.filename, tcontent.type,tcontent.subType, tcontent.siteid,
				tcontent.contentid, tcontent.contentHistID, tcontent.target, tcontent.targetParams,
				tcontent.restricted, tcontent.restrictgroups, tcontent.displaystart, tcontent.displaystop, tcontent.orderno,tcontent.sortBy,tcontent.sortDirection,
				tcontent.fileid, tcontent.credits, tcontent.remoteSource, tcontent.remoteSourceURL, tcontent.remoteURL,
				tfiles.fileSize,tfiles.fileExt, tcontent.audience, tcontent.keypoints
				,tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes
				,tcontentstats.comments, '' as parentType, null as kids,tcontent.path, tcontent.created, tcontent.nextn,
				tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
				tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
				

				
				FROM  tcontent 

				
					Left Join tfiles  ON (tcontent.fileID=tfiles.fileID)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

				
				
				

				

				WHERE
				    tcontent.parentid = 'C0CF4354-5FB1-42A7-A93255F52C66B8B0'
					
	
	
 	
 		
 			
 		
		
			and tcontent.active = 1
			and tcontent.Approved = 1
		
	

					AND tcontent.isNav = 1
					AND tcontent.moduleid = '00000000000000000000000000000000000'
					AND tcontent.siteid = 'default'

					

					AND (
					   	

			

					 	tcontent.Display = 1
					  	OR
					  	(
					  		tcontent.Display = 2
					 		AND
					 	 		(
					 	 			tcontent.DisplayStart < 
	
		{ts '2026-08-07 03:55:00'}
						  			AND
						  				(
						  					tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null
						  				)
						  		)
						)

					  


		  				)

					

					


					

					


				
	
	and (tcontent.mobileExclude is null
		OR
		
			tcontent.mobileExclude in (0,1)
		
	)
	


				order by

				
						
						tcontent.orderno asc

SELECT fileID, contentID, siteID, moduleID, filename, fileSize, contentType, contentSubType, fileExt, created, alttext, caption, credits  FROM tfiles where fileid= ''

select tcontentobjects.object,tcontentobjects.name,tcontentobjects.objectid, tcontentobjects.orderno, tcontentobjects.params, tplugindisplayobjects.configuratorInit from tcontentobjects
	inner join tcontent On(
	tcontentobjects.contenthistid=tcontent.contenthistid
	and tcontentobjects.siteid=tcontent.siteid)
	left join tplugindisplayobjects on (tcontentobjects.object='plugin'
										and tcontentobjects.objectID=tplugindisplayobjects.objectID)
	where tcontent.siteid='default'
	and tcontent.contenthistid ='04158935-B65E-4595-84F57EA09F8E6761'
	and tcontentobjects.columnid=2
	order by tcontentobjects.orderno

Select
	feedID,siteID,dateCreated,lastUpdate,lastUpdateBy,name,altName,lang,maxitems,isActive,isPublic,isDefault,description,allowHTML,isFeaturesOnly,restricted,restrictGroups,version,channelLink,type,sortBy,sortDirection,nextn,displayName,displayRatings,displayComments,parentID,remoteID,remoteSourceURL,remotePubDate,imageSize,imageHeight,imageWidth,displayList,showNavOnly,showExcludeSearch,viewalllink,viewalllabel,autoimport,isLocked,CssClass,useCategoryIntersect,contentpoolid,authtype
	from tcontentfeeds where
	name= 'Small footer links'
	and siteid='default'

SELECT
				
				

				
					
						tcontent.siteid, tcontent.title, tcontent.menutitle, tcontent.restricted, tcontent.restrictgroups,
						tcontent.type, tcontent.subType, tcontent.filename, tcontent.displaystart, tcontent.displaystop,
						tcontent.remotesource, tcontent.remoteURL,tcontent.remotesourceURL, tcontent.keypoints,
						tcontent.contentID, tcontent.parentID, tcontent.approved, tcontent.isLocked, tcontent.contentHistID,tcontent.target, tcontent.targetParams,
						tcontent.releaseDate, tcontent.lastupdate,tcontent.summary,
						tfiles.fileSize,tfiles.fileExt,tcontent.fileid,
						tcontent.tags,tcontent.credits,tcontent.audience, tcontent.orderNo,
						tcontentstats.rating,tcontentstats.totalVotes,tcontentstats.downVotes,tcontentstats.upVotes,
						tcontentstats.comments, tparent.type parentType,
						tcontent.path, tcontent.created, tcontent.nextn, tcontent.majorVersion, tcontent.minorVersion, tcontentstats.lockID, tcontentstats.lockType, tcontent.expires,
						tfiles.filename as AssocFilename,tcontent.displayInterval,tcontent.display,tcontentfilemetadata.altText as fileAltText,tcontent.changesetid
					

					
				

			FROM
				 tcontent 

				

				
				

				
				

				
					left Join tfiles  on (tcontent.fileid=tfiles.fileid)
					left Join tcontentstats  on (tcontent.contentid=tcontentstats.contentid
						and tcontent.siteid=tcontentstats.siteid)
					Left Join tcontent tparent  on (tcontent.parentid=tparent.contentid
						and tcontent.siteid=tparent.siteid
						and tparent.active=1)
					Left Join tcontentfilemetadata  on (tcontent.fileid=tcontentfilemetadata.fileid
						and tcontent.contenthistid=tcontentfilemetadata.contenthistid
						and tcontent.siteid=tcontentfilemetadata.siteid)
				

				

				

			WHERE
				tcontent.siteid in ('default')
				
	
	
	
		
			
				
			
			
				and tcontent.active = 1
				and tcontent.Approved = 1
			
		
	

				
					AND tcontent.isNav = 1
				

				
					AND tcontent.moduleid = '00000000000000000000000000000000000'
				

				
					AND tcontent.searchExclude = 0
				

				
					AND tcontent.contentid <> '00000000000000000000000000000000001'
				

				AND tcontent.type <>'Module'

				
				

				

				

				

				

				
					AND (
						tcontent.Display = 1
						OR
							(
								tcontent.Display = 2


								AND
								(

									(   
											tparent.type!='Calendar'
										

										and tcontent.DisplayStart <= 
	
		{ts '2026-08-07 03:55:00'}
										and (tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null)
									) OR (
										
											tparent.type='Calendar'
										

										and tcontent.DisplayStart <= 
	
		{ts '2027-08-07 03:55:00'}
										and (tcontent.DisplayStop >= 
	
		{ts '2026-08-07 03:55:00'} or tcontent.DisplayStop is null)
									)
								)
							)

					)

					AND (
						tcontent.mobileExclude is null
						OR
						
							tcontent.mobileExclude in (0,1)
						
					)
				

				
				
				

				
					
						order by

						
							
									
										tcontent.lastUpdate desc
									
								

							
						
					
					
					
						limit 20

select tcontent.Active,tcontent.Approved,tcontent.audience,tcontent.Body,tcontent.ContentHistID,
tcontent.ContentID,tcontent.Credits,tcontent.Display,tcontent.DisplayStart,tcontent.DisplayStop,tcontent.featureStart,
tcontent.featureStop,tcontent.FileID,tcontent.Filename,tcontent.forceSSL,tcontent.inheritObjects,tcontent.isFeature,
tcontent.IsLocked,tcontent.IsNav,tcontent.keyPoints,tcontent.lastUpdate,tcontent.lastUpdateBy,tcontent.lastUpdateByID,
tcontent.MenuTitle,tcontent.MetaDesc,tcontent.MetaKeyWords,tcontent.moduleAssign,tcontent.ModuleID,tcontent.nextN,
tcontent.Notes,tcontent.OrderNo,tcontent.ParentID,tcontent.displayTitle,tcontent.ReleaseDate,tcontent.RemoteID,
tcontent.RemotePubDate,tcontent.RemoteSource,tcontent.RemoteSourceURL,tcontent.RemoteURL,tcontent.responseChart,
tcontent.responseDisplayFields,tcontent.responseMessage,tcontent.responseSendTo,tcontent.Restricted,tcontent.RestrictGroups,
tcontent.searchExclude,tcontent.SiteID,tcontent.sortBy,tcontent.sortDirection,tcontent.Summary,tcontent.Target,
tcontent.TargetParams,tcontent.Template,tcontent.Title,tcontent.Type,tcontent.subType,tcontent.Path,tcontent.tags,
tcontent.doCache,tcontent.created,tcontent.urltitle,tcontent.htmltitle,tcontent.mobileExclude,tcontent.changesetID,
tcontent.imageSize,tcontent.imageHeight,tcontent.imageWidth,tcontent.childTemplate,tcontent.majorVersion,tcontent.minorVersion,tcontent.expires,tcontent.displayInterval,tcontent.objectParams
, tfiles.fileSize,
					tfiles.contentType, tfiles.contentSubType, tfiles.fileExt,tfiles.filename as assocFilename,
					tapprovalrequests.status as approvalStatus, tapprovalrequests.requestID,tapprovalrequests.groupid as approvalGroupID
					 from tcontent
					left join tfiles on (tcontent.fileid=tfiles.fileid)
					left join tapprovalrequests on (tcontent.contenthistid=tapprovalrequests.contenthistid)
					where
					tcontent.contenthistid in ('3B2BA4F7-FDA6-4C05-B10A730150FC2B1B','27B443A2-D603-4FC2-964AFECF4714082F','895CBA9C-5CC9-474C-81D52A5688719A05','CB72CCCF-990F-4575-8D788690221DAA01','7C27542F-866B-45EB-94D0304800419552','C8B42516-67A7-4394-90056E3DFD288FC9','A675F6B6-D8FC-4F9E-845095E67A8EBAC8','A90DEC9C-A5CF-4B51-8A863B2BE31ABEDF','D13C7D38-583B-42D5-B425763012E82C8D','8A60E4D2-E290-40F3-941BEFD256DB6CE8','35F3A7EE-7099-4613-B3138A91D03335B9','B3B54708-C243-4744-9D085B7D8B002E6C','BC284863-FCC3-42B8-82FFFCDFA9B37655','6C2BB92D-E407-41E8-A13D8773B559A43D','467132C6-9636-4652-92CC3BBA4A1596CB','E248A4F5-E1E5-4775-9BABBFF19497B2C4','306123DB-CF08-40E5-B62A3CD43DCABBC0','42D43F77-303E-40E2-B3D5333C57E2F506','3E4A59FC-3C89-42D2-B4F37F243901BFFD','931BE5B5-FA65-4303-BD741619257E70E3')

select * from rsPage where contenthistid='3B2BA4F7-FDA6-4C05-B10A730150FC2B1B'

select * from rsPage where contenthistid='27B443A2-D603-4FC2-964AFECF4714082F'

select * from rsPage where contenthistid='895CBA9C-5CC9-474C-81D52A5688719A05'

select * from rsPage where contenthistid='CB72CCCF-990F-4575-8D788690221DAA01'

select * from rsPage where contenthistid='7C27542F-866B-45EB-94D0304800419552'

select * from rsPage where contenthistid='C8B42516-67A7-4394-90056E3DFD288FC9'

select * from rsPage where contenthistid='A675F6B6-D8FC-4F9E-845095E67A8EBAC8'

select * from rsPage where contenthistid='A90DEC9C-A5CF-4B51-8A863B2BE31ABEDF'

select * from rsPage where contenthistid='D13C7D38-583B-42D5-B425763012E82C8D'

select * from rsPage where contenthistid='8A60E4D2-E290-40F3-941BEFD256DB6CE8'

select * from rsPage where contenthistid='35F3A7EE-7099-4613-B3138A91D03335B9'

select * from rsPage where contenthistid='B3B54708-C243-4744-9D085B7D8B002E6C'

select * from rsPage where contenthistid='BC284863-FCC3-42B8-82FFFCDFA9B37655'

select * from rsPage where contenthistid='6C2BB92D-E407-41E8-A13D8773B559A43D'

select * from rsPage where contenthistid='467132C6-9636-4652-92CC3BBA4A1596CB'

select * from rsPage where contenthistid='E248A4F5-E1E5-4775-9BABBFF19497B2C4'

select * from rsPage where contenthistid='306123DB-CF08-40E5-B62A3CD43DCABBC0'

select * from rsPage where contenthistid='42D43F77-303E-40E2-B3D5333C57E2F506'

select * from rsPage where contenthistid='3E4A59FC-3C89-42D2-B4F37F243901BFFD'

select * from rsPage where contenthistid='931BE5B5-FA65-4303-BD741619257E70E3'

Application Variables:
appAutoUpdated=false
appHandlerLookUp=Struct (2)
appInitialized=true
appInitializedTime={ts '2026-08-04 21:03:17'}
applicationname=mura88016B3EF0F06123D6478ACB205AFB16
appReloadKey=appreload
autoUpdater=Component (mura.autoUpdater.autoUpdater)
BADWORDS=
broadcastInit=true
categoryManager=Component (mura.category.categoryManager)
CFSTATIC=Struct (0)
CFVersion=2016
changesetManager=Component (mura.content.changeset.changesetManager)
CLASSEXTENSIONMANAGER=Component (mura.extend.extendManager)
clusterManager=Component (mura.cluster.clusterManager)
CONFIGBEAN=Component (mura.configBean)
contentGateway=Component (mura.content.contentGatewayLucee)
contentManager=Component (mura.content.contentManager)
contentRenderer=Component (mura.content.contentRenderer)
contentServer=Component (mura.content.contentServer)
contentUtility=Component (mura.content.contentUtility)
coreversion=7.1.505
dashboardManager=Component (mura.dashboard.dashboardManager)
dataCollectionManager=Component (mura.content.dataCollection.dataCollectionManager)
emailManager=Component (mura.email.emailManager)
ENCRYPTIONKEY=icObDJ/g07PCR+JbJ6hjKA==
eventManager=Component (mura.plugin.pluginManager)
favoriteManager=Component (mura.content.favorite.favoriteManager)
feedManager=Component (mura.content.feed.feedManager)
instanceID=9B5887A5-A267-45CF-98F9CA454E9D2D69
loginManager=Component (mura.login.loginManager)
mailinglistManager=Component (mura.mailinglist.mailinglistManager)
MURA=Component (mura.MuraScope)
muraExternalConfig=Struct (0)
OBJECTMAPPINGS=Struct (36)
permUtility=Component (mura.permission)
pluginManager=Component (mura.plugin.pluginManager)
PLUGINS=Struct (0)
raterManager=Component (mura.content.rater.raterManager)
RBFACTORY=Component (mura.resourceBundle.resourceBundleFactory)
scriptProtectionFilter=Component (mura.Portcullis)
SERVICEFACTORY=Component (mura.bean.beanFactory)
sessionTrackingManager=Component (mura.user.sessionTracking.sessionTrackingManager)
sessionTrackingThrottle=false
settingsManager=Component (mura.settings.settingsManager)
setupComplete=true
setupSubmitButton=AEC1B89157B4BD7E1B9AEA0803F8BA51E
setupSubmitButtonComplete=A54DD05474BE8D56993B27940C6C37B64
userManager=Component (mura.user.userManager)
utility=Component (mura.utility)

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=/home/examplen/public_html/careerspathway.binarydev.net/index.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=*/*
http_accept_encoding=gzip, br, zstd, deflate
http_accept_language=
http_connection=close
http_cookie=
http_host=careerspathway.binarydev.net
http_referer=
http_user_agent=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
https=on
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=178.159.5.243
local_host=greyhound.dnshostnetwork.com
path_info=
path_translated=/home/examplen/public_html/careerspathway.binarydev.net/index.cfm
query_string=
remote_addr=216.73.216.36
remote_host=216.73.216.36
remote_user=
request_method=GET
request_url=https://careerspathway.binarydev.net/index.cfm
script_name=/index.cfm
server_name=careerspathway.binarydev.net
server_port=443
server_port_secure=1
server_protocol=HTTP/1.1
server_software=
web_server_api=

Cookie Variables:
mobileFormat=false
MXP_TRACKINGID=1CDFC19C-439D-43B8-A0B479211E6AC959

Request Variables:
__muraresponse__=<!DOCTYPE html>
<html class="no-js" lang="en">
<head>
<!-- Google Tag Manager -->
<script>
(function(w,d,s,l,i){w[l]=w[l]||[];w[l].push({'gtm.start':
new Date().getTime(),event:'gtm.js'});var f=d.getElementsByTagName(s)[0],
j=d.createElement(s),dl=l!='dataLayer'?'&l='+l:'';j.async=true;j.src=
'https://www.googletagmanager.com/gtm.js?id='+i+dl;f.parentNode.insertBefore(j,f);
})(window,document,'script','dataLayer','GTM-M8874J3');
</script>
<!-- End Google Tag Manager -->
		
	
	<meta charset="UTF-8">
	<meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
	<title>Home -  Default</title>

	<meta name="apple-mobile-web-app-capable" content="yes" />
	<meta http-equiv="X-UA-Compatible" content="IE=Edge"/>

	

	<meta name="keywords" content="" />
	<meta name="description" content="" />

	<meta name="dcterms.creator" content="Medical Research Council, MRC" />
	<meta name="dcterms.date" content="20 Oct 2020" />
	<meta name="dcterms.publisher" content="Medical Research Council, Polaris House, North Star Avenue, Swindon, SN2 1ET, email websupport@headoffice.mrc.ac.uk" />
	<meta name="dcterms.rights" content="Copyright : Medical Research Council, https://mrc.ukri.org" />
	<meta name="dcterms.title" content="Home" />


	
		<meta name="viewport" content="width=device-width, initial-scale=1" />
	

	
	<script src="/sites/default/themes/MRC/js/jquery/jquery.js"></script>
	<!-- Modernizr -->
	<script src="/sites/default/themes/MRC/js/theme/modernizr.min.js"></script>

	<!-- Webfonts -->
	<script>
		var contentid='00000000000000000000000000000000001';
		(function() {
		  var wf = document.createElement('script');
		  wf.src = ('https:' == document.location.protocol ? 'https' : 'http') +
		  '://ajax.googleapis.com/ajax/libs/webfont/1/webfont.js';
		  wf.type = 'text/javascript';
		  wf.async = 'true';
		  var s = document.getElementsByTagName('script')[0];
		  s.parentNode.insertBefore(wf, s);
		})();

	</script>

	<!-- Stylesheets -->
	<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/core.css" />
	<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/grid990.css" media="screen and (min-width: 769px)" id="grid990" />
	<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/grid1140.css" media="screen and (min-width: 1200px)" />
	<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/grid990.css" media="print" />
	<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/print.css" media="print" />
	<link rel='stylesheet' href='/sites/default/themes/MRC/css/theme/paginatedForm.css' type='text/css'>

	<link rel='stylesheet' href='/sites/default/themes/MRC/css/bootstrap/search.bootstrap.lite.min.css' type='text/css'>
	<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.5.0/css/font-awesome.min.css">

	<!--[if lte IE 8]>
		<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/grid990.css" media="screen" />
		<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/ie/ie8.css" media="screen" />
		<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/grid1140.css" media="screen" />
	<![endif]-->

	<!--[if lte IE 7]>
		<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/ie/ie7.css" media="screen" />
	<![endif]-->

	<!--[if IE 6]>
		<link rel="stylesheet" href="/sites/default/themes/MRC/css/theme/ie/ie6.css" media="screen" />
		<script src="/sites/default/themes/MRC/js/theme/unitpngfix.js"></script>
	<![endif]-->

	
	<link rel="shortcut icon" href="/sites/default/themes/MRC/images/favicon.ico" />
	

	<script type="text/javascript">

		(function() {
		  var wf = document.createElement('script');
		  wf.src = ('https:' == document.location.protocol ? 'https' : 'http') +
		  '://ajax.googleapis.com/ajax/libs/webfont/1/webfont.js';
		  wf.type = 'text/javascript';
		  wf.async = 'true';
		  var s = document.getElementsByTagName('script')[0];
		  s.parentNode.insertBefore(wf, s);
		})();
	</script>

	
	
	

<script type="text/javascript" src="/core/modules/v1/core_assets/js/mura.min.js?v=7.1.505"></script>
<script>
Mura.init({
loginURL:"?display=login",
siteid:"default",
contentid:"00000000000000000000000000000000001",
contenthistid:"04158935-B65E-4595-84F57EA09F8E6761",
changesetid:"",
parentid:"00000000000000000000000000000000END",
context:"",
nocache:0,
assetpath:"/sites/default",
corepath:"/core",
fileassetpath:"/sites/default",
themepath:"/sites/default/themes/MRC",
reCAPTCHALanguage:"en",
preloaderMarkup: "\x0D\x0A\x20\x20\x20\x20\x20\x20\x3Cdiv\x20class\x3D\x22mrc\x2Dloader\x22\x3E\x0D\x0A\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20Loading,\x20please\x20wait...\x0D\x0A\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x3Cbr\x3E\x0D\x0A\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x3Cdiv\x20class\x3D\x22mrc\x2Dspin\x22\x3E\x0D\x0A\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x3Csvg\x20version\x3D\x221.1\x22\x20id\x3D\x22mrc\x2Dloader\x2D1\x22\x20xmlns\x3D\x22http\x3A\x2F\x2Fwww.w3.org\x2F2000\x2Fsvg\x22\x20xmlns\x3Axlink\x3D\x22http\x3A\x2F\x2Fwww.w3.org\x2F1999\x2Fxlink\x22\x20x\x3D\x220px\x22\x20y\x3D\x220px\x22\x20width\x3D\x2260px\x22\x20height\x3D\x2260px\x22\x20viewBox\x3D\x220\x200\x2040\x2040\x22\x20enable\x2Dbackground\x3D\x22new\x200\x200\x2040\x2040\x22\x20xml\x3Aspace\x3D\x22preserve\x22\x3E\x0D\x0A\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x3Cpath\x20opacity\x3D\x220.2\x22\x20id\x3D\x22mrc\x2Dloader\x2Dpath\x22\x20fill\x3D\x22\x23000\x22\x20d\x3D\x22M20.201,5.169c\x2D8.254,0\x2D14.946,6.692\x2D14.946,14.946c0,8.255,6.692,14.946,14.946,14.946\x20s14.946\x2D6.691,14.946\x2D14.946C35.146,11.861,28.455,5.169,20.201,5.169z\x20M20.201,31.749c\x2D6.425,0\x2D11.634\x2D5.208\x2D11.634\x2D11.634\x20c0\x2D6.425,5.209\x2D11.634,11.634\x2D11.634c6.425,0,11.633,5.209,11.633,11.634C31.834,26.541,26.626,31.749,20.201,31.749z\x22\x3E\x3C\x2Fpath\x3E\x0D\x0A\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x3Cpath\x20fill\x3D\x22\x236F217D\x22\x20id\x3D\x22mrc\x2Dloader\x2Dmarker\x22\x20d\x3D\x22M26.013,10.047l1.654\x2D2.866c\x2D2.198\x2D1.272\x2D4.743\x2D2.012\x2D7.466\x2D2.012h0v3.312h0\x20C22.32,8.481,24.301,9.057,26.013,10.047z\x22\x20transform\x3D\x22rotate\x28351.328\x2020\x2020\x29\x22\x3E\x3C\x2Fpath\x3E\x0D\x0A\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x3C\x2Fsvg\x3E\x0D\x0A\x20\x20\x20\x20\x20\x20\x20\x20\x20\x20\x3C\x2Fdiv\x3E\x0D\x0A\x20\x20\x20\x20\x20\x20\x3C\x2Fdiv\x3E\x0D\x0A\x20\x20",
mobileformat: false,
windowdocumentdomain: "",
layoutmanager:true,
type:"Page",
subtype:"Default",
queueObjects: true,
rb:{"formrequiredwrapperclass":"","formradiolabelclass":"radio","formresponsewrapperclass":"","formwrapperclass":"well","formbuttoncancellabel":"Cancel","formselectclass":"form-control","formbuttonclass":"btn btn-default","formfileclass":"form-control","formbuttonwrapperclass":"btn-group","formbuttoninnerclass":"","formcheckboxwrapperclass":"","formradiowrapperclass":"","formcheckboxlabelclass":"checkbox","formbuttonnextlclass":"form-nav","forminputclass":"form-control","formradioclass":"","formcheckboxclass":"","formfieldlabelclass":"control-label","formtextareaclass":"form-control","formbuttonbacklabel":"Back","formbuttonsubmitclass":"form-submit  btn-primary","formbuttonsubmitlabel":"Submit","formrequiredlabel":"Required","generalwrapperclass":"well","formbuttonnextlabel":"Next","generalwrapperbodyclass":"","formbuttomsubmitclass":"form-submit  btn-primary","formbuttonbackclass":"form-nav","formerrorwrapperclass":"","formbuttoncancelclass":"form-cancel btn-primary pull-right","formwrapperbodyclass":"","formbuttonsubmitwaitlabel":"Please Wait...","formgeneralcontrolclass":"form-control","formfieldwrapperclass":"control-group"},
dtExample:"10/11/2024",
dtCh:"/",
dtFormat:[1,0,2],
dtLocale:"en-GB"
});
</script></head>


	<body id="homepage home" class="sysHome dna1 mrc-layout-one-column">
<!-- Google Tag Manager (noscript) -->
<noscript><iframe src="https://www.googletagmanager.com/ns.html?id=GTM-M8874J3"
height="0" width="0" style="display:none;visibility:hidden"></iframe></noscript>
<!-- End Google Tag Manager (noscript) -->
		
		
	

	
	<header>
		<div class="wrap">
	      <a href="/" class="logo">
	        <div data-picture="" data-alt="MRC - Medical Research Council">
	          <div data-src="/sites/default/themes/MRC/images/template/desktop/logo.png"></div>
	          <div data-src="/sites/default/themes/MRC/images/template/mobile/low-res/logo.png" data-media="(max-width: 767px)"></div>
	          <div data-src="/sites/default/themes/MRC/images/template/mobile/high-res/logo.png" data-media="(max-width: 768px) and (min-device-pixel-ratio: 1.5) and (-webkit-min-device-pixel-ratio: 1.5)">
	          </div> <!-- picture -->
	          <noscript>
	            <img src="/sites/default/themes/MRC/images/template/desktop/logo.png" alt="MRC - Medical Research Council" />
	          </noscript>
	        <img alt="MRC - Medical Research Council" src="/sites/default/themes/MRC/images/template/desktop/logo.png" />
	        </div>
	        <span></span>
	      </a>


				<div class="mobileNav">
					























 




  
   



	
	

	
		<button class="menu c-menu__toggle c-toggle c-modal-bg__foreground" data-toggle-open=".c-menu, .c-menu__toggle" href="#" class="menu">
			<span class="c-toggle__open">Menu</span>
			<span class="c-toggle__close">Close</span>
		</button>
		<nav class="c-menu c-model-bg__container">
			<ul><li><form role="search" class="c-menu__mobile-search-form" action="/search-results/">
		<fieldset style="display: block;">
			<input type="text" name="keywords" id="searchKeywordsHeader" placeholder="What are you looking for?" value="" class="c-menu__mobile-search-form--input" autocomplete="off">
			<input type="submit" value="Go" class="submit">
			<input type="hidden" name="siteid" id="siteidHeader" value="mrc">
		</fieldset>
	</form></li>
			
				<ul>
					
						<li class="c-menu__item">
							<a class="c-menu__link" data-contentid="00000000000000000000000000000000001" href="/">MRC Home</a>
						</li>
					
					
				</ul>
			
		
		</nav>
	
























 







				</div>

	      <nav class="secondary">
	        <ul>
						
							<li><a href="#content-start">Skip to content</a></li>
						
		        
		        
						
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/andrew-steele/">Andrew Steele</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/">Explore career and funding options - Interactive career framework</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/about-us/">About us</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/publications/">Publications</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/news/">News</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/">Skills & Careers</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/innovation/">Innovation</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/our-successes/">Our successes</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/research/">Research</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/funding/">Funding</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/professor-john-ainsworth/career-highlights/">Career highlights</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/professor-john-ainsworth/further-information/">Further information</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/javier-herrero/further-information/">Further information</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/professor-john-ainsworth/words-of-wisdom/">Words of wisdom</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/sera-aylin-cakiroglu/further-information/">Further information</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/dr-nessa-carey/further-information/">Further information</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/professor-john-ainsworth/next-steps/">Next steps</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/sara-wells/skills-and-next-steps/">Skills and next steps</a></li>
	            
		          	
		          	<li><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/dr-nessa-carey/final-word/">Final word</a></li>
	            
		          	
		          	<li class="omega"><a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/sara-wells/further-information/">Further information</a></li>
	            
						
	        </ul>
	      </nav>  <!-- secondary -->

	    <form action="/index.cfm/search-results/" id="searchForm">
				<fieldset>
					<legend style="display:none;">Site search</legend>
					<input type="text" id="textSearch" title="Search site" class="text" name="keywords" onfocus="if(this.value == 'Search this site...') { this.value = ''; }" value="Search this site...">
					<input type="submit" value="Go" class="submit">
					<input type="hidden" name="display" value="search">
					<input type="hidden" name="newSearch" value="true">
					<input type="submit" class="submit" value="Go" style="display: none;">
				</fieldset>
		  </form>

		  

	      
	    </div> <!-- wrap -->


		<div class="container">
			
	<nav class="primary">
	      <div class="wrap">
	      	

		      























 




  
   



					

			
				

				
				<ul id="navPrimary" class="nav nav-4CF82B78A7F93BD68BFD9E9ED359DF04">
				<li class="first active" id="navHome"><a href="/" class="active">Home</a></li>
			

			
			
			

			
			<li id="navFunding"><a href="/index.cfm/funding/">Funding</a></li>
			
			
			

			
			<li id="navResearch"><a href="/index.cfm/research/">Research</a></li>
			
			
			

			
			<li id="navOurSuccesses"><a href="/index.cfm/our-successes/">Our successes</a></li>
			
			
			

			
			<li id="navInnovation"><a href="/index.cfm/innovation/">Innovation</a></li>
			
			
			

			
			<li id="navSkillsCareers"><a href="/index.cfm/skills-careers/">Skills &amp; Careers</a>

			

			
			
			

			
				
				
				<ul>
			
			<li class="last first" id="navExploreCareerAndFundingOptions"><a href="/index.cfm/skills-careers/interactive-career-framework/">Explore career and funding options</a></li>
			
			</ul>
			</li>
			
			
			

			
			<li id="navNews"><a href="/index.cfm/news/">News</a></li>
			
			
			

			
			<li id="navPublications"><a href="/index.cfm/publications/">Publications</a></li>
			
			
			

			
			<li class="last" id="navAboutUs"><a href="/index.cfm/about-us/">About us</a></li>
			
			</ul>
			
				























 






	      </div> <!-- wrap -->
	</nav> <!-- primary -->
	</div>
	<div class="clear"></div>
</header>


      		<div id="content">
      			<div class="wrap">
      				<section class="intro">
	      				
	      				<div class="introTitle"></div>
      				</section>
      				



							

					<div class="primary sysDefault">

						<section class="module text">

						

						

						

						
		
		
		
			
				
				 
				 	
						<h1 class="pageTitle">Home</h1>
					
					
					
				

				
				

				
					
						
						
							
								<div class="mura-region mura-region-loose">
					<div class="mura-region-local"></div>
					</div>
							
						
					
					
	
	
		
		
		
			
				
					
				
			
		
	
	
	
				
			
		
	

						
						</section>
				    </div>
					<div class="clear"></div>
			    </div> <!-- wrap -->
			
	<footer class="neurons">
		<div class="connect-footer">
			<div class="wrap home-grid">
				<div class="connect-footer--social">
					<h3>Connect with us</h3>
					<ul>
						<li class="social youtube"><a href="http://www.youtube.com/user/MRCcomms">YouTube</a></li>
						<li class="social twitter"><a href="http://twitter.com/The_MRC">Twitter</a></li>
						<li class="social scoop"><a href="https://www.scoop.it/t/medical-research-by-mrc-inthe-news">it!</a></li>
						<li class="social facebook"><a href="https://www.facebook.com/MRCComms">Facebook</a></li>
					</ul>
				</div>
				<div class="connect-footer--newsletter">
					<h3>Keep up-to-date with our newsletter</h3>
					<form action="https://public.govdelivery.com/accounts/UKMRC/subscribers/qualify" id="invite" method="POST">
							<input name="authenticity_token" type="hidden" value="MmAlfuVYPVa7cd9cDIedbF9gcs8Zh5Y4DFDW/btG+fE=" />
							<input class="email-input" type="text" placeholder="Enter your email" name="email" id="address" title="Email address" />
							<button type="submit">Sign me up</button>
					</form>
				</div>
			</div>
		</div>
	    <div class="white-bar">
	      <div class="wrap">
	        
	        
	        
		        <section class="links">
		          <p>
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/andrew-steele/">Andrew Steele</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/">Explore career and funding options - Interactive career framework</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/about-us/">About us</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/publications/">Publications</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/news/">News</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/">Skills & Careers</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/innovation/">Innovation</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/our-successes/">Our successes</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/research/">Research</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/funding/">Funding</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/professor-john-ainsworth/career-highlights/">Career highlights</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/professor-john-ainsworth/further-information/">Further information</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/javier-herrero/further-information/">Further information</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/professor-john-ainsworth/words-of-wisdom/">Words of wisdom</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/sera-aylin-cakiroglu/further-information/">Further information</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/dr-nessa-carey/further-information/">Further information</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/professor-john-ainsworth/next-steps/">Next steps</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/sara-wells/skills-and-next-steps/">Skills and next steps</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/dr-nessa-carey/final-word/">Final word</a> | 
			         
					     	
						 		<a href="https://careerspathway.binarydev.net/index.cfm/skills-careers/interactive-career-framework/case-studies/sara-wells/further-information/">Further information</a>
			         
		         </p>
		        </section>
	        
	      </div>
	    </div>
	    <div class="wrap">
				<div class="higherOrgs">
					<a href="https://www.ukri.org/"><img src="/sites/default/themes/MRC/images/ukri-logo.png" alt="UK Research and Innovation" /></a>
				</div> <!-- higherOrgs -->
        <div class="copyright">
          <p>Copyright 2026. Medical Research Council</p>
				</div> <!-- copyright -->
	    </div>
  </footer>


		    </div><!-- content -->
		

	<script src="/sites/default/themes/MRC/js/theme/styling.js"></script>
	<script src="/sites/default/themes/MRC/js/theme/bv-jquery-a11y-menu.js"></script>
	<script src="/sites/default/themes/MRC/js/theme/jquery.flexslider.js"></script>
  <script src="/sites/default/themes/MRC/js/theme/picturefill.js"></script>
  <script src="/sites/default/themes/MRC/js/theme/jquery.adaptivetext.js"></script>
  <script src="/sites/default/themes/MRC/js/theme/jquery.easing.js"></script>
  <script src="/sites/default/themes/MRC/js/theme/flexslider-functions.js"></script>
	<script src="/sites/default/themes/MRC/js/theme/modernizr.functions.js"></script>
  <script src="/sites/default/themes/MRC/js/theme/application.min.js"></script>
  <script src="/sites/default/themes/MRC/js/theme/resizer.min.js"></script>
  <script src="/sites/default/themes/MRC/js/theme/cookies.js"></script>
	<script src="/sites/default/themes/MRC/js/theme/fancyfields-1.2.min.js"></script>
	<script src="/sites/default/themes/MRC/js/theme/google_analytics_tagging.js"></script>
	<script src="/sites/default/themes/MRC/js/paginatedForm/paginatedForm.js"></script>
	<script src="/sites/default/themes/MRC/js/theme/lunametrics-youtube.gtm.min.js"></script>
	<script src="//cdnjs.cloudflare.com/ajax/libs/jquery.imagesloaded/4.0.0/imagesloaded.pkgd.min.js"></script>
	<script src="//cdnjs.cloudflare.com/ajax/libs/jquery.matchHeight/0.7.0/jquery.matchHeight-min.js"></script>

    <div id="clonebag-latestupdates" style="display:none;"></div>
    <div id="clonebag-keyfacts" style="display:none;"></div>



	<script>

		$(document).ready(function() {

			$("#content .primary form:not('#invite, #filters, .no-ff ')").not(".wp-comment-form").fancyfields();
			$("#content .primary .text blockquote").prepend("<span>&ldquo;</span>");
			if (getCookie('desktop_format')){
				$('span.mobileLink').show();
				$('link#grid990').attr('media', 'screen');
				$('#navHome a').css('padding','0 17px 0 16px')
			}else if (getCookie('desktop_format') == 0){
				$('span.desktopLink').show();
			}
			$(".primary .text img").each(function(){
				if(this.title.length && $(this).parents(".wp-caption").length === 0){
          if (!$(this).parent().text().trim().length){
             $(this).unwrap('p');
          }
					$(this).wrap('<div class="imageWrap"></div>');
					if ($(this).css('float') == 'left'){
						$(this).parent().addClass('imageWrap--left');
					}
					if ($(this).css('float') == 'right'){
						$(this).parent().addClass('imageWrap--right');
					}
					var title = this.title;
					var width = this.width;
					var width = width - 20;
					$(this).after('<div class="caption" style="width:'+ width +'px">'+ title +'</div>');
				}
			});

			var linkSelectorStr = '.primary p a, .wrap aside p a, .col-right p a, .primary li a, .primary td a ';
			var linkExcluderStr = '.home-col li a, .primary p img a, .primary .fcPagination li a, .wrap aside p.showAllFundingCalls a, .primary .pagination li a, .featurePageCarousel .slides>li>a, .primary .dataTable td a';
			$(linkSelectorStr).not(linkExcluderStr).filter(function() {
			    return this.hostname && this.hostname !== location.hostname;
			}).addClass('external link');

			$(linkSelectorStr).not(linkExcluderStr).filter(function() {
			    return this.hostname && this.hostname == location.hostname;
			}).addClass('internal link');
			$('.internal.link').has('img').removeClass('internal link');
			// flag items in links folder as external links
			$('a[href*="\/links\/"].internal.link').removeClass('internal').addClass('external');

			$('a.external.link').on('click', function() {
				trackOutboundLink($(this).text(),$(this).attr('href'),$(this).attr('target'));
			})
		  $( "a" ).click(function() {
		   	  $("a").removeClass("selected");
		      $(this).addClass("selected");
		  });

			var trackOutboundLink = function(text, url, target) {
				 ga('send', 'event', 'outbound', text, url, {
				 'transport': 'beacon',
					 'hitCallback': function(){
						 if(target != '_blank'){
							document.location = url;
						}
					 }
				 });
			};

		});

</script>

<script type="text/javascript">
	/*<![CDATA[*/
	(function() {
	var sz = document.createElement('script'); sz.type = 'text/javascript'; sz.async = true;
	var s = document.getElementsByTagName('script')[0]; s.parentNode.insertBefore(sz, s);
	})();
	/*]]>*/
</script>


	<script type="text/javascript">
	$next = 1;			// fixed, please do not modfy;
	$current = 0;		// fixed, please do not modfy;
	$interval = 15000;	// You can set single picture show time;
	$fadeTime = 1200;	// You can set fadeing-transition time;
	$imgNum = 6;		// How many pictures do you have

	$(document).ready(function(){
		//NOTE : Div Wrapper should with css: relative;
		//NOTE : img should with css: absolute;
		//NOTE : img Width & Height can change by you;
		$('.fadeImg').css('position','relative');
		$('.fadeImg .toFade').css({'position':'absolute'});

		nextFadeIn();
	});

	function nextFadeIn(){
		//make image fade in and fade out at one time, without splash vsual;
		$('.fadeImg .toFade').eq($current).delay($interval).fadeOut($fadeTime)
		.end().eq($next).delay($interval).hide().fadeIn($fadeTime, nextFadeIn);

		// if You have 5 images, then (eq) range is 0~4
		// so we should reset to 0 when value > 4;
		if($next < $imgNum-1){ $next++; } else { $next = 0;}
		if($current < $imgNum-1){ $current++; } else { $current =0; }
	};
</script>


	
<script src="//careerspathway.binarydev.net/core/modules/v1/cta/js/mura.displayobject.cta.min.js" ></script></body>
</html>
alttheme=
backported=true
backports=Struct (1)
bodyrenderargs=Array (13)
cacheitem=true
cacheitemtimespan=
categoryid=
contentbean=Component (mura.content.contentBean)
contentrenderer=Component (muraWRM.sites.default.contentRenderer)
crumbdata=Array (1)
currentfilename=
currentfilenameadjusted=
currentuser=Component (mura.user.sessionUserFacade)
custommurascopekeys=Struct (0)
display=
doaction=
domuraglobalsessionstart=true
exporthtmlsite=0
forcecache=false
forcessl=0
handlerfactory=Component (mura.plugin.pluginStandardEventFactory)
hascfapplicationcfm=true
htmlfootqueue=Array (1)
htmlheadqueue=Array (1)
inheritedobjects=04158935-B65E-4595-84F57EA09F8E6761
isondisplay=1
keywords=
linkservid=
localhandler=Component (muraWRM.sites.default.eventHandler)
mlid=
month=8
mura404=false
muraactiveregions=
muraadminrequest=false
muraallowcomments=1
muraapirequest=false
muraappreloaded=false
muracachingoutput=false
murachangesetpreview=false
murachangesetpreviewtoolbar=false
muradynamiccontenterror=false
muraexporthtml=false
muraforcefilename=true
murafrontendrequest=true
murahandledevents=Struct (23)
muraindocker=0
muramobilerequest=false
muramobiletemplate=false
muramostrecentpluginmoduleid=
muraoutputcacheoffset=
murapointintime=
murapreviewdomain=
muraregionid=0
murarequeststart=1786075085701
murascope=Component (mura.MuraScope)
murasessionmanagement=true
murashowtrace=false
murasiteidinurl=false
murasiteidredirect=false
murasysenv=Struct (30)
muratemplatemissing=false
muratraceroute=Array (1)
muratransaction=0
muravalidatedomain=true
nocache=0
org.apache.catalina.AccessLog.Protocol=HTTP/1.1
org.apache.catalina.AccessLog.RemoteAddr=216.73.216.36
org.apache.catalina.AccessLog.RemoteHost=216.73.216.36
org.apache.catalina.AccessLog.ServerName=careerspathway.binarydev.net
org.apache.catalina.AccessLog.ServerPort=443
org.apache.tomcat.remoteAddr=216.73.216.36
org.apache.tomcat.request.forwarded=true
pagenum=1
path=/default//
preformated=true
purgecache=false
r=Struct (6)
relatedid=
remoteaddr=216.73.216.36
returnformat=html
returnurl=
servletevent=Component (mura.servletEvent)
showmeta=0
siteid=default
startrow=1
tag=
themepath=/sites/default/themes/MRC
track=0
tracksession=false
useragent=mozilla/5.0 applewebkit/537.36 (khtml, like gecko; compatible; claudebot/1.0; +claudebot@anthropic.com)
year=2026

Server Variables:
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.0.6=Complex type
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.1.1=Complex type
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.1.2=Complex type
CACHE=Struct (188)
CACHE_TIMESTAMPS=Struct (188)
cbox-javaloader-1B50254DE719A76B2ADC708B9F6D56EE=Component (modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-52B877CA0494DF462AFAE4B19932AA27=Component (modules.contentbox.modules.contentbox-deps.modules.cbmarkdown.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-554E0B2DF76810BDA83FB33DA8A8ABE9=Component (modules.contentbox.modules.contentbox-deps.modules.cbmarkdown.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-757114FCCFB5C490D952526BFDF3987E=Component (modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-7C624209BA64FDFA88C5C8208DA20E5C=Component (modules.quick.modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-8E03551109DB0559698D811C86B103EB=Component (modules.contentbox.modules.contentbox-deps.modules.cbmarkdown.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-AEAAE1EF90B4BB57161501BD525097AE=Component (modules.BCrypt.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-D3D5EEDE3F35A4658B10897E5F82E29A=Component (modules.relax.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-D98F90619134ECE764EC062DCA91FCE0=Component (modules.quick.modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-DDCEE58D59F22F146C90D6E97C07CA45=Component (modules.relax.modules.cbjavaloader.models.javaloader.JavaLoader)
cbox-javaloader-F4E336252BF14F02E265FDC3C6BA95E1=Component (modules.quick.modules.str.modules.cbjavaloader.models.javaloader.JavaLoader)
coldfusion=Struct (9)
java=Struct (8)
LOGIN_BRIDGE=Struct (0)
lucee=Struct (8)
os=Struct (8)
PRODSTRUCT=Struct (1)
RECENT_ORDERS=Array (16)
separator=Struct (3)
servlet=Struct (1)
system=Struct (2)
ZONESTR=Struct (0)

Session Variables:
blockLoginUntil=
cfid=1947585a-cf66-448a-8672-8374d8c9cd48
cftoken=0
DATEKEY=<script type="text/javascript">var dtExample="10/11/2024", dtCh="/", dtFormat =[1,0,2], dtLocale="en-GB";</script>
DATEKEYFORMAT=DD/MM/YYYY
lastvisit={ts '2026-08-07 03:58:05'}
LOCALE=en_GB
LOCALEHASDAYPARTS=0
loginAttempts=0
mura=Struct (20)
muraSessionID=1CDFC19C-439D-43B8-A0B479211E6AC959
muraTrackingID=1CDFC19C-439D-43B8-A0B479211E6AC959
rb=en_US
rememberMe=0
sessionid=mura88016B3EF0F06123D6478ACB205AFB16_1947585a-cf66-448a-8672-8374d8c9cd48_0
siteid=default
timecreated={ts '2026-08-07 03:58:05'}
urltoken=CFID=1947585a-cf66-448a-8672-8374d8c9cd48&CFTOKEN=0
USERFILESPATH=/sites/default/assets/

URL Variables:
path=/default//