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
Cabinet Makers Cabinets Cabinets Custom Built Cable (manufacturers) Cable Television Service Cable Television Systems Cajun Food Calibration Services Calligraphers Campers & Pick Up Coaches Dealers Camping Equipment Candles Candy & Confectionery Retail Canoes Car Service Car Stereo Systems Wholesale Car Stereos Sales & Service Car Washing & Polishing Carburetors Cardiology Career & Vocational Counseling Carpet & Rug Cleaning Equip supls (whol) Carpet & Rug Dealers New Carpet & Rug Dealers New Carpet & Rug Dealers New Wholesale Carpet & Rug Installers Carpet & Rug Pads Linings & Accessories Carpet Rug & Upholstery Cleaners Carports Cash Registers & Supplies (wholesale) Castings Catalog Showrooms Caulking Contractors Ceiling Cleaning Ceiling Contractors Cellular Telephone Service Equipment Cemeteries Certified Public Accountants CPA Chambers of Commerce Chauffeur Service Check Cashing Service Chemical Cleaning Industrial Chemicals (wholesale) Child Care Consulting & Information Child Care Referral Services Child Care Service Children's & Infants' Wear Chimney & Fireplace Cleaning Repair Chinese Food Chiropractors DC Christian Science Practitioners Christian Science Reading Rooms Christmas Trees Church Supplies Churches Cigar & Cigarette Accessories Civil Law Attorneys Clean Rooms Installation & Equipment Cleaning Exterior Cleaning Services Cleaning Services Commercial residential Cleaning Systems Pressure Chemicals Clinics Closets Designing & Remodeling Clothing Bought & Sold Clubs Clutches Coal & Coke Retail Coatings Protective Manufacturers Cocktail Lounges Coffee & Tea Coffee & Tea Shops Coffee Break Service & Supplies Coin Dealers Supplies Collectibles Collection Agencies Collection Law Attorneys Color Consultants Color Sprtns Offset Photo Engrave (mfrs) Comic Books Commodity Brokers		Communication & Electronic Contractors Communication Service Communications Consultants Compact Discs Retail Compressors Air & Gas (wholesale) Computer Consultants Computer Data Recovery Computer Dealers Computer Graphics Computer Parts & Supplies Computer Service Repair Computer Services Computer Software Computer Training Computers Networking Computers On Line Services & Internet Computers Renting & Leasing Computers Wholesale Concert Bureaus Concrete Contractors Concrete Products (wholesale) Concrete Repair & Restoration Concrete Restoration Repair & Cleaning Condominiums Conference & Seminar Coordinators Conference Centers Connectors Electric (wholesale) Consignment Service Construction Consultants Construction Estimates Construction Reports 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 Remodeling & Repairing Contractors Sewer Contractors Waterproofing Controls & Control Systems Regulators Convenience Stores Convention Services & Facilities Cookies & Crackers Cooking Utensils Copiers & Copier Supplies Copiers Service & Repair Copying & Duplicating Service Cosmetic Services Cosmetic Surgery Cosmetics & Perfumes Retail Costumes Masquerade & Theatrical Cotton (manufacturers) Cotton Gins Counselors Human Relations Counselors Licensed Counter Tops Court & Convention Reporters Crane Service Cranes Renting Credit & Debt Counseling Services Credit Repair Service Credit Reporting Agencies Credit Unions Criminal Law Attorneys Cruises Culverts Customs Brokers

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

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

Categories_6879 (Records=1364, Time=78ms)
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=6879
	WHERE		a.MYCatID > 1 AND a.display ='y'

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

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

141 milliseconds

URL Parameters:

LETTER=C
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=35801

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=118156301; CFTOKEN=71317184; CFCLIENT_MAGICYELLOW=CATNAME%3DAntique%5FDealers%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D4%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+14%3A16%3A33%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A14%3A15%27%7D%23
HTTP_HOST=35801.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=35801.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI