Keyword:	ZipCode:

Category List starting with L: View other categories: A B C D E F G H I J K L M N O P R S T U V W Y
Labor Contractors Labor Organizations Laboratories Medical Laboratories Testing Laminations Plastic Paper Landscape Architects Landscape Consultants Landscape Contractors Landscape Designers Landscape Lighting Landscaping Service Laundries Laundromats Self Service Law Firms Lawn Installation & Maintenance Lawn Mowers Parts & Supplies Lawyers & Attorneys At Law		Leather Goods Dealers Libraries Public Lighting Fixtures Wholesale Lighting Systems & Equipment Limousine & Limo Car Service Linen Supply Service Linens Lingerie Liquor Stores Loans Loans Personal Loans Real Estate Locksmiths Logistics Luggage Retail Lumber Retail Lumber Wholesale

sitevars (Records=1, Time=0ms)
SQL = 
select *
		from	sitevars where siteid = 4

GetCity (Records=1, Time=0ms)
SQL = 
SELECT	City, StateCode, GeoCityID
		FROM	ZipCoords
		WHERE	iZip=06040

Categories_7622 (Records=815, Time=16ms)
SQL = 
SELECT		a.MYCatID, a.CatName, substring(a.CatName,1,1) AS letter, b.ListingCounts
	FROM		listingCategories a INNER JOIN ListingsCountIndex b ON a.MYCatID=b.MYCatID AND b.CityID=7622
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=34, Time=15ms)
SQL = 
SELECT		*
	FROM		Categories_7622
	WHERE		Catname LIKE 'L%'
	ORDER BY	CatName

CatLetters (Records=23, Time=16ms)
SQL = 
SELECT		DISTINCT letter
	FROM		Categories_7622
 	ORDER BY	Letter

63 milliseconds

URL Parameters:

LETTER=L
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=06040

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\ZipsLocal\morecategories.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
GATEWAY_INTERFACE=CGI/1.1
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_CHARSET=ISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CACHE_CONTROL=no-cache
HTTP_CONNECTION=close
HTTP_COOKIE=CFID=117259947; CFTOKEN=11836560; CFCLIENT_MAGICYELLOW=CATNAME%3DAutomobile%5FRoad%5FService%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D5%23LASTVISIT%3D%7Bts+%272010%2D09%2D07+08%3A28%3A57%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D07+08%3A07%3A41%27%7D%23
HTTP_HOST=06040.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_L.html
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_X_CC_ID=ccc03-02
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
PATH_INFO=/morecategories.cfm
PATH_TRANSLATED=D:\Websites\ZipsLocal\morecategories.cfm
QUERY_STRING=Letter=L
REMOTE_ADDR=38.107.191.109
REMOTE_HOST=38.107.191.109
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=06040.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI