SELECT *
	FROM tFLexSites
	WHERE WebsiteID = 0

	SELECT *
	FROM tFLexSites
	WHERE WebsiteID = 49

			SELECT categoryTitle
			FROM tFlexCategories
			WHERE categoryid = 11514 
		

		SELECT isnull(categoryExclude3rdCol,0) as Exclude3rdCol , 0 as FromReelz
		FROM tFLexCategories 
		WHERE Categoryid = 11514
		and websiteid = 49
	

		SELECT *
		FROM tFLexCategories
		WHERE categoryid = 11514
		AND WebsiteID = 49
	

	SELECT id 
	FROM tFlexCategoriesAds
	WHERE websiteID = 49
	AND categoryid = 11514 
	AND Active = 1 
	AND '01/10/2012'	BETWEEN convert(varchar(50), StartDate, 101) and convert(varchar(50), endDate, 101)

	SELECT *
	FROM tFlexCategories
	WHERE categoryid = 11514 

	SELECT Elem.ElementID,Elem.SysName, Page.NoOfStories as NoOfStories, 
		Page.NoFirstStoryToLoad as NoFirstStoryToLoad, 
		Page.StoryCategoryID, Page.StoryID, Page.PageLayoutID
	FROM tFlexPageLayout Page
	INNER JOIN tFlexElementControl Elem ON Elem.ElementID = Page.ElementID
	WHERE Page.LocationCategoryID = 11514
	AND Page.websiteID = 49
	AND Page.Active = 1
	AND Page.ColumnPosition = 1
	AND ((Page.Startdate < '01/10/2012' and Page.EndDate >= '01/10/2012')
	 OR (Page.Startdate = '01/10/2012' and Page.Starttime <= '10:31:09'))
	AND Elem.type in (0,1,2,3,4,5) 
	ORDER BY page.OrderID

	SELECT Elem.ElementID,Elem.SysName, Page.NoOfStories as NoOfStories, 
		Page.NoFirstStoryToLoad as NoFirstStoryToLoad, 
		Page.StoryCategoryID, Page.StoryID, Page.PageLayoutID
	FROM tFlexPageLayout Page
	INNER JOIN tFlexElementControl Elem ON Elem.ElementID = Page.ElementID
	WHERE Page.LocationCategoryID = 11514
	AND Page.websiteID = 49
	AND Page.Active = 1
	AND Page.ColumnPosition = 2
	AND ((Page.Startdate < '01/10/2012' and Page.EndDate >= '01/10/2012')
	 OR (Page.Startdate = '01/10/2012' and Page.Starttime <= '10:31:09'))
	AND Elem.type in (0,1,2,3,4,5) 
	ORDER BY page.OrderID

	SELECT storyid, replace(replace(headline,'<p>',''),'</p>','') as headline, summary, lastupdate,
	memo, media, storyShowPub, print_email, template, outsidelink, authorid, openNewWindow, showbyline, byline, HasUserComments, 
	isnull(date1,lastupdate) as date1, location
	FROM tFlexstories WITH (NOLOCK)
	WHERE storyid = 995885
	
	
	
		AND (( date < '01/10/2012' and killDate >= '01/10/2012')
		 OR (date = '01/10/2012' and time <= '10:31:09'))
	 
	
	
	AND publish = 1
	
	
	
	

	SELECT Elem.ElementID,Elem.SysName, Page.NoOfStories as NoOfStories, 
		Page.NoFirstStoryToLoad as NoFirstStoryToLoad, 
		Page.StoryCategoryID, Page.StoryID, Page.PageLayoutID
	FROM tFlexPageLayout Page
	INNER JOIN tFlexElementControl Elem ON Elem.ElementID = Page.ElementID
	WHERE Page.LocationCategoryID = 11514
	AND Page.websiteID = 49
	AND Page.Active = 1
	AND Page.ColumnPosition = 3
	AND ((Page.Startdate < '01/10/2012' and Page.EndDate >= '01/10/2012')
	 OR (Page.Startdate = '01/10/2012' and Page.Starttime <= '10:31:09'))
	AND Elem.type in (0,1,2,3,4,5) 
	ORDER BY page.OrderID

	SELECT storyid, replace(replace(headline,'<p>',''),'</p>','') as headline, summary, lastupdate,
	memo, media, storyShowPub, print_email, template, outsidelink, authorid, openNewWindow, showbyline, byline, HasUserComments, 
	isnull(date1,lastupdate) as date1, location
	FROM tFlexstories WITH (NOLOCK)
	WHERE storyid = 2110760
	
	
	
		AND (( date < '01/10/2012' and killDate >= '01/10/2012')
		 OR (date = '01/10/2012' and time <= '10:31:09'))
	 
	
	
	AND publish = 1
	
	
	
	

	SELECT Elem.ElementID,Elem.SysName, Page.NoOfStories as NoOfStories, 
		Page.NoFirstStoryToLoad as NoFirstStoryToLoad, 
		Page.StoryCategoryID, Page.StoryID, Page.PageLayoutID
	FROM tFlexPageLayout Page
	INNER JOIN tFlexElementControl Elem ON Elem.ElementID = Page.ElementID
	WHERE Page.LocationCategoryID = 11514
	AND Page.websiteID = 49
	AND Page.Active = 1
	AND Page.ColumnPosition = 5
	AND ((Page.Startdate < '01/10/2012' and Page.EndDate >= '01/10/2012')
	 OR (Page.Startdate = '01/10/2012' and Page.Starttime <= '10:31:09'))
	AND Elem.type in (0,1,2,3,4,5) 
	ORDER BY page.OrderID

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\kstc45\admin\createHtml.cfm
CONTENT_LENGTH=
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=deflate, gzip, x-gzip, compress, x-compress
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=close, TE
HTTP_COOKIE=
HTTP_HOST=kstc45.com
HTTP_REFERER=
HTTP_USER_AGENT=ColdFusion
PATH_INFO=/admin/createHtml.cfm
PATH_TRANSLATED=D:\websites\kstc45\admin\createHtml.cfm
QUERY_STRING=cat=11514&pub=1&web=49
REMOTE_ADDR=192.168.24.21
REMOTE_HOST=192.168.24.21
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/admin/createHtml.cfm
SERVER_NAME=kstc45.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/6.0
WEB_SERVER_API=

Cookie Variables:
CFID=20416656
CFTOKEN=32743111

Session Variables:
sessionid=8430ada22ae7bba8b9ef24805b1b1f342315
urltoken=CFID=20416656&CFTOKEN=32743111&jsessionid=8430ada22ae7bba8b9ef24805b1b1f342315

URL Parameters:
cat=11514
pub=1
web=49