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

MyBayCity.com
Leave a Comment

The Editors of MyBayCity.com invite you to leave a comment about the article you are reading. That article is still open in another browser window or tab. You can click back to view it then return to this comment form.

Your comment will be reviewed by the editorial staff and then added to the bottom of the article.

The Editors of MyBayCity.com reserve the right to edit your comment for length and content and will make the final decision to post the comment with the article.
Voting-Poll Article 7198: 22-Jul-12

More Digital Billboards in Bay City? -- Yes? or No?

By: O. J. Cunningham

Your Name
Your e-mail
Your Phone
As a person To Prevent Spam Click Any 3 Boxes Before Submitting Your Comments  
               
Comment
--- Advertisments ---
     

0390 nd 10-15-2021
P3_NewspaperID = '1561' - P3_ArticleID = '7198' - v 101810.1246

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-0390 (1) 0   ID:Default   UserID:Default   Type:reader   R:x   PubID:mbC   NewspaperID:1561
  pid:1560   pd:11-18-2012   nd:2021-10-15   ax:2021-10-19   Site:5   ArticleID:7198   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-0390.cfm
Time Stamp 19-Oct-21 02:27 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 35.172.217.174
Host Name 35.172.217.174

Execution Time

Total Time Avg Time Count Template
110 ms 110 ms 1 top level D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0390.cfm
63 ms 63 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-LogBox.cfm
63 ms 63 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-LogBox2.cfm
16 ms 8 ms 2 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-Banner.cfm
16 ms 16 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-CategoryBox.cfm
16 ms 16 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/Scripts/P3_V2/P3V3-t010.cfm
15 ms 15 ms 1 D:/Websites/bcra-mlscom/mybaycity.com/scripts/P3_V2/Application.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-Feedback-AList.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-MenuBox.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  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
125 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

MBC_GetUser (Datasource=MyBayCity, Time=15ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\p3_v2\Application.cfm @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
SELECT	* FROM Banners
		WHERE ExpDate > '2021-10-19'
		  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 @ 14:27:53.053
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 @ 14:27:53.053
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = 'freedom'
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-10-19'
P3_CategoryQuery (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-CategoryBox.cfm @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
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 @ 14:27:53.053
SELECT *
		FROM Categories
		WHERE CategoryID = '083'
P3_CurrentPaper (Datasource=mybaycity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0390.cfm @ 14:27:53.053
SELECT *
	FROM Newspapers
	WHERE NewspaperID = '1561'
P3_Article (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0390.cfm @ 14:27:53.053
SELECT *
	FROM articles
	WHERE ArticleID = '7198'
P3_Author (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0390.cfm @ 14:27:53.053
SELECT *
	FROM authors
	WHERE AuthorUsername = 'admin'
P3_Category (Datasource=MyBayCity, Time=0ms, Records=1) in D:\Websites\bcra-mlscom\mybaycity.com\scripts\P3_V2\P3V3-0390.cfm @ 14:27:53.053
SELECT *
	FROM categories
	WHERE CategoryID = '76'
P3_FeedbackList (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Feedback-AList.cfm @ 14:27:53.053
SELECT *
	FROM p3_tFeedback
	WHERE tFB_ArticleID = '7198'
	ORDER BY  tFB_CommentID
P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 14:27:53.053
SELECT	*
		FROM Banners
		WHERE ExpDate > '2021-10-19'	
		  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 @ 14:27:53.053
SELECT	*
		FROM Banners
		WHERE BannerUserName = 'xxx'
P3_ReadLog (Datasource=mybaycity, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-Banner.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-10-19'
P3_AvailableBanners (Datasource=Advertising, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-BannerInit.cfm @ 14:27:53.053
SELECT	*
		FROM Banners
		WHERE ExpDate > '2021-10-19'	
		  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 @ 14:27:53.053
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 @ 14:27:53.053
SELECT * FROM P3_tLog
	WHERE tLOG_RecordType	 = 'A'
	  and tLOG_ItemID 		 = ''
	  and tLOG_PublicationID = 'mbC'
	  and tLOG_Date			 = '2021-10-19'
P3_LogThesePubs (Datasource=MyBayCity, Time=0ms, Records=6) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox.cfm @ 14:27:53.053
SELECT *
	FROM P3_tPublications
	ORDER BY PUB_PublicationID
P3_LogThesePubs (Datasource=MyBayCity, Time=16ms, Records=6) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
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 @ 14:27:53.053
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Frankenmuth'
		  and tLOG_Date = '2021-10-18'
P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Frankenmuth'
			  and tLOG_Date >= '2021-09-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Freeland'
		  and tLOG_Date = '2021-10-18'
P3_Pub30DayLog (Datasource=MyBayCity, Time=15ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Freeland'
			  and tLOG_Date >= '2021-09-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Gower'
		  and tLOG_Date = '2021-10-18'
P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Gower'
			  and tLOG_Date >= '2021-09-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'MBC'
		  and tLOG_Date = '2021-10-18'
P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'MBC'
			  and tLOG_Date >= '2021-09-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'MTCN'
		  and tLOG_Date = '2021-10-18'
P3_Pub30DayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'MTCN'
			  and tLOG_Date >= '2021-09-17'
P3_Test30dayLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
		WHERE tLOG_RecordType = 'P'
		  and tLOG_PublicationID = 'Pinconning'
		  and tLOG_Date = '2021-10-18'
P3_Pub30DayLog (Datasource=MyBayCity, Time=16ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox2.cfm @ 14:27:53.053
SELECT * FROM P3_tLog
			WHERE tLOG_RecordType = 'P'
			  and tLOG_PublicationID = 'Pinconning'
			  and tLOG_Date >= '2021-09-17'
P3_PubCurrentLog (Datasource=MyBayCity, Time=0ms, Records=0) in D:\Websites\bcra-mlscom\mybaycity.com\Scripts\P3_V2\P3V3-LogBox.cfm @ 14:27:53.053
SELECT *
	FROM P3_tLog
	WHERE tLOG_RecordType = 'P'
	  and tLOG_Date = '2021-10-18'

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-0390.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-0390.cfm?P3_NewspaperID=1561&P3_ArticleID=7198
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-0390.cfm
QUERY_STRING=P3_NewspaperID=1561&P3_ArticleID=7198
REMOTE_ADDR=35.172.217.174
REMOTE_HOST=35.172.217.174
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/scripts/P3_V2/P3V3-0390.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=9598739
CFTOKEN=61182adf2fa609a3-0210095C-0AC9-280B-213245180323A916

Session Variables:
authortype=unknown
cfid=9598739
cftoken=61182adf2fa609a3-0210095C-0AC9-280B-213245180323A916
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_9598739_61182adf2fa609a3-0210095C-0AC9-280B-213245180323A916
urltoken=CFID=9598739&CFTOKEN=61182adf2fa609a3-0210095C-0AC9-280B-213245180323A916

URL Parameters:
P3_ArticleID=7198
P3_NewspaperID=1561
Debug Rendering Time: 15 ms