Keyword:	ZipCode:

Category List starting with G: 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
Galvanizing (manufacturers) Games & Game Supplies Garage Builders Garage Doors & Openers Garages Garden Centers Gardeners Gas Companies Gas Detectors Gas Industrial Medical Cylinder & Bulk Gas Liquefied Petroleum Bottled Bulk Gas Propane Wholesale Gas Wholesale & Distributors Gasoline & Oil Wholesale Gastroenterology Gates Gay & Lesbian Organizations Gears & Gear Cutting Manufacturers General Contractors Generators Electric Wholesale Generators Installation Geologists German Food Gift Baskets & Parcels Gift Shops Gift Wholesalers Gifts Wholesale & Manufacturers Giftwares Wholesale Glass Beveled Carved Ornamental Glass Blocks Glass Carved Ornamental Beveled Etc Glass Stained & Leaded Glass Wholesale Gloves Work & Industrial Go Carts Gold Silver & Platinum Dealers Golf Cars & Carts Golf Course Architects		Golf Course Construction Golf Course Equipment Wholesale Golf Courses Miniature Golf Courses Private Golf Courses Public Golf Driving Ranges Golf Equipment & Supplies Sales & Repair Golf Equipment & Supplies Wholesale Golf Instruction Golf Tour Organizers & Promotions Gourmet Shops & Food Services Government Contract Consultants Government Offices City & Townships Government Offices County Government Offices Indian Government Offices State Government Offices US Government Post Offices Grain Dealers Wholesale Granite Wholesale Graphic Designers Graphic Services Grease Traps Cleaning Service Greek Food Greenhouses Greeting Cards Retail Grinding Precision & Production Grocers Retail Supermarket Grocers Wholesale Group Dental Insurance Gun Instruction Guns Accessories & Gunsmiths Gutters & Downspouts Gymnasiums Gymnasiums Equipment & Supplies Gymnastic Instruction Gynecologic Oncology Gynecology Gypsum & Gypsum Products Manufacturers

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

Categories_7042 (Records=2253, 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=7042
	WHERE		a.MYCatID > 1 AND a.display ='y'

Categories (Records=77, Time=46ms)
SQL = 
SELECT		*
	FROM		Categories_7042
	WHERE		Catname LIKE 'G%'
	ORDER BY	CatName

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

187 milliseconds

URL Parameters:

LETTER=G
MODE=
OVERRIDE_DEBUG_MODE=DEBUG
ZIP=85032

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+15%3A09%3A02%27%7D%23TIMECREATED%3D%7Bts+%272010%2D09%2D09+15%3A09%3A02%27%7D%23; CFID=118168105; CFTOKEN=34252735
HTTP_HOST=85032.zipslocal.com
HTTP_PRAGMA=no-cache
HTTP_SCRIPT_URL=/cats_G.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=G
REMOTE_ADDR=38.107.191.109
REMOTE_HOST=38.107.191.109
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/morecategories.cfm
SERVER_NAME=85032.zipslocal.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/5.0
WEB_SERVER_API=ISAPI