SELECT 
cb.ContentBlockID as id,
convert(varchar(38), cb.ContentBlockID) as myid,
cb.ContentBlockName as title,
Cast(cb.HTMLContent AS Varchar(2000)) as description, 
Cast(t.TeaserText AS Varchar(800)) as teaser,
cb.display as published,
SPACE(2) AS filelocation,
SPACE(2) as categoryid,
CAST('text' AS char(8)) as mytype,
convert(varchar(20), cb.Display, 111) AS GroupDate,
SPACE(2) AS previewimage,
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
 		
	  Year(Display) = 2017
		AND Month(Display) = 7
		AND Day(Display) = 2
	 
	AND ct.CategoryCode LIKE 'NEWS'
	AND (cb.Status = 60 OR cb.Status = 80)
	
UNION ALL
SELECT
	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 Year(published) = 2017
		AND Month(published) = 7
		AND Day(published) = 2 

UNION ALL
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 Year(ApprovedDate) = 2017
		AND Month(ApprovedDate) = 7
		AND Day(ApprovedDate) = 2 


Order By published DESC, sortorder DESC

SELECT DISTINCT Year(Display) as year
from vwContentBlock cb INNER JOIN ContentType ct
	ON cb.ContentTypeCode = ct.ContentTypeCode
WHERE ct.CategoryCode LIKE 'NEWS'
	AND (cb.Status = 60 OR cb.Status = 80)
	AND Year(Display) > 2002
Order By Year(Display)

SELECT DISTINCT Month(Display) as month
from vwContentBlock cb INNER JOIN ContentType ct
	ON cb.ContentTypeCode = ct.ContentTypeCode
WHERE ct.CategoryCode LIKE 'NEWS'
		AND (cb.Status = 60 OR cb.Status = 80)
		AND Year(Display) = 2017
Order BY Month(Display)

SELECT DISTINCT Day(Display) as days
from vwContentBlock cb INNER JOIN ContentType ct
	ON cb.ContentTypeCode = ct.ContentTypeCode
WHERE  ct.CategoryCode LIKE 'NEWS'
	AND (cb.Status = 60 OR cb.Status = 80)
		AND Year(Display) = 2017
		AND Month(Display) = 7

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 02:48:21'} ANd ApprovedDate > {ts '2025-11-28 02:48:21'} 

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 02:00:00'} 
ORDER BY published DESC

SELECT *
	FROM qryWidgets
	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=CFTOKEN=2a30ab0924f1d26f-AC53409E-C423-9CAE-C6628181FCD0EFE7; CFID=5128474; JSESSIONID=69FACAF85FFDF838EC71D07FF294E08E.cfusion
HTTP_HOST=www.aero-news.net
HTTP_REFERER=
HTTP_URL=/Subscribe.cfm?do=main.archive&month=7&year=2017
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.archive&month=7&year=2017
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=5128474
CFTOKEN=2a30ab0924f1d26f-AC53409E-C423-9CAE-C6628181FCD0EFE7
JSESSIONID=69FACAF85FFDF838EC71D07FF294E08E.cfusion

Session Variables:
sessionid=69FACAF85FFDF838EC71D07FF294E08E.cfusion
urltoken=CFID=5128474&CFTOKEN=2a30ab0924f1d26f-AC53409E-C423-9CAE-C6628181FCD0EFE7&jsessionid=69FACAF85FFDF838EC71D07FF294E08E.cfusion

URL Parameters:
do=main.archive
month=7
year=2017