SELECT
	cb.ContentBlockID as id,
	cb.ContentBlockName as title,
	cb.Display,
	ct.DisplayTemplate,
	cb.HTMLContent as description,
	cb.ForumCode,
	cb.Icon,
	convert(varchar(20), cb.Display, 111) AS GroupDate,
	t.TeaserText as teaser,
	cb.SortOrder
FROM
	vwContentBlock cb INNER JOIN ContentType ct
	ON cb.ContentTypeCode = ct.ContentTypeCode
	LEFT OUTER JOIN Teaser t
	ON cb.ContentBlockID = t.ContentBlockID AND t.TeaserType <> 'L'
WHERE
	cb.ContentBlockID = ?
	AND Status IN ('60','80') AND (Display <{ts '2025-12-02 00:30:27'} OR Display IS NULL)

SELECT HTMLContent
FROM ContentBlockLive
WHERE ContentBlockKey = 'ANNOUNCE' 
	AND Status = 60 
	AND ((Display <{ts '2025-12-02 00:00:00'} OR Display IS NULL) 
	AND (Expire > {ts '2025-12-02 00:00:00'} OR Expire IS NULL))

SELECT NewID() as id,
	CAST(episodesid AS VARCHAR(38)) as myid,
	title,
	CAST(subtitle  AS Varchar(800)) as teaser, 
	CAST(summary AS Varchar(2000)) as description,
	ApprovedDate as published,
	episodefile as filelocation, 
	podcastsid as categoryid,
	CAST('audio' AS char(8)) as mytype,
	ApprovedDate as GroupDate,
	SPACE(2) AS previewimage,
	0 AS sortorder
FROM episodes
	WHERE Approved = 1 
		
	AND ApprovedDate <{ts '2025-12-02 00:00:00'} ANd ApprovedDate > {ts '2025-11-28 00:00:00'} 

Order By published DESC, sortorder DESC

SELECT TOP 3
videoId as id, 
	convert(varchar(38), videoId) as myid, 
	title, 
	CAST(description AS Varchar(2000)) as description, 
	Cast(teaser AS Varchar(800))as teaser,
	published,
	filelocation, 
	categoryid,
	CAST('video' AS char(8)) as mytype,
	published as GroupDate,
	previewimage,
	0 AS sortorder
	
FROM Videos
WHERE active = 1 AND approved = 1 AND published <{ts '2025-12-02 00:00:00'} 
ORDER BY published DESC

SELECT *
	FROM qryWidgets
	WHERE wname IN('flashAd','today','search','podcasts','topvideos','adsection234')
	ORDER By sortorder

SELECT 
			ContentTypeName, ContentTypeCode
		FROM ContentType 
		WHERE CategoryCode = 'NEWS' AND CONTENTTYPECODE <> 'ATRVNW'
		ORDER BY ContentTypeName

SELECT 
			ContentTypeName, ContentTypeCode
		FROM ContentType 
		WHERE CategoryCode = 'NEWS'
		ORDER BY ContentTypeName

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=C:\inetpub\wwwroot\clients\aero-news.net\subscribe.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=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=CFID=5099184; CFTOKEN=bda00f9756a8358e-A764B86C-9E28-5BCB-92E3ADE66CD7501E; JSESSIONID=9558F98C2C8D9159F54DA9296337B969.cfusion
HTTP_HOST=www.aero-news.net
HTTP_REFERER=
HTTP_URL=/subscribe.cfm?do=main.textpost&id=03B4B60E-59E5-420E-8962-623DACA33029
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=10.0.20.10
PATH_INFO=
PATH_TRANSLATED=C:\inetpub\wwwroot\clients\aero-news.net\subscribe.cfm
QUERY_STRING=do=main.textpost&id=03B4B60E-59E5-420E-8962-623DACA33029
REMOTE_ADDR=10.0.20.1
REMOTE_HOST=10.0.20.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/subscribe.cfm
SERVER_NAME=www.aero-news.net
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=5099184
CFTOKEN=bda00f9756a8358e-A764B86C-9E28-5BCB-92E3ADE66CD7501E
JSESSIONID=9558F98C2C8D9159F54DA9296337B969.cfusion

Session Variables:
sessionid=9558F98C2C8D9159F54DA9296337B969.cfusion
urltoken=CFID=5099184&CFTOKEN=bda00f9756a8358e-A764B86C-9E28-5BCB-92E3ADE66CD7501E&jsessionid=9558F98C2C8D9159F54DA9296337B969.cfusion

URL Parameters:
do=main.textpost
id=03B4B60E-59E5-420E-8962-623DACA33029