ZIPS Local Home
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

HOME  MAJOR CITIES  CATEGORIES  ABOUT US 

6


Queries

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


Execution Time

78 milliseconds
0 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
0 msD:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 msD:\WEBSITES\ZIPSLOCAL\LINKS.CFM
78 msD:\WEBSITES\ZIPSLOCAL\MORECATEGORIES.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SEARCHBOX.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SERVERID.CFM
0 msSTARTUP, PARSING, & SHUTDOWN


Parameters
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