Bay City, Michigan 48706
Front Page 09/18/2021 09:22 Log-In About us
Home Community Arts/Theater Business Schools Government Downtown
Local News Opinion Health/Fitness Events Groups & Non-Profits

mybaycity.com
Community Links


Real Estate

Bay City Real Estate Saginaw Real Estate

Sports

Club Tiger - The Tiger Woods Fan Club CNN-SI
The Steve Yzerman Page CBS SportsLine
The Unofficial Herman Moore Website Pete Sampras Online
Index of Mickey Redmond Quotes The Detroit Red Wings
The Official Grant Hill Website The Detroit Tigers
GolfWeb The Detroit Shock
NBA.com

News and Opinion

The Onion Newspaper MSN Slate News

Entertainment

Bob And Tom Website - Radio Astrology.com
Find Old Classmates Cartoon Factory
Riddler's Games The Really Cheap Free Stuff Page
Kids.com Disney.com
CyberPet Conspire.com
Dilbert Zone

Music/Movies/Television

Tee Vee Elvis Presley's Graceland
The Internet Movie Database Frank Sinatra.com
Lyrics.com Pollstar - The Concert Hotwire
UltimateTV.com Gilligan's Island Fan Club
Patsy Cline Home Page PBS Online

Science

JaneGoodall.com Atlas of Cyberspace
NASA Homepage Rainforest Action Network
ExoScience Exploratorium.com
National Library of Medicine Current Archeology
Delta College Planetarium Homepage Spaceweather.com

News

CNN News Dictionary.com
The Weather Channel USA Today
Wall Street Journal Resource for Health and Fitness
Intelihealth.com The New York Times

Cooking

Food TV Top Secret Recipes
Food and Nutrition Information Center Meals For You

Travel

Lonely Planet Travel Center Babelfish Language Translator
Guide to Australia Adventure Travel
Danger Finder

Government

US Postal Service The White House
The Central Intelligence Agency

Miscellaneous

Worst Personal Ads Ever -- From AOL Blue Mountian Arts Greeting Cards
Ask Dr. Weil Skydive Archive
Motorcycle Online The Wedding Channel

--- Advertisments ---
     



0330 nd 09-14-2021

12/31/2020 P3v3-0200-Ad.cfm

SPONSORED LINKS



12/31/2020 drop ads P3v3-0200-Ad.cfm


Designed at OJ Advertising, Inc. (V3) (v3) Software by Mid-Michigan Computer Consultants
Bay City, Michigan USA
All Photographs and Content Copyright © 1998 - 2021 by OJA/MMCC. They may be used by permission only.
P3V3-0330 (1) 0   ID:Default   UserID:Default   Type:reader   R:x   PubID:mbC   NewspaperID:1561
  pid:1560   pd:11-18-2012   nd:2021-09-14   ax:2021-09-18   Site:5   MaxA: 999999   MaxAA: 999999
