Keyword:	ZipCode:

Category List starting with S: 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
Safety Consultants Safety Equipment & Clothing (whol) Salvage & Surplus Merchandise Sand & Gravel (wholesale) Sandblasting Sandwich Shops Sandwiches Satellite Comms Services Common Carrier Satellite Equipment & Systems Retail Saws Saws Sharpening & Repairing Scaffolding & Aerial Lifts Scales (wholesale) School Furniture & Equipment (whol) School Supplies (wholesale) Schools Schools Business & Secretarial Schools Industrial Technical & Trade Schools Medical & Dental Assistants tech Schools Nursery & Kindergarten Academic Schools Parochial Schools Private Schools Universities & Colleges Academic Scrap Metals & Iron (wholesale) Scrapbook Albums & Supplies Screen Printing Screen Printing Equipment & Supplies Screw Machine Products (manufacturers) Screws (wholesale) Seafood Secretarial & Court Reporting Services Security Alarm Systems Security Consultants Security Guard & Patrol Service Security Systems Security Systems Consultants Seeds & Bulbs Retail Seeds & Bulbs Wholesale Senior Citizens Service Organizations Septic Tanks Septic Tanks Systems Cleaning Repairing Service Station Equipment (wholesale) Service Stations Service Stations Gasoline & Oil Sewer & Drain Cleaning Service repair Sewer Contractors Sewing Contractors Sewing Instruction Sewing Machines Household Sewing Machines Repairing Sharpening Service Sheet Metal Work Contractors Shelving (wholesale) Shipping Services Shoe & Boot Repairing Shoe Shining Shoes Shopping Centers & Malls Shower Doors & Enclosures Shredding Records & Documents Shutters Siding Contractors Siding Materials Sightseeing Tours Signs Sitting Services Skateboards & Equipment Skating Rinks		Skin Care Skylights Sleep Disorders Doctors Slip Covers Soccer Clubs Social Security Attorneys Social Service & Welfare Organizations Social Workers Sod & Sodding Service Solar Products & Service Retail Soul Food Sound Systems & Equipment (wholesale) Spas & Hot Tubs Spas & Hot Tubs Service & Repair Speakers Lectures & Seminars Speech Language Pathologists Speech Pathologists Speedometers (wholesale) Sporting Goods Sporting Goods Wholesale Sports & Entertainment Centers Sports Bars Sports Information Sports Medicine & Injuries Sports Promoters Managers & Recruiters Sportswear Retail Sprinklers Garden & Lawn Retail Stables Stadiums Arenas & Athletic Fields Stained Glass Starters Engine Stationers Retail Stationery Retail Stationery Wholesale Steak Houses Steel Detailers Structural Steel Distributors & Warehouses Steel Erectors Steel Fabricators Steel Processing Stevedoring Contractors Stock & Bond Brokers Stone Contractors Stone Crushed Stone Natural Stone Setting Contractors Storage Storage Household & Commercial Storage Sheds Store Fixtures (wholesale) Storm Windows & Doors Stucco & Exterior Coating Contractors Stucco & Textured Coating Contractors Stump Removal Service Sundries Stores Sunglasses & Sun Goggles Support Groups Surgical Appliances Surgical Centers Surveying Instruments (wholesale) Surveyors Land Swimming Instruction Swimming Pool Consultants Swimming Pool Designers Swimming Pool Equipment & Supls (whol) Swimming Pool Service Swimming Pools Private Swimming Pools Public Synagogues

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

Categories_6960 (Records=1670, Time=47ms)
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=6960
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=137, Time=15ms)
SQL = 
SELECT		*
	FROM		Categories_6960
	WHERE		Catname LIKE 'S%'
	ORDER BY	CatName

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

110 milliseconds

URL Parameters:

LETTER=S
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=72205

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=118161450; CFTOKEN=58723948; CFCLIENT_MAGICYELLOW=CATNAME%3DAir%5FDuct%5FCleaning%23FAVORITES%3D%23SOURCE%3DNA%23; CFGLOBALS=HITCOUNT%3D2%23LASTVISIT%3D%7Bts+%272010%2D09%2D09+14%3A37%3A55%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A37%3A19%27%7D%23
HTTP_HOST=72205.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_S.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=S
REMOTE_ADDR=38.107.191.105
REMOTE_HOST=38.107.191.105
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=72205.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI