Keyword:	ZipCode:

Category List starting with P: 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
Packaging Service Packing & Crating Service Paging & Signaling Equipment & Systems Paging & Signaling Equipment (whol) Paint Ball Games Equip & Supls (whol) Paint Retail Painting Contractors Painting Contractors Commercial & Ind Paper (wholesale) Paralegals Parking Area lots Maintenance & Marking Parking Facilities Parks Patent & Trademark Attorneys Patent Agents Patent Attorneys Patent Attorneys & Agents Patio & Deck Builders Pawnbrokers Pay Telephones & Booths Equipment & Svc Pediatrics Pens & Pencils Sales & Repairing Pension & Profit Sharing Plans Personal Injury Attorneys Personnel Consultants Pest Control Pest Control Supplies & Equipment (whol) Pet Shops Pharmaceutical Products Wholesale Pharmacies Photo Finishing Retail Photo Finishing Wholesale Photographers Aerial Photographers Commercial Photographic Equip & Supplies Retail Photographic Equipment Repairing Physical Therapists Physicians & Surgeons Doctor of Podiatry Physicians & Surgeons Dpm Group Assoc Physicians & Surgeons Equip & Supls Whol Physicians & Surgeons Information Bureau Physicians & Surgeons Medical Clinics Physicians & Surgeons Referral Service Physicians Assistants Physicians Chiropractic Dc		Physicians Naturopathic Physicians Surgeons Doctors Piano & Organ Movers Pianos Picture Frames Dealers Picture Frames Wholesale Pipe Line Contractors Piping Contractors Pizza Plant Shops Plants Retail Plastic Surgery Plastics Fabricating finish decor Mfrs Plating (manufacturers) Plumbers Plumbing Contractors Referral Service Plumbing Drain & Sewer Cleaning Plumbing Fixtures & Supplies New Retail Plumbing Fixtures & Supplies Wholesale Podiatry Podiatrists Police Departments Pool Service Portrait Photographers Power Washing Precious,semi Prcs,synthetic Stns (whl) Premium Goods (wholesale) Pretzels (wholesale) Pretzels Retail Printed & Etched Circuits Mfrs Printers Continuous & Individual Form Printing Services Printing Supplies (wholesale) Private Detectives Private Investigators Product Liability Law Attorneys Psychologists Psychotherapists Public Relations Counselors Public Speaking Instruction Publishers Publishers Representatives Pulmonary & Respiratory Pumping Contractors Pumps (wholesale) Pumps Repairing

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

Categories_7607 (Records=952, 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=7607
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=90, Time=16ms)
SQL = 
SELECT		*
	FROM		Categories_7607
	WHERE		Catname LIKE 'P%'
	ORDER BY	CatName

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

109 milliseconds

URL Parameters:

LETTER=P
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=06810

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=117261543; CFTOKEN=23268272; CFCLIENT_MAGICYELLOW=CATNAME%3DBeer%5Fand%5FAle%5FWholesale%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D2%23LASTVISIT%3D%7Bts+%272010%2D09%2D07+08%3A18%3A55%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D07+08%3A16%3A01%27%7D%23
HTTP_HOST=06810.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_P.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=P
REMOTE_ADDR=38.107.191.107
REMOTE_HOST=38.107.191.107
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=06810.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI