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 08:02:46'} OR Display IS NULL)

SELECT HTMLContent
FROM ContentBlockLive
WHERE ContentBlockKey = 'ANNOUNCE' 
	AND Status = 60 
	AND ((Display <{ts '2025-12-02 08:00:00'} OR Display IS NULL) 
	AND (Expire > {ts '2025-12-02 08: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 08:00:00'} ANd ApprovedDate > {ts '2025-11-28 08: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 08: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=
HTTP_HOST=www.aero-news.net
HTTP_REFERER=
HTTP_URL=/subscribe.cfm?do=main.textpost&id=E36AD274-A64B-443A-B08D-D9E144A20468
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=E36AD274-A64B-443A-B08D-D9E144A20468
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=5176384
CFTOKEN=dc7b32c34b510f08-B791B2AB-EB7D-7FB5-0CDD9CBBCFB26B59

Session Variables:
sessionid=9B0218179F772873AA34226E7FC84291.cfusion
urltoken=CFID=5176384&CFTOKEN=dc7b32c34b510f08-B791B2AB-EB7D-7FB5-0CDD9CBBCFB26B59&jsessionid=9B0218179F772873AA34226E7FC84291.cfusion

URL Parameters:
do=main.textpost
id=E36AD274-A64B-443A-B08D-D9E144A20468