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 Q R S T U V W X Y Z
Cabinets Cable (manufacturers) Cad Systems & Services Cafes Cajun Food Cake Decorating Equipment & Supplies Calculating & Adding Machs supls (whol) Calendars (wholesale) Calibration Services Calligraphers Campgrounds Camping Equipment Camps Camps Day Candles Candles Wholesale Candy & Confectionery Retail Candy & Confectionery Wholesale Canoes Canvas Goods (wholesale) Car Service Car Stereo Systems Wholesale Car Stereos Sales & Service Car Washing & Polishing Car Washing & Polishing Coin Operated Car Washing polishing Equip supls (whol) Carbonic Gas (wholesale) Carburetors Cardiology Career & Vocational Counseling Carpenters Carpet & Rug Cleaning Equip supls (whol) Carpet & Rug Dealers New Carpet & Rug Dealers Used Carpet & Rug Distributors Carpet & Rug Installers Carpet & Rug Installers Equipment supls Carpet & Rug Pads Linings & Accessories Carpet & Rug Repair & Refasten Carpet Rug & Upholstery Cleaners Carports Cash Registers & Supplies (wholesale) Casinos Casters & Glides (wholesale) Castings Caulking Contractors Caulking Materials & Equipment Wholesale Ceiling Cleaning Ceiling Contractors Ceilings Cellular Telephone Service Equipment Cement Wholesale Cemeteries Ceramic Equipment & Supplies Ceramic Products Decorative Certified Public Accountants CPA Chambers of Commerce Charities Chauffeur Service Chauffeur Service Check Cashing Service Check Recovery & Verification Checks Printing (manufacturers) Chemical Plant Equipment & Supplies Chemicals (wholesale) Child Abuse Services Child Care Centers Consultants Child Care Consulting & Information Child Care Referral Services Child Care Resources & Referral Child Care Service Child Day Care Providers Child Guidance Chimney & Fireplace Cleaning Repair Chimney Cleaning China & Crystal Chinese Food Chinese Food Products Chiropractors DC Christian Science Practitioners Christian Science Reading Rooms Christmas Lights & Decorations Christmas Trees Church Organizations Church Supplies Churches Cigar Cigarette & Tobacco Dealers Retail Cigar Cigarette & Tobacco Dealers Whol Civil Law Attorneys Clean Rooms Installation & Equipment Cleaners & Dyers Equipment (wholesale) Cleaning Compounds (wholesale) Cleaning House & Office Cleaning Services Cleaning Services Commercial residential Clinics Clocks Dealers Clocks Repairing & Parts Closets & Closet Accessories Wholesale Clothes & Accessories Children Wholesale Clothes & Accessories Men Wholesale Clothes & Accessories Vintage Clothes Consignment & Resale Clothes Men Retail Clothes Women Wholesale & Manufacturers Clothing Bought & Sold Clothing Children's Clothing Custom Made Clothing Womens Clubs Clubs Fraternal Clubs Special Interest Clubs Sports & Entertainment Clutches Coal Mining & Shipping Coatings Protective Manufacturers Cocktail Lounges Coffee & Tea Coffee & Tea Wholesale Coffee Break Service & Supplies Coffee Brewing Devices Coffee Houses Coffee Roasting (wholesale)		Coin Dealers Supplies Collectibles Collection Agencies Collection Law Attorneys Color Consultants Color Sprtns Offset Photo Engrave (mfrs) Comedy Clubs Comic Books Commercials Radio & Television Commodity Brokers Commodity Brokers Communications Consultants Community Organizations Compact Discs Records & Tapes Retail Compact Discs, Tapes, Records Wholesale Compressors Air & Gas (wholesale) Compressors Repair Computer Consultants Computer Data Recovery Computer Dealers Computer Furniture Computer Graphics Computer Parts & Supplies Computer Rooms Installation & Equipment Computer Service Repair Computer Services Computer Software Computer Software Developers Computer Training Computers & Computer Equip Svc & Repair Computers Cabling & Installation Computers Dealers Used Computers Networking Computers Renting & Leasing Computers Wholesale Concessionaires Concrete Additives (wholesale) Concrete Breaking Cut saw Eqpt (whol) Concrete Breaking Cutting & Sawing Concrete Construction Forms & Access Concrete Contractors Concrete Prestressed (manufacturers) Concrete Products (wholesale) Concrete Pumping Service Concrete Ready Mixed Concrete Reinforcements (wholesale) Concrete Repair & Restoration Concrete Restoration Repair & Cleaning Condominiums Conference Centers Connectors Electric (wholesale) Consignment Service Construction Consultants Construction Estimates Construction Management Construction Site Clean Up Services Consulate & Foreign Government Represent Consultants (management) Contact Lenses Continental Contract Manufacturing Contractors Alteration 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 Plumbing Contractors Referral Services Contractors Remodeling & Repairing Contractors Sewer Contractors Waterproofing Controls & Control Systems Regulators Convenience Stores Convention & Meeting Facilities Convention Information Bureaus Convention Services & Facilities Convents & Monasteries Conveyors & Conveying Equipment wholsale Cookies & Crackers Cooking Instruction Cooking Instruction Cooking Utensils Cooling Towers Copiers & Copier Supplies Copying & Duplicating Service Corporate Business Attorneys Corporate Finance & Securities Attorneys Corrosion Control Cosmetic Surgery Cosmetics & Perfumes Retail Costumes Masquerade & Theatrical Counselors Christian Counter Tops Court & Convention Reporters Court Reporters & Stenographers Craft Galleries & Dealers Craft Supplies Crane Service Cranes & Derricks (wholesale) Credit & Debt Counseling Services Credit Card & Other Credit Plans Credit Card Merchant Services Credit Card Plans Equipment Supplies Credit Repair Service Credit Reports Credit Unions Cremation Services Crematories Crime Prevention Programs Criminal Law Attorneys Crisis Intervention Service Cruises Crushing & Screening Equipment Customs Brokers

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

Categories_7548 (Records=2191, Time=172ms)
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=7548
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=247, Time=47ms)
SQL = 
SELECT		*
	FROM		Categories_7548
	WHERE		Catname LIKE 'C%'
	ORDER BY	CatName

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

250 milliseconds

URL Parameters:

LETTER=C
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=80202

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%2D09+14%3A53%3A33%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A53%3A33%27%7D%23; CFID=118164817; CFTOKEN=82975075
HTTP_HOST=80202.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.106
REMOTE_HOST=38.107.191.106
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=80202.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI