Keyword:	ZipCode:

Category List starting with A: 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
Abrasives (wholesale) Accident Attorneys Accountants Licensed Public Accountants Public Accounting Service Adjusters Advertising Agencies & Counselors Advertising Direct Mail Advertising Outdoor Advertising Specialties & Promotional Air Conditioning Contractors Air Conditioning Equipment Repair Air Conditioning Heating Installation Air Duct Cleaning Air Pollution Control Aircraft Equipment Parts & Supplies Airport Transportation Service Alcohol Abuse & Addiction Info treatment Alcoholism Information & Treatment Amusement Devices Amusement Places Annuities Antique Dealers Apartments Appliances Major Dealers & Service Appraisers Architects Architects & Builders Service Architectural Designers Art Galleries Dealers Consultants Art Materials & Supplies Artists Fine Arts		Asphalt & Asphalt Products Asphalt Paving Contractors Assembly & Fabricating Service Assisted Living & Elder Care Services Associations Attorneys Service Bureaus Auctioneers Audiologists Auto Body Repairing Painting Auto Car Insurance Auto Car Parts Auto Dealers New Cars Auto Dealers Used Cars Auto Glass Auto Parts & Supplies Wholesale Auto Parts Used Rebuilt Auto Rental Leasing Car Auto Repair Service Automobile Antique & Classic Automobile Bumpers Guards Grills Automobile Customizing Automobile Dealers Used Cars Wholesale Automobile Dent Repair Paintless Automobile Diagnostic Service Automobile Machine Shop Service Automobile Oil & Lubrication Services Automobile Parts Recyclers & Dismantlers Automobile Racing Car Equipment Automobile Seatcovers Tops & Upholstery Automobile Transporters & Drive Away Automobile Wrecking (wholesale) Automotive Consultants

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=06460

Categories_7625 (Records=902, Time=31ms)
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=7625
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=64, Time=31ms)
SQL = 
SELECT		*
	FROM		Categories_7625
	WHERE		Catname LIKE 'A%'
	ORDER BY	CatName

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

78 milliseconds

URL Parameters:

LETTER=A
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=06460

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=CFCLIENT_MAGICYELLOW=FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D1%23LASTVISIT%3D%7Bts+%272010%2D09%2D07+08%3A11%3A57%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D07+08%3A11%3A57%27%7D%23; CFID=117260857; CFTOKEN=56071796
HTTP_HOST=06460.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_A.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=A
REMOTE_ADDR=38.107.191.106
REMOTE_HOST=38.107.191.106
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=06460.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI