ZIPS Local Home
Keyword:  ZipCode:

Category List starting with I:


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
Ice
Ice Cream & Frozen Desserts
Ice Cream & Frozen Desserts Distributors
Ice Making Equipment & Machines (whol)
Identification Card Service
Identification Equipment & Supls (whol)
Image Consultants Personal
Imaging Services
Immigration Law Attorneys
Importers
Importing General
Incorporate Management Services
Indian Food
Industrial Consultants
Industrial Equipment & Supplies (whol)
Industrial Hygiene Consultants
Inks Printing & Lithographing
Inspection Bureaus
Insulation Contractors
Insulation Materials Cold & Heat
Insulation Materials Cold & Heat Whol
Insurance Agents & Agencies
Insurance Annuities
Insurance Business & Commercial
Insurance Claim Processing Services
Insurance Commercial
Insurance Consultants & Advisors
Insurance Farm
Insurance General
Insurance Group
Insurance Health Care
Insurance Inspection & Audits
Insurance Law Firms
Insurance Life Agents
Insurance Property & Casualty
Insurance Title
Insurance Workmen's Compensation
Intercoms Systems & Services
Interior Decorators & Designers Workroom
Interior Decorators dsgnrs Supls (whol)
Interior Design Decorators
Internal Medicine
International Movers
Internet Access Providers
Internet Service
Internet Service Providers
Inventors
Inventory Service
Investment Advisory Service
Investment Securities
Investments Real Estate
Irish Food
Ironwork
Irrigation Systems & Equipment Wholesale
Italian Restaurants

HOME  MAJOR CITIES  CATEGORIES  ABOUT US 

6


Queries

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

Categories_6845 (Records=1857, 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=6845
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=55, Time=31ms)
SQL = 
SELECT		*
	FROM		Categories_6845
	WHERE		Catname LIKE 'I%'
	ORDER BY	CatName

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


Execution Time

141 milliseconds
16 msD:\WEBSITES\ZIPSLOCAL\APPLICATION.CFM
0 msD:\WEBSITES\ZIPSLOCAL\FOOTER.CFML
0 msD:\WEBSITES\ZIPSLOCAL\LINKS.CFM
125 msD:\WEBSITES\ZIPSLOCAL\MORECATEGORIES.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SEARCHBOX.CFM
0 msD:\WEBSITES\ZIPSLOCAL\SERVERID.CFM
0 msSTARTUP, PARSING, & SHUTDOWN


Parameters
URL Parameters:

LETTER=I
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=35209

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%3A21%3A49%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+14%3A21%3A49%27%7D%23; CFID=118157988; CFTOKEN=64598755
HTTP_HOST=35209.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_I.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=I
REMOTE_ADDR=38.107.191.108
REMOTE_HOST=38.107.191.108
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=35209.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI