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

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

141 milliseconds

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