CCBot/2.0 (https://commoncrawl.org/faq/)


Debugging Information
ColdFusion Server Enterprise 2021,0,0,323925
Template /scripts/P3_V2/P3V3-0330.cfm
Time Stamp 18-Sep-21 09:22 AM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 35.172.203.87
Host Name 35.172.203.87


Execution Time

Total Time Avg Time Count Template
109 ms 109 ms 1 top level D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0330.cfm
31 ms 16 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Banner.cfm
31 ms 31 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-LogBox.cfm
31 ms 31 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-LogBox2.cfm
31 ms 31 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-t010.cfm
16 ms 16 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-MenuBox.cfm
15 ms 15 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-CategoryBox.cfm
0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-0200-Ad.cfm
0 ms 0 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerInit.cfm
0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerTop.cfm
0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-BannerTopInit.cfm
0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-GOAD.cfm
0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-GoogleAnalytics.cfm
0 ms 0 ms 3 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-MBCcolor.cfm
0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-SitePal.cfm
0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-t900.cfm
0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/_Configuration.cfm
0 ms 0 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/scripts/P3_V2/Application.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
109 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

MBC_GetUser (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\p3_v2\Application.cfm @ 09:22:36.036
SELECT * FROM 	authors
	WHERE	AuthorUsername	 = 'xxx-xxx'
P3_CurrentPaper (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 09:22:36.036
SELECT *
	FROM Newspapers
	WHERE NewspaperID = '1561'
P3_PublicationDef (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 09:22:36.036
SELECT *
	FROM P3_tPublications
	WHERE PUB_PublicationID = 'mbC'
P3_Get_SiteInfo (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 09:22:36.036
SELECT *
	FROM Sites
	WHERE Name LIKE '%MyBayCity.com%'
P3_PriorPaper (Datasource=mybaycity, Time=16ms, Records=2) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 09:22:36.036
SELECT *
	FROM Newspapers
	WHERE ActivatedDate IS NOT NULL
	AND NPR_PublicationID = 'mbC'
	ORDER BY NewspaperID DESC
P3q_CurrSubscriber (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 09:22:36.036
SELECT * from Subscribers
		WHERE subscriberid ='9191919'
P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTopInit.cfm @ 09:22:36.036
SELECT	* FROM Banners
		WHERE ExpDate > '2021-09-18'
		  AND Banner_Type = 'W'
		ORDER BY StartDate
P3_GetBanner (Datasource=Advertising, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTop.cfm @ 09:22:36.036
SELECT	*
		FROM Banners
		WHERE BannerUserName = 'freedom'
P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerTop.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = 'freedom'
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-18'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '002'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '003'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '004'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '006'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '009'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '012'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '017'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '019'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '039'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '074'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 09:22:36.036
SELECT *
		FROM Categories
		WHERE CategoryID = '083'
P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 09:22:36.036
SELECT	*
		FROM Banners
		WHERE ExpDate > '2021-09-18'	
		  AND Banner_Type != 'W'
		
		ORDER BY StartDate
P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 09:22:36.036
SELECT	*
		FROM Banners
		WHERE BannerUserName = 'xxx'
P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-18'
P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 09:22:36.036
SELECT	*
		FROM Banners
		WHERE ExpDate > '2021-09-18'	
		  AND Banner_Type != 'W'
		
		ORDER BY StartDate
P3_GetBanner (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 09:22:36.036
SELECT	*
		FROM Banners
		WHERE BannerUserName = 'xxx'
P3_ReadLog (Datasource=mybaycity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-18'
P3_LogThesePubs (Datasource=MyBayCity, Time=0ms, Records=6) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox.cfm @ 09:22:36.036
SELECT *
	FROM P3_tPublications
	ORDER BY PUB_PublicationID
P3_LogThesePubs (Datasource=MyBayCity, Time=0ms, Records=6) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT *
	FROM P3_tPublications
	ORDER BY PUB_PublicationID
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Frankenmuth'
		  and tLOG_Date = '2021-09-17'
P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Frankenmuth'
			  and tLOG_Date >= '2021-08-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Freeland'
		  and tLOG_Date = '2021-09-17'
P3_Pub30DayLog (Datasource=MyBayCity, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Freeland'
			  and tLOG_Date >= '2021-08-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Gower'
		  and tLOG_Date = '2021-09-17'
P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Gower'
			  and tLOG_Date >= '2021-08-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'MBC'
		  and tLOG_Date = '2021-09-17'
P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'MBC'
			  and tLOG_Date >= '2021-08-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'MTCN'
		  and tLOG_Date = '2021-09-17'
P3_Pub30DayLog (Datasource=MyBayCity, Time=15ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'MTCN'
			  and tLOG_Date >= '2021-08-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Pinconning'
		  and tLOG_Date = '2021-09-17'
P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 09:22:36.036
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Pinconning'
			  and tLOG_Date >= '2021-08-17'
P3_PubCurrentLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox.cfm @ 09:22:36.036
SELECT *
	FROM P3_tLog
	WHERE tLOG_RecordType = 'P'
	  and tLOG_Date = '2021-09-17'


Scope Variables

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-0330.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=mybaycity.com
HTTP_REFERER=
HTTP_URL=/scripts/P3_V2/P3V3-0330.cfm?P3_NewspaperID=1561
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-0330.cfm
QUERY_STRING=P3_NewspaperID=1561
REMOTE_ADDR=35.172.203.87
REMOTE_HOST=35.172.203.87
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/scripts/P3_V2/P3V3-0330.cfm
SERVER_NAME=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=7524373
CFTOKEN=33d5e0c52b205d01-BAB07588-D92E-FCF1-40E78754D67EBF7B
Session Variables:
authortype=unknown
cfid=7524373
cftoken=33d5e0c52b205d01-BAB07588-D92E-FCF1-40E78754D67EBF7B
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=mybaycity.com
p3v2_privdiag=0
p3v2_publication=mbC
sessionid=P3V2SYS_7524373_33d5e0c52b205d01-BAB07588-D92E-FCF1-40E78754D67EBF7B
urltoken=CFID=7524373&CFTOKEN=33d5e0c52b205d01-BAB07588-D92E-FCF1-40E78754D67EBF7B
URL Parameters:
P3_NewspaperID=1561
Debug Rendering Time: 16 ms