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

Mid-Michigan News Service
Subscriber Services

Welcome MyBayCity.com Reader.
If you are a subscriber, use this form to login
E-mail
Password
A password is required for subscription updates.
If you forgot or don't know your password just leave this blank.
We'll give you some other options on the next screen.
If you are NOT A SUBSCRIBER:
Click here to return to Article 07602

Mid-Michigan News Service is a subsidiary of OJ Advertising, Inc. - Bay City, Michigan
--- Advertisments ---
     


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-0436 (1) 0   ID:Default   UserID:Default   Type:reader   R:x   PubID:mbC   NewspaperID:1561
  pid:1560   pd:11-18-2012   nd:2021-09-16   ax:2021-09-20   Site:5   ArticleID:07602   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-0436.cfm
Time Stamp 20-Sep-21 04:48 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 3.230.144.31
Host Name 3.230.144.31


Execution Time

Total Time Avg Time Count Template
47 ms 47 ms 1 top level D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0436.cfm
32 ms 32 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-CategoryBox.cfm
0 ms 0 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Banner.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-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-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
47 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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
SELECT *
	FROM Sites
	WHERE Name LIKE '%MyBayCity.com%'
P3_PriorPaper (Datasource=mybaycity, Time=0ms, Records=2) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-t010.cfm @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
SELECT	* FROM Banners
		WHERE ExpDate > '2021-09-20'
		  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 @ 16:48:06.006
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 @ 16:48:06.006
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = 'freedom'
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-20'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
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 @ 16:48:06.006
SELECT	*
		FROM Banners
		WHERE ExpDate > '2021-09-20'	
		  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 @ 16:48:06.006
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 @ 16:48:06.006
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-20'
P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 16:48:06.006
SELECT	*
		FROM Banners
		WHERE ExpDate > '2021-09-20'	
		  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 @ 16:48:06.006
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 @ 16:48:06.006
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-09-20'


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-0436.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-0436.cfm?P3_NewspaperID=1561&P3_articleID=07602
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-0436.cfm
QUERY_STRING=P3_NewspaperID=1561&P3_articleID=07602
REMOTE_ADDR=3.230.144.31
REMOTE_HOST=3.230.144.31
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/scripts/P3_V2/P3V3-0436.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=7704605
CFTOKEN=c7749752deac9926-319DAA6E-EF45-C8DA-62DEFB4479450280
Session Variables:
authortype=unknown
cfid=7704605
cftoken=c7749752deac9926-319DAA6E-EF45-C8DA-62DEFB4479450280
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_7704605_c7749752deac9926-319DAA6E-EF45-C8DA-62DEFB4479450280
urltoken=CFID=7704605&CFTOKEN=c7749752deac9926-319DAA6E-EF45-C8DA-62DEFB4479450280
URL Parameters:
P3_NewspaperID=1561
P3_articleID=07602
Debug Rendering Time: 16 ms