ZIPS Local Home
Keyword:  ZipCode:

Category List starting with C:


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 X Y
Cabinets
Cable (manufacturers)
Cad Systems & Services
Cajun Food
Cake Decorating Equipment & Supplies
Calligraphers
Camping Equipment
Car Service
Car Stereos Sales & Service
Car Washing & Polishing
Car Washing polishing Equip supls (whol)
Cardiology
Career & Vocational Counseling
Carpenters
Carpet & Rug Cleaning Equip supls (whol)
Carpet & Rug Dealers New
Carpet & Rug Distributors
Carpet & Rug Installers
Carpet Rug & Upholstery Cleaners
Cash Registers & Supplies (wholesale)
Caulking Contractors
Caulking Materials & Equipment Wholesale
Ceiling Contractors
Cellular Telephone Service Equipment
Ceramic Products Decorative
Certified Public Accountants CPA
Chains (wholesale)
Chambers of Commerce
Chauffeur Service
Check Cashing Service
Check Recovery & Verification
Chemical Cleaning Industrial
Chemicals (wholesale)
Child Care Consulting & Information
Child Care Referral Services
Child Care Resources & Referral
Child Care Service
Child Guidance
Chimney & Fireplace Cleaning Repair
Chimney Cleaning
Chinese Food
Chiropractors DC
Christmas Lights & Decorations
Church Organizations
Churches
Cigar Cigarette & Tobacco Dealers Retail
Civil Law Attorneys
Cleaning Compounds (wholesale)
Cleaning Services
Cleaning Services Commercial residential
Clinics
Clocks Dealers
Clocks Repairing & Parts
Closets & Closet Accessories Wholesale
Clothes & Accessories Vintage
Clothes Men Retail
Clothes Women Wholesale & Manufacturers
Clothing Children's
Clothing Womens
Clutches
Coal Mining & Shipping
Coatings Protective Manufacturers
Coffee & Tea
Coffee & Tea Wholesale
Coffee Houses
Collectibles
Collection Agencies
Collection Law Attorneys
Color Consultants
Comic Books
Commercials Radio & Television
Commodity Brokers
Communications Consultants
Compact Discs Records & Tapes Retail
Compressors Air & Gas (wholesale)
Computer Consultants
Computer Data Recovery
Computer Dealers
Computer Graphics
Computer Parts & Supplies
Computer Rooms Installation & Equipment
Computer Service Repair
Computer Services
Computer Software
Computer Training
Computers Cabling & Installation
Computers Dealers Used
Computers Networking
Computers Renting & Leasing
Computers Wholesale
Concessionaires
Concessionaires Equipment & Supplies
Concrete Breaking Cut saw Eqpt (whol)
Concrete Breaking Cutting & Sawing
Concrete Construction Forms & Access
Concrete Contractors
Concrete Pumping Service
Concrete Repair & Restoration
Concrete Restoration Repair & Cleaning
Condominiums
Conference Centers
Construction Consultants
Construction Estimates
Construction Management
Consultants (management)
Consultants Manufacturing
Contract Manufacturing
Contractors Building
Contractors Building General
Contractors Driveway
Contractors Drywall
Contractors Engineering General
Contractors Equipment & Rental
Contractors Equipment & Supls Repair
Contractors Equipment & Supply
Contractors Excavating
Contractors Foundation
Contractors Framing
Contractors Heating Ventilating
Contractors Masonry
Contractors Paving
Contractors Pipe Line
Contractors Plumbing
Contractors Remodeling & Repairing
Contractors Waterproofing
Controls & Control Systems Regulators
Convenience Stores
Convention Services & Facilities
Cooking Utensils
Cooling Towers
Copiers & Copier Supplies
Copying & Duplicating Service
Corrosion Control
Cosmetic Surgery
Cosmetics & Perfumes Retail
Cosmetics & Perfumes Wholesale
Costumes Masquerade & Theatrical
Counter Tops
Court Reporters & Stenographers
Craft Supplies
Crane Service
Cranes & Derricks (wholesale)
Credit Card & Other Credit Plans
Credit Card Merchant Services
Credit Unions
Cremation Services
Crime Prevention Programs
Criminal Law Attorneys
Cruises
Crushing & Screening Equipment

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

Categories_7554 (Records=1407, Time=125ms)
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=7554
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=150, Time=31ms)
SQL = 
SELECT		*
	FROM		Categories_7554
	WHERE		Catname LIKE 'C%'
	ORDER BY	CatName

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


Execution Time

172 milliseconds
0 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
0 msD:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 msD:\WEBSITES\ZIPSLOCAL\LINKS.CFM
172 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=C
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=80110

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=118163333; CFTOKEN=44168381; CFCLIENT_MAGICYELLOW=CATNAME%3DBeans%5F%28wholesale%29%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D3%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+14%3A47%3A39%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A46%3A20%27%7D%23
HTTP_HOST=80110.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_C.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=C
REMOTE_ADDR=38.107.191.107
REMOTE_HOST=38.107.191.107
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=80110.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI