SELECT * FROM 	authors
	WHERE	AuthorUsername	 = 'xxx-xxx'

SELECT *
	FROM categories
	WHERE CategoryID = '2'

SELECT *
	FROM Newspapers
	WHERE NewspaperID = '1561'

SELECT *
	FROM P3_tPublications
	WHERE PUB_PublicationID = 'mbC'

SELECT *
	FROM Sites
	WHERE Name LIKE '%MyBayCity.com%'

SELECT *
	FROM Newspapers
	WHERE ActivatedDate IS NOT NULL
	AND NPR_PublicationID = 'mbC'
	ORDER BY NewspaperID DESC

SELECT * from Subscribers
		WHERE subscriberid ='9191919'

SELECT	* FROM Banners
		WHERE ExpDate > '2021-09-20'
		  AND Banner_Type = 'W'
		ORDER BY StartDate

SELECT	*
		FROM Banners
		WHERE BannerUserName = 'freedom'

SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = 'freedom'
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-20'

SELECT *
		FROM Categories
		WHERE CategoryID = '002'

SELECT *
		FROM Categories
		WHERE CategoryID = '003'

SELECT *
		FROM Categories
		WHERE CategoryID = '004'

SELECT *
		FROM Categories
		WHERE CategoryID = '006'

SELECT *
		FROM Categories
		WHERE CategoryID = '009'

SELECT *
		FROM Categories
		WHERE CategoryID = '012'

SELECT *
		FROM Categories
		WHERE CategoryID = '017'

SELECT *
		FROM Categories
		WHERE CategoryID = '019'

SELECT *
		FROM Categories
		WHERE CategoryID = '039'

SELECT *
		FROM Categories
		WHERE CategoryID = '074'

SELECT *
		FROM Categories
		WHERE CategoryID = '083'

SELECT	*
		FROM Banners
		WHERE ExpDate > '2021-09-20'
		ORDER BY StartDate

SELECT	*
		FROM Banners
		WHERE BannerUserName = 'xxxxxx'

SELECT *
	FROM articles
	WHERE ArticleID = '07616'

SELECT *
	FROM authors
	WHERE AuthorUsername = 'admin'

SELECT *
	FROM categories
	WHERE CategoryID = '2'

SELECT *
			FROM bodytext
			WHERE ArticleID = '07616'
			  and BodyIndex = '1'

SELECT *
	FROM articles
	WHERE CategoryID = '2'
	  AND Approved = 'Approved'
	  AND ArticleDate > '2021-03-20'
	ORDER BY ArticleDate desc

SELECT	*
		FROM Banners
		WHERE ExpDate > '2021-09-20'	
		  AND Banner_Type = 'W'
		ORDER BY StartDate

SELECT	*
		FROM Banners
		WHERE BannerUserName = 'xxxxxx'

SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-20'

SELECT	*
		FROM Banners
		WHERE BannerUserName = 'xxxxxx'

SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-20'

SELECT *
	FROM P3_tPublications
	Order by PUB_PublicationID

SELECT *
	FROM P3_tPublications
	ORDER BY PUB_PublicationID

SELECT *
	FROM P3_tPublications
	ORDER BY PUB_PublicationID

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Frankenmuth'
		  and tLOG_Date = '2021-09-19'

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Frankenmuth'
			  and tLOG_Date >= '2021-08-19'

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Freeland'
		  and tLOG_Date = '2021-09-19'

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Freeland'
			  and tLOG_Date >= '2021-08-19'

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Gower'
		  and tLOG_Date = '2021-09-19'

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Gower'
			  and tLOG_Date >= '2021-08-19'

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'MBC'
		  and tLOG_Date = '2021-09-19'

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'MBC'
			  and tLOG_Date >= '2021-08-19'

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'MTCN'
		  and tLOG_Date = '2021-09-19'

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'MTCN'
			  and tLOG_Date >= '2021-08-19'

SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Pinconning'
		  and tLOG_Date = '2021-09-19'

SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Pinconning'
			  and tLOG_Date >= '2021-08-19'

SELECT *
	FROM P3_tLog
	WHERE tLOG_RecordType = 'P'
	  and tLOG_Date = '2021-09-19'

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=D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0348.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=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=br,gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.mybaycity.com
HTTP_REFERER=
HTTP_URL=/scripts/P3_V2/P3V3-0348.CFM?P3_NewspaperID=1561&P3_CategoryID=2
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=192.168.162.152
PATH_INFO=
PATH_TRANSLATED=D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0348.CFM
QUERY_STRING=P3_NewspaperID=1561&P3_CategoryID=2
REMOTE_ADDR=3.230.144.31
REMOTE_HOST=3.230.144.31
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/scripts/P3_V2/P3V3-0348.CFM
SERVER_NAME=www.mybaycity.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=

Cookie Variables:
CFID=7700528
CFTOKEN=61a453ded41a99cf-2EA0DE4D-E682-FEDA-3CB679A098A6787B

Session Variables:
authortype=unknown
cfid=7700528
cftoken=61a453ded41a99cf-2EA0DE4D-E682-FEDA-3CB679A098A6787B
login_role=x
login_status=firsttime
login_type=reader
login_userid=Default
loginid=Default
p3_priornewspaperdate=2012-11-18 00:00:00.0
p3_priornewspaperid=1560
p3v2_home=www.mybaycity.com
p3v2_privdiag=0
p3v2_publication=mbC
sessionid=P3V2SYS_7700528_61a453ded41a99cf-2EA0DE4D-E682-FEDA-3CB679A098A6787B
urltoken=CFID=7700528&CFTOKEN=61a453ded41a99cf-2EA0DE4D-E682-FEDA-3CB679A098A6787B

URL Parameters:
P3_CategoryID=2
P3_NewspaperID=1561