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

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

172 milliseconds

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